Why $row is EMPTY
| From: | Nasreen Laghari | Date: | Tue, 29 Apr 2008 18:27:57 +0000 |
| Subject: | Why $row is EMPTY | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44921@lists.php.net to get a copy of this message | ||
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