[PHP-DB] COM

2003-03-29 Thread Kiswa
Server Win2000 +ISS5 +PHP Trying to get access to an access DB through COM but i wont work. there is no results generated. Can anyone help me Here is the code $rownum =0; $conn = ADONewConnection('access'); $conn-PConnect('webdb.mdb'); $result = $conn-Execute('SELECT Produkt, Artikelnr, Pris,

[PHP-DB] Related to WAR - 1

2003-03-29 Thread ckra
The War By Eduardo Galeano Just think. In the middle of last year, when this war was still only gestating, George W. Bush stated that 'we have to be ready to attack in any obscure corner of the world'; ergo, Iraq is an obscure corner of the world. Does Bush believe that civilization began in

[PHP-DB] Related to WAR - 2

2003-03-29 Thread ckra
The Somoza dynasty, set on the throne by the Marines, lasted half a century before being swept away by popular fury in 1979. Then, president Ronald Reagan got on his horse and set out to rescue the country from the threat of the Sandinista revolution. Among the poorest of the poor, Nicaragua was a

[PHP-DB] Related to WAR - 3

2003-03-29 Thread ckra
So Iraq does not heed United Nations (UN) resolutions? And what about Bush, who has just dealt the most resounding blow ever to international legality? And what about Israel, the leading specialist in ignoring UN resolutions? Iraq has ignored 17 UN resolutions, Israel 64. Will Bush bomb his most

Re: [PHP-DB] Related to WAR - 1

2003-03-29 Thread David T-G
My dear ckra -- ...and then [EMAIL PROTECTED] said... % % The War % By Eduardo Galeano Would you please keep this crap off of the php-db list (and, before I see it anywhere else, any other php list at the very least)? I am here to discuss php and nothing else unless it is related to php. If

RE: [PHP-DB] Related to WAR - 1

2003-03-29 Thread Peter Lovatt
Hi There are many aspects to this complex political mess, most of us will have views on it, and there are plenty of places to discuss it. This is the wrong place. I would echo David's comments Keep it off php lists Thanks Peter -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] An interesting Apache Log to MySql ?

2003-03-29 Thread Dave Carrera
Hi All I have been trying to find a way to write Apache Log data to a MySql db via a pipe log directive. So far I have this: LogFormat %v:*:%B:*:%u:*:%f:*:%h:*:%a:*:%s:*:%{%Y-%m-%d %H:%M:%S%z}t:*:%{Content-type:}o:*:%U:*:%{Referer}i:*:%{User-Agent}i:*:% {cookie}n mysqllog As my Logformat

[PHP-DB] Re: COM

2003-03-29 Thread John Lim
Hi Kiswa, You are using mixing programming styles incorrectly. Kiswa [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Server Win2000 +ISS5 +PHP Trying to get access to an access DB through COM but i wont work. there is no results generated. Can anyone help me Here is the code

Re: [PHP-DB] An interesting Apache Log to MySql ?

2003-03-29 Thread Jason Wong
On Saturday 29 March 2003 22:25, Dave Carrera wrote: I have been trying to find a way to write Apache Log data to a MySql db via a pipe log directive. Search the archives, a solution was presented in the past few days. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

[PHP-DB] INSERT Question

2003-03-29 Thread Charles Kline
Hi there. I was wondering what is the best way to insert multiple records into a table? Here is the scenario... I have a form which has 5 select menus as part of the data that gets entered. Most of the data goes into a table called tbl_reports. Each of these 5 menus contains the same list of

RE: [PHP-DB] INSERT Question

2003-03-29 Thread John W. Holmes
I was wondering what is the best way to insert multiple records into a table? Here is the scenario... I have a form which has 5 select menus as part of the data that gets entered. Most of the data goes into a table called tbl_reports. Each of these 5 menus contains the same list of people

Re: [PHP-DB] INSERT Question

2003-03-29 Thread Charles Kline
Since I don't totally understand (newbie) I will show you an example of the form. form select name=person1 option value=1Joe Smith/option etc. /select input type=radio name=person1yn value=Yes Y input type=radio name=person1yn value=No N select name=person2 option value=1Joe Smith/option etc.

RE: [PHP-DB] INSERT Question

2003-03-29 Thread John W. Holmes
Since I don't totally understand (newbie) I will show you an example of the form. form select name=person1 option value=1Joe Smith/option etc. /select input type=radio name=person1yn value=Yes Y input type=radio name=person1yn value=No N So if the 'Y' radio button is chosen, you'll

Re: [PHP-DB] INSERT Question

2003-03-29 Thread Charles Kline
John, Thanks. Yes that is a big help. The radio button is actually not used for that purpose (sorry that was a bit confusing of me to put in without an explanation). For each person selected, the radio button Y/N relates to whether they are an author of the report or just a contributer. I

Re: [PHP-DB] INSERT Question

2003-03-29 Thread Charles Kline
John, I modified my form, but not having much luck. Here is my new form (so far): ** I need to add 4 more selects, not sure how to name them ** select name=investigator[person] option value=0Choose person/option option value=1064618047Paul A/option option value=1655387822Katrina A/option option

RE: [PHP-DB] INSERT Question

2003-03-29 Thread Peter Lovatt
Hi you need to create 5 selects, all named investigator[] with index 1-5 (or 0-4), with the option set to empty for no selection. this will return an array investigator[1] = '1064618047' investigator_yesno[1] = 'Y' investigator[2] = '1649815377' investigator_yesno[2] = 'N' for example form

RE: [PHP-DB] INSERT Question

2003-03-29 Thread John W. Holmes
The only addition I have is to adapt the code to create a single INSERT query in the format I gave earlier. It will run quicker overall. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -Original Message- From:

Re: [PHP-DB] INSERT Question

2003-03-29 Thread Charles Kline
Okay. Will do. Thanks both of you for your time and help. It is appreciated! - Charles On Saturday, March 29, 2003, at 09:21 PM, John W. Holmes wrote: The only addition I have is to adapt the code to create a single INSERT query in the format I gave earlier. It will run quicker overall.

[PHP-DB] multiple connections to MySQL in a single script example

2003-03-29 Thread Lonnie Cumberland
Hello All, I am new to using PHP with MySQL and was wondering if anyone had a simple example of how to have multiple active connections to two MySQL databases in a single script? I will have to access two different databases but am not sure how to keep the active connections and make different

[PHP-DB] MySql Help needed

2003-03-29 Thread Sparky Kopetzky
Greetings! I am building an application in PHP and am creating a global $connect_id for MySql. I have MySql on a separate machine and am using the connect like this: $server = development.myservermachine.net; $username = myname; $password = mypassword; $connect_id = mysql_connect($server,

Re: [PHP-DB] MySql, PHP, and Dates

2003-03-29 Thread Bruce Feist
I originally wrote: when I retrieve a date from MySQL into PHP, it shows up as a string instead of a date data type What's the best way of controlling date format? John W. Holmes replied: If you want a Unix timestamp, which is compatible with the date() function in PHP, then use the