[PHP-DB] Re: php to mysql client problem.

2004-02-09 Thread michael
I've since used different combinations and discovered that I can access the database as long As I don't use Passwords... I guess it is the Webserver and not the Sql server causing the problem... Michael G. Tracey wrote: This is my setup: Not really worried about security. W2kPro w\s

[PHP-DB] Re: php5/MySQL 4.1.1 connection error

2004-02-09 Thread michael
I have done the same thing... but still get "Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client" So beside copying the libmySQL.dll's to the System32 folder and the settings in the .ini... Should'nt there be more files to loca

[PHP-DB] end of line

2004-08-29 Thread michael
Hi. I'm trying to find a simple way to allow a client to update a "notes" page on her site whenever she wants. I created a form which allows her to save a few paragraphs to a mysql table. What I want to do, though, is write her paragraphs to an html page so others can see her words. Is there a w

[PHP-DB] mac and mysql

2004-08-31 Thread michael
nk command line you think of the old dos prompt. What does the Mac have that will give us command line access? Again, please excuse my ignorance, but here is an opp to educate those of us stuck in a MS POV. Thank you in advance. Michael -- PHP Database Mailing List (http://www.php.net/) To uns

[PHP-DB] Re: Portability concerns

2001-08-13 Thread Michael
Manuel Lemos wrote: > > Hello André, > > On 03-Aug-01 10:31:30, you wrote: > > >But what other issues are there? Should there not be a part of the PHP > >documentation dedicated to describing all the things you should worry about > >if you want to write portable code? Shouldn't there be a "port

[PHP-DB] Re: interbase or postgres

2001-08-17 Thread Michael
J-E-N wrote: > > just want to here comments from you guys. i will be doing a shopping cart and i'm >still looking for the best database which i could use aside from Oracle.i'm still >thingking which is better. interbase or postgres? Just a few comments - Postgresql has a larger range of data t

[PHP-DB] How can you hide database login passwd in your script?

2001-09-01 Thread Michael
How can you hide database login passwd in your script? I hate having to have scripts with passwords in it that can be viewed by others. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact t

[PHP-DB] Problem with file upload...

2001-12-10 Thread Michael
Bildes: " . mysql_error().""); } } I hope somebody can help with this as I already spent several days without results :-(( I already asked my provider if I have the rights to access the tmp/ file and he says yes! Regards, Michael

[PHP-DB] data access problem...

2002-01-12 Thread Michael
l me. I get no error messages but the timeout from the browser. TIA, Michael -- 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] data access problem...

2002-01-12 Thread Michael
Hi again, I just solved the problem myself. It was a endless loop in one of the functions I use. Thanks anyway, Michael Hi, I have a quite strange problem with PHP/MySQL. I wrote some scripts for an user database and it's working fine so far. Today I implemented a script to change the de

[PHP-DB] how is this line a security risk?

