outputting query?

del753

im trying to output the results of a mysql query, the Cname works okay, but none of the other details will come up? heres my code..

$query = "SELECT * FROM cars WHERE Cname = '" . $POST['Cname'] . "'";

echo "You have selected the {$POST['Cname' ]}(<----THIS WORKS FINE)
 The price is: " . $row ['Price']. " ; (<----????)

thanks

kkobashi

1) Remove the space between $row and ['Price']:

$row['Price']

Not

$row ['Price']

2) Place another set of double quotes at the end and terminate the echo statement with a semicolon. Also it is , not :

" ";

You also got a in the index of the post array. Remove it.

Use this:

$query = "SELECT * FROM cars WHERE Cname = '" . $POST['Cname'] . "'";
echo "You have selected the {$POST['Cname']} ";
echo "The price is: " . $row['Price'] . " ";

bradgrafelman

Is that your entire code for the MySQL query?? Aren't you missing something like:

$exec = mysql_query($query);
$row = mysql_fetch_assoc($exec);

before you use $row['Price'], etc. ??