Re: Loops

Hello Steve, Tuesday, December 14, 2004, 3:52:26 PM, you wrote: SM> I would like to loop the multiple variables rather than put all the SM> variables into a single variable with an array. I can not figure out how to SM> do this. I assume you have placed the MySQL query and checked the number of rows it has returned? You could just do: while ($row == mysql_fetch_assoc($result)) { $name = $row['name']; $desc = $row['description']; echo "$name <br />"; echo "desc <br />"; } This is just one of many ways of performing the same task. You could use a for() loop based on mysql_num_rows, you could use fetch_array instead of assoc. If you are only extracting a couple of details then you could even use mysql_result($result, $record, 'name'). I would suggest you take a look in the PHP manual, there are many examples of this. Best regards, Richard Davey -- http://www.launchcode.co.uk - PHP Development Services "I am not young enough to know everything." - Oscar Wilde