Re: dynamic variables in sq?l
| From: | Raymond Lilleodegard | Date: | Fri, 25 Jan 2002 19:43:49 +0000 |
| Subject: | Re: dynamic variables in sq?l | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-82155@lists.php.net to get a copy of this message | ||
Than you very much for all help!
I see that my database design is a little dumb, so I'll just make another
one.
Best regards Raymond
"Raymond Lilleodegard" <raymol@online.no> wrote in message
news:20020125185033.14393.qmail@pb1.pair.com...
> 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
>
>
>
>