Web Hosting Talk







View Full Version : reload page with different index


crowitis
10-16-2004, 10:37 AM
I have a mysql address database and a php site which works.
The user should be allowed to load the site with a different index (name, city,state, zip).
BTW. the site is www crowitis.com/member/test2.php
I know the site need some cosmetics but first I like to have it running with all features *LOL*
Any help is welcome.
Fritz

pflangan
10-18-2004, 12:59 PM
the reason no one has replied is probably because;

the link is wrong.
your question is vague and unhelpful.

crowitis
10-18-2004, 01:51 PM
Sorry, in meantime I deleted all my test sites.
I just copied the site to different site-names and put a link to these sites, they just will load the database with a different index. It's no professional way but it works *lol*
The site you can find at crowitis.com/member/index.php
Thanks
Fritz

thartdyke
10-18-2004, 05:34 PM
Ouch! It runs like molasses! Is your server overloaded, or do you not have any indexes on the fields you wish to sort by?

pflangan
10-19-2004, 06:42 AM
And you want what?
Index is being used out of context here.

When you say you want to 'load the site with a different index'
what you really mean is that you want people to be able to load the site with the list 'SORTED' by different fields.

1. Change your submit method to GET.
this way you can link to the page using index.php?sort=city or index.php?sort=state etc. from other sites / pages

Improving performance; At the start of you page place
<?PHP ob_start(); ?>

and at the end

<?PHP ob_end_flush(); ?>

this should help the speed of rendering your page. the page will be sent to the browser in one final blast, rather than in small chunks as it is loaded by the database.

Consider using indexes in your table. simple to do, improves speed no end.

crowitis
10-19-2004, 12:59 PM
I set the indexes but in meantime I found out that the host not the fastest for PHP/Mysql.
I'll check out your hints and try to make it faster.
If it don't work I have to look for a faster host.
Thanks
Fritz