search db by date
Posted: Wed Dec 07, 2005 7:09 am
$datum = time();
All entries in db in field 'date' are inserted with value of $datum at the time of inserting into db
Is folowing code correct to search db in column 'date' where 'date' = '21.10.2005'
All entries in db in field 'date' are inserted with value of $datum at the time of inserting into db
Is folowing code correct to search db in column 'date' where 'date' = '21.10.2005'
Code: Select all
$datum = $_POST['pojam'];
include("../stranice/con_db.php");
$result = mysql_query("select * from $table_name where
date = date("d.m.Y ", $datum)") or
die (mysql_error());
while($row = mysql_fetch_array($result))
{
etc......