[PHP-DB] Another dynamic sql.

Hi all! I have this form with some choices: Enter how many cars you want: ford bmw mercedes 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 = $

[PHP-DB] Is this possible?

Hi! I have this tricky case, at lest for me : ) I'm trying to get some data out of two tables and listing the data in a product/price site. But. : I have one table with productinfo and one with prices. And it is several columns with the same id in the pricetable, because every product have

[PHP-DB] Query with numbers like 1, 3, 5..........

Hi! Is there a way to get the rows with id's like 1, 3, 5, and so on or 2, 4, 6, ...? Best regards Raymond -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Query with numbers like 1, 3, 5..........

y to do it? Reagrds Raymond - Original Message - From: "Rick Emery" <[EMAIL PROTECTED]> To: "'Raymond Lilleodegard'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 8:55 PM Subject: RE: [PHP-DB] Query with numbe

Re: [PHP-DB] Query with numbers like 1, 3, 5..........

uot;); > while ( $ref1 = mysql_fetch_object($qry) ) { > $ref2 = mysql_fetch_object($qry) > ?>$ref1->id  $ref2->id   } > ?> > > > btw, the   is to keep the internal cell borders from not appearing > using netscape. (keeps it from being empty). > > Hope thi

[PHP-DB] Re: count from the results

Hi Barry! you can do it like this for example: $query = "SELECT * FROM artist WHERE artist_name LIKE 'b%' ORDER BY artist ASC"; $count = mysql_query("SELECT COUNT(artist) AS count FROM artist WHERE artist_name LIKE 'b%'",$db); $x = mysql_fetch_array($count); $result = mysql_query($query) or

[PHP-DB] Re: mysql_connect() and phpmyadmin

Hi Martin! I dont think I understood your question right here. Are you trying to connect to mysql ? regards Raymond "Martin Allan Jensen" <[EMAIL PROTECTED]> wrote in message 005901c1b40d$6143c390$040a@IceSystems">news:005901c1b40d$6143c390$040a@IceSystems... I just don't understand why

[PHP-DB] Making a txt file from db data, is it possible?

Hi! I would like to make a txt file our from some db output, is this possible? Couldn't find anything about it in the function list. Thanks for all help! Best regards Raymond Lilleodegard -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.ph

[PHP-DB] Re: Making a txt file from db data, is it possible?

"Andy" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > mysqldump dbname.tablename > filename.txt > > Cheers, Andy > > > "Raymond Lilleodegard" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > [EMAIL PROTECTED]