Using PHP variable

[johnnycabbage]

How could this be done? It won't allow me to use the $id variable in the mysql_query() function:

PHP Code:

if (isset($_GET["id"]))
   {
   $id = explode(":",$_GET["id"]);
}

$result = mysql_query("SELECT * FROM Articles WHERE `ID` = $id"); 


[minder]

The explode function returns an array. You can't just plug an array of values into an sql query.

What do you want to do? Do you want to have the array values as part of an IN list in your sql query?

[johnnycabbage]

You're right, well how could I convert the array into an integer?

[johnnycabbage]

Wait, using my previous Perl knowledge, I managed to figure it out:

PHP Code:

  if (isset($_GET["id"])) 
   { 
   $id = explode(":",$_GET["id"]);
 }   
$articleid = $id[0];
echo $id['0'];
$result = mysql_query("SELECT * FROM Articles WHERE `ID` ='$articleid'");