Code: Select all
$sqlstring3 = "SELECT ///// ";
$result2 = mysql_query($sqlstring3);
while ($row = mysql_fetch_array($result2, MYSQL_ASSOC))
{
$strquery .= " ".$row["numbers"].", ";
}
mysql_free_result($result2);
213, 321, 123, 221, 321,
which is great but how do insert that into the next query? I am currently doing this.
Code: Select all
$query = "select * from ??? where number IN (".$strquery.") order by Value";
Code: Select all
$query = "select * from ??? where number IN (213, 321, 123, 221, 321, ) order by Value";
any help on how to alter this
Code: Select all
while ($row = mysql_fetch_array($result2, MYSQL_ASSOC))
{
$strquery .= " ".$row["numbers"].", ";
}
to get the last value to do 321) not a 321, )???