mysql table is set up like this: ------------------------------------------ bmw | ford | mercedes | ------------------------------------------ 100 | 50 | 120 |
It is just a very simple one. ----- Original Message ----- From: "Jeff Sheltren" <[EMAIL PROTECTED]> To: "Raymond Lilleodegard" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, January 25, 2002 8:00 PM Subject: Re: [PHP] dynamic variables in sq?l > Can you show how your mysql table is set up? Otherwise I am not quite sure > what you are trying to do with your SQL statement. > > Jeff > > > 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; > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]