MySQL: Help Needed With MySQL_fetch_array() Error help needed

[Cookiemonster1405241499 0]

I have my site up and running, it it written in php but the problem im getting is the mysql database the warning is:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mrogers/public_html/config.php on line 47but on line 47 it shows this:$email = mysql_fetch_array($adminemail);any one help on this + my site wont connect to my database. I have feeled out all the requirements that has asked and i know its write.All help would be apreciated as i would like my site fully functional by next week.

Edited June 20, 2005 by microscopic^earthling (see edit history)

[vizskywalker 0]

Without a greater block of code to know what $adminemail represents we can't help you. And the error message that MySql gives you would help us assess the problem.~Viz

[Cookiemonster1405241499 0]

I could give you the config file if you want or my web address so you may see what the problem is as i would really like to get this problem fixed.

[vizskywalker 0]

Both the php script you wrote (with username and password x'ed out for security and the web address would be helpful.~Viz

[Houdini 0]

what it looks like is the config file for a PHP-Nuke but nevertheless look at the below code: I host a Nuke on Xisto so you should be similar.

$dbhost = "localhost";

$dbuname = "XXXXXX";

$dbpass = "XXXXXX";

$dbname = "yourUsername";

$prefix = "nuke";

$user_prefix = "nuke";

$dbtype = "MySQL";

$sitekey = "S·kQSd5%W@Y62-dm29-.-39.3a8sUf+W9";

$gfx_chk = 0;

$subscription_url = "";

$admin_file = "admin";

$advanced_editor = 0;

$display_errors = 0;

If you go to your site lets say http://forums.xisto.com/no_longer_exists/ and it shows Sorry there seems to be a problem with the MySQL server you have not set up your database. If you are using PHP-Nuke then this is the case I run a standard PHP-Nuke and also an IPB-Nuke site (it has IPB forums instead of phpBB) and I write ported MODs for PHP-Nuke and I also modify the IPB boards mostly cause I don't like the crappy button in the posting area.

 

If you want further help send me a PM or email and I'll correct you code in a few minutes.

[miCRoSCoPiC^eaRthLinG 0]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mrogers/public_html/config.php on line 47

 

but on line 47 it shows this:

 

$email = mysql_fetch_array($adminemail);

 

any one help on this + my site wont connect to my database. I have feeled out all the requirements that has asked and i know its write.

<{POST_SNAPBACK}>

See this is your second post with almost exact same problem - we've told you before, unless you can post a good part of the code it won't be possible to crack the problem in any way. This way at best, we can make some wild guesses - such error messages can be caused by over a million different reasons. You'll never get a good reply unless you're more specific with your problem.

[fabiocardoso 0]

In this case $adminemail has that to be the result of a valid query. Something as:$adminemail = mysql_query("SELECT email FROM table";I wait to have helped.

[ajmal 0]

@fabio: are you Brazilian? Your name and the way you write just looks Brazilian =)@Houdini: the piece of code you post won't help; you must use mysql_connect() to actually connect to the database.@Cookiemonster: Your problem is exactly what it says; "argument is not a valid MySQL result resource ". Do what fabio told; or something like:$adminemail = mysql_query("SOMEQUERYHERE") or die (mysql_error());which will return an error if any