Creating a link 2

[sundance1980]

Hello everyone. Just a quick question. I have an index page (index.php) that shows 15 recent enteries using a query like this:

$query="SELECT id, title, DATE_FORMAT(date,'%M %D, %Y') AS date FROM article ORDER BY ID DESC LIMIT 15";

I would also like to have a link "View All" that would contain the query:

$query="SELECT * FROM article ORDER BY ID DESC";

I am not really sure on how to incorporate this link without creating a new page like viewall.php.

Thanks for any help.

 

[ericbrunson]

In the page create an element (checkbox, button, link, something), name it something like "showall" for example and check for if that element was activated in your php app:

$query = "the select for all";
if ( ! isSet( $_REQUEST[ 'showall' ] ) ) {
   $query = $query . " LIMIT 15";
}

 

[sundance1980]

Not really sure I understand. What should my link look like:

<a href="index.php?=showall">View All</a>

$query = "SELECT * FROM article ORDER BY ID DESC";
if ( ! isSet( $_REQUEST[ 'showall' ] ) ) {
   $query = $query . " LIMIT 15";

So if it is not showall it will default to limit 15?

Sorry to be a pain but I would like to try and understand it rather then just copying.

 

[DRJ478]

To illustrate ericbrunson's post:
Link example:

<a href="view.php?showall=true">View all</a>

In a form:

<form action="view.php" method="post">
<input type="checkbox" name="showall" value="true"><label for="showall">View all</label>

 

[sundance1980]

Thank you.