Posted: Sat Jun 19, 2004 10:56 pm
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";
}
?>