[SOLVED] SELECT statement

[thomashw]

Can someone tell me what's wrong with this? I am getting an error saying there is something wrong with the SQL syntax.

 

$result = mysql_query("SELECT * 
FROM product, product_attributes, product_options 
WHERE product.product_id={$id} 
AND product_attributes.options_id=product_options.product_options_id, 
product_options.product_options_id=product_options_values_to_product_options.product_options_id, 
product_options_values_to_product_options.product_options_values_id=product_options_values.product_options_values_name") or die(mysql_error());

[revraz]

Post that error

[Ken2k7]

What are you trying to do?

[thomashw]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' product_options.product_options_id=product_options_values_to_product_options.' at line 4

[GingerRobot]

You should be using AND, not a comma to separate the different conditions of the WHERE clause:

 

<?php
$result = mysql_query("SELECT * FROM product, product_attributes, product_options WHERE product.product_id={$id} 
AND product_attributes.options_id=product_options.product_options_id AND  
product_options.product_options_id=product_options_values_to_product_options.product_options_id AND 
product_options_values_to_product_options.product_options_values_id=product_options_values.product_options_values_name") or die(mysql_error());
?>

[thomashw]

I might as well post the whole code. If you see any problems with it please let me know!

 

<?
$result = mysql_query("SELECT * 
FROM product, product_attributes, product_options 
WHERE product.product_id={$id} 
AND product_attributes.options_id=product_options.product_options_id, 
product_options.product_options_id=product_options_values_to_product_options.product_options_id, 
product_options_values_to_product_options.product_options_values_id=product_options_values.product_options_values_name") or die(mysql_error());
$count = 0;
while($name = mysql_fetch_assoc($result)) {
if(mysql_num_rows($name) > 0) {
if($count==0) {
echo "<tr>\n<td>\n<label>\n<span>";
echo $name["product_options_name"];
echo "</label></span></td>";
++$count;
}}}
echo "<tr>\n<td>";
echo "<td align=\"left\" class=\"productdrop\">";
echo "<select name=\"cat1\">";
$count = 0;
while($form = mysql_fetch_assoc($result)) {
if(mysql_num_rows($result) > 0) {
if($count==0) {
echo "<option value=\"Quantity&#58; 16\">$form[product_options_values_name]</option>";
}}}
?>

[Ken2k7]

Did you read GingerRobot's post?

[thomashw]

Yep, I was posting at the same time as him. I feel like an idiot now. Thank you!

[GingerRobot]

No problem. Can you mark this as solved if you're all done?

[thomashw]

Okay. Done.