Global Variable problem

[FIDO]

I'm having a real problem with a single variable... and I've read every post I could find to resolve it.

In the following code (I only show the stuff after the form is submitted), everything works fine if I remove the first if statement "if ($email != 0) {xxxxx} otherwise I get an error... This seems like a global variable issue since "if" is a sort of function and, therefore, may treat $result as a local variable.

Does anyone know why (and a solution)?

Thanks,
Fido

<?php

// if form has been submitted
if (isset($POST['submitok']))
{
$email = $POST['email'];
$lastname = $POST['lastname'];
$company = $POST['company'];
global $result;
$result = 0;

// get email

if ($email != 0)
{ $result = mssql_query("SELECT * FROM users WHERE email = '".$_POST['email']."'");
if (DB::isError($result))
{ die($email_check->getMessage()); }
}

echo "<table border=0 cellspacing=0 cellpadding=0>\n";
echo "<tr><td class='boldtext'><A HREF='databasemenu.html'>back to database menu</A><P></td></tr>\n";
echo "<tr><td class='titletext'>Database Entries<P></td></tr>\n";
echo "<tr><td>";
echo "<table border=0 cellspacing=1 cellpadding=3 bgcolor='#CCCCCC'>\n";
echo "<tr><td bgcolor='#eeeeee' class='boldtext' colspan=26>Database: PURE</td></tr>\n";
echo "<tr bgcolor='#eeeeee' class='boldtext'><td>email</td><td>Sal</td><td >FName</td><td>MName</td><td>LName</td><td>Cmpy</td><td>URL</td><td>Addr1</td><td>Addr2</td><td >City</td><td>State</td><td>Zip</td><td>Phone1</td><td>Phone2</td><td>Fax</td><td>School</td><td>Deg</td><td>Grad</td><td>Specialty</td><td>Lic #</td><td>PW</td><td>PW2</td></tr>\n";

while ($myrow = mssql_fetch_row($result))
{ printf("<tr bgcolor='#FFFFFF' class='text'><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n", $myrow[1], $myrow[9], $myrow[6], $myrow[7], $myrow[8], $myrow[10], $myrow[11], $myrow[12], $myrow[13], $myrow[14], $myrow[15], $myrow[16], $myrow[17], $myrow[18], $myrow[19], $myrow[20], $myrow[29], $myrow[21], $myrow[22], $myrow[23], $myrow[2], $myrow[24]); }
echo "</table>\n";
echo "</td></tr></table>\n";
}
?>

[edwardsbc]

It would help to know what the actual error is... Can you please post the text of the error message. I don't see any reason you need to declare $result global. You don't have any functions called that might need it.

BTW, I think this is much easier to read:

$result = mssql_query("SELECT * FROM users WHERE email = '{$_POST['email']}' ");

or better yet:

$result = mssql_query("SELECT * FROM users WHERE email = '$email' ");

since you made that assignment earlier.

[FIDO]

Hi edwardsbc -

The error (shown below) seems to be saying that the argument "$result" is not accessable inside the If statement. Yet it works fine outside the if statement.
I'm just guessing it's a global variable issue.

Thanks for your help...

Warning: mssql_fetch_row(): supplied argument is not a valid MS SQL-result resource in c:\Inetpub\wwwroot\pure\login\updatesearch.php on line 57

[Weedpacket]

No, it's saying that what was sent back from MS SQL was not a valid resource; a possibility would be that the SQL you sent it was broken in some way (though it looks fine from here). Whatever, you attempted to use the invalid resource on line 57 (whichever one that is; the while() loop I guess). Do you actually connect to a database? And why do you use the PEAR DB package for just a moment? If you're going to use it you might as well use it all the way - you're not using it for anything you can't do yourself just as easily:

if ($email != 0)
{ $result = mssql_query("SELECT * FROM users WHERE email = '".$_POST['email']."'")
    or die(mssql_get_last_message());
}

Nothing to do with global variables or local variables (and if is a statement and not really like a function at all).

[FIDO]

As is probably obvious, I'm pretty new at this php stuff. I just take/make a little code and try it out. Then read some threads to see why it doesn't work..

I did find the error (trial & error). It was just skipping the stuff inside the if statement... If I replace the 0 in the if statement with "" (null)... everything works fine.
I know it's a string variable, but I've seen lots of code where comprring results to 0 "looks" the same (to me) as comparing resullts to null.

Thanks for your help...

Fido