[PHP-DB] Adding Up MySQL Results

2005-01-15 Thread Nathan Mealey
I hope someone can help with this frustratingly simple (I assume!) question I have. I run this mysql query: "select sum(quantity)*price,price from sale where dvd_id=1 group by price"; I get this result: sum(quantity)*price price 450.00 15.00 29.99 29.99 I

RE: [PHP-DB] MySQL db sync

2005-01-15 Thread Bastien Koert
sqlyog is a great tool bastien From: "Kris Geens" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] MySQL db sync Date: Sat, 15 Jan 2005 14:06:50 +0100 Hi, I need some help. Does anyone know a good tool to synchronize MySQL databases? Thanks in advance for your help Regards, Kris -- PHP Database Mailing

Re: [PHP-DB] Integrating Interbase.so and PHP

2005-01-15 Thread Doug Thompson
Todd Cary wrote: I have compiled interbase.so, but even though I have extension=interbase.so in the php.ini file, it is not part of PHP. Has anyone had success doing this? Todd A quick peek at the list archives (search term="interbase.so") revealed this: http://marc.theaimsgroup.com/?l=php-db&m

[PHP-DB] MySQL db sync

2005-01-15 Thread Kris Geens
Hi, I need some help. Does anyone know a good tool to synchronize MySQL databases? Thanks in advance for your help Regards, Kris

[PHP-DB] values getting blown away

2005-01-15 Thread Stuart Felenstein
I have a page set up with a sql query that receives $_POST values (from pervious page) to perpare records for update. Two of the values are via $HTTP_POST_VARS, 1 is via $_SESSION. Goes something like this: // begin Recordset $colname__rsLPINDS = '-1'; if (isset($HTTP_POST_VARS['PN'])) { $colnam

[PHP-DB] Re: Integrating Interbase.so and PHP

2005-01-15 Thread Lester Caine
Todd Cary wrote: I have compiled interbase.so, but even though I have extension=interbase.so in the php.ini file, it is not part of PHP. Has anyone had success doing this? Try asking on the firebird-php list http://groups.yahoo.com/group/firebird-php There are various notes on different distribu

[PHP-DB] Integrating Interbase.so and PHP

2005-01-15 Thread Todd Cary
I have compiled interbase.so, but even though I have extension=interbase.so in the php.ini file, it is not part of PHP. Has anyone had success doing this? Todd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Integrating Firebird into PHP

2005-01-15 Thread Todd Cary
I have compiled interbase.so, but even though I have extension=interbase.so in the php.ini file, it is not part of PHP.  Has anyone had success doing this? Todd -- <>

RE: [PHP-DB] Require VB Usergroup

2005-01-15 Thread Bastien Koert
definitely off topic...but www.tek-tips.com is my place for that sort of info...forums more than mail group.. bastien From: Rinku <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] Require VB Usergroup Date: Fri, 14 Jan 2005 09:04:15 -0800 (PST) Dear all, Can any of you suggest me a

Re: [PHP-DB] Require VB Usergroup

2005-01-15 Thread Rinku
Thanks for your co-operation !!! But I need user group for VB 6.0 for client based programme and not for VB.NET. Regards, Rinku Joseph Crawford <[EMAIL PROTECTED]> wrote: you could try the Vermont .NET user group, there are several VB guru's there i think it's http://www.vt

Re: [PHP-DB] Input ++90 causing problems

2005-01-15 Thread graeme
Hi, I was able to trick IE but not Firefox to display some of the characters you had displayed. ï ï212- By selecting the encoding Arabic ASMO 708 and then selecting auto select in the encoding. On IE with right to left it appears -212 followed by the two characters that look like a sleepy 9 wit