ok. I am going nuts trying to figure this out. I have a db that I want to put the items in, but show on the page in a reverse order. They then click on the item and that takes him to the actual content.
So I have read a lot of information on this, and from what I read, this is the way to make it happen. Yet everytime I run this script, I get:
"Unable to select info"
What is wrong with this script?
$link = mysql_connect(localhost,$username,$password) or die( "Unable to get SQL");
mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM table ORDER BY index DESC";
$result=mysql_query($lquery, $link) or die( "Unable to select info");
$result2 = mysql_num_rows($result);
while ($i = mysql_fetch_array($result))
print "$field1 - $field2";