Yes I want to be able to limit the results as well.
I have a jump menu which is carrying the value over, the 1,2,3 etc and lets me show an individual record just fine, the problem is with how to pass something from that menu to show all the records.
The code that is doing the selecting (I think, in the beginner section for a reason )
$query_RSitems = sprintf("SELECT * FROM items_list WHERE item_type = %s AND items_list.item2_type = %s ", GetSQLValueString($colname_RSitems, "int"),GetSQLValueString($colname2_RSitems, "int"));
I am using echo from the recordset to show the info in the body.