Thread: a query problem
View Single Post
  #4 (permalink)  
Old 12-20-03, 11:52 AM
darkcarnival's Avatar
darkcarnival darkcarnival is offline
PHP/MySQL coder
 
Join Date: Jun 2003
Posts: 939
Thanks: 0
Thanked 0 Times in 0 Posts
hi,

i fixed it but theres still 1 small problem. the date doesnt appear it shows 0000-00-0000 heres the fixed code:

PHP Code:



while ($row mysql_fetch_array ($resultsMYSQL_ASSOC)) {
 echo 
"<A HREF=\"{$row['Address']}\">{$row['Name']}</A> - {$row['Description']}<br>\n";

mysql_query("INSERT INTO SSearch_log (Catagory, Keyword, Date) VALUES ('$Choice', '$keyword', '$date')");

and if you need to know what $date look like:

PHP Code:

$date Date("j-d-Y"); 

i hope someone can help me with this. thx
Reply With Quote