dispay images on a table

vavavince

hi peeps... im trying to display a field from a db.. i want it to display 5 pictures per row.. these pics are hyperlinks to certain pages.. a sample is www.gsmarena.com, click on a phone make.. http://www.gsmarena.com
it displays 4 but i want to display 5.. thanks in advance.. more power!!!!

tsinka

Hi,

please post some code ... maybe a loop error ?

Thomas

vavavince

thanx for the quick response.. im new to php, i tried displaying it but it echoed as only one line.. 😃

<?php
$result = @('SELECT model FROM fones2 where make="alcatel"');
if (!$result)
{
die('<p>Error performing query: ' . mysql_error() . '</p>');
}

$i=1;
	while ($i<=5)
	 {
	 while ( $row = mysql_fetch_array($result) )
	 {
	 echo($row['model']); 
	 $i++;
	 }
	 echo "<br>";
	 }

model is also the filename of the image to b called by the script..
thanks again.. maybe u can give me a better alternative.. i've already borrowed books but i cant seem to find the right code..
More Power!!!

vavavince

i belive this is very wrong coz i hav to put it in a table.. no borders though.. when u click on the picture, it's supposed to go to the php page of the model u clicked.. hav u seen the gsmarena.com pages.. that's what im tryin to copy..

tsinka

Hi,

I'd suggest to use a table. Besides that there are problems with the loop:

Simple example without styles and without using a table class or something like this.

<?php 
$result = @mysql_query('SELECT model FROM fones2 where make="alcatel"'); 
if (!$result) 
{ 
die('<p>Error performing query: ' . mysql_error() . '</p>'); 
} 

echo "<table>\n  <tr>\n";

$i=1; 

while ( $row = mysql_fetch_array($result) ) 
{
  $imagePath = $row['model'];
  $id = $row['id'];

  if ($i==6) {
    echo "  </tr>\n  <tr>\n";
    $i = 1;
  }

  echo <<< EOHTML
    <td>
      <a href="detail.php?id=$id">
        <img src="$imagePath" border="0">
      </a>
    </td>

EOHTML;
  $i++; 
}

  for ($cnt=$i;$cnt<6;$cnt++) {
    echo "    <td>&nbsp;</td>\n";
 }

  echo "  </tr>\n</table>\n";
?>

Thomas

vavavince

thanks.. ill try that out.. 😃

vavavince

Hey Ya!!! 😃

im having an error message..

Parse error: parse error, unexpected T_SL, expecting ',' or ';' in D:\xampp\htdocs\test_fones\modelstestalcatel2.php on line 29

it pertains to this part of the code:

echo <<< EOHTML
<td>
<a href="detail.php?id=$id">
<img src="$imagePath" border="0">
</a>
</td>

EOHTML;

what does echo <<< EOHTML do?
thanks again..

🙂

tsinka

Hi,

this is called heredoc syntax. You won't have to mess around with escaping double quotes or something like that.

The problem here is that there are spaces after <<< HTML if you copy'n'paste the code from a post.

Just make sure that the line

echo <<< EOHTML doesn't contain any spaces after EOHTML and ends with EOHTML.

Thomas