Need help beating my query into submission...

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

User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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";
}

?>
David B
Forum Newbie
Posts: 9
Joined: Sat Jun 19, 2004 3:38 pm
Location: Seattle

Post by David B »

OK, thanks.
Post Reply