mysql select statement

[Anon]

This sql statement is not working, can you tell me how i would write this statement.

$sql = "SELECT *
from names
WHERE name_id = \"1\"
AND name_id = \"2\"
ORDER BY user_name";

if ($name_id = "1"){
header ('Location:test.php');

}elseif ($name_id = "2") {
header ('Location:true.php')

}
is something wrong w/ my sql statement or my if statement

please help

[mattw]

Well, you are sticking the sql statment into a string and then doing nothing with it. Look into the database functions for the database you are using..for mysql, you would do something like this:

$sql = "SELECT * FROM names WHERE name_id = \"1\" AND name_id = \"2\" ORDER BY user_name";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);

if ($row['name_id'] == "1"){
header ('Location:test.php');

} elseif ($row['name_id'] == "2") {
header ('Location:true.php')

}

Now this will only test the first result sent back from that query...but hopefully will get you started...

Matt Wade
codewalkers.com

[Anon]

well the sql statement gives me trouble everytime i add the second WHERE (AND name_id =\"2\") it doesn't do anything it just brings out a blank page but if i remove the AND name_id = \"2\" then the browser goes to the link where the id is 1..

i don't understand why the sql statement doesn't work....

[mattw]

I was tired when I looked at this before..I see the problem right off now....you are using an AND instead of an OR...the name_id can't be 1 AND 2...try this:

$sql = "SELECT * FROM names WHERE name_id = \"1\" OR name_id = \"2\" ORDER BY user_name";

Matt Wade
codewalkers.com