Re: [PHP-DB] Help in passing multiple HTML form options to SQL query <-- Newbie

2001-10-27 Thread Richard Chauvaux
first, the select tag in your form should be setup as an array: then the array $country[] will be available to your script on submittal. a simple way to build your sql where clause would be to iterate through the array using a subscript variable: $sql = "select * from tbl where ctry='$country[0]

Re: [PHP-DB] ADORecordset Equivalent in PHP?

2001-10-23 Thread Richard Chauvaux
I would suggest checking out the classes at http://phpclasses.upperdesign.com/browse.html I've used the mysql_recordset class that is part of the mysql_db package. It has the basic methods similar to ADO. I found it to be very functional if you're using mysql. There are other classes there as w

Re: [PHP-DB] Inseting info into MySQL and retrieving all in one SQL command

2001-08-19 Thread Richard Chauvaux
Take a look here and all will be revealed: http://www.mysql.com/doc/G/e/Getting_unique_ID.html basically, you need a field in the db with an auto_increment attribute. Richard CrossWalkCentral wrote: > Question how do you use this function? > > mysql_insert_id(); > > I have tried it and it give

Re: SV: [PHP-DB] mssql_connect() commandline problem

2001-08-14 Thread Richard Chauvaux
Erik, Having only set up PHP once on Windoze and once with Apache on Linux, I would have to reference the installation docs on php.net. On Windoze, you edit the php.ini file-- maybe that's also true for the stand-alone on Linux? You need the stand-alone version if you want to bypass the Apac

Re: [PHP-DB] mssql_connect() commandline problem

2001-08-14 Thread Richard Chauvaux
Sounds like you might be working with 2 different versions of php: Mod-php for Apache in the web environment, stand-alone php operating in the shell. You might want to start by ensuring that the stand alone version is compiled -with mssql. Try running phpinfo() in the shell? Richard Erik wrote

Re: [PHP-DB] Record Update Link

2001-07-28 Thread Richard Chauvaux
There's a good tutorial that covers the subject of creating a list of contacts with hyperlinks to edit, delete etc. at: http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html It was my first intro to PHP and was extremely helpful, although if I remember right a couple of t