Re: [PHP-DB] Problems building PHP with Informix support

Hi Daryl, Have a look through the attached files. I use these to build PHP, Apache & Informix(SE 7.25.UC6, CSDK 2.81.UC1) on a Redhat 8.0 machine. I don't use RPM but this may give you some clues on how to compile it all as I know this setup works. Compiling with Informix can be an absolute ^%$"$!

[PHP-DB] PHP and UniData

Is it simple to connect to a unidata db on a AIX system? John Greco I.T. Department RAB Electric Manufacturing, Inc. 170 Ludlow Avenue Northvale, NJ 07647 Tel: 888 RAB-1000 Fax: 888 RAB-1232 Web: www.rabweb.com Email: [EMAIL PROTECTED]

[PHP-DB] Re: Page counter from a query ?

I use PEAR db to make my life easy.. here's their pager class http://vulcanonet.com/soft/index.php?pack=pager pete Larry Sandwick wrote: Is there a way to limit the number of pictures being display from a query? Example. Let say I have 100 pictures and I would like to display only 20. How w

[PHP-DB] Re: Page counter from a query ?

and here's a tutorial http://www.phpnoise.com/tutorials/9/1 ;-) Larry Sandwick wrote: Is there a way to limit the number of pictures being display from a query? Example. Let say I have 100 pictures and I would like to display only 20. How would I put the numbers at the bottom of the page?

Re: [PHP-DB] Re: Page counter from a query ?

question/comment... i don't use PEAR currently. but i noticed this class expects register_globals=on and would therefore not to work on my system. Or does another parent class take care of the translation between $form and $_GET['form']? Jeff

[PHP-DB] Query Error

I've been racking my brain and the web for finding a solution and no luck so far. Here's the form: $display_block .= "Input item: Item ID:Quantity: "; $display_block .= "01"; for ($i=2; $i < 301; $i++){ $display_block .= "$i"; } $display_block .= "Price:"; And here is the additem.php file w

RE: [PHP-DB] Re: Page counter from a query ?

Just do an extract on your $_GET var (if security concerns are negligible) Say you get line is: ?sid=123&form=12 // Execute this extract($_GET) // You end up with: $sid == "123"; $form == "12"; Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 "Pay It Forward" mailto:[EMAIL

RE: [PHP-DB] Re: Page counter from a query ?

not to belabour this topicbut, that i know. i was just curious as to why that class is written like that still? it seems that if PEAR does this for you(extract), that _may_ be a security concern for those that are not being security concious. Not that i'm saying, or know, that PEAR does thi

Re: [PHP-DB] Query Error

From: "Robert Sossomon" <[EMAIL PROTECTED]> > And here is the additem.php file where it check for the info in the > field and it is erroring out. It would be rather useful to know the error... > $get_iteminfo = "select * from GCN_items where 'item_num' LIKE > '%$_POST[sel_item_id]%'"; Take aw

RE: [PHP-DB] Query Error

The errors as it prints are: The query I just ran was: select * from GCN_items where `item_num` = '%fm-a294%' The query I just ran was: Resource id #2 0 -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 11:04 AM To: Robert Sossomon;

[PHP-DB] Re:Subject: KB in a query / column?

SELECT SUM(LENGTH(Comments))/1000 FROM table Kinda obvious now isn't it ;-) Cheers - Neil. At 11:19 04/11/2003 +, you wrote: Message-ID: <[EMAIL PROTECTED]> From: "Chris Payne" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Date: Mon, 3 Nov 2003 14:38:34 -0500 MIME-Version: 1.0 Content-Type: mul

Re: [PHP-DB] Query Error

From: "Robert Sossomon" <[EMAIL PROTECTED]> > The errors as it prints are: > > The query I just ran was: select * from GCN_items where `item_num` = > '%fm-a294%' > The query I just ran was: Resource id #2 > 0 Those aren't errors; it's just what you asked the script to display. Your query simply

RE: [PHP-DB] Query Error

That fixed the output to actually find the information, however I'll be danged if it is not adding the items to the database. In fact I am seeing errors with it adding half the stuff to the database from stuff that was working. I rebooted the system. Removed the database, stopped the server. Sta

[PHP-DB] phpmyadmin screwup

Hi all: I was trying to use phpmyadmin for the first time and messed up when trying to give the [EMAIL PROTECTED] a password. I did that because phpmyadmin told me something about lax security using "root" with no password. Anyhow something went wrong. Now I can't do anything with phpadmin

Re: [PHP-DB] phpmyadmin screwup

this should fix ya.. http://www.mysql.com/doc/en/Resetting_permissions.html hth Jeff Joffrey Leevy

Re: [PHP-DB] phpmyadmin screwup

I'm not to familiar with the jargon. Do I use the code (shell>mysql...) in a query box because it's giving me a syntax error. thanks J - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard

[PHP-DB] Re:Subject: KB in a query / column?

SELECT SUM(LENGTH(Comments))/1000 FROM table Kinda obvious now isn't it ;-) Cheers - Neil. At 11:19 04/11/2003 +, you wrote: Message-ID: <[EMAIL PROTECTED]> From: "Chris Payne" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Date: Mon, 3 Nov 2003 14:38:34 -0500 MIME-Version: 1.0 Content-Type: mul