foreach () to display multiple table rows

ali_p

Hi,
i am trying to use foreach() to loop through and run several queries.

i have a variable called $row[query] which is coming out of a table which stores several queries, these queries contain a mysql select statement such as SELECT * FROM jobs where etc.

Now i would like to access them all and just print them to screen. This is what i have been using but to no avail:


if (isset($row[query]) && is_array($row[query])) { 
foreach ($row[query] as $value){

echo "value: $value<br>\n";
exit;

}
}

What i expected to see was
SELECT FROM jobs WHERE country = 'AU'
SELECT FROM jobs WHERE country = 'TY'
SELECT * FROM jobs WHERE country = 'HH'

And so on for every row in my table.
Eventually these will be used to produce seperate queries themselves but for now i just want to see them listed.
i think my use of foreach is very wrong. Any help will be much appreciated.

Thanks

laserlight

Out of curiosity, why do you use exit?

ali_p

Sorry i forgot to take it out for this posting.
(Basically I have other code on the page that i do not want to run)

Najjar

(Basically I have other code on the page that i do not want to run)

Then you need the "exit" outside the loop.

ali_p

Hi,
Can we forget about the exit; please, because even when i remove it and remove all additional code on my page my problem remains. I cannot get the foreach to loop through and prints all rows.
Would the foreach not work because it does not see the variable $row[query] as an array?

Thanks

Najjar

Are you getting any error at all, or nothing?
Check if $row[query] is an array or not and "count" how many values are in there.

ali_p

Hi,

I am beginning to doubt that it is an array as i get nothing at all displayed on the screen. How then do i go about making it an array that i can work with??

Thanks

homchz

If you are not comparing anything together why not just use

print "Value: $row[query]";
[code=php]

After your query to get the queries (boy that sounds complicated :D)

So

[code=php]
$sql = mysql_query("Select query FROM table");
if (mysql_num_rows($sql) > "0")
    {
        while ($row = mysql_fetch_array($sql))
           {
                print "Value:$row[query]";
           }
     }

mysql_fetch_array() returns your query into an array

That is how I would do it. Assuming I am understanding your question

Najjar

If $row[query] is an output of the query then I agree with "homchz"
The only thing I would change is: mysql_num_objects instead or mysql_num_rows.
and to output that you use $row->TableFieldName.

Roger_Ramjet

I'm just guessing cos you ain't very clear about it and did not post enough code.

You run a query that returns a resultset that includes a column called 'query' which contains one sql statement per record. So why do you need an array?

answer: You don't.


while ($row = mysql_fetch_array($result)) {
   echo $row['query'];
}