help with new product listing

[rrrhythm]

i want to get the 20 most recently added products, then in the new products box display 9 random products from that larger list.

 

i'm not asking anyone to code it for me (althought that would be nice), just looking for guidance on how to proceed. i'm a fairly compentent PHP/MYSQL programmer, just feeling stuck here.

 

thanks

rj

[rrrhythm]

i want to get the 20 most recently added products, then in the new products box display 9 random products from that larger list.

 

i'm not asking anyone to code it for me (althought that would be nice), just looking for guidance on how to proceed. i'm a fairly compentent PHP/MYSQL programmer, just feeling stuck here.

 

thanks

rj

 

i suppose this gets to the point that i don't quite understand the interface between php and the database. $new_products_query = tep_db_query("...

this variable, $new_products_query, is what? a 2D array?

 

and $new_products = tep_db_fetch_array($new_products_query), what is $new_products? also an array? a string?

 

so i'm not sure if i should approach this from the DB query or from the php.

[rrrhythm]

answering my own question. but if anyone else is interested, my own solution, as well as others even more elegant, and solutions to similar problems can be found In This Thread

[zhexiang]

What i know is that it's a 2D array method for displaying the New Products box.