opposite of desc??

[brcolow]

Hey, i have a script that lists things by id, so how can i list them by id but only list 10 and have the LAST ones listed, like the newest articles etc. I have this so far

SELECT title FROM reviews LIMIT 10 ORDER BY

But im not sure what the order by would be...
Thanks,
Mike

[barand]

To order by a field you have to select it

SELECT id,title FROM reviews ORDER BY id DESC LIMIT 10

HTH

[brcolow]

ok but thzats not what i want, i dont want the ids like this..
1
2
3
I want them like this
3
2
1
SO i can display the newest things

[barand]

Originally posted by brcolow
ok but thzats not what i want, i dont want the ids like this..
1
2
3
I want them like this
3
2
1
SO i can display the newest things

I know you do, that is what DESC-ending does - it gives the highest numbers first.

ASC-ending gives lowest first and is the default.

Try it!

[brcolow]

ok now i have this...

<?
@ $db = mysql_pconnect("localhost", "notshown", "notshown");
 if (!$db)
 {

 echo "<b>Could not connect to database, try again later.</b>";

 exit;

 }

mysql_select_db("news");
$result = mysql_query("SELECT id,title FROM reviews ORDER BY id DESC LIMIT 10 ");
$numrows = mysql_num_rows($result);
if ($numrows > 0)  

{ 
$row = mysql_fetch_object($result);;
print"<h6><a href=\"http://www.flashstand.com/reviews/reviewdis.php?id=$row->id\">$row->title</a></h6>";
}
else
{
print"No reviews exsist yet!";
}
?>

And it only displays the newest one, not 10 of the newest ones. I tried doing the print 10 times but it just displayed the newest one ten times? How can i make it so it displays the 10 different newsest ones?

[barand]

You need to loop through the whole result set, printing one row in each pass through the loop :-

mysql_select_db("news");
$result = mysql_query("SELECT id,title FROM reviews ORDER BY id DESC LIMIT 10 ");
while (list($id,$title) = mysql_fetch_row($result)) {
echo "<h6><a href=\"http://www.flashstand.com/reviews/reviewdis.php?id=$id\">$title</a></h6><br>";
}

[brcolow]

ok that works,
http://flashstand.com/list.php
but ho do i get them to be no lines apart...? Like this..
review
review
review

[Ace_Online]

Originally posted by brcolow
ok that works,
http://flashstand.com/list.php
but ho do i get them to be no lines apart...? Like this..
review
review
review

Try taking out the <br> in the for loop. The new code would look like:

mysql_select_db("news");
$result = mysql_query("SELECT id,title FROM reviews ORDER BY id DESC LIMIT 10 ");
while (list($id,$title) = mysql_fetch_row($result)) {
echo "<h6><a href=\"http://www.flashstand.com/reviews/reviewdis.php?id=$id\">$title</a></h6>";
}

Don't know if that would solve it, but it makes sense to me.

[brcolow]

i already took the br out, made it go down one line but its still spaced another

[barand]

I think it is the use of <h6> . Heading styles give you extra spacing. Try using a font tag or a style.

[brcolow]

ok that worked thanks for all the help but i have one more request, how can i make it so like if the title is over a certain ammount of characters the lkast three get replaced by ... so it doesnt make it too big?
Thanks,
Mike

[barand]

if (strlen($title) > $MAX_LEN) {
$title = substr($title,0,$MAX_LEN)."...";
}