Jump to content

Building Static Pages - Script Timing Out


deezin

Recommended Posts

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]
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.