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";}
>
> $connection=@mysql_connect($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
