[PHP-DB] Help With An UPDATE Query Please

Hi, How can I update a column where the first letter begins with 'M' and adjust it so that column ends with 'M' instead. So something like 'UPDATE table SET column = 'xxxM' WHERE column = 'Mxxx'. I hope this explains what I am trying to achieve! Thanks -- PHP Database Mailing List

Re: [PHP-DB] Help With An UPDATE Query Please

UPDATE table SET column = CONCAT( MID( column, 2, LENGTH( column ) - 1 ), MID( column, 1, 1 ) ) WHERE column LIKE 'M%' HTH Ignatius _ - Original Message - From: Shaun [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 14:15 Subject:

Re: [PHP-DB] msql perfomance: fast through mysql, slow through php

There are couple of things that look like they may be slowing you down. The first one being the east coast/west coast thing. There's a big possibility for latency issues going that distance no matter how fast your connection is. You can do a quick test using ping. You're also writing out to

Re: [PHP-DB] msql perfomance: fast through mysql, slow through php

Hi jde, this sounds very strange. Please post send the results of an traceroute and ping to the list. Perhaps, the bandwidth could be the problem. We have a constellation like you with our boxes in germany. The webservers are located in karslruhe, the mysql-boxes in frankfurt. Everything works

[PHP-DB] PHP / mysql / opendb / Apache

I am trying to get a functioning instance of these components working on my Solaris 2.8 box. Are there any comprehensive instructions out there to achieve this? Thanks Terry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Compatibility between Sybase and PHP

Hi, I found that there is a problem in the version compatibility between our Sybase server and PHP/apache server. PHP can retrieve data from Sybase but get core dump when exit from sybase call. This seems to happen in several version of freetds and php. Has anyone encountered such problem before

[PHP-DB] Re: mktime question

http://www.mysql.com/documentation/mysql/bychapter/manual_Functions.html#IDX1342 insert into tbl (timeCol) values (now()) when you retrieve the time from mySQL, you format it the way you want and then display it !!!

[PHP-DB] Missing mysql_real_escape_string() function in PHP 4.3.4

I'm trying to move a PHP application that was originally built on the windows PHP implementation to a newly installed Fedora FC1 Linux system. However the Fedora implementation of PHP 4.3.4 seems to be missing the mysql_real_escape_string() function. I suspect that there might be other mysql

[PHP-DB] RE: [PHP] Missing mysql_real_escape_string() function in PHP 4.3.4

[snip] I'm trying to move a PHP application that was originally built on the windows PHP implementation to a newly installed Fedora FC1 Linux system. However the Fedora implementation of PHP 4.3.4 seems to be missing the mysql_real_escape_string() function. I suspect that there might be other