[thelist] php/mySQL error...
Tom Dell'Aringa
pixelmech at yahoo.com
Fri Jul 18 13:23:48 CDT 2003
Hi folks,
Can't figure this out:
mysql_fetch_array(): supplied argument is not a valid MySQL result
resource
I wrote a function to get some content:
function PrintSidebarMain()
{
// select sidebarMain content
$result = @mysql_query("SELECT sidebarMain FROM sidebar");
// Get db results
$qResult = mysql_fetch_array($result);
$sbMain = $qResult["sidebarMain"];
print $sbMain;
}
which is called in my page:
<?= PrintSidebarMain(); ?> (not sure if I need the "=" there...)
Anyway, the same code works for another query I have, but not here. I
do have a valid db connection, and I do have content in the db.
What have I done wrong?
Tom
=====
http://www.pixelmech.com/ :: Web Development Services
http://www.DMXzone.com/ :: Premium Content Author / JavaScript / Every Friday!
http://www.maccaws.com/ :: Group Leader
[Making A Commercial Case for Adopting Web Standards]
"That's not art, that's just annoying." -- Squidward
More information about the thelist
mailing list