Jump to content

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>";

}
?>
Link to comment
https://forums.phpfreaks.com/topic/4302-how-to-display-vertically/
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 =)
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>";
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.