Re: mySQL commands in PHP
| From: | scottrus at ipass dot net | Date: | Sun, 12 Nov 2000 04:36:04 +0000 |
| Subject: | Re: mySQL commands in PHP | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-4380@lists.php.net to get a copy of this message | ||
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.