Hi, I really hope someone can help me with this. I'm new to PHP; just got started late last year. I've put together a MySQL/Apache/PHP system to manage contacts. It's all running locally on my Win2k system.
I have installed phpmyadmin also, and I used that utility to populate my tables. So far, so good. I can browse the tables with that utility all I like. Now, when I go to my own PHP pages, and attempt to pull data, all is well as long as I set my LIMIT to 10 or 15 or so. Much higher than that, and the system just spins its wheels. It never gets to a PHP time-out because it's not PHP taking up the time (in fact, php shows 0 seconds used on the Windows Task Manager). If I stop the browser (IE), I get a partial table, and if I have a look at the source code, it's always just shy of 4, 8, or 16k. (I don't know if that's relevant, but it seemed non-coincidental). But what I'm saying is, it's not a whole lot of data. There's not even 400 rows in the table. And on another page, I attempted to dump all the email addresses from my table into groups of (n) addresses, as a test. I'm only pulling 3 data columns (2 name columns and the email address). Still, the page just idles. Can someone point me to the problem? I think it must be in my code, because I can get PHPMYADMIN to do a complete dump on this system without a problem. Here's a code sample from the email address page. (The web mail client I'm using is wiping out my formatting, please drop me a personal email and I'll send you the actual entire PHP file). if (isset($submit) && (is_numeric($list_length))) { /* We are creating a list from the database */ $sql = "select name_fn, name_ln, email from contact where correspond = 'email' and email is not null and email != '' order by name_ln, name_fn"; $contacts = mysql_query($sql,$db) or die ('<h2> ERROR: Unable to read from the database because </h2>'.mysql_errno().': '.mysql_error().'<br>'); $g =1; $i =1; while ($contact = mysql_fetch_array($contacts)) { if ($i==1) echo "<P><B>Group $g:</b><p>"; if ($i>1) echo $list_separator; /* to put a separator between email addresses */ print ($contact['name_fn'].' '.$contact['name_ln'].' <'.$contact['email'].'>'); if ($i==$list_length) { $i=1; $g++; } else { $i++; } } mysql_free_result($contacts); } If it's not my code, can someone maybe point me at someplace I can look next? When I tried this on my old work laptop, (which was using PHP, Mysql and IIS on Win2k), I was able to dump the whole table with a very similar script, and no timeouts. So perhaps it's something about my Apache setup? I'm very confused, please give a newbie a hand? Thanks, -P -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]