Show Smilies...
Posted: Mon May 23, 2005 5:25 pm
Im adding a smiliey page to display all my smilies for my shout box.. and well on the ("URL") part i want it to show like the picture so i need the full url on that part but here is the script for it..
Thanx
Smackie
Code: Select all
<html>
<table border="0" CELLSPACING="0" CELLPADDING="10" align="center">
<?php
$result = mysql_query ("select * from smilies");
$count = 1;
$column = 1;
//loop statement
while ($myrow = mysql_fetch_array ($result))
{
// first column display
if ($column == 1)
{
//field is the column in your table
printf("<tr><td>%s</td>",$myrow["URL"]);
else{
//second column display
printf("<td>%s</td></tr>",$myrow["Symbol"]);
}
$count += 1;
$column = $count % 2;
}
?>
</table>
</html>Smackie