search page - db query pulled from url

[davieboy]

what im trying to do is have a search_results.php page which contains all the main details for displaying results.
the db queries i want dependant on the url clicked / submitted.
eg
search_results.php?airlinesearch=BA

if (isset($aircraftsearch)) {
$query_count1 = "SELECT * FROM photos WHERE status = 'accepted' AND aircraft='$aircraftsearch'";
$query_do = "SELECT * FROM photos WHERE status = 'accepted' AND aircraft='$aircraftsearch' ORDER by ID LIMIT $limitvalue,$limit";
}
if (isset($airlinesearch)) {
$query_count1 = "SELECT * FROM photos WHERE airline='$airlinesearch'";
$query_do = "SELECT * FROM photos WHERE airline='$airlinesearch' ORDER by ID LIMIT $limitvalue,$limit";
}

Cant seam to get it working at all

David

[ClarkF1]

You have the query, you just need to run them using mysql_query()

If you do have this further down the script it might be a problem with register_globals.

Do you have $airlinesearch = $_GET['airlinesearch']; anywhere.

Using just $airlinesearch without getting the value from the $_GET array and the query not working implies that register_globals is off which is a good idea.

Have you used mysql_error() or echoed the query to check for errors.

[davieboy]

yea i do have the bits

<?php 
include("config.php"); 
mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die (mysql_error());

$aircraftsearch = $_GET['aircraftsearch'];
$locationsearch = $_GET['locationsearch'];
$regsearch = $_GET['regsearch'];
$datesearch = $_GET['datesearch'];
$airlinesearch = $_GET['airlinesearch'];

if (isset($aircraftsearch)) {
$query_count1 = "SELECT * FROM photos WHERE status = 'accepted' AND aircraft='$aircraftsearch'";
$query_do = "SELECT * FROM photos WHERE status = 'accepted' AND aircraft='$aircraftsearch' ORDER by ID LIMIT $limitvalue,$limit";
}
if (isset($airlinesearch)) {
$query_count1 = "SELECT * FROM photos WHERE airline='$airlinesearch'";
$query_do = "SELECT * FROM photos WHERE airline='$airlinesearch' ORDER by ID LIMIT $limitvalue,$limit";
}

$limit          = 5;              
$query_count    = "$query_count1";       
$result_count   = mysql_query($query_count);       
$totalrows      = mysql_num_rows($result_count);    

$PHP_SELF    =    $_SERVER['PHP_SELF']; 

if(!isset($_GET['page'])){ // Checks if the $page variable is empty (not set) 
    $page = 1;     // If it is empty, we're on page 1 
} else{ 

    $page = $_GET['page']; 
} 



$limitvalue = $page * $limit - ($limit);    
// Ex: (page2 * 5(items per page) = 10) - 5 = 5 <- data starts at 5 

$query = "$query_do";
echo $query_do;
$result = mysql_query($query);
while ($r=mysql_fetch_array($result))
{    

    $id=$r["id"];
	$reg=$r["reg"];
	$airline=$r["airline"];
    $status=$r["status"];
	$uploaded=$r["awhen"];
	$file_name=$r["file_name"];
	$hits=$r["hits"];
	$copyright=$r["copyright"];
	$group_photo=$r["group_photo"];
	$awhere=$r["awhere"];
	$aircraft=$r["aircraft"];
	$date_from_unix =$r["awhen"];

if(mysql_num_rows($result) == 0){ 
    echo("Nothing to Display!"); 
}

echo "STUFFF";

}





if($page != 1){    
    $pageprev = $page - 1; //decrementing $page-- does not work on all php configurations. 


    echo("<a href=\"$PHP_SELF?page=$pageprev\"><b>PREV</b>".$limit."</a> ");    
}else{ 
    echo("PREV".$limit." "); 
} 

$numofpages = $totalrows / $limit;    


#echo "<br>", $totalrows; 
   #exit; 

for($i = 1; $i <= $numofpages; $i++){ 
    /* This for loop will add 1 to $i at the end of each pass until $i is greater    
    than $numofpages. */ 
    if($i == $page){ 
        echo($i." "); 
    }else{ 
        echo("<a href=\"$PHP_SELF?page=$i\">$i</a> "); 
    } 
} //code above has been decoded lozza 


if(($totalrows % $limit) != 0){ 
    if($i == $page){ 
        echo($i." "); 
    }else{ 
        echo("<a href=\"$PHP_SELF?page=$i\">$i</a> "); 
    } 
} 

if(($totalrows - ($limit * $page)) > 0){ 
    $pagenext = $page + 1; //incrementin $page like $page++ does not work in all enviroments 

    echo("<a href=\"$PHP_SELF?page=$pagenext\"><b>NEXT</b>".$limit."</a>");    
}else{ 
    echo("NEXT".$limit);    
} 


?>