Page 2 of 2

Posted: Sat Jun 19, 2004 10:56 pm
by feyd
no they can be used.. the following will kick out all the data returned.

Code: Select all

<?php

$query = "SELECT IDArea, Parent1 FROM family 
INNER JOIN area USING(IDArea) 
INNER JOIN basics USING(IDArea) 
WHERE basics.IDarea = '" . $mycode . "'"; 

$result = mysql_query($query) or die(__FILE__.'('.__LINE__.') '.mysql_error());

if(!mysql_num_rows($result))
 die("no data returned for query "$query"";

$rowcount = 0;
while($row = mysql_fetch_assoc($result))
{
  echo "{$rowcount}. IDArea = '{$row['IDArea']}'; Parent1 = '{$row['Parent1']}'; <br />\n";
}

?>

Posted: Sun Jun 20, 2004 3:07 pm
by David B
OK, thanks.