Another dynamic sql.
| From: | Raymond Lilleodegard | Date: | Fri, 25 Jan 2002 18:48:21 +0000 |
| Subject: | Another dynamic sql. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16175@lists.php.net to get a copy of this message | ||
Hi all!
I have this form with some choices:
<form>
Enter how many cars you want:<input type="text" name="number" >
<select size="1" name="car">
<option selected>ford</option>
<option>bmw</option>
<option>mercedes</option>
</select>
And then I am trying to get the price out of a table in my database with
this code:
$sql = mysql_query("SELECT '$car' FROM varetabell where carid='$carid'
");
$myrow= mysql_fetch_array($sql);
$x = $myrow["$car"];
$price = $x * $number;
Shouldn't this work? Or am I missing something here?
Best regards Raymond