Write data in file if date is under...

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
krasi_e_d
Forum Newbie
Posts: 20
Joined: Mon Feb 27, 2012 5:00 am

Write data in file if date is under...

Post by krasi_e_d »

Hello, guys

I use this code :

Code: Select all

<?php header("Content-Type: text/html; charset=utf-8"); ?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<?php
include("import.php");
$doc_num = $_REQUEST['doc_num'];
//$folder_num = $_REQUEST['folder_num'];
//$date_doc   = $_REQUEST['date_doc'];

//$comment  = $_REQUEST['comment'];
$sql = mysql_connect("****", "**", "*****");
mysql_select_db("****") or die(mysql_error());
mysql_query("SET NAMES cp1251");
mysql_query ('SET CHARACTER SET CP1251');


$data = mysql_query("SELECT * FROM day WHERE date = '$doc_num'")
 or die(mysql_error());



$filewrite = fopen("ajur.txt", "w");
  while($row = mysql_fetch_array( $data, MYSQL_ASSOC )) 
       {
fwrite($filewrite, $row['contragent'] . "|");
fwrite($filewrite, $row['date'] .  "|");
fwrite($filewrite, $row['duty'] . "|");
fwrite($filewrite, "\r\n");
  } 
//mysql_query("DELETE FROM day"); 

  
?>
When I write for request date 30.08.2012 everywhere have date 30.08.2012 is write in file, but i want to write in file everything before this date 30.08.2012.

Please, help
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: Write data in file if date is under...

Post by Celauran »

Your query uses = when you appear to want <

Also, sanitize your inputs.
krasi_e_d
Forum Newbie
Posts: 20
Joined: Mon Feb 27, 2012 5:00 am

Re: Write data in file if date is under...

Post by krasi_e_d »

Something wrong when I change to

Code: Select all

SELECT * FROM day WHERE date < '$doc_num
is not correct, because write some rows with data after this date.
Celauran wrote:Your query uses = when you appear to want <

Also, sanitize your inputs.
krasi_e_d
Forum Newbie
Posts: 20
Joined: Mon Feb 27, 2012 5:00 am

Re: Write data in file if date is under...

Post by krasi_e_d »

Everything what is writing is in the same month.
Post Reply