My while php mysql query?

Question

Hi,
Whats wrong with my query, i get notces saying its not a valid mysql statement....

$entrys=mysql_query("SELECT * FROM tags WHERE user_id='$user_id' AND approved_tag_flag = 1 ORDER BY date_of_tag");

while($e=mysql_fetch_array($entrys))
{
$page = $e['tag_id'];
$locationforlink = "&tagid=". $e['tag_id'];
}

it cut off this in the middle:

while($e=mysql_fetch_array ($entrys))

Answer 1

Add "DESC" or "ASC":

$entrys=mysql_query("SELECT * FROM tags WHERE user_id='$user_id' AND approved_tag_flag = 1 ORDER BY date_of_tag DESC");

And... "entries", not "entrys" :P

Answer 2

I'm assuming $user_id is a php variable that you have already defined. Your query looks ok provided the fields user_id, approved_tag_flag and date_of_tag are named correctly.

I'd add 'echo $entrys' before running the query to make sure the SQL looks how you expect it to. You can then remove this once your code works as you want it to.

Can you execute a simple query like 'SELECT * FROM tags'? This will tell you if the problem is connecting to your database or if it is your SQL statement.

Answer 3

You have not read my previous note again!

$entrys=mysql_query("SELECT * FROM tags WHERE user_id='$user_id' AND approved_tag_flag = 1 ORDER BY date_of_tag");

WHERE ` user_id ` = ' " . $user_id . " ' AND

(spaces added for visibility)

Watch the `, ', ", and . !
(You do not need to put ASCending or DESCending: it is ASCending by default)

Answer 4

You need to add DESC or ASC on your order by