AW: [PHP-DB] delete working erratically on ODBC

2001-01-12 Thread Michael Rudel
Ciao Fabrizio, try to COMMIT after your first DELETE and then start the Second one and so on. Hope 'tll work. Greetinx, Mike (Germany) -Ursprngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 12. Januar 2001 16:39 An: [EMAIL PROTECTED] Betreff:

AW: [PHP-DB] PHP4 + interbase 6 : UPDATE or INSERT has no effect

2001-01-22 Thread Michael Rudel
Hi Nicolas, ... don't you need a COMMIT on IB6-DB ??? Hope this helps. Greetinx, Mike (Germany) -Ursprngliche Nachricht- Von: nicolas [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 22. Januar 2001 14:39 An: [EMAIL PROTECTED] Betreff: [PHP-DB] PHP4 + interbase 6 : UPDATE or INSERT has

AW: [PHP-DB] Viewing the DB

2001-01-24 Thread Michael Rudel
Hi Scott, Try: SELECT * FROM TAB ... it works with Oracle and Access, don't know what with other SQL-Servers. Greetinx, Mike (Germany) -Ursprngliche Nachricht- Von: Scott Fletcher [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 24. Januar 2001 16:40 An: [EMAIL PROTECTED] Betreff:

AW: [PHP-DB] recursion

2001-01-30 Thread Michael Rudel
Hi Andrew, This works fine: // Prints out an array recursiv function print_array( $array, $seperator = "" ) { while ( list( $key, $val ) = each($array) ) { if ( is_array( $val ) ) { print_array( $val, $seperator." = ".$key ); }

RE: [PHP-DB] help can please some1 help me?

2001-03-01 Thread Michael Rudel
Buenos Dias, Pedro ! Have U tried the php-function htmlentities ?? For further information consult the Manuel (String Functions -- htmlentities) Greetinx, Mike (Germany) -Original Message- From: Pedro M. S. Oliveira [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 8:59 PM

RE: [PHP-DB] How would you have liked to have invested in Yahoo when it was still a year old?

2001-03-01 Thread Michael Rudel
Its SPAM. Ignore it silently =8) ... or send an abuse mail to the sender's mail-provider. Greetinx, Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstrae 20 D-78467 Konstanz Germany fon: +49-(0)7531

RE: [PHP-DB] parsing parameter over page

2001-03-06 Thread Michael Rudel
Hi andrie, have you tried to 'serialize()' and 'unserialize()' your object ?? look at the 'Miscellaneous functions' in the php-manual. hope this helps. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration

RE: [PHP-DB] Error prevention

2001-03-13 Thread Michael Rudel
Hi Martin, ... you forgot to 'mysql_fetch_row' or 'mysql_result'. Read about it in the PHP-Manual in the MySQL Functions. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstrae 20 D

RE: [PHP-DB] File Optimisation

2001-03-14 Thread Michael Rudel
Hi Steve, if your users have all JavaScript enabled, you could generate the HTML-Doc clientside, using things like document.write or document.writeln. Hope this helps. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration

RE: [PHP-DB] FATAL: emalloc(): Unable to allocate 2147483599 bytes

2001-03-22 Thread Michael Rudel
Hi Denis, try this one: $r=odbc_exec($x,"select 'a' as a_leter from some_table"); or $r=odbc_exec($x,"select \"a\" as a_leter from some_table"); which you prefer, but you have to escape the "" within a ""-String !! Hope this solves yo

RE: [PHP-DB] RE: [PHP] Printing MySQL into HTML Tables

2001-03-23 Thread Michael Rudel
echo " TD ".$row[$count]." /TD\n"; } echo " /TR\n"; } echo "/TABLE\n"; } ? Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - _

RE: [PHP-DB] Another newbie question

2001-03-26 Thread Michael Rudel
; } // End Event-Handler // Hope this helps. If there are still questions ... ask =8) Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstrae 20 D

