Re: RE: [newbie] drop down boxes
| From: | Philip Olson | Date: | Mon, 07 Apr 2003 23:10:57 +0000 |
| Subject: | Re: RE: [newbie] drop down boxes | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-142764@lists.php.net to get a copy of this message | ||
> if(!isset($severity))
> {
> $_SESSION['querystring'] = "SELECT bugid, status, severity, assigned_to,
> summary, date_opened
> , estimated_completion, related_file, created_by
> FROM Bug";
> }
> else
> {
> $_SESSION['querystring'] = "SELECT bugid, status, severity, assigned_to,
> summary, date_opened, estimated_completion, related_file, created_by FROM
> Bug WHERE severity ='$severity' LIMIT 40";
> }
> ?>
>
> //then in file2.php
> session_start();
> $db_result = mysql_query($_SESSION['querystring']) or die(mysql_error());
Storing a SQL statement as a session variable seems
like a bad idea, you really should rewrite your code
to not do this.
Regards,
Philip