Problem pulling data from a database table using PHP

**kiacovin71** · 04-17-2011 11:13 AM

this code:

<html>
<head>
<title>php</title>
</head>
<body>
<h1>Show Database </h1>
<?
//make the database connection
$conn = mysql_connect("localhost", "clocky_time", "********");
mysql_select_db("clocky_clock", $conn);

//create a query
$sql = "SELECT * FROM clock_clock";
$result = mysql_query($sql, $conn);

print "<table border = 1>\n";

//get field names
print "<tr>\n";
while ($field = mysql_fetch_field($result)){
print " <th>$field->name</th>\n";
} // end while
print "</tr>\n\n";

//get row data as an associative array
while ($row = mysql_fetch_assoc($result)){
print "<tr>\n";
//look at each field
foreach ($row as $col=>$val){
print " <td>$val</td>\n";
} // end foreach
print "</tr>\n\n";
}// end while

print "</table>\n";
?>
</body>
</html>

which I changed from some code that works on my friends godaddy account is giving me the error:

"Show Database

Warning: mysql_fetch_field(): supplied argument is not a valid MySQL result resource in /home/clocky/public_html/showalldata.php on line 20

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/clocky/public_html/showalldata.php on line 26
"

Any ideas? Besides that I really like x10hosting

**descalzo** · 04-17-2011 11:35 AM

Warning: mysql_fetch_field(): supplied argument is not a valid MySQL result resource in /home/clocky/public_html/showalldata.php on line 20

Look at what it is telling you. Count lines or use the Code Editor in cPanel or note the place you call mysql_fetch_field is

Code:

while ($field = mysql_fetch_field($result))

It is saying that $result is not a valid result. Where did it come from?

Code:

$result = mysql_query($sql, $conn);

mysql_query returns a result object on SELECT queries (even if there are no matches), unless there is an error. Hence you have an error.

To display the problem, always test the return value of the query.

Code:

$result = mysql_query($sql, $conn);
if (!$result) {
    echo('MySQL error: ' . mysql_error());
}

Thread: Problem pulling data from a database table using PHP

LinkBack

Thread Tools

Display

Problem pulling data from a database table using PHP

Re: Problem pulling data from a database table using PHP

Similar Threads

query multiple tables and present data depending on the table

HTML Table from SQL Data

Suggestions for best way to build a MySQL table from raw data?

Database table gone

Posting Permissions