RE: [PHP-DB] Another newbie question

2001-03-26 Thread Michael Rudel
h r e e z e r o : : : the mill, millstone lane, leicester, le1 5jn e : [EMAIL PROTECTED] :: m : 07747 845690 w : http://www.threezero.co.uk : : :t h r e e z e r o From: "Michael Rudel" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED]

RE: [PHP-DB] table 1 to table 2

2001-03-27 Thread Michael Rudel
I was thinking that MySQL doesn't support subselects ?! Or is there a new MySQL-Version which does support them ? Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstrae 20 D-78467

RE: [PHP-DB] MySQL manager

2001-03-27 Thread Michael Rudel
what about kmysql and kmysqladmin ?? Greetinx, Mike -Original Message- From: Rubanowicz, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 4:34 PM To: 'Rosen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL manager www.mysqlfront.de I have used it and found it to

RE: [PHP-DB] How to limit a WHILE statement?

2001-04-03 Thread Michael Rudel
Yes, LIMIT will do the job, but to answer your question: $x = 0; while ( ( $myrow = mysql_fetch_array( $result ) ) and ( ++$x 20 ) ) { [...] } Greetinx, Mike Michael Rudel - Web-Development, Systemadministration

RE: [PHP-DB] Auto load PHP

2001-04-03 Thread Michael Rudel
!empty( $message ) ) die( "div style='font-family: Arial, Sans-serif; font-size: 12pt;' align=center ".$message." /div" ); } ? Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___

RE: AW: [PHP-DB] syntax error - -- agghhh!

2001-04-25 Thread Michael Rudel
it's always eaiser to count the parens and braces backwards to make sure they're all there. i do it all the time. ... or you use a cool Editor (like UE32) which will do this job for you =8) Greetinx, Mike (Germany) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

RE: [PHP-DB] How to select [please HELP]

2001-04-25 Thread Michael Rudel
... AND recordid NOT LIKE '$recordid' I think this will do the job. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstraße 20 D-78467 Konstanz Germany fon: +49-(0)7531-89207-17 fax

RE: [PHP-DB] Printing out usernames and logins

2001-05-14 Thread Michael Rudel
¥es, U R overwriting Ur result-set from the 1st qry. Store instead the 1st result into an array and iterate it then, sending your second select. U can also use 2 connections, but ... ? Greetinx, Mike Michael Rudel - Web-Development, Systemadministration

RE: [PHP-DB] Url link

2001-05-15 Thread Michael Rudel
Hi Mark, have a look @ http://www.php.net/manual/en/function.stripslashes.php Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstraße 20 D-78467 Konstanz Germany fon: +49-(0)7531

RE: [PHP-DB] Update Multiple records

2001-05-17 Thread Michael Rudel
Hi Ben, I think U can use: [...] where db_uid = '1' or db_uid = '2' ... OR [...] where db_uid in ('1', '2', ...) Hope this helps. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG

RE: [PHP-DB] Detect OS

2001-05-17 Thread Michael Rudel
in 80%. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstraße 20 D-78467 Konstanz Germany fon: +49-(0)7531-89207-17 fax: +49-(0)7531-89207-13 e-mail: mailto:[EMAIL PROTECTED] internet

RE: [PHP-DB] Filling mysql db with access db

2001-05-17 Thread Michael Rudel
Sorry for the late answer, but better too late than never =8) OK, there's a tool named access2mysql (but only on Unix). I think U can get it @ the mysql-web site. Hope this helps. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration

RE: [PHP-DB] function login problem

2001-05-17 Thread Michael Rudel
Hi Greg, I can't C a call 2 Ur function login() in the below code-snipplet ... perhaps that's the clue ?? Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstraße 20 D-78467 Konstanz

RE: [PHP-DB] mssql_fetch_array problem

2001-06-19 Thread Michael Rudel
{ print option value= . $myrow[countryid] . . $myrow[countryname] . /option . \n; } Hope this helps. If not, plz post what is going wrong. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration

