LMPX.COM |
Home | Linux | Mysql | PHP | XML | ||
|
|
|||
From: Nasreen Laghari Date: Tue Apr 29 12:27:57 2008 Subject: Why $row is EMPTY
Hi,
Why my program is not going in while loop? When I run the same query in SQL cmd, it brings result but here when I print $result gives Resouce ID number means $result has data then why $row is empty.
$query = 'SELECT * FROM `gig` LEFT JOIN genre ON gig.genreId=genre.genreId LEFT JOIN venue ON gig.venueID = venue.vid where gig.gigid = '.$gigDetail.' ORDER BY gig.gigid';
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
echo "Program is in While loop";
$g_name = $row["gig.gigName"];
$vname = $row["venue.venueName"];
$genre = $row["genre.name"];
echo("Gig Name: ".$g_name);
}
Regards
Nasreen
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
| Navigate in group php.db at sever news.php.net | |
| Previous | Next |
| © No Copyright You are free to use Anything |
Site Maintained by PHP Developer
Powered By PHP Consultants |