Jump to content


Photo

If date is > current date help PLEASE


  • Please log in to reply
1 reply to this topic

#1 AARisAIR

AARisAIR
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 08 January 2006 - 02:14 AM

Ok, basicly the sql database has a stored date and if the current date is < the stored date it will do the php function, if not you get an error. But right now my it just skips the date check and does the other things in the query. Below is my query in php/sql.

$date=date("Y-m-d");
$result = mysql_query("SELECT * FROM `items` where `id` = $yourid and `innum` > $yournum and `date` > '$date'", $link);

the date in mysql is 2006-01-05

EDIT: it works find in sqllog or any other sql program but the php code dosnt.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 08 January 2006 - 06:56 AM

So the problem is WHAT?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users