[PHP-DB] Re: What's wrong with this code?

2002-09-01 Thread Jean-Christian Imbeault
Shoulder To Shoulder Farm wrote: > > mysql_query("INSERT INTO prod VALUES ( 'Name', 'ShortDesc', 'LongDesc', > 'PriceOZ', 'PriceLB', 'URLOZ', 'URLLB', 'IMG') VALUES ('$_POST[Name]', > '$_POST[ShortDesc]', '$_POST[LongDesc], '$POST[PriceOZ', > '$_POST[PriceLB]', '$_POST[URLOZ]', '$_POST[URLLB],

[PHP-DB] Re: What's wrong with this code?

2002-09-01 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > Hi all, I'm running PHP4. What's wrong with this code: > > > $db = mysql_connect("localhost", "Taj", "passwordhere"); > > mysql_select_db("s2s",$db); > > mysql_query("INSERT INTO prod VALUES ( 'Name', 'ShortDesc', 'LongDesc', > 'Pri

[PHP-DB] pg_fetch_result returns something other than boolean???

2002-09-01 Thread Matthew Newby
I am having trouble with the pg_fetch_result function when trying to access a boolean field in a PostgreSQL database. Here's the code snippet: $strField = "blnAllDayEvent"; $intFieldNum = pg_field_num($rsEvent,$strField); echo "Field type for " . $strField . " is " . pg_field_type($rsEvent,$intF

RE: [PHP-DB] What's wrong with this code?

2002-09-01 Thread Beau Lebens
I'd use var inclusions like this; VALUES ('" . $_POST['Name'] . "', that might help you // -Original Message- // From: Shoulder to Shoulder Farm [mailto:[EMAIL PROTECTED]] // Sent: Monday, 2 September 2002 11:42 AM // To: PHP Database List // Subject: [PHP-DB] What's wrong with this c

[PHP-DB] What's wrong with this code?

2002-09-01 Thread Shoulder to Shoulder Farm
Hi all, I'm running PHP4. What's wrong with this code: This will wrap, but, it should work. TIA, Taj -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] What's wrong with this code?

2002-09-01 Thread Shoulder to Shoulder Farm
Hi all, I'm running PHP4. What's wrong with this code: This will wrap, but, it should work. TIA, Taj -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Erratic isset()

2002-09-01 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > Hi > > Can anyone shed some light on this problem? > > The DB update only happens when I change the if(isset($submit)) to read > if(!isset($submit)). > > Yes, I am using PHP 4.0.6 but have also tried with PHP 4.2.2, same problem. > Co

[PHP-DB] uploading images before creating db entry

2002-09-01 Thread Andy
Hi there, I have a running system where users can upload images. Each image has to be acompanied with several other text infos suplied by the uploading person. The image istself is stored in the filesystem and the data (like name of the user and imagefilename) are stored in a mysql myisam table.

Re: [PHP-DB] transactions and persitent connections

2002-09-01 Thread Jean-Christian Imbeault
Paul Dubois wrote: > >> Does the script go from start to finish even though the connection to >> the browser has been severed. I.e. The script will run complete even >> if there is output to the browser as the script is running? > > > Not necessarily. It won't base its actions on what the br

Re: [PHP-DB] transactions and persitent connections

2002-09-01 Thread Paul DuBois
At 12:52 +0900 9/1/02, Jean-Christian Imbeault wrote: >Paul Dubois wrote: >> > > >>>I am worried that if I use persistent connections it might be >>>possible for more than one PHP script to be inside the same >>>transaction at the same time. >> >> >>Not at the *same* time, because although a pe