2008-09-23 Thread michael
I get an error stating that this line in my code is a security risk when I code it. require_once($PLUGINS_DIRECTORY."forum/forum.php"); here is what the explanation is: include() or analogous is used with variable argument this can be dangerous since variables are in many cases controlled by

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) -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 12. Januar 2001 16:39 An: [EMAIL PROTECTED] Betreff: [

AW: [PHP-DB] Problem width SQL on PHP4

2001-01-15 Thread Michael Rudel
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

[PHP-DB] SQL coloring in BBEdit 6.0?

2001-01-16 Thread Michael Zornek
Hello, I'm using BBEdit 6.0.2 to do some PHP. I love the way it colors the PHP commands differently. I also do mySQL. I usually write up a whole list of SQL statements in a text editor and then feed them into the server. Is there a way to have BBEdit color code the mySQL commands that same wa

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) -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] 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) -Ursprüngliche Nachricht- Von: Scott Fletcher [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 24. Januar 2001 16:40 An: [EMAIL PROTECTED] Betreff: [P

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

[PHP-DB] Re: [PHP] newlines in boxes..

2001-01-31 Thread Michael Hall
Use nl2br (new line to ). Mick On Wed, 31 Jan 2001, James Smith wrote: > Alright, on my site, I have a news section, whenever i > goto insert new news in the Admin area, I have to > insert or /n in it, while typing in the news. > How do I make this a automated process I know it can > be done

[PHP-DB] extra lines

2001-02-01 Thread Michael Gerholdt
Why would this code produce the desired list of records in a table row, and then add an equal amount of blank lines ( = num of records) before producing the next set of records? while ($row = mysql_fetch_array ($result)) { $num = count ($row); for ($c=0; $c<$num; $c++) { echo $row[$c].""; } } T

[PHP-DB] A php-xml mailing list?

2001-02-09 Thread Michael Dearman
I think it would be helpful. What do you folks think? MD -- 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]

Re: [PHP-DB] Link list

2001-02-13 Thread Michael McGlothlin
Which part were you having trouble with? You just want to store link name and url in a db and have PHP write that as a list in HTML that simply targets an alternate frame when opening the url? John Halladay wrote: > I am having the hardest time finding a simple script where I can have a list >

RE: [PHP-DB] subtotal

2001-02-14 Thread Michael Norton
There is a ROUND function in MySQL...try this: $totalsql = "SELECT ROUND(SUM(total),2) FROM entry WHERE user_id='$passedid'"; $totalresult = mysql_query($totalsql); $totalrow = mysql_fetch_array($totalresult); print "Total : $totalrow[0]"; --Mike Norton -Original Message- From: bryan

RE: [PHP-DB] md5

2001-02-28 Thread Krznaric Michael
I know there is an issue about encrypting an already encrypted string, or encrypting something twice. I believe it is against the law in the US for some algorithms (like MD5). They [they] have to be able to crack your stuff. Maybe someone can confirm? How does this rela

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 T

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

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

[PHP-DB] php-mySQL and an SQL query

2001-03-08 Thread Michael Gerholdt
trSQL"; $month will be carrying the three-character short version of the alpha month name. I don't think it likes my subquery, though I like it just fine. Regards, Michael -- 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-mySQL and an SQL query

2001-03-08 Thread Michael Gerholdt
trSQL"; $month will be carrying the three-character short version of the alpha month name. I don't think it likes my subquery, though I like it just fine. Regards, Michael -- 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] Whence Cometh Line Break?

2001-03-09 Thread Michael Gerholdt
I've discovered that this little bit of code is introducing a line break into my SQL string and it is causing it to break. the month comes through as '[linebreak here]Mar'   (these are two unbroken lines in original code.) Where does a line break come from in value="" ?? I'm mystified! Than

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

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

[PHP-DB] if () and () - newbie Q

2001-03-17 Thread Michael Gerholdt
s and something like: if (($rectype == 'events') and ($action == 'add') and ($manage == 'some')) Also - what about something like 'isNull' ? I don't see any documentation in the PHP online manual nor is 'null' even mentioned in the index of m

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

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

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

RE: [PHP-DB] Another newbie question

2001-03-26 Thread Michael Rudel
$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] Another newbie question

