limiting items displayed while using the

[Anon]

I need help, see i store a user's items in a string in the db, then use explode to seperate that string, is there anyway to limit how many items are displayed...?

[Anon]

I already figured it out...

	while($i_string = mysql_fetch_array($userdet)){	
	$items = $i_string["items"];
	}
	$num = "0";
	$item = explode(">", $items);

	foreach($item as $printItem){
	$itemdet = mysql_query("SELECT * FROM items WHERE id='$printItem'", $link_id); 
		while($i_string = mysql_fetch_array($itemdet)){	
		$i_id = $i_string["id"];
		$i_name = $i_string["name"];
		$num++;

//then print the item

echo"$i_name" //or whatever

and then just check to see when $num reaches a certaain number, and end the script...

[[deleted]]

First, stop storing all those values in one string.
Instead, make a new table and link it to the users through the user's id.

Second, once you exploded the string, you have an array with elements.
How many of those you print is up to you.

What's the problem?

[Anon]

I fixed it, but i had to print all the elements of the array, after being exploded...