	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

05/11/2005 at 07:52AM PDT, ID: 21420523

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

5.6

Speeding up the php/mysql process

Asked by katneej in PHP Scripting Language

Tags: php

Hi all,

I'm basically in the process of developing a largely dependent php/mysql site. As I'm progressing through each section, I'm wondering if my approach could be changed for more efficiency. I'm not sure if you're allowed to mention site names here but www.jammyjunction.com/games.php gives a good idea of the sort of layout to be used throughout the site. So, my approach:

<div class="listings">
<table width="550" border="1" cellpadding="0" cellspacing="0" bordercolor="#7B868E" align="center" >
<tr>

<?php
include "database.php";
$query="SELECT * FROM games order by date desc";
$result = mysql_query($query)
or die ("Couldn't execute query");
while ($row=mysql_fetch_array($result)){

echo"<td width='50%' bgcolor=$colour>
<div id='info'><h2>{$row['title']}</h2></div>
<a href='play.php?title={$row['title']}&file={$row['filename']}'>
<img src=media/{$row['picfile']} border='0'><div id='write'></a>
{$row['descrip']}</div>
</td>";
}
?>

</table>

I've left out some functions and other such frills as not to bombard you all with code. I just found that the php pages usually hang for a while before loading. Any suggestions? I remember reading something about tables have to be populated before anything is diplayed? Maybe the include statement is called too many times?

Also, to display a game, I use the $_GET array as one can see from above,play.php is called with e.g. play?title=gamename&file=filename.swf. From here, play.php extracts this and plays it.

In the MySql database there is a table corresponding to each type of file i.e.videos, animations,games as to seperate the surge or queries.

Thanks in advance

View the Solution FREE for 30 Days

Keywords: Speeding up the php/mysql process

	Title
1	Fill a rotation jscript with information fro…
2	how to detect the DIV name with PHP…
3	php with javascript
4	Fatal error: Call to undefined function …
5	Blank Pages With PHP and MY SQL an…
6	trying to load a image to and retrieve fr…

Loading Advertisement...

20091028-EE-VQP-87 - Hierarchy

1. Ray_Pas... 2,056,571
2. cxr 1,232,724
3. hielo 347,424
4. angelIII 317,162
5. al3cs12 285,771
6. Michael701 280,511
7. bportlock 257,437
8. gr8gonzo 246,267
9. profya 229,051
10. logudotcom 219,914
11. wuff1uk 213,320
12. BrianMM 211,960
13. thehagman 142,302
14. gamebits 141,942
15. shobinsun 138,579
16. RQuadling 130,730
17. Mahdii7 121,650
18. mplungjan 119,450
19. Hube02 115,519
20. routinet 102,525
21. ddrudik 101,262
22. agamal 100,643
23. fibo 98,578
24. ycTIN 94,812
25. TerryAtO... 93,365

1. Ray_Pas... 2,759,183
2. hernst42 2,557,533
3. hielo 2,363,165
4. Roonaan 2,131,418
5. cxr 1,472,454
6. angelIII 1,301,795
7. TeRReF 1,246,909
8. Squinky 1,065,477
9. Diablo84 1,046,676
10. RQuadling 953,974
11. glcummins 763,827
12. steelseth12 654,695
13. logudotcom 638,873
14. snoyes_jw 599,563
15. bportlock 587,696
16. yodercm 544,631
17. Michael701 542,692
18. routinet 542,090
19. gamebits 517,885
20. Zyloch 496,930
21. ddrudik 489,665
22. b0lsc0tt 476,997
23. nizsmo 470,054
24. ldbkutty 468,085
25. Batalf 452,611

Speeding up the php/mysql process

Asked by katneej in PHP Scripting Language

Tags: php

About this solution