SQL problem O.o

[black-ops]

I have just gone brain dead, anyone can tell me what is wrong with this code lol.
I dunno but I am overlooking such a stupidly simple thing, coding for several hours straight doesn't help haha.

if(mysql_query("SELECT * FROM `calculation` WHERE username='Hobgoblin'")){
echo "duplicate detected";
}

 

[shine]

You don't need the single quotes around the table name. Also what error are you getting?

 

[Dj_Jestar]

You really need to read up on how to use mysql_query...

 

[sist_si]

what's the error?

 

[Dj_Jestar]

You don't need the single quotes around the table name. Also what error are you getting?

Semantically, the back-ticks are correct.

 

[Inquisitor]

mysql_query returns a resource for a SELECT query. You need to extract the information from that query using the appropriate function (i.e. mysql_num_rows in your case).

Strictly speaking, by the way, the correct way to check for a conflict like this is to use COUNT(*) to find the number of rows with the given user name. This avoids actually fetching the row from the database (since it's not needed).

 

[black-ops]

You really need to read up on how to use mysql_query...

it's not the fact that I don't know, it's the fact that I can't think as i've been coding for quite some time and need to finish this part asap lol.

doesn't help that I made an abstraction layer too which my guess is it's falling under that region.

 

[Dj_Jestar]

Then take a break. Fragile minds create fragile code.

 

[steve-h]

Then take a break. Fragile minds create fragile code.

This, because you're doing it wrong

5 minutes outside, go~

 

[RobH]

You are using mysql_query() inside an if() statement which expects a boolean value. mysql_query() returns true on success and false on error which is not the functionality you're after.

 

[Dj_Jestar]

You are using mysql_query() inside an if() statement which expects a boolean value. mysql_query() returns true on success and false on error which is not the functionality you're after.

It returns a MySQL resource handler on success, and false on failure. A query returning 0 results is a success...