|
|
Posted by daksport00 on 06/26/06 19:31
Im not sure if Im posting this in the proper Group, if not, please
direct me to the correct place.
I am working on a website for a gaming league/ladder. I have one
particular line of code that is giving me a hell of an issue.
$mbrguid = (mysql_query(SELECT guid FROM users WHERE id='$inviteid'")
if (is_null($mrbguid)){go into error page}
The table Users has a text field GUID which defaults to a Null. Id is
a numberic player ID which is typed in by the end-user.
All of my SQL knowledge tells me that this code should pull the GUID
field form the Users table based on the ID.
The problem I am having is that when I echo the $mrbguid variable, it
return a value of "Resource ID #19". This value doesn't appear in the
Users table anywhere, let alone in ANY table.
Any suggestions as to what is causing this error, or perhaps a way to
work around this code.
What I am looking to do, is pull the GUID field form the table. If it
is a null or blank value, throw the program into error.
Yes, I know that Null and Blank(empty) are not the same thing, but I
can change the table setup to suit the easier variant.
Thanks
-Dave
Navigation:
[Reply to this message]
|