Re: Re: query strings coming from the same page going back to the same page

going to try some different things out... the if statement didnt work cuz when i didnt put a query string at the end of the page name when going to it it complained about month being an undefined index... ----- Original Message ----- From: "Rainer Müller" <rainer.mueller@codingfarm.de> To: <php-general@lists.php.net> Sent: Saturday, April 10, 2004 6:33 PM Subject: [PHP] Re: query strings coming from the same page going back to the same page > Andy B schrieb: > > was wondering if this would work or do i need different code: > > <?php > > include("libs/conf.db"); > > if(($_GET['month']==0)||($_GET['month']>12)){ > > $query="SELECT > > Type, > > StartDate, > > EndDate, > > Name, > > County, > > Notes > > FROM $EventsTable > > ORDER BY StartDate DESC"; > > } else { > > $query="SELECT > > Type, > > StartDate, > > EndDate, > > Name, > > County, > > Notes > > FROM $EventsTable WHERE > > StartingMonth='{$_GET['month']}' > > ORDER BY StartDate DESC";} > > mysql_pconnect($host, $mysqluser, $mysqlpwd)||die(mysql_error()); > > $result=mysql_query($query) or die(mysql_error()); > > ?> > > then i would have a link on the same page this code came from: > > <a href="ViewEvents.php?month=1">Jan</a> > > the link is supposed to reload the same page it came from and be bart of the > > query above... the thing im not sure of is if that will work or not or do i > > need something else...(new to self referrencing pages)... > > Probably it is better to use > <a href="<?php echo $_SERVER['PHP_SELF']; > ?>?month=1">Jan</a> > Then it is not in dependency to the filename. > > And btw. you should check with is_numeric() if the value from > $_GET['month'] is really a number or you will have an security hole in > you script. > > Rainer > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >