Layout Help

[xsfssg]

Hello,

I am a self-taught designer for ministries with limited knowledge of PHP/MySQL. I would like to custom fit 80+ vehicle records into either pages of 10 or 2 columns. I really could use the help to get this ministry page to view as above. The following code lists them all in one long page.

<?
$dbuser = "user"; 
$dbserver = "localhost"; 
$dbpass = "pass"; 
$dbname = "name_com"; 

mysql_connect($dbserver, $dbuser, $dbpass)
or die ("UNABLE TO CONNECT TO DATABASE");
mysql_select_db($dbname)
or die ("UNABLE TO SELECT DATABASE");

$sql = "SELECT * FROM inventory";
$result = mysql_query($sql);
if ($myrow = mysql_fetch_array($result)) {
do
{
$id=$myrow['id'];
$ref=$myrow['ref'];
$year=$myrow['year'];
$make=$myrow['make'];
$model=$myrow['model'];
$price=$myrow['price'];
echo "    <table width=285 cellspacing=10 cellpadding=0 class=reg>
    <tr>
     <td width=90 rowspan=3><img src=list/$ref.jpg alt='Image not available' width=75 height=56></td>
     <td width=210>Ref# $ref</td>
    </tr>
    <tr>
     <td width=210>$year $make $model</td>
    </tr>
    <tr>
     <td width=210>$$price</td>
    </tr>
   </table>
";
}
while ($myrow = mysql_fetch_array($result));
}
?>

Thanks,
xsfssg

[SargeZT]

First things first, I'd be very careful about using $$price, as that will do something entirely unexpected. But, to the main point:

What you'll need to do is add a LIMIT clause to the MySQL query. For the first page, it will be

$sql = "SELECT * FROM inventory LIMIT $start,10 ORDER BY id DESC";

assuming that you want the newest ID's to be listed first. That would list ID's 1-10, assuming that's how you have it set up.

Then, at the bottom of the page, you'd add a self-referencing link:

<?
$start += 10;
echo '<a href="./car.php?start=$start">Next page</a>';
?>

From that point, you need to add one more variable at the stop of the page:

isset($_GET['start']) ? $start = $_GET['start'] : $start = 0;

Which will see the beginning part of the LIMIT to zero on the first page, and then will display the pertinent information.

Edit:

Oh, and one last thing. I'd reccomend avoiding the use of * in the MySQL query if you know exactly what tables you're retrieving, as one query with an asterik will actually perform several queries. A better way would be:

$sql = "SELECT id, ref, year, make, model, price FROM inventory LIMIT $start,10 ORDER BY id DESC";

[xsfssg]

Thanks SargeZT, but now I'm getting:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/*/**-www/car.php on line 23

xsfssg

[SargeZT]

Two things you can do to help me find out what's wrong:
Immediatly after declaring $sql, echo it out.

Secondly, in the

$result = mysql_query($query);

, change it to

$result = mysql_query($query) or die(mysql_error());

Thanks.

[xsfssg]

SargeZT,

Had to play with what you told me to do. It will open the page with the next 10 records, but not display a link for the next 10 on the 3rd page.

<?
isset($_GET['start']) ? $start = $_GET['start'] : $start = 0;

$dbuser = "user"; 
$dbserver = "localhost"; 
$dbpass = "pass"; 
$dbname = "dbname"; 

mysql_connect($dbserver, $dbuser, $dbpass)
or die ("UNABLE TO CONNECT TO DATABASE");
mysql_select_db($dbname)
or die ("UNABLE TO SELECT DATABASE");

$sql = "SELECT * FROM inventory ORDER BY ref ASC LIMIT $start,10";
$result = mysql_query($sql) or die(mysql_error()); 
if ($myrowsel = mysql_fetch_array($result)) {
do
{
$id=$myrowsel['id'];
$ref=$myrowsel['ref'];
$year=$myrowsel['year'];
$make=$myrowsel['make'];
$model=$myrowsel['model'];
$price=$myrowsel['price'];
switch ($shade)
{
case 'row_lite':
$shade = 'row_drk';
break;
case 'row_drk':
$shade = 'row_lite';
break;
default:
$shade = 'row_lite';
break;
}
echo "             <tr>
              <td valign=top class=$shade>
               <table width=100% cellspacing=0 cellpadding=3>
                <tr>
                 <td width=75 align=center valign=middle><img src=list/$ref.jpg alt='Image not available' width=75 height=56></td>
                 <td width=100 nowrap class=reg>Ref#&nbsp;$ref</td>
                 <td width=250 nowrap class=reg>$year&nbsp;$make&nbsp;$model</td>
                 <td width=70 nowrap class=reg>$$price</td>
                 <td width=60 nowrap class=reg>&nbsp;td>
                 <td width=100%>&nbsp;</td>
                </tr>
               </table>
              </td>
             </tr>
";
}
while ($myrowsel = mysql_fetch_array($result));
}
?>
            </table>
           </td>
          </tr>
         </table>
        </td>
       </tr>
       <tr>
        <td width=100% valign=top colspan=2>
         <table width=100% cellspacing=0 cellpadding=3>
          <tr>
           <td width=10>&nbsp;</td>
           <td width=100%>
<?
$next = +10;
if ($start < 10) {
echo "<a class=lnk href=list_main3.php?start=$next>Next page »</a>";
}
?> 

I really appreciate your time with this.

xsfssg

P.S. The $$price you mentioned above was actually & # 3 6 ; $price without spaces