mysql_fetch_array help

[wd-]

Hey guys, I'm new to PHP, I had this small program made for me, and it gives an error, I was wondering if anyone could help me out.

The error is:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site8/fst/var/www/html/product.php on line 39

Here's the code:

	$link = mysql_connect($mysql_host, $mysql_user, $mysql_pass);
	mysql_select_db($mysql_db);

function display_value($request) {
	global $mysql_db, $link;
	$part_product = $_SERVER["PATH_INFO"];
	$q = "SELECT $request FROM $mysql_table WHERE product_name='$part_product'";
	$r = mysql_query($q);
	$result = mysql_fetch_array($r);
	echo $result[0];
}

Line 39 is: $result = mysql_fetch_array($r);

Thanks in advance for your replys!

[chads2k2]

$q = "SELECT $request FROM $mysql_table WHERE product_name='$part_product'";

Is not right....

$q = "SELECT * FROM $mysql_table WHERE product_name='$part_product'";

Maybe it would help to tell us what $request is and what is supposed to be defined as entering the loop.

Chad

[wd-]

Thank you for your reply, Chad.

I am not sure what $request is... as I mentioned I did not write the script.

I call the function with display_value("field_name");

display_value("product_name"); is the only other line of code in the script (other than mysql user/pass etc)

[wd-]

Well I guess $request is the function param...
display_value("product_name"); in this case..

Are you able to help?

Replacing the $q = statement didn't work.

[uniflare]

Try This:

    function display_value($request) { 
        global $mysql_db, $link, $mysql_table; 
        $part_product = $_SERVER["PATH_INFO"]; 
        $q = "SELECT \"".$request."\" FROM `".$mysql_table."` WHERE \"product_name\"='".$part_product."'"; 
        $r = mysql_query($q); 
        $result = mysql_fetch_array($r); 
        echo $result[0]; 
    }

[thegraham]

that script seems much more complicated than it needs to be:

//php
$result = mysql_query("SELECT '".$request."' FROM '".$mysql_table." 'WHERE 'product_name' ='".$part_product."'");
$row = mysql_fetch_array($result, MYSQL_NUM));
// i would actually use MYSQL_ASSOC instead of MYSQL_NUM - it is easier to understand
echo $row[0];
// you would use echo $row[$request] with ASSOC

hope thats helpful