I've been trying several scripts, but cant seem to get it to work, any ideas?
with the current code it just show all the of them, but trying to get it to show 5 layouts pr page =( any takers?
current using
Code: Select all
<?php
include ("top.txt");
print "<p class=head align=center>Div // CSS Designs</p>\n";
$INFOї'sql_user'] = "aetherea_staff";
$INFOї'sql_pass'] = "*******";
$INFOї'sql_db'] = "aetherea_layoutsdb";
$INFOї'sql_host'] = "localhost";
$DB = mysql_connect($INFOї'sql_host'], $INFOї'sql_user'], $INFOї'sql_pass']) or die("Could not connect");
mysql_select_db($INFOї'sql_db']) or die("Could not select database");
$query = "SELECT * FROM div WHERE 1 ORDER BY `id` DESC LIMIT 0, 200";
$result = mysql_db_query($INFOї'sql_db'], $query);
if (!$result)
echo mysql_errno().": ".mysql_error()."<br />";
else
{
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$name = $rowї'name'];
$series = $rowї'series'];
$id = $rowї'id'];
$designer = $rowї'designer'];
echo ("
<table width='95%' align='center'>
<tr>
<td width='95%' class='outline' align='center'><b>$name </b></td>
</tr>
</table>
<table width='95%' height='125' align='center'>
<tr>
<td class='outline' valign='top' width='12'><img src='http://aethereality.net/layouts/div/$id/thumb.jpg' width='200' height='125' border='0' align='left' alt='$name'>
</td>
<td class='outline' valign='top' width='215' style='padding-left:5px;'>
<b>Name:</b> $name<br>
<b>Type:</b> Div // CSS<br>
<b>Artist:</b> $designer<br>
<b>ID:</b> $id<br>
<b>Report:</b> ї <a href='mailto:ivytran87@hotmail.com?subject=Designs Errors || Div || $id || $name ||'>Errors</a> ]<br>
ї <a href='http://aethereality.net/layouts/div/$id/index.html' target='_blank'>Preview</a> ] ї <a href='http://aethereality.net/layouts/div/$id/layout.zip'>Download</a> ]</td>
</tr>
</table>
<table width='95%' align='center'>
<tr>
<td width='95%' class='outline' align='center'><b>$series</b>
</td>
</tr>
</table>
<br>
");
}
}
mysql_close($DB);
include("bottom.txt");
?>