[SOLVED] How Do You Display Full Error Info?

[limitphp]

Right now I use this if a query fails:

mysql_query($query_playlist) or die (mysql_error());

 

Is there a way to have it give me more info?

 

all its saying is:

Unknown column 'u2' in 'where clause'

 

where u2 is a username....

thanks

[premiso]

mysql_query($query_playlist) or die ("SQL Was (playlist): " . $query_playlist . "<br />Mysql Returned: " . mysql_error());

[limitphp]

mysql_query($query_playlist) or die ("SQL Was (playlist): " . $query_playlist . "<br />Mysql Returned: " . mysql_error());

thank you...

 

SQL Was (playlist): SELECT p.name FROM playlists p INNER JOIN user u ON p.userID = u.userID WHERE u.username = u2 AND p.nameHash = Punk-Rock LIMIT 1

Mysql Returned: Unknown column 'u2' in 'where clause'

 

I don't understand why its saying u2 is a column, when its really a value in a column??

[premiso]

Because you do not have single quotes around it.

 

u.username = 'u2'  is what it should be.

[limitphp]

Because you do not have single quotes around it.

 

u.username = 'u2'   is what it should be.

 

oh yeah....

 

the actual code looks like this:

WHERE u.username = ".clean($p_username,'sql')."

 

I forgot to add those single quotes in there....

 

thank you....