Problem with query result...

[jrahma]

Hi,

I have the following code:

$mysql_query = $mysql_connection->prepare("CALL sp_get_company_details(:param_company_guid)");
$mysql_query->bindParam(':param_company_guid', $_GET["id"], PDO::PARAM_STR);
$mysql_query->execute();

$mysql_row_count = $mysql_query->rowCount();

if ($mysql_row_count <= 0) { exit(header("Location: " . $_SESSION["domain_name"] . "home")); }

while ($mysql_row = $mysql_query->fetch())
{
    $company_guid = $mysql_row["company_guid"];
    $company_name = $mysql_row["company_name"];
    $company_industry = $mysql_row["industry_name"];
    $company_country = $mysql_row["country_name"];
    $company_telephone = $mysql_row["company_telephone"];
    $company_fax = $mysql_row["company_fax"];
    $company_website = $mysql_row["company_website"];
    $company_email = $mysql_row["company_email"];
    $about_company = $mysql_row["about_company"];
    $hide_email = $mysql_row["hide_email"];
}

$mysql_query->closeCursor();

if (isset($_SESSION["member_guid"]))
{
    $mysql_query = $mysql_connection->prepare("CALL sp_check_if_company_admin(:param_company_guid, :param_member_guid)");
    $mysql_query->bindParam(':param_company_guid', $company_guid, PDO::PARAM_STR);
    $mysql_query->bindParam(':param_member_guid', $_SESSION["mmeber_guid"], PDO::PARAM_STR);
    $mysql_query->execute();

while ($mysql_row = $mysql_query->fetch())
{
    $is_company_admin = $mysql_row["company_admin_id"];
}        
}

var_dump($company_guid);
var_dump($_SESSION["member_guid"]);
var_dump($is_company_admin);

the result for the three var_dump is:

string(36) "30383394-53bf-11e3-aef0-74de2b9a31a4" string(36) "22e52867-495d-11e3-95af-74de2b9a31a4" NULL

my question, why I am getting NULL? when I run the sp_check_if_company_admin on the database server using the same param's value I get a single record with company_admin_id = 13 which means it's not NULL.!

Please Help...

[NogDog]

My first guess would be that the query returned zero results. You could check this by putting some sort of debug output within the while loop.

[Weedpacket]

How many records do you expect to get? If there's only one, you don't need a loop.
You could also try looking at [font=monospace]$mysql_row[/font] to see what it actually contains (if anything). If it's empty then a notice would have been triggered (you do have error reporting turned on, of course) stating that [font=monospace]$is_company_admin[/font] doesn't have a value. Unless you're reusing a variable you used for something else earlier, but that would not be a good idea.

[jrahma]

I found where is the problem.
It's spelling mistake
$SESSION["mmeber_guid"] (double m) and it should be $SESSION["member_guid"]

Thank you so much guys 🙂