Jump to content

Archived

This topic is now archived and is closed to further replies.

DoggerWatson

How to display vertically

Recommended Posts

G'day
This random image script works ok...but displays the resulys in a line horizontally.
How can I get them to appear below one another.
I've tried putting \n in every place I can think of & nada..

<?

// Connect to the database
mysql_connect ('localhost', 'root', 'sherlock') ;
mysql_select_db ('twihjlight');

// Edit this number to however many links you want displaying
$num_displayed = 4 ;

// Select random rows from the database
$result = mysql_query ("SELECT
books.Id,
books.Titles,
books.Image_Sml
FROM
books
WHERE
(books.Image_Sml != 'images/thumbs/NoImage_sml.jpg') ORDER BY RAND() LIMIT $num_displayed");

// For all the rows that you selected
while ($row = mysql_fetch_array($result))

{
// Display them to the screen...
echo "<a href=\"books_detail.php?recordID=" . $row["Id"] . "\">
<img src=\"" . $row["Image_Sml"] . "\" border=0 alt=\"" . $row["Titles"] . "\">
</a>";

}
?>

Share this post


Link to post
Share on other sites
Hey.

This might not be the answer you're looking for, I'm new here and inexperienced in this category as well.

When looking to make things list vertical though, I use the HTML <br> tag. Though I lack the PHP skills to tell you exactly where to put it, you might know/be able to figure it out.

Just another thing to try if you haven't =)

Share this post


Link to post
Share on other sites
All fixed...
Amazing what a bit of sleep can do

$pics="<a href=\"books_detail.php?recordID=" . $row["Id"] . "\">
<img src=\"" . $row["Image_Sml"] . "\" border=0 alt=\"" . $row["Titles"] . "\" >
</a>";

echo "<table border=0 width=100% >";

echo $pics ."</tr>";
echo "</table>";

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.