PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Moderator: General Moderators
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » 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";
}
?>
David B
Forum Newbie
Posts: 9 Joined: Sat Jun 19, 2004 3:38 pm
Location: Seattle
Post
by David B » Sun Jun 20, 2004 3:07 pm
OK, thanks.