Printable Version of Topic

Click here to view this topic in its original format

HTMLHelp Forums _ Databases _ help With error

Posted by: minidiapolis Oct 6 2011, 05:45 PM

Why am I getting this error?
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

<?php
require_once("functions.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
DatabaseConnection();

$query= "SELECT * FROM treats";
$result_set= mysql_query($query);

$output = "<table>";
while($row = mysql_fetch_array($result))
{
$productDetail1['product_id'];
$productDetail2['product_title'];
$productDetail3['product_Description'];
$productDetail4['price'];
$productDetail5['product_pic'];
$output .= ("
<tr>
<td>".$productDetail1['product_id'] ."</td>
</tr>
")
;}
$output .= "</table>";
echo $output;
?>
</body>
</html>

Posted by: pandy Oct 6 2011, 07:17 PM

See if this helps.
http://forums.devarticles.com/mysql-development-50/mysql-fetch-array-supplied-argument-is-not-a-valid-mysql-3251.html

Posted by: minidiapolis Oct 6 2011, 07:32 PM

that didn't help. I just want to put data from a database into a two column table. I changed the code. Any suggestions?

<?php
require_once("functions.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
DatabaseConnection();

$query= "SELECT * FROM treats";
$result_set= mysql_query($query) or die(mysql_error());
/*
$output = "<table>";
while($row = mysql_fetch_array($result))
{
$productDetail1['product_id'];
$productDetail2['product_title'];
$productDetail3['product_Description'];
$productDetail4['price'];
$productDetail5['product_pic'];
$output .= ("
<tr>
<td>".$productDetail1['product_id'] ."</td>
</tr>
")
;}
$output .= "</table>";
echo $output;*/
while($row = mysql_fetch_array($result))
{
echo "<table>";
echo "</td><td>";
echo $row['product_id'];
echo "</td><td>";
echo $row['product_title'];
echo "</td><td>";
echo "</rd></tr>";
}
echo "</table>";

?>
</body>
</html>

Posted by: minidiapolis Oct 6 2011, 10:41 PM

problem resolved

Posted by: pandy Oct 7 2011, 05:00 AM

It would help others with the same problem if you told us how. Share a little sometimes, minidiapolis. It doesn't hurt.