How to show the last variable value in the query

adam9110

I have planted a new comment mod from other guys.

But the comment mod shows many comments result on the page.

what i want is just a lastest comment show in the page.

How to do it ?

Thanks
Adam

NogDog

If the output is based on a database query, take a look at the "limit" SQL function.

adam9110

i mean how to return the last record in the database

adam9110

$reviews_query_raw = "select r.reviews_id, left(rd.reviews_text, 1000) as reviews_text,
r.reviews_rating, r.date_added, r.customers_name
from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd
where r.products_id = '" . (int)$GET['products_id'] . "'
and r.reviews_id = rd.reviews_id
and rd.languages_id = '" . (int)$SESSION['languages_id'] . "'" .
$review_status . "
order by r.reviews_id desc";
Thanks Nogdog, where should i put the "limit" in above code.
thanks again

NogDog

At the very end of the query, add LIMIT 1, changing "1" to the number of result rows you want if more than 1.

adam9110

but the numbers of row is changed. I mean changed time to time. Once some one leave the comment , the rows will be added one. So how ..........

NogDog

Did you try it? I'm assuming that your reviews_id column is an auto-incremented integer, so when you do the "order by r.reviews_id desc" part of the query, it is going to sort the results with the newest item first. Then when you add the "limit 1" to the end of the query, you will only get the first row of that result set, which will be the latest entry.

adam9110

yes, Nogdog, I have tried.

But i got :

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 6' at line 7
in:
[select r.reviews_id, left(rd.reviews_text, 1000) as reviews_text, r.reviews_rating, r.date_added, r.customers_name from China_reviews r, China_reviews_description rd where r.products_id = '0' and r.reviews_id = rd.reviews_id and rd.languages_id = '1' order by r.reviews_id desc LIMIT 1 limit 0, 6]

What i add is like :
$reviews_query_raw = "select r.reviews_id, left(rd.reviews_text, 1000) as reviews_text,
r.reviews_rating, r.date_added, r.customers_name
from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd
where r.products_id = '" . (int)$GET['products_id'] . "'
and r.reviews_id = rd.reviews_id
and rd.languages_id = '" . (int)$SESSION['languages_id'] . "'" .
$review_status . "
order by r.reviews_id desc LIMIT 1";

I have check the query yes reviews_id column is an auto-incremented integer

NogDog

Where does the "limit 0, 6" come from in query text in the error message? (It appears you have two LIMIT clauses in there, which is probably a syntax error.)