从基于Array的mysql中提取数据

Question

I have a file file.php and inside my file I am using the code bellow to pull some data from my database and display some information.

My code is

$array = $_GET['theurl']; // My url looks like myfile.php?theurl=1,2,3 (id,s)
$sqlnt4 = "select * from mytable WHERE `id` IN ($array)";
$rsdt4 = mysql_query($sql);
$tc4a = mysql_fetch_assoc($rsdt4);
$mycomma4 = ",";
if ($tc4a['a_youtube'] == "#"){
}else{
    while ($tc4 = mysql_fetch_assoc($rsdt4))
    {
        echo $tc4['a_youtube'];
        echo ",";
    }
}

I expect to echo the infos of the two id's (in array) inside my while function, but it returns the results only from the first.

Any ideas?

Answer 1

I am confusing on $sql :

$sqlnt4 = "select * from mytable WHERE `id` IN ($array)";
$rsdt4 = mysql_query($sql);

Can you take a look after changing below:

$sqlnt4 = "select * from mytable WHERE `id` IN ($array)";
$rsdt4 = mysql_query($sqlnt4);