Here is some code I have for an index page of people who post
charts on the Web, kind of like Yahoo Photos or something.
It displays the album title, number of images and date of last
upload. The page takes about 5-6 seconds to load which is all
in the queries I'm sure. Is there a way I can make this more efficient?


$table_name = "Chart_Users";
$sql = "SELECT * FROM $table_name order by album_title";
$result = @mysql_query($sql,$connection) or die(" Couldn't execute query.");
//if(! $result = mysql_query($sql,$connection)) {
  //            print("ERROR ".mysql_errno().": ".mysql_error()."<br>\n$sql<br>\n");
        //              }

        while ($row = mysql_fetch_array($result)) {
        $id = $row['id'];
        $username = $row['username'];
        $title1 = $row['album_title'];
        $title = stripslashes($title1);

                $sql1 = "SELECT COUNT(*) FROM Chart_Files where id = '$id'";
                $result1 = @mysql_query($sql1,$connection) or die(" Couldn't execute 
                //if(! $result = mysql_query($sql1,$connection)) {
                //print("ERROR ".mysql_errno().": ".mysql_error()."<br>\n$sql<br>\n");
                        $count = mysql_result($result1,0,"count(*)");

                                $sql2 = "SELECT date_format(date, '%b. %D, %Y') as 
date1 FROM Chart_Files where
id = '$id' order by photoid desc limit 1";
                                $result2 = @mysql_query($sql2,$connection) or die(" 
Couldn't execute query.");
                                $row = mysql_fetch_array($result2);
                                $date1 = $row['date1'];

                                if ($count > 0) {

        $display_block .= "<tr><td nowrap align=\"left\"><b><a
align=\"left\">$count</td><td align=\"right\" nowrap>$date1</td></tr>";

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to