does my database query look correct please cheers..

[redarrow]

advance thank you.

 

<?php
$result = mysql_query("SELECT * FROM users where id='id' AND ORDER BY id ");
?>

[trq]

We wouldn't have a clue. Do you have a field called id that holds a value of id[/]?

[redarrow]

Just want to no how to use the order by with a id='$id'

 

please and thank you.

 

database

 

users.

 

id

name

 

 

$res="select * from users where id='$id' order by id";

$res_result=mysql_query($res)or die(mysql_error());

 

 

Does it look correct trying to learn the order by and id='$id'

 

Also this trying to learn.

 

$res="select id , name,  from users where id='$id'  FIRST(order by id) group by name";

$res_result=mysql_query($res)or die(mysql_error());

 

 

 

 

[blueman378]

take out the AND