In the forum software I use, SMF, there is a links directory mod, and I am trying to ask the author but to no avail. I want to have PHP echo out a random link/discription from the SQL table "smf_links" and display it in a block on the bottom of the left side blocks on http://www.kcmartz.com/

How do I do this? Thanks

I suppose you could select * from thetable;
Then count the rows returned,

Now use php to choose a random number between 1 and the max row number.

Then do a select for that row with that ID number.

Then echo the details you need into wherever on your page.

I am a complete sucker, and suck at php. I only know echo (text and html) and include for including a file NO OTHER PHP, not even syntax for other codes.

Ok cool, We have all been there.

Check this out, Read it, Play around with it.
It will REALLY help more than someone just giving you code.


http://www.tizag.com/mysqlTutorial/

Ok, i will tomorrow I am starting to be busy now. google bookmarked

you can create a class in php similar to echo, but in this case will output the table

Originally Posted by keysrecover

you can create a class in php similar to echo, but in this case will output the table

You must not have read this part:

Originally Posted by kcmartz

I am a complete sucker, and suck at php. I only know echo (text and html) and include for including a file NO OTHER PHP, not even syntax for other codes.

you could do it easily with a txt file and php

one value per line ( if the 79th line gets selected, anything on that line will be echoed )

then use the follow code to select a random line and echo it

<?
$textfile ="random.txt";
$items = file("$textfile");
$item = rand(0, sizeof($items)-1);
echo $items[$item];

?>

so put each url and descriptions on a separate line

so say line 79 was

ModDish - Website Design firm - http://www.moddish.com - blahhhhhhhhhh < description ( like my plug lol)


it would echo it on the doc with the above code.

you could also format each line with <b> </b> ( or any html code) around the title etc , and the html code would work when its echoed.

foreach ($resultSet as $row)
{
echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['result'] . "</td>";
echo "</tr>";
}
with:

foreach ($resultSet as $row)
{
echo "Dear ".$row['name'].", you are ".$row['result'];
}