displaying rows of images from db

cyronuts

can anyone see anything wrong with the following code? bunkermaster was trying to help me out...it seems like the $Next varialbe and ,9 are stopping it out:


<?

require_once("sc_fns.php");

db_connct(); 

 mysql_select_db("supra_sc");
  $query = "SELECT * FROM images LIMIT ".$Next." , 9";
  $result = mysql_query($query);

?>

<TABLE WIDTH="450" CELLPADDING="3" CELLSPACING="10" BORDER="0" COLS="3"> 
<?
$inc = 1;
while ($row = mysql_fetch_array($result)) {
    if ( $inc % 3 == 1 ){    

?>
<TR> 
<?
    }

?>
<TD WIDTH="33%" ALIGN="CENTER"><A HREF="<?= $row["a_href"]?>"><IMG SRC="<?= $row["img_src"]?>" WIDTH="100" HEIGHT="100" BORDER="0"></TD> 
<?
    if ( $inc % 3 == 0 ){
?>
</TR> 
<?
    }
    $inc++;
}
// next display urkl will be "display.php?Next=$inc"

echo ("<a HREF='display.php?Next=$inc'>Next</a>");
?>

Tekime

Posted by cyronuts
db_connct();

Should this be db_connect()?

Weedpacket

  $query = "SELECT * FROM images LIMIT $Next,9";
$result=mysql_query($query) or die ("MySQL died on '$query' with this error:".mysql_error());

cyronuts

well, here is the error, not sure why???

MySQL died on 'SELECT * FROM images LIMIT ,9' with this error:You have an error in your SQL syntax near '9' at line 1

cyronuts

did a little revising and got the bug out, but it is still not quite performing the way I need it. The code does bring back the first nine images, and provides the 'NEXT' link, but it does not link to the next few images still in the database? HEre is the current code:


<?

require_once("sc_fns.php");

db_connct(); 

 mysql_select_db("supra_sc");
  $query = "SELECT * FROM images LIMIT 9";
  $result=mysql_query($query) or die ("MySQL died on '$query' with this error:".mysql_error());

?>

<TABLE WIDTH="450" CELLPADDING="3" CELLSPACING="10" BORDER="0" COLS="3"> 
<?
$inc = 1;
while ($row = mysql_fetch_array($result)) {
    if ( $inc % 3 == 1 ){    

?>
<TR> 
<?
    }

?>
<TD WIDTH="33%" ALIGN="CENTER"><A HREF="<?= $row["a_href"]?>"><IMG SRC="<?= $row["img_src"]?>" WIDTH="100" HEIGHT="100" BORDER="0"></TD> 
<?
    if ( $inc % 3 == 0 ){
?>
</TR> 
<?
    }
    $inc++;
}
// next display urkl will be "display.php?Next=$inc"

echo ("<a HREF='display.php?Next=$inc'>Next</a>");
?>

cyronuts

it works with this line:

$query = "SELECT * FROM images LIMIT 9, $Next";

Now, HOW TO PUT IN A 'PREV' link...?

thanks to all! here is the completed code:


<?

require_once("sc_fns.php");

db_connct(); 

 mysql_select_db("supra_sc");
  $query = "SELECT * FROM images LIMIT 9, $Next";
  $result=mysql_query($query) or die ("MySQL died on '$query' with this error:".mysql_error());

?>

<TABLE WIDTH="450" CELLPADDING="3" CELLSPACING="10" BORDER="0" COLS="3"> 
<?
$inc = 1;
while ($row = mysql_fetch_array($result)) {
    if ( $inc % 3 == 1 ){    

?>
<TR> 
<?
    }

?>
<TD WIDTH="33%" ALIGN="CENTER"><A HREF="<?= $row["a_href"]?>"><IMG SRC="<?= $row["img_src"]?>" WIDTH="100" HEIGHT="100" BORDER="0"></TD> 
<?
    if ( $inc % 3 == 0 ){
?>
</TR> 
<?
    }
    $inc++;
}
// next display urkl will be "display.php?Next=$inc"

echo ("<a HREF='linking.php?Next=$inc'>Next</a>");
?>