mysql_fetch_assoc() expects parameter 1

[apachelearner]

Hi,

When I place my php file in the browser, I encounter the following error :

mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\products.php on line 8

products.php :

Code: Select all

<?PHP
$link=mysql_connect("localhost","","");
mysql_select_db("brimelow_store");
$query='SELECT * FROM products';
$results=mysql_query($query);
echo "<?xml version=\"1.0\"?>\n";
echo "<products>\n";
while ($line=mysql_fetch_assoc($results)){
    echo "<item>".$line["pruduct"]."</item\n";
}
echo "</products>\n";
mysql_close($link);
?>

Which part that causes error, please point out.

[Altrea]

Hi apachelerner,

Which part that causes error, please point out.

output errors with the help of mysql_errno() and mysql_error() to find it out yourself.

best wishes,
Altrea

[apachelearner]

Although try many ways but still can't solve.

[Altrea]

Although try many ways but still can't solve.

Sorry but i don't believe that.

The error message says, that mysql_fetch_assoc() expects parameter 1 ($result) to be a resource (to be as specific as possible: a MySQL result set).
It contains a boolean value instead, which is most common the value false.
You have to find out why $result contains false.

The way to find that out is to implement mysql error functions on every place where a mysql command can fail (connection, db selection, query).
Show us how you have tried to implement the error functions and we can continue to give you specific help.
But we will not do the debugging work for you.

best wishes,
Altrea

[apachelearner]

Hi, I use the following in the browser and got this : 0: 0:

<?php
$link = mysql_connect("localhost", "root", "");

mysql_select_db("brimelow_store", $link);
echo mysql_errno($link) . ": " . mysql_error

($link). "\n";

mysql_select_db("brimelow_store", $link);
mysql_query("SELECT * FROM products", $link);
echo mysql_errno($link) . ": " . mysql_error

($link) . "\n";
?>

What does it mean ?

[Altrea]

Try this:

Code: Select all

<?php
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}

$db_selected = mysql_select_db('brimelow_store', $link);
if (!$db_selected) {
    die ('Can\'t use brimelow_store: ' . mysql_error());
}

$result = mysql_query("SELECT * FROM products", $link);
if (!$result) {
    die('Invalid query: ' . mysql_error());
}
?>

[apachelearner]

Hi,
I add some lines to your code, no errors, and it works.
Your guide and hints very helpful to me.
Thanks a lot,

<?php
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
die('Could not connect: ' . mysql_error());
}

$db_selected = mysql_select_db('brimelow_store', $link);
if (!$db_selected) {
die ('Can\'t use brimelow_store: ' . mysql_error());
}
$sql = 'SELECT product FROM products';
$result = mysql_query($sql, $link);
if (!$result) {
die('Invalid query: ' . mysql_error());
}

while ($row = mysql_fetch_assoc($result)) {
echo $row['product'];
}

mysql_free_result($result)
?>