mysql_query

[bob2006]

this is a stupid thing but i cant remember how to do it there is the code

$find=mysql_query("select * from `vistor_ip` where date='$month$day$year'")or die (mysql_error());
echo" $find";

how do i get all the information from that day the filed in the table or date time an user_ip

i want all the in fo in a table it you can tell me how to get the information out i can do the table i just can not remember how to do it

[cooldude832]

just get a date in the same version as its stored in the table and you can compare them

 

http://www.w3schools.com/php/php_ref_date.asp

 

good date refernce

[ryeman98]

this is a stupid thing but i cant remember how to do it there is the code

$find=mysql_query("select * from `vistor_ip` where date='$month$day$year'")or die (mysql_error());
echo" $find";

how do i get all the information from that day the filed in the table or date time an user_ip

i want all the in fo in a table it you can tell me how to get the information out i can do the table i just can not remember how to do it

 

echoing the query won't really do anything. Try:

<?php
$find = mysql_query("SELECT * FROM `vistor_ip` WHERE date='$month$day$year'") or die(mysql_error());
$row = mysql_fetch_array($find);

echo $row['id']
// or whatever the column name is
?>

If you're displaying multiple results, use a while loop.