[Resolved] $_GET two variables syntax

etoast

Could you take a look at this code for me please and see if you can spot anything wrong. I'm guessing my syntax is incorrect somehow because if I use just one variable it works fine - it is when I try to put the AND bit in the query (or maybe where i echo the rows?). If the page URL looks like this:

...whatever.php?priceband_id=1&area_id=1

then i am trying to $_GET the two values to interrogate the 'stuff' database table. The database table/column names are all correct. Can you see anything is obviously wrong? I just get a blank page.

<?php 
require_once ('mysql_connect.php');
if (isset($_GET['priceband_id']) && isset($_GET['area_id'])) { 

$priceband_id=$_GET['priceband_id'];  

$area_id=$_GET['area_id'];  

$sql = mysql_query("SELECT * FROM stuff WHERE priceband_id=".$priceband_id" AND area_id='.$area_id'") or die (mysql_error()); 

$result = $sql;

while($row=mysql_fetch_array($result)) { 
echo "'.$row['price'].'"<br />;
echo "'.$row['area'].'";
<br /> 

}
}
?>

Thanks!

Norman_Graham

Hi Etoast

Your query has some extra and unnecessary knick-knacks:

$sql = mysql_query("SELECT * FROM stuff WHERE priceband_id='$priceband_id' AND area_id='$area_id'") or die (mysql_error());

I think that should work now.

Norm

etoast

thanks, but it still isn't working.
i cannot find any tutorials anywhere for passing/handling more than one variable in the URL with $_GET

weird. i thought it would be a common thing.

TheDefender

Change to:

$result = mysql_query("SELECT * FROM stuff WHERE priceband_id='".$priceband_id."' AND area_id='".$area_id."'") or die (mysql_error());
while($row = mysql_fetch_array($result)) {
echo $row['price']."<br />"; 
echo $row['area']."<br />"; 
}

It is a common thing, but what is uncommon is trying to decipher poorly developed code... It's unique for everyone's code and coding skills.

etoast

fantastic!
thank you so much.

TheDefender

No problem... be sure you look around the manual regarding how to manipulate strings, as it appears as though it is something you could use a refresher on. You can read up on concatenation, proper use of single quotes, double quotes, etc... It's good reading. Feel free to post back for any other help you may need, and if this thread is good to go, be sure to mark it resolved.