Re: [PHP-DB] ecommerce - storing as an array or temporary record

2001-04-01 Thread Stuart J. Browne
> I am developing a script that will eventually be a "pay-to-list your whatever" script. > I am wondering if the best way to hold data throughout the four forms would be to hold > these in an array - each form would array_push() the vars into the $listing array. > Or would it be better to insert

Re: [PHP-DB] retrieving images

2001-04-01 Thread Stuart J. Browne
Hello, I'm trying to retrieve and output all the binary images in my images table. This is what I have, $result = mysql_query("SELECT * FROM images",$db); if ($myrow = mysql_fetch_array($result)) { // display list if there are records to display do { $filetype = ($myrow

Re: [PHP-DB] auto_increment in mysql

2001-03-28 Thread Stuart J. Browne
> I use MySQL 3.22.23 but I just had a hunt about on the web and I found > a posting that confirmed your findings - I.E: auto_increment starts at > 1!! > > I stand corrected! The reasoning behind this a colleague of mine recently informed me of.. When an insert occurs, the new record is given th

Re: [PHP-DB] Inserting Image as Blob in MySql DB

2001-03-25 Thread Stuart J. Browne
> Does anyone know the proper method for inserting an image(*.jpg or > *.gif) into a MySql database blob field? I am recieving the file via an > html form with the usual enctype for this and > parameters. I can save it as just a regular file and then display it > fine on the page, but no way ca

Re: [PHP-DB] Help with displaying rest of page after MySQL error

2001-03-16 Thread Stuart J. Browne
""Stuart J. Browne"" <[EMAIL PROTECTED]> wrote in message 98ujpk$i2j$[EMAIL PROTECTED]">news:98ujpk$i2j$[EMAIL PROTECTED]... > > My first line of PHP code (embedded in HTML) has: > > > > $db = mysql_connect("x","y","z

Re: [PHP-DB] Help with displaying rest of page after MySQL error

2001-03-16 Thread Stuart J. Browne
> My first line of PHP code (embedded in HTML) has: > > $db = mysql_connect("x","y","z") or > die("saysomethinghere"); > > If I have a connection problem, it does print the > "die" message and the connection error, but it also > stops the page right there: no more HTML is displayed. Well, you've