> i have a table that contains articles. i have another table which
> contains the order 1 - 9 that i would like to display them in.
>
> this part is done, and is not a problem. here is where I am not sure
> how to proceed.
>
> 1. tbl_display_order - can only have 9 records in it (or do i just
>
Charles, it sounds like you want the most recent 9 articles ("...order set
to 1 so it shows up first when ..."), so why not something like "select *
from article_table order by id desc, limit 9" [assumes id is int not null
auto_incremented].
You could also increment the value in the field something
2 matches
Mail list logo
