Getting Quantity and Price from 2nd table

dmacman1962

Hi All,

I have a page that get all the items from a table by dealerID and all the quantities and prices from another table.

I am getting a parse error and cannot see why.

I tried the code to get the quantities and prices seperate from the items and that worked.

I also tried to get all the items with no prices or quantities and that worked.

I tried to combine the two and this is where I am getting the parse error.

<html> 
<head><title>Online Sign Ordering</title></head> 
<body> 
<?php  

include ("includes/connect_db.php");
$path = "images/";  

?>  

<form action="process4.php" method="post" name="SignOrder" id="SignOrder">  

<?php 
if(isset($_POST['order'])) 
{ ?>
<table> 
    <tr> 
        <td width="100">Item Number</td> 
        <td width="100">Item Name</td> 
        <td width="150">Item Description</td> 
        <td width="100">Image</td>
		<td width="100"> Price</td> 
        <td width="150">Order</td> 
        <td width="150">Quantity</td> 
    </tr> 
<?php  

echo $DealerID;
$result = mysql_query("SELECT * FROM dealeritems");  

$Quantity = array();
$Price  = array();
$result=mysql_query("SELECT * FROM Quantities");
while ($row = mysql_fetch_array($result)) {
    $Quantity[] = $row['Quantity'];
    $Price[] = $row['Price'];
}

$count = count($Quantity);
//$result = mysql_query("SELECT * FROM dealeritems WHERE DealerID='$DealerID'"); */ 
while($row = mysql_fetch_assoc($result)) {   

?>  

<tr> 
        <td width="100"><?php echo $row['ID']; ?></td> 
        <td width="100"><?php echo $row['ItemName']; ?></td> 
        <td width="150"><?php echo $row['ItemDescription']; ?></td> 
		 <td width="150"><img src="<?php echo $path.$row['ImageName']; ?>" width="100" height="125"></td>
		<input type="hidden" name="price_<?php echo $row['ID']; ?>" value="<?php echo $row['Price']; ?>">
        <td width="100"><?php echo "$".$row['Price']; ?></td> 
        <td width="50"> 
            <input name="order[]" type="checkbox" value="<?php echo $row['ID']; ?>"> 
                <!-- Aside: include hidden itemnames to be used 
                    in the 'thank you for your order message' --> 
            <input type="hidden" name="name_<?php echo $row['ID']; ?>" value="<?php echo $row['ItemName']; ?>"> 
        </td> 
        <td width="50"> 
				<select name="quantity_<?php echo $row['ID']; ?>">
				<?php

echo '<option value="-1">Please choose a quantity</option>';
for ($i=0; $i<$count; $i++) {
    echo '<option value="'.$i.'">'.$Quantity[$i].' '.$Price[$i].'</option>';
}
            </select> 
			?>
        </td> 
    </tr> 
<?php  

}   ?>  

<?php } ?>
</table> 
<p> 
<input type="submit" name="Submit" value="Submit Your Order Now"> 
<input type="reset" name="Reset" value="Reset"> 
</p> 
</form> 

</body> 
</html>

Thanks in advance,

Don

thorpe

where are you getting the parse error? what line?

you do have a </select> tag in the middle of some php, without an echo() to go with it.

}
</select>
?>

ps: use the php tags instead of code.... any syntax erros will stand straight out.

kburger

remove this line, or at least the */

//$result = mysql_query("SELECT FROM dealeritems WHERE DealerID='$DealerID'"); /

dmacman1962

6 eyes are better than 2!!!

You both helped.

I changed:

<select>

to

echo '<select';

And that fixed the parse error. Now, I did not get any results, but that would be because my logic is off, not a missed character.

I will put up the final fix, once, I figure out what works.

Thanks,

Don

dmacman1962

I got the parse error fixed, but I have never done 2 queries and had to match up IDs from both and display the results.

IE, I get the products from the dealerItems table matched by DealerID, then i get the prices and quantities from the Quanities table, and want to match productID.Quantity with productID.dealerItems. I am not sure I am using the correct logic here.

I never did anything like this before, and I know it can be done.

I read a lot of similar posts, but I cannot seem to get their logic to work with my example.

Thanks,

Don