2001-03-26 Thread Michael Rudel
ge- > From: Matt Coyne [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 26, 2001 3:22 PM > To: PHP DB > Subject: Re: [PHP-DB] Another newbie question > > > Hi Michael > > Thanks for the prompt reply, much appreciated > > I can see where the code snippet is going. Cre

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

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 fou

RE: [PHP-DB] CSS versus Includes

2001-03-31 Thread Michael Geier
this post is about apples and oranges... CSS (Cascading Style Sheets) have nothing to do with includes. They only have to do with formatting elements on a web page. They can be written inside the document, or can referenced externally via a tag. Includes can be anything from a configuration fil

Re: [PHP-DB] Renaming a Table in a database

2001-03-31 Thread Michael Gerholdt
>From the mySQL manual: G.1 Things that must done in the real near future RENAME table as table, table as table [,...] Regards, Michael Gerholdt > Greetings! > > Can anyone tell me the SQL sintax to rename a Table in a MySql > database

Re: [PHP-DB] Access db

2003-11-20 Thread Michael Mauch
Luke Van Blerk wrote: > I'll probably just extract the data with an access to mysql script and run > it on mysql. This is probably the best approach if you have access to Windows machine. If not, <http://freshmeat.net/projects/mdbtools/> might help. Regards...

[PHP-DB] Killing MSSQL Query

2003-12-02 Thread Michael Lewis
I am looking for a way to kill my current MSSQY query from an PHP script. For example, I have a page where the user picks some selection criteria, the script then constructs aa MSSQL query and executes it, 5 minutes into it the user decides, "Forget about it" and presses a button (ideally) to kill

[PHP-DB] mssql and resource handling

2003-12-16 Thread Michael Lewis
RESS is comes back as RESOURCE OBJECT #12, the second time as 0. When I look in the session file, it is zero. Help! How can I pass this variable and its contents so they are usable to the next web page? Thanks in advance. Michael -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] oracle compilation with php

2004-01-07 Thread Michael Mauch
php oci8 or oracle options. > Thanks for the quote below, I will then want to look more to > the oci8 calls then. Unfortunately, neither oci8 or oracle php > option let me compile, due to the respective missing header files. Yes, Oracle's installer is fun. Regards...

[PHP-DB] Truncated fields

2004-01-21 Thread Michael Lewis
d/or has anyone else had this problem? Thanks. Michael -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Truncated fields

2004-01-21 Thread Michael Lewis
John, I'm getting much more than 255 characters. The field is not varchar but a text field. I've looked into FREETDS as the most likely source of the problem but haven't found anything yet. Michael > Michael Lewis wrote: > > > I'm having a problem with retrieving

[PHP-DB] Re: [PHP] Oracle + PHP

2004-01-30 Thread Michael Mauch
_TIME LC_COLLATE LC_MONETARY LC_MESSAGES LC_PAPER LC_NAME LC_ADDRESS LC_TELEPHONE LC_MEASUREMENT LC_IDENTIFICATION LC_ALL Some parts of Apache/Oracle/whatever-else apparently has trouble with locales. Regards... Michael -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
e so much, but php treats this as an error, and doesn't execute my query. I'm running php 4.3.3 for Windows; the SQL Server and web server are on the same machine. I'm using PEAR:DB for the database access. Thanks. Michael Flanagan voice: (1) 303-674-2691 fax: (1) 603-963-0

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
ELECT statement I'm getting the message on is the second query in my script. The other query is to the same db; in fact, it uses the exact same $db connection object. Any ideas on getting PHP to ignore this info message? Thanks again. Michael -Original Message- From: Adam Voigt [mai

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
don't work? mssql.min_error_severity = 11 mssql.min_message_severity = 11 Michael -Original Message- From: Adam Voigt [mailto:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 12:44 PM To: Michael Flanagan Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MS SQL 'Changed database context&

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
severity levels, and their interplay with MS SQL Server?? Thanks. Michael -Original Message- From: Frank M. Kromann [mailto:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 5:07 PM To: Michael Flanagan Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MS SQL 'Changed database context' e

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-19 Thread Michael Flanagan
Hi Robert, I've seen your name on a few of the ODBTP posts. You're one of the developers of same, yes? Are you familiar with the 'Changed database context' message? Do you know for sure that ODBTP handles that correctly? Thanks. Michael -Original Message- From: R

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-21 Thread Michael Flanagan
So, is this a PEAR problem? If not, what am I doing wrong? If so, how can I get around this? Thanks! Michael -Original Message- From: Frank M. Kromann [mailto:[EMAIL PROTECTED] Sent: Saturday, February 21, 2004 7:40 PM To: Php-Db Subject: RE: [PHP-DB] MS SQL 'Changed database c

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-22 Thread Michael Flanagan
= $result->getMessage() . $result->getDebugInfo (); return FALSE; } return $result; } -Original Message- From: Robert Twitty [mailto:[EMAIL PROTECTED] Sent: Sunday, February 22, 2004 2:49 PM To: Michael Flanagan Cc: Php-Db Subject: RE: [PHP-DB] MS SQL 'Cha

RE: [PHP-DB] MS SQL 'Changed database context' error

2004-02-22 Thread Michael Flanagan
ite so stupid as when I'm trying to be quite so smart! Thanks for sticking with me on this one. Michael -Original Message- From: Robert Twitty [mailto:[EMAIL PROTECTED] Sent: Sunday, February 22, 2004 6:38 PM To: Michael Flanagan Cc: Php-Db Subject: RE: [PHP-DB] MS SQL 'C

[PHP-DB] odd behavior

2004-04-03 Thread Michael Lewis
words, it works the way it's supposed to. I was running 4.3.5 and upgraded to 4.3.6rc1 this morning and the problem still exists. If anyone could shed any light on this I would greatly appreciate it. Thanks, Michael -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Odd behavior

2004-04-03 Thread Michael Lewis
Okay, problem solved. I've been looking at the code for so long that it was too obvious to see. The "or die" was the culprit. Just a reminder that one should watch cutting and pasting. Thanks to anyone who used any brain time on this. Michael -- PHP Database Mailing List (htt

RE: [PHP-DB] Displaying Date from Value in MySQL DB

2004-04-20 Thread Michael Scappa
Add an AS to your statement ... ditoevents.eventdate,DATE_FORMAT(ditoevents.eventdate, '%a, %b %d %Y') AS eventdateformatted, ditoevents.eventtime ... then $row[eventdateformatted] should contain the date in the way you want it. -Mike -Original Message- From: Tyler Replogle [mailto

Re: [PHP-DB] Linux/PHP/Access Database - oh boy :(

2004-05-13 Thread Michael Forbes
I'm glad you found a solution to your problem-- how big a stick did it require? I actually learned a LOT just reading that thread (although I'm an Access guru who came to PHP/MySQL by way of conversion to zealotry, I've never used PHP against an Access back-end). Many thanks to those who cont

Re: [PHP-DB] Linux/PHP/Access Database - oh boy :(

2004-05-13 Thread Michael Forbes
I'm glad you found a solution to your problem-- how big a stick did it require? I actually learned a LOT just reading that thread (although I'm an Access guru who came to PHP/MySQL by way of conversion to zealotry, I've never used PHP against an Access back-end). Many thanks to those who cont

Re: [PHP-DB] Edit with notepad

2004-05-11 Thread Michael Forbes
Why not just provide them with two different links to the document-- one version includes the tag, the other doesn't. -Mike Forbes Ng Hwee Hwee wrote: hi, header("Content-type: application/vnd-ms.word"); is not what my customers want. They may or may not want to save it in their harddisk.. but

[PHP-DB] Re: upload files into MySQL database

2004-05-11 Thread Michael Forbes
I've not run into this problem before, but the solution seems obvious: replace your filename spaces with underscores, or get rid of them completely. -Mike Forbes Phpdiscuss - Php Newsgroups And Mailing Lists wrote: Hello, I have problem for downloading files from MySQL database. Although I st

Re: [PHP-DB] question on

2004-05-13 Thread Michael Forbes
Interesting idea. Since I'm convinced that javascript is the bastard offspring of Bill Gates, Larry Ellison, and Baalzebub, can I sue too? :) Hengameh wrote: Well I am suing Java script to capture the selected item and make it the value of my input box. But my problem is how to access this info

[PHP-DB] Re: Dynamic Email Address in an HTML table

2004-05-09 Thread Michael Forbes
Two alternatives: One is to store the entire string "" in your field. The other is to just store the field, but concat the string together when you echo/print it. i.e.,: print ""; Phpdiscuss - Php Newsgroups And Mailing Lists wrote: Hello, I have a page displaying the results of a query fr

Re: [PHP-DB] - Delete records in an Access DB

2004-05-03 Thread Michael Forbes
Nope. Access' version of SQL is a slight bit different from ANSI SQL. All he needs to do in his statement is change it to this: $query="DELETE * FROM Test_Table WHERE name='franco';"; (notice the wildcard in there-- Access isn't smart enough to realize that the deletion of any information in

[PHP-DB] Re: The usual problem

2004-05-03 Thread Michael Forbes
If your ID is an autoincremented field, try not including it in your insert statement. I.E.: $sql = "INSERT INTO underskrifter (type, navn, epost, tid, ip, domain, sted) " . " VALUES ('$_POST[type]', '$_POST[navn]', '$_POST[epost]', '$tid', '$ip', '$host', '$_POST[sted]' );" -Mike Forbes Ma

[PHP-DB] Re: SQL question!

2004-05-03 Thread Michael Forbes
What you wrote will give you the list of users who also happen to have comments. What you really want is more like this: SELECT Users.ID, Users.UserName, Comments.Description FROM Users LEFT JOIN Comments ON Users.ID = Comments.UserID; (note that you'll need to have the UserID foreign key in you

Re: [PHP-DB] - Delete records in an Access DB

2004-05-03 Thread Michael Forbes
. -Original Message- From: Michael Forbes [mailto:[EMAIL PROTECTED] Sent: Monday, May 03, 2004 07:00 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] - Delete records in an Access DB Nope. Access' version of SQL is a slight bit different from ANSI SQL. All he needs to do in his statement i

Re: [PHP-DB] MySQL persistent connections

2004-06-13 Thread Michael Gale
query then persistent connections would not be worth it. Plus with persistent connections I have heard most people have issues with hitting the too many open connections limit. Because the connections are not being closed or reused. Michael. On Fri, 11 Jun 2004 11:38:37 -0400 Radek Zajkowski &l

[PHP-DB] mysql and indexes

2004-06-16 Thread Michael Gale
columnname1 columnname A 6623NULLNULL Could the multiple index cause a problem ? I am trying to speed up a DB query ? Michael. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] perfornance with POST or db check ??

2004-06-30 Thread Michael Gale
e original owner and compare that with the owner value of the select box OR should I do another db select to see if the field changed ??? I was thinking that passing a string would have less of a performance impact ? then db activity. ? Michael -- PHP Database Mailing List (http://www.php.

Re: [PHP-DB] How to take Backup ?

2004-07-01 Thread Michael Gale
Hello, Have a look at mysqldump .. it is used for backing up tables and database. Example mysqldump --add-drop-table -c testdatabase -h 127.0.0.1 -u mysqlbk --password=mysqlbk > testdatabase.bk Michael On Thu, 1 Jul 2004 21:26:27 -0700 (PDT) Rinku <[EMAIL PROTECTED]> wrote:

[PHP-DB] DB connections ?

2004-07-05 Thread Michael Gale
two where separate. Any comments ... Michael. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Storing Date in mysql

2004-07-08 Thread Michael Gale
(`token_utuser_id`,`token_name`) ) TYPE=MyISAM; So in the token_date field I am storing the date in the following format from PHP: date("d/m/Y") which creates the following entry "05/07/2004" (example). I would like to know fro the list is ... is this the best way to store the da

Re: [PHP-DB] Storing Date in mysql

2004-07-08 Thread Michael Gale
Thanks ... I can't believe I missed that in the docs ... now I feel like knob. Michael. On Thu, 8 Jul 2004 14:17:38 -0300 "Pablo M. Rivas" <[EMAIL PROTECTED]> wrote: > Hello Michael, > token_date must be a DATE FIELD... > > http://dev.mysql.c

[PHP-DB] table locking ... not required ?

2004-07-08 Thread Michael Gale
multiple users tried to insert data at the same time. For the UPDATES ... what would have it in theory two people hit the UPDATE button at the exact same time ? Would one just over write the other ... cause that is fine ? So do you think I need to lock tables ? Michael. -- PHP Database Mailing

Re: [PHP-DB] table locking ... not required ?

2004-07-09 Thread Michael Gale
Yes .. it is ok - the data that I allow to get updated like this is not that important and when a update is made it would be two people entering the same data anyways. It is just for contact info for people in the db ... like there current phone or address if it changes. Michael. On Fri, 9

[PHP-DB] mysql auto increment

2004-07-12 Thread Michael Gale
, -- Michael Gale Network Administrator Utilitran Corporation -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Intellectual property rights

2004-08-09 Thread Michael Gale
decide to take this further ... which should not be to hard with the M$ people. Michael. On Mon, 9 Aug 2004 19:03:24 -0400 "Vincent Jordan" <[EMAIL PROTECTED]> wrote: > This is a bit off topic however it may be something people here have or > will have the unpleasant opportu

[PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread Michael Cortes
/replace/g). But I cannot get the ^M in the string. If I actually hit it reads as a return; if I type ^M using the shift-6 then it looks for the actual characters. Can anyone help? -- Michael Cortes Fort LeBoeuf School District 34 East Ninth Street PO Box 810 Waterford PA 16441-0810

Re: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread Michael Cortes
[filename], and you should be all set. > > -Mensaje original- > De: Michael Cortes [mailto:[EMAIL PROTECTED] > Enviado el: Thursday, August 19, 2004 1:36 PM > Para: [EMAIL PROTECTED] > Asunto: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB > > Howe

Re: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread Michael Cortes
return. Does anyone know what ctrl seqence is line feed? Thanks On Thursday 19 August 2004 09:49 am, Michael Cortes wrote: > That didn't work. Here's why. This is not a dos file. It is a unix file > but when dumping the data from my db, some fields had a trailing CR and LF. &g

[PHP-DB] mysql results with limit

2004-09-04 Thread Michael Gale
back AWAY from the computer, your geek rights have been revoked !!! Michael Gale Slackware user :) Bluesuperman.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql results with limit

2004-09-04 Thread Michael Gale
Excellent ... thanks that is exactly what I wanted. Michael. On Sat, 04 Sep 2004 20:21:46 -0600 Doug Thompson <[EMAIL PROTECTED]> wrote: > Michael Gale wrote: > > Hello, > > > > Right now I have a mysql select statement with the LIMIT option > > of 500

[PHP-DB] gdbm locking problem

2004-10-25 Thread Michael Jeung
ite lock on the file! (using dba_open) \n"; } Here is the problem: When I run Script 1 and then Script 2 (while Script 1 is running), both scripts claim to have a writer lock on research.db. This doesn't seem right. What am I missing? I'm running both of the scripts in t

Re: [PHP-DB] gdbm locking problem

2004-10-25 Thread Michael Jeung
roblem surfaces. I also tried using just the "wl" mode, with the same result. Is there any problem between the interaction of gdbm and php and FreeBSD? I am using php 4.3.8, and FreeBSD 4.10.1 Thanks! Michael Jeung -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] More help with restore server

2004-10-27 Thread Michael Cortes
-7.3.6.i386.rpm and I get "package php-devel-4.1.2-7.3.6 is already installed" so I rpm -q php and i get "php-4.1.2-7 Something seems obviously wrong. I f anyone has ideas, I would welcome them. -- Michael Cortes Fort LeBoeuf School District 34 East Ninth Street PO Box

[PHP-DB] Re: More help with restore server

2004-11-05 Thread Michael Cortes
just php/mysql) where I was able to solve a problem by skipping the rpm and just compiling from source. Has anyone else found this to be the case? On Wednesday 27 October 2004 02:42 pm, Michael Cortes wrote: > Here is another situation I find myself in. I did a rm -rf /var/* installe

[PHP-DB] Please point me in the right direction.......

2004-11-10 Thread Michael Cortes
oint me to the correct mailing list as I don't wish to start an inapropriate thread. Thank you. -- Michael Cortes Fort LeBoeuf School District 34 East Ninth Street PO Box 810 Waterford PA 16441-0810 814.796.4795 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: htt

[PHP-DB] multiple returned lob resource being overwritten in oci8

2004-11-15 Thread Michael Caplan
{ var_dump($message->load()); } with the output being: clob4 clob4 clob4 clob4 In this example the lob resources are overwritten when you loop through the result set the first time around, resulting in all fetched lobs returning the value of the last lob in the result set. The question is: is this an oci8 bug or just how things have to be done? Thanks, Michael

[PHP-DB] oci8 cannot connect after restarting DB

2004-11-16 Thread Michael Caplan
this be a non issue?) Thanks, Michael

RE: [PHP-DB] Re: oci8 cannot connect after restarting DB

2004-11-18 Thread Michael Caplan
with the fix sitting commented in the current code) or abandond the oci8 library all together for PDO when it hits the streets (which will be some time). Best, Michael -Original Message- From: John Lim [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 3:42 AM To: [EMAIL PROTECT

[PHP-DB] Re: Optimize Query Output

2004-11-20 Thread Michael Stassen
, ', P.FirstName) = @name, '', @name:= CONCAT(P.LastName, ', ', P.FirstName) ) AS 'Name', A.AttID, S.SessionDate, A.Present FROM Attendance A, Sessions S, Participants P WHERE S.SessionID = A.Session AND P.Part_ID = A.Participant ORDER BY P.LastName, P.FirstName, S.SessionDate; Michael -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: PHP vs ASP

2004-11-27 Thread Michael Gargiullo
On Sat, 2004-11-27 at 19:57 +0800, javagen wrote: > asp is not safe because asp only run in windows. > "Matthew Perry" <[EMAIL PROTECTED]> ÐÊ > news:[EMAIL PROTECTED] > > I need some ammo to convince my boss not to use ASP but use PHP instead. > > Appeal to his budget. php + mysql (Both will run on

[PHP-DB] Re: MySQL Error 1251 / phpMyAdmin

2005-02-07 Thread Michael Stassen
rrent mysql client library. See the manual for more <http://dev.mysql.com/doc/mysql/en/old-client.html>. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed er

[PHP-DB] Re: MySQL Error 1251 / phpMyAdmin

2005-02-07 Thread Michael Stassen
The short answer is, download the php source and add --with-mysql=/your/path/to/mysql to your build options. The long answer is in the directions in the php manual <http://us4.php.net/manual/en/install.unix.php>. Michael GH wrote: I am still new to the PHP scene could you tell me

Re: [PHP-DB] Pictures+MySQL+PHP

2002-01-26 Thread Michael Waples
Ck Raju wrote: > > that I changed my mind. Gurhan Ozen>Storing images in the database is not a > good idea , just store the path of Gurhan Ozen>the images in the database > and keep your images in your hard disk... Gurhan Ozen> > > Since everything is on hard-disk, I personally feel, the imag

Re: [PHP-DB] RE: ensuring unique field value in MySQL using PHP

2002-01-30 Thread Michael Waples
Dl Neil wrote: > > Janet, > > MySQL (and indeed all multi-user databases) has a feature called "Locking". What >this means is that whilst many > users/clients may access a database, apparently simultaneously, when one (or more) >is updating the data in some > way, everyone else is kept locked-

[PHP-DB] ODBC limit

2002-03-05 Thread Michael Dolan
I know you can do an SQL LIMIT 0, 30 on MySQL. Is there any way to do this kind of limit (i.e. select only the first 30 rows) on an Access database? I want to lower the overhead of having to select all the database rows only to show the first 30. Any help is appreciated. Thanks, Mike _

[PHP-DB] Looking for a good MySQL db abstraction layer

2002-03-08 Thread Michael Zornek
I'm looking for a good MySQL db abstraction layer. I'm just coming back to PHP/MySQL and rather writing my own I figured I'd try to see if any are already out there. The layer should obviously have the basics, of connect, query, and close, and possibly some error checking and handling. thanks,

  1   2   3   4   >