[PHP-DB] PDO buffered query problem

Hi there, I'm having some serious problems with the PHP Data Object functions. I'm trying to loop through a sizeable result set (~60k rows, ~1gig) using a buffered query to avoid fetching the whole set. No matter what I do, the script just hangs on the PDO::query() - it seems the query is

Re: [PHP-DB] TOO MANY CONNECTIONS!!

On Wed, Oct 23, 2002 at 10:18:07PM +0100, Georgie Casey wrote: Im getting a too many connections error in my PHP pages at http://www.free-ringtones.tv. I presume this is from the MySQL server, and I know I access the database a lot for each page. So whats the solution to MySQL has a default of

[PHP-DB] Re: Multi-Dimensional Arrays

tArray[1][ItemNumber] = $itemnumber; $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 Jonatha

[PHP-DB] Multi-Dimensional Arrays

($itemnumber=$brand, $itemqty, $itemname)); print_r($cartArray).BRBR; echo $cartArray[0][0].BRBR; Thank you, Jonathan Duncan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Question

On Sun, 23 Jun 2002, Mike Tuller wrote: I know I will need to create a separate table to hold information about the drives, and connect them to the computer by attaching the primary key of the drives table to the Computer table. Good, you know a bit about normalisation. But, not enough.

Re: [PHP-DB] a back include script

On Fri, 21 Jun 2002, Dib, Walid (MED, Stagiaire GEMS) wrote: I want to create a file include .inc which by calling it in almost all the pages which I use, will return me to the previous page, thus this script To manipulate the browser in such a way, you have at least two options: 1) Make the

Re[2]: [PHP-DB] a back include script

On Fri, 21 Jun 2002, Latex Master wrote: DH To manipulate the browser in such a way, you have at least two options: DH 1) Make the .inc just have a link to the REFERER value from the browser. The first one want work if the person is behing a socks server or PHP gets a referer diferently?

Re: [PHP-DB] Date of Birth From Form

On Fri, 19 Apr 2002, Brandon Paul wrote: going about it wrong? Any help would be greatly appreciated. 1) Validate that the input is correct. 2) Tokenize the string based on the /s 3) Re-format the date. Or, use the date functions - I'd swear one of them can re-write dates. -- PHP Database

[PHP-DB] Re: session.save_path

k harder and you will find it somewhere. session.save_path is the file on the server where sessions are stored. It has nothing to do with the client machine. Fred Jonathan Duncan [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am reading a

Re: [PHP-DB] PHP accessing MySQL

. Any ideas anyone? Julie? Miles? Could this have anything to do with mysql user permission? Thanks, jkd Jonathan Duncan [EMAIL PROTECTED] wrote in message 9eekpb$s41$[EMAIL PROTECTED]">news:9eekpb$s41$[EMAIL PROTECTED]... YES!! I just had a feeling the book was wrong. That did

[PHP-DB] HELP! (mysql)

hello, can one of you clever people guys 30 seconds to help a lady...? can someone just tell me the best way to create a new table in a mysql database? should i use the mysql_query() function? thank you boys, xxx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

Re: [PHP-DB] mysql.com

On Sun, 24 Jun 2001, TomazSa wrote: anybody now why www.mysql.com doesn't work? lp, tomaz A simple traceroute reveals that somewhere in the Exodus network, there is a route outage. -- Sapere aude My mind not only wanders, it sometimes leaves completely. -- PHP Database Mailing List

Re: [PHP-DB] PHP accessing MySQL

That is what I thought, so I set $db_num to another number and still came up with the same error. jkd Darren [EMAIL PROTECTED] wrote in message 9e42lj$s7b$[EMAIL PROTECTED]">news:9e42lj$s7b$[EMAIL PROTECTED]... I think the 0 is referring to your $db_num Jonathan Duncan [EMAIL P

Re: [PHP-DB] PHP accessing MySQL

Miles Thompson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Jonathan .. see below. At 08:38 PM 5/18/01 +, Jonathan Duncan wrote: Miles Thank you for the response. I did some debugging and the value of $dbs is 2. I am not sure of what exa

Re: [PHP-DB] PHP accessing MySQL

YES!! I just had a feeling the book was wrong. That did get rid of the error. However, it did not completely solve my issue. Now when I run the script I just get the message Couldn't list databases. This just happens to be the die message for the same line of code that I have been looking

[PHP-DB] PHP-MySQL - Escaping single quotes

and then "unescaped" when they are retrieved? How? Is their a function like htmlspecialchars() or addslashes()? What other characters need to be escaped when receiving data through PHP into a MySQL database? Thanks Duncan. -- PHP Database Mailing List (http://www.php.net/) To unsubscri