function displayRares($type, $limit) {
$raresQuery = mysql_query("SELECT * FROM `rares` WHERE type='$type' LIMIT $limit");
echo "<table border='0'>";
while ($rows = mysql_fetch_array($raresQuery)) {
echo "<tr>";
echo "<td>";
if (!empty($rows['url'])) { echo("<img src=\"" . $rows['url'] . "\" alt=\"" . $rows['name'] . "\" />"); }
echo "</td><td>";
if (!empty($rows['name'])) { echo($rows['name']); }
echo "</td>";
if (!empty($rows['t'])) { echo("<td>" . $rows['t'] . "T</td>"); }
if (!empty($rows['hc'])) { echo("<td>" . $rows['hc'] . "HC</td>"); }
if (!empty($rows['rd'])) { echo("<td>" . $rows['rd'] . "RD</td>"); }
echo "</tr>";
}
echo '</table>';
}
?>
Results 21 to 28 of 28
-
Need a domain but dont have paypal... not to worry. You can purchase a domain via text or home phone at XeoDomains.mobi.
(X Moderator)
AKA Cheekykarl
-
Try something like this
PHP Code:function displayRares($type, $limit) {
$raresQuery = mysql_query("SELECT * FROM `rares` WHERE type='$type' LIMIT $limit");
while ($rows = mysql_fetch_array($raresQuery)) {
print("<div class=\"rare\">");
if (!empty($rows['url'])) {
echo("<img src=\"" . $rows['url'] . "\" alt=\"" . $rows['name'] . "\" /><br />");
}
if (!empty($rows['name'])) {
echo($rows['name']);
}
if (!empty($rows['t'])) {
echo($rows['t'] . "T "); }
if (!empty($rows['hc'])) {
echo($rows['hc'] . "HC ");
}
if (!empty($rows['rd'])) {
echo($rows['rd'] . "RD ");
}
print("</div>");
}
}
?>
If you want to change how many per row then you need to change the CSS.HTML Code:<?php require("functions.inc.php"); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Rare Values</title> <style type="text/css"> .rare { width: 20%; float: left; text-align: center; } </style> </head> <body> <?php displayRares("rare", "150"); ?> </body> </html>
eg. 10% would be 10 per row, 20% would be 5 per row
Enjoy - I havent tested yet so I may of done a silly error.
-
http://habmate.com/uk/test4.php
Woo
It has worked.
Thanks a lot +REP
Need a domain but dont have paypal... not to worry. You can purchase a domain via text or home phone at XeoDomains.mobi.
(X Moderator)
AKA Cheekykarl
-
No problem, thanks for the rep
-
21-08-2007, 07:06 AM #25
Thanks Lucky! +rep. How do i get the prices on a line down from the name?
eg. come out like: Holiday Romance2HC 120credits
i want it like:
Holiday Romance
2 HC
120 credits
(centered and with spaces)Last edited by Verrou; 21-08-2007 at 07:11 AM.
Originally Posted by Special-1k
-
Originally Posted by Verrou
This would be helpfull for me aswell.
Need a domain but dont have paypal... not to worry. You can purchase a domain via text or home phone at XeoDomains.mobi.
(X Moderator)
AKA Cheekykarl
-
You would need to add a <br />
PHP Code:function displayRares($type, $limit) {
$raresQuery = mysql_query("SELECT * FROM `rares` WHERE type='$type' LIMIT $limit");
while ($rows = mysql_fetch_array($raresQuery)) {
print("<div class=\"rare\">");
if (!empty($rows['url'])) {
echo("<img src=\"" . $rows['url'] . "\" alt=\"" . $rows['name'] . "\" /><br />");
}
if (!empty($rows['name'])) {
echo($rows['name']."<br />");
}
if (!empty($rows['t'])) {
echo($rows['t'] . "T "); }
if (!empty($rows['hc'])) {
echo($rows['hc'] . "HC ");
}
if (!empty($rows['rd'])) {
echo($rows['rd'] . "RD ");
}
print("</div>");
}
}
?>
-
22-08-2007, 05:01 AM #28
Yay, thanks! +REP
http://andrehamon.evenhosting.com/rare_values/test2.php Originally Posted by Special-1k
Reply With Quote
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts