Re: mySQL commands in PHP

Just as interesting as what mysql_error() returns could be the reasoning behind the single quotes around the '5'. Doug At 11:36 PM 11/11/00 -0500, scottrus@ipass.net wrote: >How does this not work? What does mysql_error() report back? I'm using date and encrypt fuctions withing >my mysql_query_db() calls and don't see any problems. > >-- Scott > >On Sat, Nov 11, 2000 at 12:38:50PM -0500, Chris Sano wrote: >> Does anyone know how to execute mySQL functions and operators from PHP? >> >> Typically in mySQL, if I wanted to do this: >> >> SELECT lcase(substring(first_name, 1,1)), lcase(last_name) FROM personal_info WHERE row_id ='5'; >> >> It'd return my name in the following format: csano >> >> But if I do the same thing from a PHP mysql_query function, it doesn't work. Does anyone know how to work around this and enable PHP to read in mySQL specific functions and operators? This really saves a lot of time and headache in programming PHP stuff.