Databases

PHP and MYSQL Update problem
Hello, I have a little problem with a sql command string $q = "UPDATE episodes SET episode_title = '$_POST[episode_title]' , episode_scheduleddate = ".strtotime($_POST['episode_scheduleddate'])." , episode_description = '$_POST[episode_description]' WHERE episode_id = $_POST[episode_id]"; I keep getting this ... 26 Jan 2010 17:49

dl () problem
Dear All, I have updated apache2 and php5 then I have faced the following message. I have set on Enable dl in php.ini file but still could not solve problem. Could you help me about this problem, please. Fatal error: Call to undefined function dl() in /usr/local/httpd/htdocs/zone/zone30.php on line 3 Mur... 26 Jan 2010 15:33

Random pick
Hello List, Trying to learn the right way to code this line. Can anyone tell me if I am doing this the right way? if $req_user_level == 0 || 1 || 2 || 3 || 4 || 5 || 6 || 7 || 8 || 9 ? "Guest" || "Regular User" || "Intl. User" || "Contractor" || "Employee" || "Sales" || "Investor" || "Human Resources" || ... 25 Jan 2010 16:15

Automatic logoff
Has anyone considered a way to run a script or automatically access a php page when a user leaves a site without logging off? The idea is to gracefully end that user's session. Thanks! ... 2 Feb 2010 17:46

result set in php pagination
The easiest thing to do is either A) store the author name in a session for the duration of the searches B) add the name to the pagination url so that its passed along withe the page number On 1/23/10, Joe Keenan <heresiarch(a)btopenworld.com> wrote: I am using php and mysql. The problem which I am... 24 Jan 2010 18:08

[PHP-DB] result set in php pagination
I am using php and mysql. The problem which I am hoping someone can help me with concerns pagination of the result set of a search of a single table. I got the pagination script I am using from a Sitepoint tutorial and it works just as it should for this query "SELECT article_id, category_name, author_na... 23 Jan 2010 14:21

Procedure Parameter OUT values
I am surprised by the order of the data returned from my stored procedure, and that it appears associated with the incorrect variables. Apparently the data is returned entirely positionally, without consideration for the variable names. So, the names of the OUT parameters in the procedure appear to be invisible ... 26 Jan 2010 17:49

DB2 connection: Setting codepage
Hi all, I have some code that has to insert data into databases (DB2 AS400) coming from multilingual sources. The code on the Webserver is the same; that's why i can not use solution involving php configuration. For example: User 1 (English) logs into the application and submits some info (uploaded fr... 21 Jan 2010 14:38

Transferring rows between 2 databases on 2 web servers
Hi Everybody, There are n number of web servers all having the same Linux-Apache-MySQL-Php setup, with identical databases. Each of these servers functions as a billing server at a store of my company. Now I am required to set up a master server that will copy all data from each of the store servers. All I wish ... 18 Jan 2010 02:07

PMC生产计划与物料控制
php-db(a)lists.php.net P M C Éú ²ú ¼Æ »® Óë Îï ÁÏ ¿Ø ÖÆ ¸ß ¼¶ ÑÐ ÐÞ °à ʱ¼ä£º2010Äê01ÔÂ14 -15ÈÕ£¨ÉϺ££© ʱ¼ä£º2010Äê01ÔÂ16 -17ÈÕ£¨ÉîÛÚ£© -------------------------------------------------------------- ¡ñ¶Ô Ïó:Éú²ú×ܼࡢÉú²ú¾­Àí¡¢Éú²ú¼Æ»®Ïà¹ØÈËÔ±¡¢³µ¼äÖ÷ÈΡ¢ÎïÁÏÖ÷¹Ü ... 10 Jan 2010 19:42