Print results in order

stonefish

I have the following query that gets 3 rows from a table where ID = 1, 2 or 3. I then print out the columns of the matching rows - url & title.

$sql = "SELECT * FROM db WHERE id = \"1\" OR id = \"2\" OR id = \"3\" ;
$rs = mysql_query($sql,$conn);
while($row = mysql_fetch_array($rs)) {
echo "URL - ".$row['url']." Title - ".$row['title']." <br>";
}

How do I know what line refers to what ID, ie does the first line that is printed refer to the row where id = 1 or does it equal 2 or 3??

And i dont want to print out the ID and I only want to use the one SELECT statement.

I have tested this and it doesnt print out the results in the order of 1, 2, 3

Ludichrist

$sql = "SELECT * FROM `db` WHERE `id` = \"1\" OR `id` = \"2\" OR `id` = \"3\" ORDER BY id ASC";
$rs = mysql_query($sql,$conn);
while($row = mysql_fetch_array($rs)) {
echo "URL - ".$row['url']." Title - ".$row['title']." <br>";
}

Now the rows will be in ascending order.

stonefish

Hello,

the ID's are not always in ASC order ie -
$sql = "SELECT * FROM db WHERE id = \"2\" OR id = \"3\" OR id = \"1\"";

I want to list the results from ID=1 first followed by ID=2 the ID=3

Ludichrist

Can you describe your table, and give an example of how you want the data to be displayed?

Ludichrist

I'm a little thick today. You probably want to group your results by the id field, don't you?

SELECT * FROM `db` WHERE `id` = \"1\" OR `id` = \"2\" OR `id` = \"3\" GROUP BY ORDER BY id ASC

stonefish

if i run the following query -

$sql = "SELECT * FROM db WHERE id = \"2\" OR id = \"3\" OR id = \"1\"";

I want to be able to list any of the 3 results I like. For example I might want to just list the result where id=3, or I might want to list 3 results in the order of id=2, id=3 then id=1