Re: Will this return a value?

[Jay Pipes]

Neither. mysql_query() returns a resource identifier, which you can then use with mysql_fetch_array() or mysql_fetch_row(), or false if there was an error, which there will be with your code.

Try:

$sql = "SELECT prod_title FROM products WHERE prod_id = '" . $array['spec_prod_id'] . "'";
if ($result = mysql_query($sql)) {
$row = mysql_fetch_array($result);
echo 'Title: ' . $row['prod_title'];
}
else {
echo 'Error: ' . mysql_error();
}

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com