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
