[Resolved] Whats wrong with this?

[Sayian]

When trying to get a user ID from a username what am i doing wrong in this query?

$query = mysql_query("SELECT id FROM shocc_users WHERE username = '$_GET['username']'";
$result= mysql_result($query);

if($result) {

$_GET['id'] == $result;

}


if(!isset($_GET['id']))
{
	header("Location: $base_url/");
	exit();
}

if(!isset($_GET['p']))
{
	$_GET['p']=1;		
}

[leatherback]

Well, there is a lot of things which could/should be changed. What is the problem you are having?

What I would change:

Retrieve the username first:

$username = html_special_chars($_GET['username']);

and use that in the query:

if(! $username ="")
 {
mysql_query("SELECT id FROM shocc_users WHERE username = $username") or die('The query failed: '.mysql_error());

I would not do:
$_GET['id'] == $result;

But more:

$id = $result;

J.

[Sayian]

Ok ive changed my code to

$username = $_GET['username'];

$query = mysql_query("SELECT id FROM shocc_users WHERE username = '$username'");
$result= mysql_result($query);

if($result) {

$_GET['id'] == $result;

}


if(!isset($_GET['id']))
{
	header("Location: $base_url/");
	exit();
}

But it's sending me to my homepage ($baseurl) so i know it's not assigning $_get['id'] to the result.

basically what im trying to do is make $_GET['id'] be the ID of the username from my query.

[leatherback]

Hi,

As I mentioned in the earlier post, I woul change the $_GET[id] also to

$id = $result;

Why do you want this value in the $_GET array?

Also, I suggested you pace an error line to your query, so you get an error when the query is wrong, which greatly helps you to debug the code.

J.

[Sayian]

I need this in the $GET array b/c my php script is looking for a $GET ID

Im trying to take the username , return the ID of the username from sql

and assign the ID to $_GET['id']

so my script can use it.

[leatherback]

ok,

so what does the query error give? Anything?

Also, try adding a line:

if($result) {

echo "OK, we got something";
$_GET['id'] == $result;

} 

[Sayian]

It's sending me to my homepage
BASEURL

See in the code where it says if NOT result then goto base url .. that's where its sending me , so i know im not getting a result .. their's somthing wrong with the php code for the query ..that's why im here.

[leatherback]

so.. please add

or die('The query failed: '.mysql_error());

to your qeury line, as I suggested in the first post, and tell what the error message is!

and:

if($result) {

$_GET['id'] == $result;

}

else
{
    header("Location: $base_url/");
    exit();
}

J.

[Sayian]

Ok , it said :

The query failed:

[leatherback]

OK. So the problem is with the query.

Now, place
echo "SELECT id FROM shocc_users WHERE username = $username";

in the code, and check whether all the colum names and table names are correct. Did you connect to the database properly?

J.

[Sayian]

Ive looked at some of my other query's it's set exactly the same table names and colums .. somthing is wrong in this

$query = mysql_query("SELECT id FROM shocc_users WHERE username = '$username'");
$result = mysql_result($query) or die('The query failed: '.mysql_error());

and i dont know what.

[leatherback]

Well,

I am trying to help you streamline the code somewhat. But if it takes three times asking before you add something in your code for everything, I cannot help you. I am sorry.

J.