i kind got a few questios to ask
... 1. how do i get mysql to read the records backwords, so insted of entry 1 being on top .. the last entry is on top...
how can 1 spesify wat record range i want to display on screen ... with privous and next link (eg .only list 4 recored on page)
another thing i need to no is how can i have recordes side by side..
For example
1 2
3 4
5 6
i tryed to use tables ... but i noticed that i can only have 1 table per line.
i hope that ant to mutch to ask, if so egnore this message
thanx.... for your time ..... below is the code i a curently using
<?php
$db = mysql_connect("localhost", "root", "like-im-gana-tell-you);
mysql_select_db("mydb",$db);
// display individual record
if ($links) {
$result = mysql_query("SELECT * FROM links WHERE links=$links",$db);
$myrow = mysql_fetch_array($result);
ECHO '<BR>';
printf("Site Name: %s\n<br>", $myrow["SiteName"]);
printf("URL: %s\n<br>", $myrow["Url"]);
printf("Description: %s\n<br>", $myrow["Description"]);
ECHO '<BR>';
} else {
// show employee list
$result = mysql_query("SELECT * FROM links",$db);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are records to display
echo '<a href=\nilz-p/index.php?goto=addlink><B>Add Your Link<B></a><BR>';
do {
ECHO '<table width="200" STYLE="border: 0px;"><TR><TD width="100" STYLE="border: 0px;">';
printf("<a href=\"%s?goto=links&links=%s\">%s</a>", $PHP_SELF, $myrow["links"], $myrow["SiteName"] );
ECHO '</TR></TABLE>';
} while ($myrow = mysql_fetch_array($result));
} else {
// no records to display
echo "Sorry, no records were found!";
}
}
?>
