Actually this ended up doing what I needed:
$result = mysql_query($sql) or die(mysql_error()); $header = false; while($row = mysql_fetch_assoc($result)){ if(!$header){ echo ($row['name']),'<br>'; echo ($row['address']),'<br>'; $header = true; } echo ($row['inDate']),'<br>'; echo ($row['inType']),'<br>'; echo ($row['notes']),'<br>'; echo ($row['critical']),'<br>' ; echo ($row['cviolations']),'<br>'; } }
On 7/16/09 2:53 PM, "Kyle Smith" <kyle.smith@xxxxxxxxxxxxxx> wrote:
Miller, Terion wrote:
Why is this an invalid argument?
foreach(($row['inType']) as $inType){
echo $inType,'<br>';}
I am trying to output results from a data base that may have multiple
results for the same name....
So trying to use an array and foreach that is the right track ...right?
Looks like you meant to do something like this:
// Always better to be plural when you have an array.
$rows = whatever_your_rows_come_from();
foreach($rows as $row)
{
$inType = $row['inType'];
echo $inType . '<br />';
}
HTH,
Kyle
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
