Code misspelt???

[Huijari]

Hi, can you tell me what is wrong with my code? Nobody wants to help me

 

$result = mysql_query("SELECT * from webid_auctions where closed = '1' and sold = 'n'  and user ='" . $user->user_data['id'] . "'", $conn);  

 

Thank you

[mrMarcus]

Hi, can you tell me what is the problem you are receiving? Seems you don't want to give too much information away .. more fun this way?  might be why nobody is helping you.

 

Thank you

 

add trigger_error (mysql_error()) to the end of your query and rerun:

 

$result = mysql_query("SELECT * from webid_auctions where closed = '1' and sold = 'n'  and user ='" . $user->user_data['id'] . "'", $conn) or trigger_error (mysql_error());

[PFMaBiSmAd]

Nobody wants to help me

Thats because you are not providing any relevant information.

 

We are not standing right beside you, so unless you tell us what error, symptom, or problem you are having when you try your code, no one can help you.

[KevinM1]

Also, ironically, 'misspelt' isn't a word.  You're looking for 'mis-spelled'.

[Zane]

Also, ironically, 'misspelt' isn't a word.  You're looking for 'mis-spelled'.

Moreover, what is misspelled in the first place.. as your thread title suggests?  Other than what Nightslyr pointed out

[Huijari]

... the problem is that it doesn't do anything. There is no error but it is not working. And the problem is in that code...

[mrMarcus]

k, i'll pry a little more, seeing as how giving meaningful information is not your forte.

 

is $user->user_data['id'] defined/set?

 

is $conn defined/set?

 

is there a table called `webid_auctions` in your database?

 

do you have a database setup?

 

are there fields called `closed`, `sold`, and `user` in your database?

 

and an important one...did you add:

 

 or trigger_error (mysql_error());

 

to the end of your query like i suggested an hour ago:

 

$result = mysql_query("SELECT * from webid_auctions where closed = '1' and sold = 'n'  and user ='" . $user->user_data['id'] . "'", $conn) or trigger_error (mysql_error());