[SOLVED] simple code not working, i cant see no errors...

[jesushax]

hi below is my test code

 

basic as anything yet it doesnt work :S

 

anyone know why?

 

Cheers

 

$ID = $_GET["ID"];
$a = mysql_query("SELECT * FROM tblUsers WHERE md5(UserID)='$ID'") or die(mysql_error());
while ($b = mysql_fetch_array($a)) {
echo $b["UserID"];
}

[bluejay002]

can you give more details in your code and the error it displays or whatever the problem that you encountered?

[jesushax]

herse the full scope

 

ive removed all my other code cos im just trying to make it return a result but it wont no errors either

 

ive echoed my sql and that ouputs fine its just not outputting anything :S

 

switch(@$_GET["mode"]) {
    case "update":
//udate code here
break;
default:
$ID = $_GET["ID"];
$a = mysql_query("SELECT * FROM tblUsers WHERE md5(UserID)='$ID'") or die(mysql_error());
while ($b = mysql_fetch_array($a)) {
echo $b["UserID"];
}
break;
}

[monkeytooth]

Whats the error your getting though upon tempting to run the script?

[monkeytooth]

nevermind just read that bit that says it comes up with none.. my bad

[jesushax]

right i know what it is now, but dont know why it is...

This Works...

$a = mysql_query("SELECT * FROM tblUsers WHERE UserID='5'") or die(mysql_error());
while ($b = mysql_fetch_array($a)) {
echo $b["UserCompanyName"];
}

But when getting an MD5'd ID from the url

the ID in the url has already been md5

it doesnt work...?

$ID = $_GET["ID"];
$a = mysql_query("SELECT * FROM tblUsers WHERE md5(UserID)='$ID'") or die(mysql_error());
while ($b = mysql_fetch_array($a)) {
echo $b["UserCompanyName"];
}

[monkeytooth]

md5(UserID)

 

that cant be a table name on your database? is it?

 

$a = mysql_query("SELECT * FROM tblUsers [b]WHERE md5(UserID)='$ID'") [/b] or die(mysql_error());

[jesushax]

figured it out

 

the md5 the url is passing does not match the md5 where trying to retrieve, ill figure out where its coming from...

 

Thanks for offering assistance though

[monkeytooth]

Im seeing a few potential errors.. over all though not knowing the full scope of your over all coding I cant help much..

 

where are you getting the ID from? a Form?

Are you trying to compare said ID to a UserID?

[monkeytooth]

No problem. I am not 100% fully knowlegeful on MD5 but from what i have learned its got its up and its got its downs.. One its got its limits, and 2.. not always is every hash created equal.

[jesushax]

fixed it