FUBAR! Error when using mysdl_fetch_array

timgray

I am ready to see if my computer can fly...literally. I am stuck on a seemingly simple code snippet. All I want to do is connect to a database and return the results.

I already have a page that works using a different database, and have tried cutting/pasting, but still get an error. Can someone please have a look at this code and tell me what my problem is?

<HTML>
<HEAD>
<TITLE>Retrieving Data from a Database</TITLE>
</HEAD>
<BODY>

<?php
// Set the variables for the database access:
$Host = "www.yourserver.com";
$User = "username";
$Password = "password";
$DBName = "database";
$TableName = "table";

$Link = mysql_connect ($Host, $User, $Password);

$Query = "SELECT * from $TableName";
$Result = mysql_db_query ($DBName, $Query, $Link);

// Create a table.
print ("<TABLE BORDER=1 WIDTH=\"75%\" CELLSPACING=2 CELLPADDING=2 ALIGN=CENTER>\n");
print ("<TR ALIGN=CENTER VALIGN=TOP>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>ID</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Title</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>Article</TD>\n");
print ("</TR>\n");

// Fetch the results from the database.

while ($Row = mysql_fetch_array($Result)) {

print ("<TR ALIGN=CENTER VALIGN=TOP>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$Row[ID]</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$Row[Title]</TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP>$Row[Article]</TD>\n");
print ("</TR>\n");

}
mysql_close ($Link);
print ("</TABLE>\n");
?>
</BODY>
</HTML>

Any help would be greatly appreciated.

Thanks!

Tim

nnichols

Try adding this after the query execution -

if (!$Result) { echo 'Error: ' . mysql_error();}

and see what it tells you.

timgray

This is what it gives me:

Warning: Supplied argument is not a valid MySQL result resource in /usr/local/plesk/apache/vhosts/timothymartingray.com/httpdocs/test1.php on line 31

FYI, line 31 is the mysql_fetch_array

nnichols

If you add the line I gave you, you will see a line saying "Error: blah blah"

The problem is with the execution of the query. It is not returning a result set.

Please try again

timgray

I figured it out. My problem was with how I was connecting.

Essentially, I thought of each MySQL user having access to any number of databases on the server. This is not the case (or at least it isn't with my hosting provider).

I was trying to connect to one database using a username and paasword assigned to a second database.

Dumb, dumb, dumb 😉

Thanks for your help. I really appreciated you getting back to me so quickly. It's nice to see PHPBuilder has such an active community.

Thanks!

Tim