TalkPHP - View Single Post

MattD · 02-14-2009, 12:24 AM

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

)
is

PHP Code:


			
$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.

Hope that explains better

02-14-2009, 12:24 AM	#5 (permalink)
MattD The Visitor Join Date: Feb 2009 Posts: 2 Thanks: 0	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 ) is PHP Code: `$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. Hope that explains better