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 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.

All help would be apreciated as i would like my site fully functional by next week.

This post has been edited by microscopic^earthling: Jun 20 2005, 03:08 AM

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

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.

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

~Viz

what it looks like is the config file for a PHP-Nuke but nevertheless look at the below code: I host a Nuke on Astahost so you should be similar.
[CODE]$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;[QUOTE] If you go to your site lets say http://mynewsite.astahost.com/ 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.

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.

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.

@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