mySQL commands in PHP

From: Date: Sat, 11 Nov 2000 17:38:50 +0000
Subject: mySQL commands in PHP
Groups: php.db 
Request: Send a blank email to php-db+get-4373@lists.php.net to get a copy of this message
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. Any help would be appreciated. Thanks! Chris ______________________________________ s a n o g r a p h i c s d o t c o m graphics with an ultimately creative touch

« previous php.db (#4373) next »