Jump to content


Photo

Building Static Pages - Script Timing Out


  • Please log in to reply
1 reply to this topic

#1 deezin

deezin
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 29 April 2006 - 06:34 PM

Hi there. I hope that you can help me. I am extracting a bunch of static pages from a database with PHP and MYSQL. I had the script working on a smaller scale, but when it had to sort out about 4,000 listings at once, it timed out. I have listings that I want separated by city within each state. So I want the page to look something like (all the listings to be separated by city one one page like below):

LISTINGS IN NEWARK, NJ

Listing Title 1
123 Generic Street Address
Newark, NJ 08520
609-371-1223

Listing Title 2
4556 Generic Street Address
Newark, NJ 08435
609-453-4323

etc.

I have included some my code below the table information, maybe one of you can help me and take a look. Thank you!!

TABLE 1

TABLE NAME: states_cites

id (auto_incremented number)
state (State Abbreviationgs)
city (City Names)

TABLE 2

TABLE NAME: tutorials

id (auto_incremented number)
title (Listing Title)
street (street address)
city (city)
state (state abbreviation)
zip (zip code)
phone (phone number)
category (category name)
catid (category id number)
icon (image name)
sub_folder (directory folder name)
categ_exp (long explanation of category)
short_category (short category explanation)

TABLE 3

TABLE NAME: categories

id (auto_incremented number)
category (category name)
short_category (short category explanation)
description (long category description)
sub_folder (directory folder name)

I will link to the code because it is too long to copy and paste into this thread.

[a href=\"http://www.aimingatmoms.com/phphelp.txt\" target=\"_blank\"]http://www.aimingatmoms.com/phphelp.txt[/a]

#2 michaellunsford

michaellunsford
  • Members
  • PipPipPip
  • Advanced Member
  • 1,023 posts
  • LocationLouisiana, USA

Posted 29 April 2006 - 07:13 PM

do you have the small scale version in production so we can see what it's supposed to be doing?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users