Results of SQL as variable???

[xadmin]

Is this possible???

<?php
if ($fp_ext == "yes" && $package == "$PACKAGE")
{
$getip = mysql_query("SELECT * FROM list WHERE status = 'inactive' ",$db);

								while ($iprow = mysql_fetch_array($getip))
								{
								//do something	
								}

?>

the value of $PACKAGE should be the results of this query:

$do_get = mysql_query("SELECT * FROM packages WHERE status='active' && based='yes'");
$num_rows = @mysql_numrows($do_get);

Any ideas would be GREATLY appreciated.

[tomkleijkers]

This won't work. You'll have to nest your SQL statement like:

SELECT FROM list WHERE status = 'inactive' AND '$package' IN ( SELECT FROM packages WHERE status='active' && based='yes' )

This will work i think, but i don't know for sure because i don't exactly know the correct SQL statement.

[xadmin]

Hi,

My problem it not so much getting the right data out of mysql, but rather what do with it when I get it. The results of the query:

$do_get = mysql_query("SELECT * FROM packages WHERE status='active' && based='yes'");
$num_rows = @mysql_numrows($do_get);

end up in an array. I can get each value by calling $myarrayname[0], $myarrayname[1], and so on. What I would like to do is this because I have no idea how many records will be returned:

if ($fp_ext == "yes" && $package == "ALL MY ARRAY VALUES")

instead of:

if ($fp_ext == "yes" && $package == "$myarrayname[0]" || "$myarrayname[1] etc…")

Thanks for your post, any additional ideas world be appreciated

[tomkleijkers]

Search for the function mysql_fetch_array(); thats the function to do it.

[xadmin]

Just in case someone else needs help with this, TheRealBeale from experts-exchange gave me the answer.

quote:

I'm assuming that you want to either tabulate the results of the query or apply a function to each returned bit of information based on a condition.

Hope this code snippet might be of some use.

<?
dbconnect(); //Calls function to connect to the DB
$result = mysql_query($query); //$query is my query string
$numresults = mysql_num_rows($result); //how many rows?

for ($n=1; $n<=$numresults; $n++)
{
$row = mysql_fetch_array($result);
if ($row[package_name]==$somevar)
{
do something;
}
}
?>

Hope that's of some use.

Regards

Beale