Error Number: 1305 :FUNCTION strtoupper does not exist

strtoupper doesn't exist

[calmseas]

When I execute the following, I get a "Error Number: 1305 :FUNCTION ... strtoupper does not exist"

$query="UPDATE users SET last = strtoupper('last')" ;

Is not strtoupper a standard function?

Thanks in advance.

[bhukkel]

strtoupper is php code in mysql it is upper (i assume you use mysql).

[Anyango]

try UCASE mysql function

[rocknbil]

This is a mysql error, not a PHP error. Since you haven't quoted the select statement, mysql is trying to interpret it as a command like

$query = "update table set dtfield=curdate()":

strtoupper is not a function in mysql. Try

$query="UPDATE users SET last = '" . strtoupper('last') . "'" ;

ucase (the mysql equivalent) will also work.

[calmseas]

Got it! Thanks to you all for your suggestions.