[SOLVED] PHP mysql_fetch_array() not working?

[EPCtech]

Hello PHPfreaks.com,

I have a code in PHP that doesn't work for some reason. Could someone help me with it?

$mainsql=MySQL_Query("SELECT * FROM mainf");
while($maininfo=MySQL_Fetch_Array($mainsql))
{
$style=$maininfo['style'];
$slogan=$maininfo['slogan'];
$title=$maininfo['title'];$footer=$maininfo['footer'];
}

But, then, when I place it on a beta folder of my website, I get the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /****/*********/productsbeta/epmanage/index.php on line 32

(I replaced some parts with asterisks because I really don't want people to know them)

If anyone could help with this, it would be greatly appreciated.

 

Best Regards,

En-Psyche

[kenrbnsn]

Change

<?php
$mainsql=MySQL_Query("SELECT * FROM mainf");
?>

to

<?php
$q = "SELECT * FROM mainf";
$mainsql=MySQL_Query($q) or die("Problem with the query: $q on line " . __LINE__ . '<br>' . mysql_error());
?>

 

You should get an error message that should tell you the problem.

 

Ken

[dezkit]

uh, aren't you just setting variables, you aren't even echo-ing anything

[EPCtech]

dezkit: The query was the problem. Not echoing.

 

kenrbnsn: The code told me something that I now feel stupid about. I forgot to connect to the database.

 

Thanks for your help. This problem has been solved.