Re: [PHP] dynamic variables in sq?l

2002-01-25 Thread Jeff Sheltren 

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]

Re: [PHP] dynamic variables in sq?l

2002-01-25 Thread Raymond Lilleødegård 

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]