[RESOLVED] Syntax help required

[Nickel01]

Hello again....
I've been banging my head on this for a day & half & cannot get the syntax correct
The idea Im trying to accomplish here is dynamic display images in a table (3 to a row) with their name below them
The images are resized thumbs (using imagethumb.php)

I'm stuck on the syntax in the echo statement(line 15?)

<?php
mysql_select_db($database_ttb, $ttb);
$query_books = "SELECT books.Title, books.Image FROM books";
$books = mysql_query($query_books, $ttb) or die(mysql_error());
$row_books = mysql_fetch_assoc($books);
$totalRows_books = mysql_num_rows($books);
$image=$row_books['Image'];
$title=$row_books['Title'];
$result = mysql_query($books);

$tdcount = 1;
$numtd = 3; // number of cells per row

echo "<table>";
while($row = mysql_fetch_array($result)<$num) {

if ($tdcount == 1) echo "<tr>";

echo "<td><a href=""><img src='imagethumb.php?s=$image'; ?>&w=100" border="0" alt= '<?php echo $title; ?>"'></a><br>" <?php echo $row_books['Title']; ?> "</td>";

if ($tdcount == $numtd) {
echo "</tr>";
$tdcount = 1;
} else {
$tdcount++;
}
}
// time to close up our table
if ($tdcount!= 1) {
while ($tdcount <= $numtd) {
echo "<td>&nbsp;</td>";
$tdcount++;
}
echo "</tr>";
}
echo "</table>";

?>

[Crowly]

Why are you echoing the php tags here???

echo "<td><a href=""><img src='imagethumb.php?s=$image'; ?>&w=100" border="0" alt= '<?php echo $title; ?>"'></a><br>" <?php echo $row_books['Title']; ?> "</td>";

do this, i prefer to concatenate in the variables, think its more readable with colors, but you could put them directly into the string when using double quotes

echo "<td><a href=\"\"><img src=\"imagethumb.php?s=".$image." w=\"100\" border=\"0\" alt=\"".$title."\"></a>
<br>".$row_books['Title']."</td>";

[ManOnTheMoon]

Hello,

so much useless Backslashes!
PHP search for real Vars when you use Doublequotes.

echo '<td><a href=""><img src="imagethumb.php?s='.$image.' w="100" border="0" alt="'.$title.'"></a><br>'.$row_books['Title'].'</td>';

--
Greets from Vienna

[TheStalker]

dont echo the <?php ?>. remeber to close them before you start new ones. Also if you are going to use double quotes in your links etc put backslashes in front of them \" or just use single quotes '

[Nickel01]

Thanks for the replies guys...fixed my syntax...however I dont get any results...on another page I have this
<?php do { ?>
<table width="50%" border="0">
<tr>
<td><a href=""><img src="imagethumb.php?s=<?php echo $row_books['Image']; ?>&w=100" border="0" alt= <?php echo $row_books['Title']; ?>></a></td>
</tr>

</table>
<?php } while ($row_books = mysql_fetch_assoc($books));
?>
which returns the images below one another in rows.
I cant see what the difference is?

[Nickel01]

Thanks all...SOLVED
Hope this helps someone else

<?php
mysql_select_db($database_ttb, $ttb);
$tdcount = 1;
$num = 3; // number of cells per row
echo '<table border="1">';
$getimages = mysql_query("SELECT * FROM books");
if(!$getimages) die("Cannot execute query. " . mysql_error());
$countRows = mysql_num_rows($getimages);
$i = 0;
if ($countRows > 0)
{
while ($rowimages = mysql_fetch_assoc($getimages))
{
if ($i % 4 == 0) echo ($i > 0? '</tr>' : '') . '<tr>';
echo '<td><img src="imagethumb.php?s='.$rowimages['Image'].'&w=100" border="0" /></td>';
if ($i == $countRows - 1)
echo '</tr>';
$i++;
}
}
echo '</table>'; 
?>

🙂