SQL ??

[Anon]

Greetings

I am, trying to get 2 maps out of a database using 2 variables. But when I put the clause AND it does not give me second map ie see below.

This scrip works

$map1 = 1;

function listmaps( $map1 )
{
$result = mysql_query ( "SELECT * from mpn_war_maps WHERE id='$map1' ");
while ( $a_row = mysql_fetch_array( $result ))
{
echo "$a_row[1]";
}
}
then all I have to do is
listmap( $map1); to display result. But i cannot get 2 out ie
##############################################

$map1 = 1;
$map2 = 2;

function listmaps( $map1, $map2 )
{
$result = mysql_query ( "SELECT * from mpn_war_maps WHERE id='$map' AND id='$map2' ");
while ( $a_row = mysql_fetch_array( $result ))
{
echo "$a_row[1]";
}
}

lismaps ( $map1, $map2 );

I am abviously doing something wrong. Please advise me if ya can.

Thanks

[rrijnders]

You can't use <b>AND</b> in that context. What you are asking the DB to do is return any row where id=1 and id=2 <i>at the same time</i>. Since it is impossible for a single record to have two different id's at the same time, you will get nothing.

What you really want to do is use <b>OR</b>:

$result = mysql_query ( "SELECT * from mpn_war_maps WHERE id='$map' <b>OR</b> id='$map2' ");

That should return your two records.

-- Rich