Need Advice On Two Points

[olygolfer]

Hi Could Someone Help Me With A Couple Of Coding Questions:

I have created the code below to fetch mysql rows with a certain value but every time i try it i get this error

Warning: Supplied argument is not a valid MySQL result resource in /homepages/14/d71795240/htdocs/frontfeature.php on line 15

This is the original code ignore the ********* for security

$db = mysql_connect ('******', '*****', '***');
mysql_select_db ('******');
$result = mysql_query ("Select product, price from products where frontfeatured = yes ",$db);
while ($myrow = mysql_fetch_array($result))
{
echo $myrow["product"];
}

My second question is how do you create html tables using php whenever I try to code I get errors like missing "" ' , parse error.

Could someone give me an example. Thanks For Your Help

[xblue]

if yes is a value and not a column name, it needs quotes.

also, use mysql_error() to get a more meaningful error message:

$query = "Select product, price from products where frontfeatured = 'yes'"; 
$result = mysql_query($query, $db) or die("Error: ".mysql_error()." in query: "$query);

[Loafin]

<table><tr><b><td>Product</td><td>Price</td></b></tr>
<?

while($row = mysql_fetch_assoc($query_result_handle))
        {

$printthis = "<tr><td>$row[product]</td><td>$row[price]</td></tr>";
        print $printthis;
                }
?>
</table>

I hope this helps

[Loafin]

$row['product'] and ['price'] would be correct. The other may still work, but it was an oversight.