2 Variables, how to display only one at a time? 1

PaulinKC · Jul 24, 2003

I've got a problem with a page that I'm trying to create. What I am wanting to do is have 2 links that display the results of a sql query based on which one was clicked.

The first link would only display the current months news items and the second would display all news items.

Here's my php code so far in index.php

<?php

$user = "username";
$pass = "pass";
$db = "database";
$link = mysql_connect ("localhost", "username", "pass&quot

or die ("I cannot connect to the database because: ".mysql_error() );

if ( ! $link )

die( "Couldn't connect to the database" );

mysql_select_db ( $db )

or die( "Couldn't open $db: ".mysql_error() );

$Query = "select * from tblNews where extract(YEAR_MONTH from newsDate) = extract(YEAR_MONTH from CURRENT_DATE)";
$Query2 = "select * from tblNews Order By newsDate DESC";

$result = mysql_query($Query, $link);
$result2 = mysql_query($Query2, $link);

?>

How would I format the URL to retrieve $result if I only wanted the current months news items and vice versa?

sleipnir214 · Jul 24, 2003

Create a page like:

<body>
<a href="thescript.php?query=1>first</a>
<a href="thescript.php?query=2>second</a>
</body>

Then in the script that produces the output, do something like:

connect to database;
select db;

switch ($_GET['query'])
{
case 1:
$query = first query;
break;
case 2:
$query = second query;
break;
}

perform query $query;

display output.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

PaulinKC · Jul 24, 2003

Thanks for your help!! Worked with no problems!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

2 Variables, how to display only one at a time? 1

PaulinKC

Programmer

sleipnir214

Programmer

PaulinKC

Programmer

Similar threads

Part and Inventory Search

Sponsor