Re: [PHP] Connect to AS400

2006-01-26 Thread James Lobley
On 1/26/06, Richard Lynch <[EMAIL PROTECTED]> wrote: > > On Thu, January 26, 2006 2:23 pm, Justin Cook wrote: > > We need to connect to a database on our AS400. Would this be best > > accomplished with ODBC? If not, what is the preferred method? Thanks! > > The AS400 was discussed on this list, or

Re: [PHP] Connect to AS400

2006-01-26 Thread James Lobley
On 1/26/06, Justin Cook <[EMAIL PROTECTED]> wrote: > > We need to connect to a database on our AS400. Would this be best > accomplished with ODBC? If not, what is the preferred method? Thanks! > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.

Re: [PHP] zipped files

2005-10-27 Thread James Lobley
view the files information, but the extract() didn't do > anything. I checked the writes for the directory the zip file was in and > it did have wright rights. Maybe you can post a code snippet. > > thanks > > clive > > James Lobley wrote: > > This is the c

Re: [PHP] zipped files

2005-10-26 Thread James Lobley
This is the class I use: http://www.phpconcept.net/pclzip/man/en/index.php On 10/26/05, Clive <[EMAIL PROTECTED]> wrote: > > Hi > > does any one have code/examples for unzipping a file thats been uploaded > to a server. I would prefer a class rather than something that uses > zip.lib as it may n

Re: [PHP] Auto unzip uploaded file

2005-09-30 Thread James Lobley
On 9/30/05, Norbert Wenzel <[EMAIL PROTECTED]> wrote: > > I know a script (it's a webgallery) where you upload your images.zip > with any amount of images in it. After uploading the .zip get unzipped > and the images will be placed into the gallery. > > How did they unzip (or better, how is it poss

Re: [PHP] Error loading extension dlls in WindosXP for PHP4.3.10

2005-01-12 Thread James Lobley
> Well Richard, I could able to solve it by copying all > dlls into Windows\System32 directory. But still not > sure why I need to copy all dlls into system32 > directory though I have mentioned in php.ini file that > extension_directory=c:\PHP4\extensions. > > regards, > Ranjan > Hi Ranjan, You

Re: [PHP] Creating Dropdown Menus From Tables

2004-09-20 Thread James Lobley
On Thu, 16 Sep 2004 13:02:31 +0100, Harlequin <[EMAIL PROTECTED]> wrote: > Hi all. > > Hoping this might be relatively easy... > > I'm wondering if I can create a dropdown menu (ABCDE) by > using a select statement and then populating this using PHP...? > > -- > - > M

RE: [PHP] is there a more efficient query?

2004-08-06 Thread James Lobley
Hi Brian, Assuming you have mysql 4.0.0 or up, I think the following query should do you: $query2 = "(SELECT value FROM element_values WHERE element=48 AND user=$user_id) UNION (SELECT value FROM element_values WHERE element=49 AND user=$user_id) UNION (SELECT value FROM element_v

RE: [PHP] UK Postcode Reg Exp

2004-02-17 Thread James Lobley
Try this one: $postcode2 = strtoupper(str_replace(chr(32),'',$postcode)); $pc_suffix = substr($postcode2,-3,3); $pc_prefix = substr($postcode2,0,(strlen($postcode2)-3)); if (!preg_match('/(^[A-Z]{1,2}[0-9]{1,2}|^[A-Z]{1,2}[0-9]{1}[A-Z]{1})$/',$pc_prefix) && !preg_match('/^[0-9]{1}[ABD-HJLNP-UW-Z]

RE: [PHP] Connection AS400-Windows & PHP

2003-10-31 Thread James Lobley
$query = "SELECT free FROM stock WHERE part='$item'"; $result = odbc_exec($connect, $query); $available = odbc_result($result, 'free'); echo($available); odbc_close($connect

RE: [PHP] Backup Database

2003-09-02 Thread James Lobley
Hi Shaun, DevShed's last weekly newsletter had the following: Daily Scheduled Backup of MYSQL Databases - Looking for a free tool or utility to handle scheduled MySQL backups. http://forums.devshed.com/t74513/s.html Haven't tried any of the solutions yet, but will be soon! James -Original

RE: [PHP] How to optimize this MySQL command?

2003-06-05 Thread James Lobley
_query("SELECT nick FROM bt_member where id ='$result[mid]'",$db); $result2 = mysql_fetch_array($result2b); mysql_free_result($result2b); .. } -- "James Lobley" <[EMAIL PROTECTED]> ???:[EMAIL PROTECTED] > I'd guess at: > > $resultb = mysql_

RE: [PHP] How to optimize this MySQL command?

2003-06-04 Thread James Lobley
I'd guess at: $resultb = mysql_query("SELECT bt_member.nick FROM bt_member, bt_message WHERE bt_member.id=bt_message.mid AND bt_message.ch='$ch'", $db); $result2 = mysql_fetch_array($resultb); . -Original Message- From: Erick [mailto:[EMAIL PROTECTED] Sent: 04 June 2003 13:12 To:

RE: [PHP] get current username from the windows system

2003-01-23 Thread James Lobley
Hi Thomas, The following code should help you... Note that you have to turn off anonymous access in IIS, so that the user authenticates to a domain. "); $user_chunks = explode("\\",strtoupper(getenv("REMOTE_USER"))); $user_domain = $user_chunks[0]; $user_name = $user_chunks[1]; echo("User domai