Re: [PHP-DB] pdo_odbc and odbc

2007-01-03 Thread Chris
james tanhs wrote: Hi, I m running on : client: XP + Apache2.2+Php5.2 ( enabled pdo, pdo_odbc, Merant) server: oracle8i Are there anyone having the same problem ? Maybe ask the php-general list since you haven't got a reply here.. there are more people on that list and more chances that someon

Re: [PHP-DB] 10 rows

2007-01-03 Thread Chris
Ron Piggott (PHP) wrote: "I would normally just pass the offset through the get var." I understand what you are saying in concept ... but what would a sample command be like? http://www.host.com/script.php?next=21";>Next Link http://www.host.com/script.php?previous=1";>Previous Link You can

Re: [PHP-DB] SQL Performance Help

2007-01-03 Thread Chris
Tony Grimes wrote: I'm developing a course calendar for a client and I'm running into performance problems with the admin site. For example, when I try to include registration counts in the course list, the page really slows down for large course lists (50 or so): COURSEATTENDEES CA

Re: [PHP-DB] Can't figure out why getting "query was empty" error

2007-01-03 Thread Chris
pantichd wrote: Figured it out. The name of the table was "Person" instead of "person"...First letter was a capital "P" I didn't realize that the sql was case-sensitive. It is with table names, field names and table aliases. Stuff like "SELECT", "INSERT", "UPDATE", "WHERE" isn't case sensit

Re: [PHP-DB] retaining form information when someone presses back

2007-01-03 Thread Chris
Christopher Blöcker wrote: Flint Million: This might not be relavent for this forum, so if not please direct me to the proper one; although I do like to keep my email list subscriptions down. I have a custom application in PHP in which a user fills out a form of information. When the user submi

Re: [PHP-DB] This won't work in MySQL 4.1.10

2007-01-03 Thread Chris
Peter Karlsson wrote: but it runs fine in 4.1.20. In .10 I get an error message about unknown column c. I built the sql with help from the comments from the MySQL website manual and have to admit that I don't fully understand it all ;). Is there a way to solve this without upgrading the s