RE: [PHP-DB] db abstraction: sql design

2001-06-20 Thread Michael Rudel
Hi Michael, …since U R using an abstraction-layer, most of Ur problems should be solved. U should have no problems if U reduce Ur SQL-statements to SQL92-standard. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration

RE: [PHP-DB] Executing several PHP scripts simultaneously??

2001-07-02 Thread Michael Rudel
Hi Lisa, ... on *nix you could use exec( /path/to/php/php.exe your-first-php-script.php ) note the ampersand at the end of the command ... this will start the task in background, so you can do other things while the script is running in the background. Hope this helps, Mike Michael Rudel

RE: [PHP-DB] Dynamic SQL + result resource error

2001-07-09 Thread Michael Rudel
( $queryResult ) ) { echo p .$myrow[bandname]. /p.\n; } / Hope this helps ;) Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle

RE: [PHP-DB] parsing checkbox array without [] and selecting all boxes

2001-07-10 Thread Michael Rudel
a checkbox named 'CHECKALL'. Most of the Freemailers use this script (or alike), too. Of course you can now use a checkbox-array using []. Hope this helps. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online

RE: [PHP-DB] finding out the result of an INSERT

2001-07-10 Thread Michael Rudel
RTFM or search in the archive of this mailinglist !!! int mysql_insert_id ([int link_identifier]) Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle 1 Stand E 16

RE: [PHP-DB] Order by unix timestamp

2001-07-12 Thread Michael Rudel
ORDER BY unixtime DESC (it default orders by asc, not desc) Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle 1 Stand E 16

RE: [PHP-DB] I need a User Authentication solution

2001-07-16 Thread Michael Rudel
Hi Brian, ... well, I think that there'll be a few people interesting in it, me too. Why simply put it on phpclasses or the other well-known source- and project-stores ?? If you don't want to do this, please let me know if you could mail me this then. TIA, Mike Michael Rudel - Web

RE: [PHP-DB] Inserting Variable Variable?

2001-07-18 Thread Michael Rudel
Hi Jeff. $varname = C_First_Name.$x; // e.g. if $x == 3 then ... echo $$varname; // ... prints the content of $C_First_Name3 Hope this is what you wanted ?! Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online

RE: [PHP-DB] Date Format

2001-07-20 Thread Michael Rudel
, $Timestamp ); Thats it. Hope this helps. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle 1 Stand E 16 ___ Suchtreffer AG

RE: [PHP-DB] record deletion using checkbox array values

2001-08-08 Thread Michael Rudel
Hi Karl, $delete = ' . implode( ', ', $delete_list ); $delete = substr( $delete, 0, ( strlen( $delete ) - 3 ) ); then use: DELETE FROM sent_items WHERE id IN ($delete) Not tested, but should work. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am

RE: [PHP-DB] LDAP and special chars

2001-08-09 Thread Michael Rudel
Hi Christian, ... you could urlencode() when inserting and urldecode() on fetching the data. Perhaps this helps. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle 1 Stand E 16

RE: [PHP-DB] order by date

2001-08-09 Thread Michael Rudel
Hi Scott, RTFM. Anyway: '... ORDER BY Date DESC' will do the job for you. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle 1 Stand E 16

RE: [PHP-DB] blinking background

2001-08-09 Thread Michael Rudel
Hi jen, even if it's silly, here your answer: It's _not_ possible in PHP, use JavaScript. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle 1 Stand E 16

RE: [PHP-DB] fopen function

2001-08-10 Thread Michael Rudel
. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle 1 Stand E 16 ___ Suchtreffer AG Bleicherstraße 20 D-78467 Konstanz Germany

RE: [PHP-DB] please, please can we stop this kind of thing ..... !

2001-08-20 Thread Michael Rudel
understand the pro's, too ! Happy programming, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle 1 Stand E 16 ___ Suchtreffer AG