[PHP-DB] Invitation from Multiply

2012-04-17 Thread MA PROPOSISION ELMAZI (via Multiply)
E-mail: selm...@superposta.com,- selam.elm...@yahoo.com Merci Thanks, MA PROPOSISION Stop e-mails, view our privacy policy, or report abuse: http://multiply.com/bl/04z4gUvdfAvWOXUCM+Dk+g We haven't added your email address to any lists, nor will we share it with anyone at any time. Copyright

Re: [PHP-DB] multiple tables and amounts

2004-01-29 Thread ma
hotos as ph left join comments as cm left join > ratings as rt on ph.id = cm.phid = rt.phid where id = '$photo_id' order > by ph.id"; > > //runs the query > $get_Quote_res = mysql_query($get_Quote) or die(mysql_error()); > > > > > -Original Messa

Re: [PHP-DB] multiple tables and amounts

2004-01-29 Thread ma
amounts > > I may be able to hack the XML code to do it, but with wanting a COUNT of > each based on the ID, it is going to be difficult to do it in 1 query > only, in my opinion at least... Is there a way to out-think the XML > generation to grab the items you need? > >

Re: [PHP-DB] multiple tables and amounts

2004-01-29 Thread ma
hi! thanks a lot for your answer. i also thought of dividing the problem into several selects, but the application i'm working with (it's designed by a friend of mine, which lets you easily generate XML out of an sql) only accepts one single query.. do you know about any problems using CREATE TEM

[PHP-DB] multiple tables and amounts

2004-01-28 Thread ma
hi! i have a weired problem: there are 3 tables: photos (id, img) comments (id, phid, text) ratings (id, phid, text) now i tried to create a query returning the amount of ratings and the amount of comments for all images in the photo-table. i tried it with multiple joins, but without success...

Re: [PHP-DB] MySQL Insert via SQL?

2004-01-07 Thread ma
idea). you're right ;) sometimes arguing can get anoying (e.g. which distribution of linux is best and so on...) greets ma # life would be easier if i knew the source code... > Von: "John W. Holmes" <[EMAIL PROTECTED]> > Antworten an: [EMAIL PROTECTED] > Datum: W

Re: [PHP-DB] MySQL Insert via SQL?

2004-01-07 Thread ma
ages for a photo-gallery). it is much faster saving the file in some directory and just save the path to the file in the db; which on the other hand, can lead to synchronisation-problems. what do you think about this topic? thx -ma # life would be easier if i knew the source code... > Von: &q

Re: [PHP-DB] MySQL Insert

2004-01-07 Thread ma
hi! no problem... people should help each other ;) so: no there is no difference. if you want people to have the possibility to download the file there are certain things to remember of. just a short example: greets -ma # life would be easier if i knew the source code... > Von: &quo

Re2: [PHP-DB] MySQL Insert

2004-01-07 Thread ma
LES['myFile']['tmp_name'])); fclose($fp); instead of $data = join(etc); greets - ma # life would be easier if i knew the source code... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL Insert

2004-01-07 Thread ma
) NOT NULL, `data` BLOB, PRIMARY KEY (`id`) ) TYPE=MyISAM the html-form: File: the php-script: for further info go&see: http://www.php.net/manual/en/features.file-upload.php hth? greetings -ma # life would be easier, if i knew the source code... > Von: "Will W"

[PHP-DB] LOCK TABLES with registry?

2004-01-06 Thread ma
Hi folks! I use a registry in my webapp which holds an instance of my sql-class. within my application i _only_ use this instance to do queries. first of all i lock all my tables with LOCK TABLES tableName WRITE; Later in the progrmm i try to do a "SELECT `menue` as `first` ..." but i get: "Tab

Re: [PHP-DB] nested sets?

2003-11-21 Thread ma
about company history today employees products i think of buying the book. its better to have a good reference. thx -ma # life would be easier if i knew the source code... > Von: Cal Evans <[EMAIL PROTECTED]> > Datum: Fri, 21 Nov 2003 11:24:52 -0600 > An:

[PHP-DB] nested sets?

2003-11-20 Thread ma
BETWEEN `second`.`left` AND `second`.`right` AND `first`.`level`=0 '; } $qry .='AND `first`.`menu`='.$menuID.' GROUP BY `first`.`left` ORDER BY `first`.`left` &

Re: [PHP-DB] Select Value with 's

2003-11-05 Thread ma
hi hm - it would help if you'd send us the code where you generate the query _ma # life would be easier if i knew the source code... > Von: "Aleks @ USA.net" <[EMAIL PROTECTED]> > Datum: Wed, 5 Nov 2003 14:23:06 -0500 > An: "'ma'" <[EMAIL

Re: [PHP-DB] Select Value with 's

2003-11-05 Thread ma
.customer LIKE "'.$FF.'"'); _ma # life would be easier if i knew the source code... > Von: "Aleks @ USA.net" <[EMAIL PROTECTED]> > Datum: Wed, 5 Nov 2003 14:01:37 -0500 > An: "'ma'" <[EMAIL PROTECTED]>, "'

