RE: [PHP-DB] How to show table???

http://www.php.net/manual/en/function.mysql-list-tables.php > -Original Message- > From: kelvin [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 24, 2001 5:09 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] How to show table??? > > > Hi there, > > I just wonder how to list all the

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

hp-news-archive): http://marc.theaimsgroup.com/?l=php-windows&m=99017650207323&w=2 Check the @all newbies - section. Please understand the pro's, too ! Happy programming, Mike Michael Rudel - Web-Development, Systemadminis

RE: [PHP-DB] fopen function

=8) 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 Bleicherstraße 20 D-78

RE: [PHP-DB] blinking background

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

RE: [PHP-DB] order by date

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

RE: [PHP-DB] LDAP and special chars

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] record deletion using checkbox array values

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-Deve

RE: [PHP-DB] Date Format

te( "d-m-Y", $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 ___

RE: [PHP-DB] Inserting Variable Variable?

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

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

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 R

RE: [PHP-DB] Order by unix timestamp

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] finding out the result of an INSERT

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] parsing checkbox array without [] and selecting all boxes

ave 2 setup 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. Aug

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

ike '%".$word."%'"; } echo $sql.""; $queryResult = mysql_query($sql); while ( $myrow = mysql_fetch_assoc( $queryResult ) ) { echo " ".$myrow["bandname"]." "."\n"; }

RE: [PHP-DB] Converting an Access DAtabase to..

Hey Ali, ... if you own a MS-SQL-Server, you could use the import/export-tool. The Data-Architect from PowerSoft (?? - PowerBuilder) can make it, too. Or you write a little php-skript which does the job for you, not much work i think. Hope this helps. Greetinx, Mike Michael Rudel - Web

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

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,

RE: [PHP-DB] delay script

Hi Jennifer, use my function: "; die( " ".$message." " ); } ?> ... in your case this will be: logging out" ); ?> Hope this helps. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21.

RE: [PHP-DB] static or dynamic "printer-friendly" webpages?

e and send it back to the browser. Yes: this means a bit of work, and I think there are several other ways out there, so keep your eyes open. This was just my suggestion. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der o

RE: [PHP-DB] Storing Code in a db?

Hi Mark, ... yes, I think it's possible. Look at the Function 'eval()' in Chapter 'XXXVIII. Miscellaneous functions'. You will to have to experiment with escaping Char's. Hope this helps. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration -

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

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] mssql_fetch_array problem

uot;; } else { print "" . $myrow["countryname"] . "" . "\n"; } Hope this helps. If not, plz post what is going wrong. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration -

RE: [PHP-DB] function login problem

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-7846

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

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, Systemadministr

RE: [PHP-DB] Detect OS

$HTTP_USER_AGENT 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 PRO

RE: [PHP-DB] Update Multiple records

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 - ___

RE: [PHP-DB] Url link

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] Printing out usernames and logins

¥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] How to select [please HELP]

... 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-89

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

> 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, e-m

RE: [PHP-DB] Auto load PHP

"; if ( !empty( $message ) ) die( " ".$message." " ); } ?> Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstraße 20 D-78467 Konstanz Ge

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

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, Systemadministrat

RE: [PHP-DB] MySQL manager

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 fou

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

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 Bleicherstraße 20 D-

RE: [PHP-DB] Another newbie question

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]> >

RE: [PHP-DB] Another newbie question

$Offset = 0; } // End Event-Handler // Hope this helps. If there are still questions ... ask =8) Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicher

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

} echo " \n"; } echo "\n"; } ?> Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstraße 20 D-78467 Konstanz Germany fon: +

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

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

RE: [PHP-DB] File Optimisation

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] Error prevention

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

RE: [PHP-DB] parsing parameter over page

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-Dev

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

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 Bleicherstraße 20 D-78467 Konstanz Germany fon: +

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

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 T

AW: [PHP-DB] recursion

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 ); }

AW: [PHP-DB] Viewing the DB

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

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

Hi Nicolas, ... don't you need a COMMIT on IB6-DB ??? Hope this helps. Greetinx, Mike (Germany) -Ursprüngliche 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] Problem width SQL on PHP4

Hi Sebastian, you don't have the mssql.dll loaded (no SQL-Support!) Just have a look with the PHP_INFO() -function. You have to enable the mssql-support in your php.ini -file. If you don't have the appropriate Library, you can get it at: http://www.php4win.de/ Hope this helps. Greetinx, M

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

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