record navigation

[bluemonkey]

hello there all im new to php ive done a bit of asp in the past and trying to learn as i go ive done a page so far my aims is to run throught the DB and put it in a table with every 3rd record add a new <td> that bit works ok i think and but getting to the forth record is the problem. the page runs but loops the first 3 records. any help would be great thank you heres my code

<?php
$dbconninfo = mysql_connect("localhost", "usrname", "pass");
$dbconnect = mysql_select_db("Ketya", $dbconninfo);
if ( $dbconnect == false )
{
echo mysql_error();
} else {
$sql = "SELECT * FROM Images";
$dbconnect = mysql_query( $sql );
if ( $dbconnect != false )
{
while ($rs = mysql_fetch_array($dbconnect))
{
$count=1;
while($count!=3)
{
if ($count==1){
echo "<tr align='center'>";
}

																echo " <td>".$count."<img src='images/" .$rs['Cat']. "/" .$rs['Name']. "_sm.jpg' width=100' height='75' border='1'><br>" .$rs['Desc']. "</td>";

																if ($count==2){
																	echo "</tr>";
																	echo " <tr height='10'>";
																	echo " <td colspan='3'><img src='images/spacer.gif' width='1' height='10'/></td>";
																	echo "</tr>";
																}

															$count++;
															}
														}
                                                    } else {
                                                        echo mysql_error();
                                                    }
                                                }

                                              ?>[/SIZE]

thanks for the help

[meigwil]

Your code is very unclear. Try stating what you want to achieve.

Is it something like this?

<tr align='center'>

  <td>1<img src='images/cat/name1_sm.jpg' width='100' height='75' border='1'><br>Description1</td>

  <td>2<img src='images/cat/name2_sm.jpg' width='100' height='75' border='1'><br>Description2</td>

  <td>3<img src='images/cat/name3_sm.jpg' width='100' height='75' border='1'><br>Description3</td>

</tr>
<tr height='10'>

 <td colspan='3'><img src='images/spacer.gif' width='1' height='10'/></td>

</tr>

[bluemonkey]

yes but with more pictures so

  <tr align="center">
    <td><img src="images/forest/000001_sm.jpg" width="100" height="75" border="1"><BR/>Description</td>
    <td><img src="images/forest/000002_sm.jpg" width="100" height="75" border="1"><BR/>Description</td>
    <td><img src="images/forest/000003_sm.jpg" width="100" height="75" border="1"><BR/>Description</td>
  </tr>
  <tr>
    <td><img src="images/spacer.gif" width="1" height="10"/></td>
  </tr>
  <tr align="center">
    <td><img src="images/forest/000004_sm.jpg" width="100" height="75" border="1"><BR/>Description</td>
    <td><img src="images/forest/000005_sm.jpg" width="100" height="75" border="1"><BR/>Description</td>
    <td><img src="images/forest/000006_sm.jpg" width="100" height="75" border="1"><BR/>Description</td>
  </tr>
  <tr>
    <td><img src="images/spacer.gif" width="1" height="10"/></td>
  </tr>

like this but i need to have 12 images per page so i will need to add a page size type of thing

thank you for the help so far 😃

[bluemonkey]

ive changed the code a tiny bit and now im stuck in a loop and i cant see were the problem is

<?php 
$dbconninfo = mysql_connect("localhost", "ketya", "ketya"); 
$dbconnect = mysql_select_db("Ketya", $dbconninfo); 
if ( $dbconnect == false ){ 
	echo mysql_error(); 
}else{ 
	$sql = "SELECT * FROM Images"; 
	$dbconnect = mysql_query($sql); 
	$count=1;
	if ( $dbconnect != false ){ 
		while ($rs = mysql_fetch_array($dbconnect)){ 
			while($count<=4){ 
				if ($count==1){ 
					echo "<tr align='center'>"; 
				} 
				echo " <td>".$count."<img src='images/".$rs['Cat']."/".$rs['Name']."_sm.jpg' width=100' height='75' border='1'><br>".$rs['Desc']."</td>"; 
				$count++; 
				if ($count==4){ 
					echo "</tr>"; 
					echo " <tr height='10'>"; 
					echo " <td colspan='3'><img src='images/spacer.gif' width='1' height='10' /></td>"; 
					echo "</tr>"; 
					$count=1; 
				}
			} 
		} 
	}else{ 
		echo mysql_error(); 
	} 
} 
?> 

[Roger_Ramjet]

Ha Ha. Whoops, did not mean to laugh. You are stuck in a loop alright - it's because you reset the count to 1 inside the while, so it never gets to be greater than 4 and you never exit the while. Have another go.

[meigwil]

Try this

$count = 1;
while ($rs = mysql_fetch_array($dbconnect)){

		if($count == 1){
			echo '<tr align="center">';
		}

		echo " <td>".$count."<img src='images/".$rs['Cat']."/".$rs['Name']."_sm.jpg' width=100' height='75' border='1'><br>".$rs['Desc']."</td>";

		if($count == 4){
							echo '<tr> <td><img src="images/spacer.gif" width="1" height="10"/></td> </tr>';
		}

  $count++;
		if($count > 4){
		  $count = 1;
		}
}

It is a way of doing it, not sure if it's the best.

Because you're using tables, you'll need a way of finishing the cells of neatly (in case you haven't got images in multiples of three).

I recommend ditching the tables and using CSS for your layouts.

Mei

[bluemonkey]

thank you very much i willg ive it a go 😃