PHP Error

[ub911]

I get this error when running this code Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource. The code is

<?php


function fetch_products(){
$sql = "SELECT 'product_id','product_name' FROM 'products'";

$result = mysql_query($sql);
$products = array();

while(($row = mysql_fetch_assoc($result)) !== false){
$products[$row['product_id']] = $row['product_name'];
}

return $products;


}




?>

I read around and someone said this is because the code isnt linking properly to the DB. However if I do

<?php


function fetch_products(){

$result = mysql_query("SELECT * FROM products");
$products = array();

while(($row = mysql_fetch_assoc($result)) !== false){
$products[$row['product_id']] = $row['product_name'];
}

return $products;


}


?>

[ub911]

Then the code works fine however as I go on coding using this tut http://www.youtube.com/watch?v=DZRxxAGCSlI. The actual voting part doesnt work if needed i can post voting part

[dalecosp]

Welcome to PHPBuilder.

Please consider learning and using the mysqli (MySQL Improved) API/function set instead of the deprecated mysql functions, which have been outdated for quite some time.

I'd recommend calling mysqli_error() [mysql_error() using the old API as you are, above] to see if you can gain any insight:

$sql = "SELECT 'product_id','product_name' FROM 'products'";

$result = mysql_query($sql);

if (!$result) {
   echo "No result ... mysql said: ".mysql_error();
} else {
   $products = array();
   while(($row = mysql_fetch_assoc($result)) !== false){ 
      $products[$row['product_id']] = $row['product_name'];
   }
}

HTH,

[Wynder]

You're using regular quotes as opposed to backticks.

Try simply:

SELECT product_id, product_name FROM products