Shamrox Posted January 23, 2007 Share Posted January 23, 2007 I have a page that lists recent registration entries. Click one of the names on the list and it takes you to the full detail of the record.Some load fine, some load a blank page. when I view the source all I see is...[code]<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD><BODY></BODY></HTML>[/code]Any idea what might be causing this? I've looked at the records in the db, but nothing seems wrong. HELP!!!! Quote Link to comment Share on other sites More sharing options...
Shamrox Posted January 23, 2007 Author Share Posted January 23, 2007 Oh, forgot to add that I'm using php/mysql. Quote Link to comment Share on other sites More sharing options...
fenway Posted January 23, 2007 Share Posted January 23, 2007 Well, it's PHP fault, whatever it is. Quote Link to comment Share on other sites More sharing options...
Shamrox Posted January 23, 2007 Author Share Posted January 23, 2007 How so? Same page loads one record, but not another. How do I debug? Any suggestions? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 23, 2007 Share Posted January 23, 2007 PHP produces the output, not MySQL... if your PHP script dies, well. Quote Link to comment Share on other sites More sharing options...
Shamrox Posted January 23, 2007 Author Share Posted January 23, 2007 www.sitename.com/registration.php?id=201 This loads fine.www.sitename.com/registration.php?id=202 This loads blank page. Same exact code just pulling a different record from db. Still php dying?? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 23, 2007 Share Posted January 23, 2007 Don't know what to tell you... obviously, the control paths are different. Quote Link to comment Share on other sites More sharing options...
Shamrox Posted January 23, 2007 Author Share Posted January 23, 2007 Also to note, things worked fine yesterday. What's a control path? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 24, 2007 Share Posted January 24, 2007 I assume your script does something different if the DB query returns no results... Quote Link to comment Share on other sites More sharing options...
Shamrox Posted January 26, 2007 Author Share Posted January 26, 2007 Here's a bit more info after doing some major digging today.In the error logs I found this error.PHP Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 54862 bytes) in /path/to/clients/files/registrar_new.php on line 788I'm not sure what that means, so I went to look at what the code in line 788 was..$sql = "SELECT * FROM `spec_supplier` ORDER BY `name`;";$results = mysql_query($sql);while($row = mysql_fetch_array($results, MYSQL_ASSOC)){ $suppliers[] = $row;}Line 788 is the while statement.So, might someone have any other insite into my problem with the added info above? Thanks. Quote Link to comment Share on other sites More sharing options...
fenway Posted January 26, 2007 Share Posted January 26, 2007 Well, i'm not sure how you're using 30MB of memory.... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.