[SOLVED] page link

[spooke2k]

hi i have just started programming in php and am having differculty finding out how to seperate my sql recordsets im returning i want to limit how many to display. And have  page one, page 2 next page back etc on on page to display next 20 pictures etc . please see code below and if someone could tell me how it would be appeciated.

 

at the moement code below just throws information out into a table and like i said im new so sorry for newb coding

.

Thanks

 

Spooke2k

 

while($row = mysql_fetch_array($result))

  {

echo "<tr>";

echo "<td>" . $row['prozenid'] . " </td>";

echo "<td>" . $row['productcode'] . "</td>";

echo "<td>£" . $row['price'] . "</td>";

echo '<td><div align="center">

<a href= "http://www.testsite/images/large/'. $row['productcode'].'.jpg">

<img src= image/tn_'. $row['productcode'].'.jpg alt="no image available"

/> <a/> </div>';

echo "</tr>";

}

 

[cooldude832]

 
  <a href= "http://www.testsite/images/large/'. $row['productcode'].'.jpg"> 

is wrong you are missing quotes to escape to a variable try

   <a href= \"http://www.testsite/images/large/". $row['productcode'].".jpg\"> 

 

you need to escape with same quotes you started with rule of thumbs always use double quotes on echo statements and if needed use \" to escape an in echo double quote

 

one sec i'm seeing a lot more issues than that one. Check your other quotes

[cooldude832]

I cleaned it up a bit

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['prozenid'] . " </td>";
echo "<td>" . $row['productcode'] . "</td>";
echo "<td>£" . $row['price'] . "</td>";
echo "<td>
	<div align=\"center\">
		<a href= \"http://www.testsite/images/large/". $row['productcode'].".jpg\">
			<img src=\"image/tn_". $row['productcode'].".jpg\" alt=\"no image available\" /> 
		<a />
	</div>";
echo "</tr>";
}

 

 

I think this is correct now

[taith]

 
  <a href= "http://www.testsite/images/large/'. $row['productcode'].'.jpg"> 

is wrong you are missing quotes to escape to a variable try

   <a href= \"http://www.testsite/images/large/". $row['productcode'].".jpg\"> 

 

you need to escape with same quotes you started with rule of thumbs always use double quotes on echo statements and if needed use \" to escape an in echo double quote

 

one sec i'm seeing a lot more issues than that one. Check your other quotes

 

nope! you gotta check your quotes... he echo '';ed not ""

 

 

 

your talking pagination... http://www.phpfreaks.com/tutorials/43/0.php

[spooke2k]

thanks guys

 

really appeciated.

 

Spooke2k

[ted_chou12]

while($row = mysql_fetch_array($result))
  {
echo "<tr>";
echo "<td>{$row['prozenid']}</td>"; 
echo "<td>{$row['productcode']}</td>"; 
echo "<td>£{$row['price']}</td>";
echo "<td><div align=\"center
\"> 
   <a href=\"http://www.testsite/images/large/{$row['productcode']}.jpg"> 
   <img src= image/tn_{$row['productcode']}.jpg alt=\"no image available\" 
   /> <a/>   </div>";
echo "</tr>";

Please make sure you use quotes consistently, and {$row['']} can avoid complex quotes.

Ted

}

[cooldude832]

while($row = mysql_fetch_array($result))
  {
echo "<tr>";
echo "<td>{$row['prozenid']}</td>"; 
echo "<td>{$row['productcode']}</td>"; 
echo "<td>£{$row['price']}</td>";
echo "<td><div align=\"center
\"> 
   <a href=\"http://www.testsite/images/large/{$row['productcode']}.jpg"> 
   <img src= image/tn_{$row['productcode']}.jpg alt=\"no image available\" 
   /> <a/>   </div>";
echo "</tr>";

Please make sure you use quotes consistently, and {$row['']} can avoid complex quotes.

Ted

}

 

you missed one on the part ,.jpg  alt=" should be .jpg alt=\"

[ted_chou12]

opps, sorry.  :-\, thanks for correcting.

Ted

[cooldude832]

also use the "

" it makes it easier to read gotta love the pretty print

[spooke2k]

is bring an error now of missing <

on page these lines somewhere any ideas

 

  <a href=\"http://www.testpagecom/images/large/{$row['productcode']}.jpg">

  <img src= image/tn_{$row['productcode']}.jpg alt="no image available\"

[ted_chou12]

<a href=\"http://www.testpagecom/images/large/{$row['productcode']}.jpg\">

  <img src= image/tn_{$row['productcode']}.jpg alt=\"no image available\"

Red is what I added, I think thats where the error is.

Ted

[cooldude832]

that and src= \" you have src= no quote for escaping into the location of image fyi if you use a text editor with line numbering php will error out line numbers which is very nice