Re: [PHP-DB] What wrong with my Query??

2005-03-26 Thread GR Kumaran
There you have to consider the following things; 1, the query is mixed with INSERT and UPDATE staments 2, `id` is a numeric data type field, so the value should be mentioned in numeric form (instead of string) 3, LIMIT is a keyword of SQL statement 4, `lastip` field is a string datatype, so the

[PHP-DB] php/js

2005-03-26 Thread Yemi Obembe
hi guys, sorry about making this stupid comparisons but i hope someone help me with them. Simply, I'd like to know php functions that are equivalent to this javascript functions: 1.document.lastModified // displays date document was modified as reported by server 2.var php = 'php forever!'

RE: [PHP-DB] php/js

2005-03-26 Thread Bastien Koert
1. http://ca.php.net/manual/en/function.filemtime.php 2. $php = php forever; echo big$php/big; bastien From: Yemi Obembe [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] php/js Date: Sat, 26 Mar 2005 06:48:27 -0800 (PST) hi guys, sorry about making this stupid comparisons but i hope

[PHP-DB] Slow access Apache + PHP + MySQL

2005-03-26 Thread Andre Matos
Hi List, I have 4 web based systems developed using PHP4 and MySQL accessed for 10 users. The Web Server and Database Server were running ok on a Mac OS X 10.3 G4 dual. However, since we move to a new server, the access becomes very slow. This was not expected since we move to a 64 bits high

RE: [PHP-DB] Slow access Apache + PHP + MySQL

2005-03-26 Thread Bastien Koert
There are a ton of things to check. Check the amount of memory that can be used by each process; add some time checks to the scripts to see where the hang ups are, if its db access or the webserver. Monitor the amount of resources consumed by each process during a page creation/query. Check the