Forum: web design and graphics community

Celestial Star Forum > Web Development > Coding > Display rows in columns?

Pages: [1]

« previous next »

Author

Topic: Display rows in columns? (Read 856 times)

paine

Angeling

Posts: 7

Display rows in columns?

« on: July 11, 2005, 12:19:37 PM »

ok i've read everything here and no one seems to be trying to combine their next, prev II navigation with the displaying rows in columns code. I'm a little lost... here's my code

Code:

<?php

$user="-----";
$host="localhost";
$password="-----";
$database="-------";

$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to server"); $db = mysql_select_db($database,$connection)
or die ("Couldn't select database");

echo "<div align=\"center\"><table width=\"95%\"><tr>";

$query .="SELECT * from ---- order by id desc";
$result= mysql_query($query, $connection) or die
("Could not execute query : $query ." . mysql_error());

//CODE A
// Start paging variables
$screen = $_GET['screen'];
$PHP_SELF = $_SERVER['PHP_SELF'];
$rows_per_page=5; // number of records per page
$total_records=mysql_num_rows($result);
$pages = ceil($total_records / $rows_per_page); // calculate number of pages required

if (!isset($screen))
$screen=0;
$start= $screen * $rows_per_page; // determine start record
$query .= "LIMIT $start, $rows_per_page";
$result= mysql_query($query) or die
("Could not execute query : $query ." . mysql_error());

while ($row=mysql_fetch_array($result))
{

$id=$row["id"];
$name=$row["name"];
$artist=$row["artist"];
$artisturl=$row["artisturl"];
$series=$row["series"];
$previewimage=$row["previewimage"];

}

$rows_per_page=24;
$total_records=mysql_num_rows($result);
$pages = ceil($total_records / $rows_per_page);
mysql_free_result($result);

if (!isset($screen))
$screen=0;
$start = $screen * $rows_per_page;
$query .= " LIMIT $start, $rows_per_page";
$result= mysql_db_query($dbase, $q, $connection) or die
("Could not execute query : $query ." . mysql_error());

$divide=0;

while ($data = mysql_fetch_array($result)) {

if($divide%2==0 && $divide!=0){
echo "</tr><tr>";
}

echo "<td><center><img src=\"$previewimage\"></center><br>
ID: $id<br>
Name: $name<br>
Artist: <a href=\"$artisturl\">$artist</a><td>";

$divide++;

}

echo "</tr></table></div>";

        if ($screen > 0) {
        $j = $screen - 1;
        $url = "$PHP_SELF?screen=$j";
        echo "<a href=\"$url\">«;</a>";
        }

        // page numbering links now
        $p = 5;
        $lower = $p;
        $upper = $screen+$p;
        while($upper>$pages){
            $p = $p-1;
            $upper = $screen+$p;
        }
        if($p<$lower){
            $y = $lower-$p;
            $to = $screen-$y;
            while($to<0){
                $to++;
            }
        }

        if(!empty($to))
        {
            for ($i=$to;$i<$screen;$i++){
                $url = "$PHP_SELF?screen=" . $i;
                $j = $i + 1;
                echo " | <a href=\"$url\">$j</a> | ";
            }
        }

        for ($i=$screen;$i<$upper;$i++) {
            $url = "$PHP_SELF?screen=" . $i;
            $j = $i + 1;
            echo " | <a href=\"$url\">$j</a> ";
        }

        if ($screen < $pages-1) {
        $j = $screen + 1;
        $url = "$PHP_SELF?screen=$j";
        echo "<a href=\"$url\">» </a>";
        }
?>

my error message is:

Code:

Could not execute query : SELECT * from kimava order by id descLIMIT 0, 5 .You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'descLIMIT 0, 5' at line 1


	Logged

puretaurus21

Guest

Display rows in columns?

« Reply #1 on: August 01, 2005, 02:11:10 AM »

I think the error is in your query. Try this:

Code:

$query = "SELECT * from ---- order by id desc ";


	Logged

Melfina

Administrator
Valkyrie Randgris

Posts: 1289

Display rows in columns?

« Reply #2 on: August 01, 2005, 04:39:46 AM »

eww, I think the code for the pagination and such is a bit messed. It may be something more like this. Some parts were duplicated. Try doing what puretaurus said if that doesn't work:

Code:

<?php

$user="-----";
$host="localhost";
$password="-----";
$database="-------";

$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection)
or die ("Couldn't select database");

echo "<div align=\"center\"><table width=\"95%\"><tr>";

$query .="SELECT * from ---- order by id desc";
$result= mysql_query($query, $connection) or die
("Could not execute query : $query ." . mysql_error());

//CODE A
// Start paging variables
$screen = $_GET['screen'];
$PHP_SELF = $_SERVER['PHP_SELF'];
$rows_per_page=5; // number of records per page
$total_records=mysql_num_rows($result);
$pages = ceil($total_records / $rows_per_page); // calculate number of pages required

if (!isset($screen))
$screen=0;
$start= $screen * $rows_per_page; // determine start record
$query .= "LIMIT $start, $rows_per_page";
$result= mysql_query($query) or die
("Could not execute query : $query ." . mysql_error());

$divide=0;

while ($row = mysql_fetch_array($result)) {

extract($row); //Shorter method to extract all columns and rows

if($divide%2==0 && $divide!=0){
echo "</tr><tr>";
}

echo "<td><center><img src=\"$previewimage\"></center><br>
ID: $id<br>
Name: $name<br>
Artist: <a href=\"$artisturl\">$artist</a><td>";

$divide++;

}

echo "</tr></table></div>";

        if ($screen > 0) {
        $j = $screen - 1;
        $url = "$PHP_SELF?screen=$j";
        echo "<a href=\"$url\">«;</a>";
        }

        // page numbering links now
        $p = 5;
        $lower = $p;
        $upper = $screen+$p;
        while($upper>$pages){
            $p = $p-1;
            $upper = $screen+$p;
        }
        if($p<$lower){
            $y = $lower-$p;
            $to = $screen-$y;
            while($to<0){
                $to++;
            }
        }

        if(!empty($to))
        {
            for ($i=$to;$i<$screen;$i++){
                $url = "$PHP_SELF?screen=" . $i;
                $j = $i + 1;
                echo " | <a href=\"$url\">$j</a> | ";
            }
        }

        for ($i=$screen;$i<$upper;$i++) {
            $url = "$PHP_SELF?screen=" . $i;
            $j = $i + 1;
            echo " | <a href=\"$url\">$j</a> ";
        }

        if ($screen < $pages-1) {
        $j = $screen + 1;
        $url = "$PHP_SELF?screen=$j";
        echo "<a href=\"$url\">» </a>";
        }
?>


	Logged

MySpace ~ MySpace Codex ~ Rune Nifelheim

Pages: [1]

« previous next »

Jump to:

Forum: web design and graphics community

General

Art boards

Web development

Off-topic