Drop down problem

[extreme011]

Hi people

Does anyone have any ideas of how i would display 6 records and give the user the option to click on a drop down menu to display all records? im using div tags and javascript, i would appreciate it if you could help?

Stuart

[Rakuli]

Hi Stuart, welcome to Webforumz.

Can you explain waht you want in a bit more detail? I interpret what you're saying as something could be done with a simple HTML select box... I'm sure it's not that easy though.

Cheers,

[extreme011]

Hi Rakuli

am designing a mobile phone website and we have a section called hotdeals, at the moment all the hotdeals are listed on the page, what would be good is to show 6 of the deals when the page is loaded and if the customer wants to see more deals then they click and all the deals appear. does that make more sense sorry im not sure how to explain it properly?

[Rakuli]

So you're using PHP and selecting the records from a database?

You could use

PHP: Select all

$_GET['perPage'] = !empty($_GET['perPage']) && is_numeric($_GET['perPage']) ? $_GET['startFrom'] ? 6;

$_GET['startFrom'] = !empty($_GET['startFrom']) && is_numeric($_GET['startFrom']) ? $_GET['startFrom'] : 0;





$query = "SELECT * FROM theTable LIMIT {$_GET['startFrom']}, $numPerPage"; 



// Links



echo '<a href="url.html?startFrom=0&amp;perPage=10000">Show All</a>'; 

This will limit the first page to 6 with a link to show all

[extreme011]

could i send you my code i already have? im not sure i understand where it goes

[Rakuli]

Yeah, paste it in a message between [php ] [ /php] BBC tags.