Menu
Community /Pin to ProfileBookmark
@NogDogAug 03.2007 — #If $_GET['searchStatus']) and $_SESSION['status'] both exist and have different values, then the query result will be empty since you are AND'ing them in the query to both be equal to vigil_call.status_num.@NogDogAug 07.2007 — #It's a bit hard trying to figure out what's going on from those brief snippets (or at least it is for me). My suggestion would be to do a little debug output if things don't go the way you expect when you execute the query:
building a URL & a db query
I am building a URL and a SELECT query at the same time. I have a GET method form on search.php. It sends the user to searchResults.php where I am retrieving searchStatus:
[code=php]<?php
if ( !empty($_GET[‘searchStatus’]) ) # if searched
{
$_SESSION[‘status’] = mysql_real_escape_string($_GET[‘searchStatus’]); # get selected status from previous page
$searchStatus = $_SESSION[‘status’];
$querySearch.= “AND vigil_call.status_num = ‘$searchStatus’ “;
}
if ( !empty($_GET[‘refreshStatus’]) ) # if refreshed, grab session from URL
{
$refreshStatus = mysql_real_escape_string($_GET[‘refreshStatus’]);
$querySearch.= “AND vigil_call.status_num = ‘$refreshStatus’ “;
}
?>
If the user is sent from the previous page, then the query is built with the searched status. However, this results page is auto refreshed. On the refresh, I am trying to display the same results … just updated. So, I am grabbing the session from the newly built URL.
[code=php]<?php
# build URL
$url = “?lastCall=” . $_SESSION[‘dbLast’] . “&refreshEagle=” . $_SESSION[‘eagle’] . “&refreshStatus=” . $_SESSION[‘status’] .
“&refreshHall=” . $_SESSION[‘hall’]. “&refreshTech=” . $_SESSION[‘tech’];
?>
I am testing by echoing the values of the 2 variables and it correctly echoes a duplicate number:
[code=php]<?php
echo “status: ” . $_SESSION[‘status’];
echo “<br>refresh status: ” . $refreshStatus;
?>
The query is successful when first reaching the page and I get my results, but upon refresh the I have no results. Undecided Can someone be of assistance? Or maybe you know of an easier/cleaner method to achieve the same effect?
Sign in
to post a comment7 Comments(s) ↴
0
@NogDogAug 03.2007 — #If $_GET['searchStatus']) and $_SESSION['status'] both exist and have different values, then the query result will be empty since you are AND'ing them in the query to both be equal to vigil_call.status_num.0
@NogDogAug 07.2007 — #It's a bit hard trying to figure out what's going on from those brief snippets (or at least it is for me). My suggestion would be to do a little debug output if things don't go the way you expect when you execute the query:[code=php]
$result = mysql_query($querySearch);
// DEBUG:
ini_set('display_errors', 1); // just in case it's not on
error_reporting(E_ALL); // ditto
if(!$result)
{
user_error("Query failed ($querySearch) - " . mysql_error());
}
elseif(mysql_num_rows($result) == 0)
{
user_error("No rows returned by query ($querySearch)");
}
// END DEBUG
[/code]