RE: [PHP-DB] using query_strings in sql
| From: | mayo | Date: | Wed, 21 Jan 2004 20:43:44 +0000 |
| Subject: | RE: [PHP-DB] using query_strings in sql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32562@lists.php.net to get a copy of this message | ||
oops. I guess I was too loose with my words ---
something does happen, just not what I want! :-)
The page displays. The sql works, the "or die" doesn't return anything.
I'm able to change the sql by changing the default values.
WHAT DOESN'T HAPPEN is that the query_string values DO NOT trump the default
variables.
so query_string = ?class=X§ion=Y&order=ASC
I can't input these variables : $class,$section,$order into the SQL
statement
SELECT *
FROM classes
WHERE section=$section
ORDER BY $class $order
-- gil
thx for all your patience
> -----Original Message-----
> From: Micah Stevens [mailto:micah@raincross-tech.com]
> Sent: Wednesday, January 21, 2004 3:12 PM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] using query_strings in sql
>
>
>
> Here goes:
>
> 1) That should work fine. Be sure and enclose the SQL in double
> quotes or the
> variable will not get translated into its value.
>
> 2) That's fine too, nothing wrong there.
>
> 3) this is wrong, but it looks like you just ommited the SQL
> statement. Be
> sure and use the or die statement as it will forward any SQL
> errors to the
> screen.
>
> $selection = mysql_query("SELECT *
> FROM whatever
> WHERE someField = '$queryString_variable'") or die(mysql_error());
> while ($row = mysql_fetch_array($selection)){
>
> if (query_variable is "X"){
>
> echo $row["classID"];
> }else{
> echo "<b>" . $row["classID"] .
> "</b>";
> }
>
> There isn't anything obviously wrong with the code, it should be doing
> something, at least printing out the html heading information.
> Try looking at
> the page source for errors as well. Change the query to include the or
> die(mysql_error()); code because the script might be dying with
> a SQL error
> and you just aren't seeing it printed out.
>
> -Micah
>
> On Wed January 21 2004 11:49 am, mayo wrote:
> > good point Micah !! :-)
> >
> > I don't get an error msg. Nothing happens.
> >
> > included is the file
> >
> > Below are the three issues I have with query_strings and sql. The
> > formatting is of the .php page is awful. I'm not certain it's legible.
> >
> >
> > 1. Main issue -- be able to use a query_string variable in a
> sql statement
> >
> > SELECT *
> > FROM whatever
> > WHERE someField = '$queryString_variable'
> >
> > 2. Be able to set defaults in case variable doesn't exist.
> >
> > if(!isset($category)){$category="Shop";}
> >
> > 3. be able to modify results from a sql query with a
> query_string variable
> >
> > $selection = mysql_query("
> > while ($row = mysql_fetch_array($selection)){
> >
> > if (query_variable is "X"){
> >
> > echo $row["classID"];
> > }else{
> > echo "<b>" . $row["classID"] . "</b>";
> > }
> >
> >
> > thanks all, this is driving me crazy. My bad for taking this
> project. Easy
> > for me in Cold Fusion, driving me nuts in PHP.
> >
> > <?php
> >
> >
> > function getClasses(){
> >
> > $username="";
> > $password="";
> > $database="XXX";
> > $hostname="localhost";
> >
> > global $category;
> > global $Section;
> > global $reorder;
> > global $order;
> > global $location;
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>