Re: [PHP-DB] Select Value with 's

2003-11-05 Thread ma
et" <[EMAIL PROTECTED]> > Datum: Wed, 5 Nov 2003 13:52:51 -0500 > An: "'CPT John W. Holmes'" <[EMAIL PROTECTED]>, "'ma'" > <[EMAIL PROTECTED]>, "'PHP-DB'" <[EMAIL PROTECTED]> > Betreff: RE: [PHP-DB

Re: [PHP-DB] Select Value with 's

2003-11-05 Thread ma
hi! do not quite understand your problem.. pls post some code? heres a small snippet that should work well... $qry = 'SELECT `customer` FROM `customerList` ORDER BY `customer`'; $res = mysql_query($qry); while($customer = mysql_fetch_object($res)) { echo stripslashes($res->customer).''."\n";

Re: [PHP-DB] Unique user ID?

2003-09-06 Thread .ma
hi! the only possibility i can think of is the following: force the users to bookmark the site with a given id (as get-parameter). once an id is used it is stored in a db or something else. but this is _no_ proper solution! ciao ma > Von: "John W. Holmes" <[EMAIL PROTECTED]

[PHP-DB] Re: [PHP-INST] Installing PHP on LINUX with options other than standard

2003-07-13 Thread . ma
://at.php.net/manual/en/install.apache.php (in this example apache is builded from source too - its possible that this is not required on your computer because it may be installed in the right configuration (with apxs)) hope this helps .ma e: [EMAIL PROTECTED] w: http://www.abendstille.at # life

[PHP-DB] phpMyAdmin-Problem

2003-07-10 Thread . ma
enter the script: I'm always displayed the login screen. This is a known PHP bug (see this bug report) from the official PHP bug database. It means there is and won't be any phpMyAdmin fix against it because there is no way to code a fix. is this the same for php 4.3.2 and IIS4

Fwd: [PHP-DB] PHP, MySQL and Flash

2003-07-09 Thread . ma
ok at http://www.flashkit.com (maybe you find some resources there) hope this helps? .ma Am Mittwoch, 09.07.03 um 14:36 Uhr schrieb Rankin, Randy: Does anyone know of any articles on integrating PHP, MySQL and Flash to perform a drag and drop routine for updating a db? Specifically, I have a cli

Re: [PHP-DB] setting session variables via a form

2003-06-16 Thread . ma
is is a requirement for session_start(). probably similar things have to be considerd vor $_SESSION['foo'] = 'bar'; .ma e: [EMAIL PROTECTED] w: http://www.abendstille.at # life would be easier if i knew the source code Am Montag, 16.06.03 um 20:04 Uhr schrieb Becoming Digit

Re: [PHP-DB] setting session variables via a form

2003-06-16 Thread . ma
''. ''; else $_SESSION['item_details'] = 'yes'; hope i understood you right and this helps? .ma e: [EMAIL PROTECTED] w: http://www.abendstille.at # life would be easier if i knew the source code Am Montag, 16.06.03 um 17:16 Uhr schrieb Becoming Digital:

Fwd: [PHP-DB] Calculating Time

2003-06-16 Thread . ma
take a look at http://www.php.net/function.mktime .ma e: [EMAIL PROTECTED] w: http://www.abendstille.at # life would be easier if i knew the source code Am Montag, 16.06.03 um 11:21 Uhr schrieb Delz: Hi All, How do I calculate time using php? Let's say I want to know the difference be

Re: [PHP-DB] How to find the last ID?

2003-06-06 Thread . ma
hi you can easily do this by using mysql_insert_id(); see http://www.php.net/manual/en/function.mysql-insert-id.php .ma e: [EMAIL PROTECTED] w: http://www.abendstille.at /***/ life would be easier if i knew the source code. Am Freitag, 06.06.03 um 23:16 Uhr schrieb Chris Payne: Hi

Re: [PHP-DB] Is it worth upgrading Mysql on linux?

2003-06-06 Thread . ma
hi! if you upgrade i'd say upgrade to 4.1 which provides the IN()-method which allows komplex subselects. But may be this is not a very good idea cause 4.1 is only alpha afaik .ma e: [EMAIL PROTECTED] w: http://www.abendstille.at Life would be easier if i knew the s

[PHP-DB] same connection to access two different database?

2002-01-29 Thread Vincent Ma
) Vincent Ma -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] PostgreSql query help....

2001-11-19 Thread Vincent Ma
"select nextval()"; do anyone know how to get current sequence number, in php. Thank for your help Vincent Ma -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] [PHP-PostgreSQL] table & field name case senstive problem

2001-11-13 Thread Vincent Ma
compid from table" Thus, I got error message said "no attribute **compid***". the field or table become lower case. Is anyone know how to prevent pg_exec case conversion. I guess may put some special character around the field name. Thank for any help Vincent Ma -- PHP Dat