I may be misunderstanding you, but your first statement about pulling from a 
query string is throwing me. 

<?php echo $section; ?> will only display the value of $section on the screen. 
You will need to build a form to get a value into $section. 

<form action="soemthing.php">
<input type="text" name="section">
</form>

something.php:

<?php echo "This is what was submitted in the form: ".$section; ?>

Now you can do your query:

$selection = mysql_query("SELECT *
                                        FROM classes
                                        WHERE
                                                classCategory = '$section'
                                        ")

you'll notice I pulled the other variables out since you had not defined them 
yet, like your ordering variables. Otherwise the SQL would end with ORDER 
which will cause an error.. 

-Micah


On Wed January 21 2004 10:41 am, mayo wrote:
> I'm a cold fusion refugee and am having incredible problems with something
> that I think is relatively easy -- so I must be missing something basic.
>
> I would like to pull info from a query string and use it inside a database
> call.
>
> I can pull the query string into a general variable:
>
> <?php echo $section;  ?>
>
> now I would like to use it in a SQL statement, or in
> if/else clauses to modifiy results from queries.
>
> examples below:
>
>
> USE query_string in SQL :
>
> <?php
>
>       function whatever(){
>
>       $username = "";
>       ...
>
>       // setting the default variables
>
>       if(!isset($category)){$category="Something";}
>       if(!isset($section)){$section="SomethingElse";}
>
>       [EMAIL PROTECTED]($hostname,$username,$password);
>       mysql_select_db($database);
>       $selection = mysql_query("
>                                       SELECT *
>                                       FROM classes
>                                       WHERE
>                                               classCategory = '$category'
>                                       ORDER BY $reorder $order
>                                       ")
>
>       ...
>
> ?>
>
> The PHP SQL call below work nicely:
>
> while ($row = mysql_fetch_array($selection)){
>
> echo $row["sectionName"];
>
> }
>
> now I would like to do an if/else to modifiy it:
>
>
>
> while ($row = mysql_fetch_array($selection)){
>
> if (section == $sectionName){
>       echo "<b>" . $row["sectionName"] . "</b>";
> }else{
>       echo $row["sectionName"];
> }
>
> Nothing is working. I must be missing something basic over here.
>
> thx, Gil

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to