[PHP-DB] Re: Multiple MSSQL Server connections (per script)

2002-10-15 Thread Owen Prime
We have had two or more MySQL datasources in the same PHP script on a few different sites. Can't really tell you much though as we didn't do anything out of the norm to do it. Just connected to them. Thought you might like reassurance that it has been done. Cheers, Owen

[PHP-DB] Re: Preserving the string

2002-10-14 Thread Owen Prime
($string_of_numbers) to see if it has the leading 0's and what its type is immediately before you insert into the DB. Cheers, Owen Prime http://www.noggin.com.au Michael Conway wrote: > I have a problem using barcodes. They are variable in length (up to 13 > integers). I had to

[PHP-DB] Re: checkboxes names & values in mySQL (newbie)

2002-10-10 Thread Owen Prime
they appear is arbitrary, but that makes no matter for a MySQL enum. So just do an implode on the array to put it in the database. Cheers, Owen Prime http://www.noggin.com.au John wrote: > I'm new at using PHP and mySQL, so please forgive my potentially naive > question. > >

[PHP-DB] Re: Multi-Dimensional Arrays

2002-10-09 Thread Owen Prime
number; $cartArray[1]["Brand"] = $brand; $cartArray[1]["Quantity"] = $itemqty; $cartArray[1]["ItemName"] = $itemname; Note that $cartArray[] = $val is just a short hand way of doing array_push($cartArray, $val); Cheers, Owen Prime http://www.noggin.com.au Jonath

[PHP-DB] Re: array intersect with 2 arrays created from mysql

2002-10-07 Thread Owen Prime
be an array. Cheers, Owen Prime http://www.noggin.com.au Nigel Dunn wrote: > Hi, > > If anyone can help me with this I'd be most appreciative. > > I'm constructing 2 arrays of IDs from 2 different tables. Then I want to > compare one to the other and only use

[PHP-DB] Re: Auto Increment

2002-10-07 Thread Owen Prime
BTW... you only need to do it once. Subsequent INSERTS will follow on from the previous insert. Owen Prime wrote: > Gavin, > > You can specify the next auto_increment id by using > > SET INSERT_ID = #; > > Where # is your desired number. Will only work for the next I

[PHP-DB] Re: Auto Increment

2002-10-07 Thread Owen Prime
Gavin, You can specify the next auto_increment id by using SET INSERT_ID = #; Where # is your desired number. Will only work for the next INSERT/ALTER. Have a look down the bottom of 7.33 in the MySQL language reference. Cheers, Owen Gavin Nouwens wrote: > Hi peoples, > > Just wondering i