Re: [PHP-DB] Subject Matter

2013-08-27 Thread Matijn Woudt
Op 27 aug. 2013 18:06 schreef "Daniel Brown" het volgende: > > On Fri, Aug 23, 2013 at 4:21 AM, Matijn Woudt wrote: > > > > The problem is: there is no maintainer;) > > Sure there is. > > -- > > Network Infrastructure Manager > http://www.php.net/ Uh, you're right. I meant moderator..

Re: [PHP-DB] Subject Matter

2013-08-23 Thread Matijn Woudt
On Fri, Aug 23, 2013 at 10:15 AM, Matt Pelmear wrote: > Hello all, > > I am subscribed to this list because of my interest in PHP's database > integration. At this point only a small percentage of the messages are > related to that. > > I am not sure who runs the list, whether they care about off

Re: [PHP-DB] oncurrence problem with PEAR:MDB2 + msqli driver in forked CLI environment

2013-07-04 Thread Matijn Woudt
On Thu, Jul 4, 2013 at 6:09 PM, Toni Moreno wrote: > Hi. > > I have a found a very strange and big "concurrence" problem after develop a > CLI tool which parallelizes data processing by using "pcntrl_fork", ( If > we run the same executions sequentially the result is correct) > > The trouble a

Re: [PHP-DB] Problem with query

2013-06-23 Thread Matijn Woudt
On Sun, Jun 23, 2013 at 8:31 PM, Ethan Rosenberg, PhD < erosenb...@hygeiabiomedical.com> wrote: > Dear List - > > There is an error in my query, and I cannot find it. > > This fails: > > $_SESSION['Cust_Num'] = $_REQUEST['cnum']; > $_SESSION['CustNum'] = $_REQUEST['cnum']; > > echo "session"; //th

Re: [PHP-DB] excec / query on Sqlite3

2013-05-20 Thread Matijn Woudt
On Mon, May 20, 2013 at 2:35 PM, Gilles wrote: > Hello, > > I'm not sure if it's a bug : > > $o_sqlite3=new SQLite3('test.sqlite'); > > $r=$o_sqlite3->exec(''); > echo'';var_dump($r);echo'**'; // bool(true) > > $r=$o_sqlite3->query(''); > echo'';var_dump($r);echo'**'; // bool(false) > > $r=$o_sq

Re: [PHP-DB] Probleme upper accents

2013-04-05 Thread Matijn Woudt
On Fri, Apr 5, 2013 at 3:19 PM, Toby Hart Dyke wrote: > > It looks similar to this bug: > http://bugs.php.net/bug.php?**id=54379- > possibly fixed in a later version? Your PHP is pretty elderly. > > Toby > > > I would suggest to upgrade the full system. L

Re: [PHP-DB] My Comments

2013-02-21 Thread Matijn Woudt
On Thu, Feb 21, 2013 at 10:08 PM, Ethan Rosenberg, PhD < erosenb...@hygeiabiomedical.com> wrote: > > Dear List - > > I feel, and correct me if I am wrong, that a list as this or similar, > should be devoted to help and not sarcasm. I try to be quiet and to not > "toot my horn", but as events have

Re: [PHP-DB] Firebird return wrong value

2013-01-18 Thread Matijn Woudt
On Fri, Jan 18, 2013 at 12:49 PM, wrote: > Dear List! > > i have a strange problem. > > I have a Firebird database (dialect 3). Firebird server: 2.0.6 > I create a table, and insert a row like that: > CREATE TABLE PRICE ( > ID INTEGER NOT NULL, > "NAME" VARCHAR(10), > COST NUMERIC(15, 2));

Re: [PHP-DB] mysqldump

2013-01-01 Thread Matijn Woudt
On Wed, Jan 2, 2013 at 12:50 AM, Ethan Rosenberg, PhD < erosenb...@hygeiabiomedical.com> wrote: > Dear List - > > I am using the following command: > > mysqldump -u root -p Store > StoreBkup.sql; > > to backup the database called Store. > > Mysql insists on giving a syntax error. > > Advice and h

Re: [PHP-DB] Program Dies

2012-10-14 Thread Matijn Woudt
On Sun, Oct 14, 2012 at 11:57 PM, Ethan Rosenberg, PhD wrote: > Dear List - > > Thank you ever so much for all your help. > > I apologize in advance for dumping all this code on you. I cannot get any > debugger to work for me [see my separate email on debuggers]. I placed > numerous echo and pri

Re: [PHP-DB] opening error messages in a new window

2012-09-26 Thread Matijn Woudt
On Wed, Sep 26, 2012 at 10:41 AM, Dr Vijay Kumar wrote: > In filling a form, error messages should come in a new widow while > retaining the form filled on the screen. Coding in php is required. > > -- PHP can't do anything 'onscreen'. If you want to do anything onscreen, you need to use javascr

Re: [PHP-DB] Prepared Statements Insert Problem - Any more ideas?

2012-09-02 Thread Matijn Woudt
On Sun, Sep 2, 2012 at 10:41 PM, Ethan Rosenberg, PhD wrote: > On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD > wrote: >> >> Dear List - >> >> I wish to accomplish the following with prepared statements: >> >> $stmt = mysqli_stmt_init($cxn); >> if($stmt = mysqli_stmt_prepare($stmt, "

Re: [PHP-DB] Prepared Statements Insert Problem

2012-09-02 Thread Matijn Woudt
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD wrote: > Dear List - > > I wish to accomplish the following with prepared statements: > > $stmt = mysqli_stmt_init($cxn); > if($stmt = mysqli_stmt_prepare($stmt, "INSERT INTO Intake3 (Site, > MedRec, Fname, Lname, Phone, Height, Sex, Hx,

Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-25 Thread Matijn Woudt
On Wed, Jul 25, 2012 at 12:21 PM, Tamara Temple wrote: > Brad wrote: >> Here is where everything stands.. L >> >> http://pastie.org/4317155 > > I feel strange bottom posting, somehow, BUT THAT'S THE RULE It makes each individual message readable in a human readable order. That's why. > > You

Re: [PHP-DB] SQL omit record if ever had value set

2012-06-18 Thread Matijn Woudt
On Mon, Jun 18, 2012 at 11:56 PM, Dee Ayy wrote: > I would like a query that lists records where a column has not taken > on a specific value when grouped by another column. > > N  V > n1 v1 > n1 v2 > n2 v1 > n2 v2 > n2 v3 > n3 v1 > > If v3 has ever been set for N, do not list N.  So the result wo

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Matijn Woudt
On Sun, Jun 17, 2012 at 10:21 PM, Jim Giner wrote: > > "Ethan Rosenberg" wrote in message > news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... >> At 03:30 PM 6/17/2012, Jim Giner wrote: >>>"Ethan Rosenberg" wrote in message >>>news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... >>> > Dear List - >>> >

Re: [PHP-DB] ERROR W/ SQLSRV, PHP 5.4 & SYMFONY!!!

2012-06-07 Thread Matijn Woudt
On Thu, Jun 7, 2012 at 7:42 AM, OJFR wrote: > HI, > > OSAIN. > > Hi, You might want to read the PHP mailing list rules[1] and RFC 1855[2] before posting to this mailing list again. - Matijn [1] http://www.php.net/reST/php-src/trunk_README.MAILINGLIST_RULES [2] http://www.faqs.org/rfcs/rfc1855

Re: [PHP-DB] Mysterious 5 second delay on sybase_connect()

2012-05-24 Thread Matijn Woudt
On Thu, May 24, 2012 at 10:51 AM, Tom Lloyd wrote: > Hi there.  I'm working on a PHP-driven project on Debian Squeeze that > connects to an instance of Microsoft SQL Server on Windows Server 2008. > I'm using the sybase extensions to PHP. > > Since I rebooted the webserver on the weekend, both the

Re: [PHP-DB] Multiple Database Connection Using Prepard Statements

2012-05-19 Thread Matijn Woudt
On Sat, May 19, 2012 at 8:36 PM, Ron Piggott wrote: > > How do I connect to multiple mySQL databases using Prepared Statements ? > > I have the syntax > > === > $dsh = 'mysql:host=localhost;dbname='.$database3; > $dbh = new PDO($dsh, $username, $password); > === > > I want to connect to $database1

[PHP-DB] Re: [PHP] PHP & Database Problems -- Code Snippets

2012-05-05 Thread Matijn Woudt
On Thu, May 3, 2012 at 4:20 PM, Ethan Rosenberg wrote: > At 06:47 PM 5/2/2012, Matijn Woudt wrote: >> >> On Wed, May 2, 2012 at 11:43 PM, Ethan Rosenberg >> wrote: > Dear list - > > Sorry for the attachment. Â Here are code snippets >> --- Ethan, I don't

[PHP-DB] Re: [PHP] PHP & Database Problems -- Code Snippets

2012-05-02 Thread Matijn Woudt
On Wed, May 2, 2012 at 11:43 PM, Ethan Rosenberg wrote: > Dear list - > > Sorry for the attachment.  Here are code snippets --- Ethan, I don't want to sound rude, but it appears to me you don't have any understanding of what you're doing. It might help if you understand what the code is doing...

Re: [PHP-DB] Engine?

2012-04-16 Thread Matijn Woudt
On Mon, Apr 16, 2012 at 1:09 PM, Bastien wrote: > > > Bastien Koert > > On 2012-04-16, at 2:21 AM, Karl DeSaulniers wrote: > >> On Apr 15, 2012, at 9:29 PM, Vinay Kannan wrote: >> >>> Hello, >>> >>> I've always been left wondering what Engine to use while creating tables, >>> I've read quite a fe

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Matijn Woudt
On Fri, Mar 30, 2012 at 7:49 PM, Jim Giner wrote: > > ""Jim Giner"" wrote in message > news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2... >> === >> Martijn & Jim - >> >> Is it just the date that is the problem? >> >> Yes. >> >> Tru dat.  But mySql doesn't want the dashes embedded.  The

Re: [PHP-DB] search of data base - again

2012-03-29 Thread Matijn Woudt
On Fri, Mar 30, 2012 at 1:10 AM, Ethan Rosenberg wrote: > Sending again, since no response on 1st try. > > Ethan > == > Dear List > > I am trying to insert data into a table, with no success. > > I have two tables: > > mysql> describe Visit3; > ++--+--+-

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 4:53 PM, Gu®u wrote: > No Michael, your code is also not working. What you have understood is > correct. let me explain it to others too. > > If variable twitter and facebook are empty don't echo anything, > > if variable twitter has a value and facebook is empty echo out o

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 3:06 PM, Gu®u wrote: > The issue is both the images are echoing and no if else statement is > working. > First of all, please bottom post on this (and probably any) mailing list. You should perhaps provide what the contents of $search->plugin->ListViewValue()=="" and $sea

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 1:03 PM, Gu®u wrote: > Hi, > > Please help me with this code. I have 2 different fields in mysql table. > What I want is if the field is empty don't show the image. Please look at > the code below. I have looked at it. Maybe you should tell what is wrong, what it outputs

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Matijn Woudt
On Wed, Feb 29, 2012 at 3:01 PM, Kranthi Krishna wrote: > Hi all, > > Say I have an object like > > array >    schoolName => string >    board => array >         string >         string > > I generally create  two MySql tables > > schools: id PRIMARY KEY, SchoolName > boards: id FOREGIN KEY refers

Re: [PHP-DB] Subscription Suspensions

2012-01-31 Thread Matijn Woudt
On Tue, Jan 31, 2012 at 6:35 PM, Ron Piggott wrote: > > Hi Everyone. > > I manage an e-mail list.  I am trying to add a new function into it: > suspensions.  The idea is that someone wouldn’t have to unsubscribe.  Instead > there would be a record of their suspension in the table > member_subsc

Re: [PHP-DB] php & adodb book suggestins

2012-01-26 Thread Matijn Woudt
On Thu, Jan 26, 2012 at 12:06 PM, David McGlone wrote: > On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: >> David McGlone wrote: >> > can anyone suggest any good up to date books out there on php&  adodb. > >> The only documentation on ADOdb is the website >> http://adodb.sourceforge.net/#d

Re: [PHP-DB] Multiple Access to Database

2012-01-17 Thread Matijn Woudt
Ethan, you've send the same question a few days ago. There's no point in asking the same question twice. Matijn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Set Mssql Application name in connection string

2011-12-13 Thread Matijn Woudt
On Tue, Dec 13, 2011 at 10:58 PM, Dan Rowe wrote: > Hey Matijn, > > Thanks for the tip. We did send it there the day we submitted it, so its > good to know we were on the right track. Unfortunately it didn't gain any > traction or any status updates on the bug tracker. > > Figured I would send to

Re: [PHP-DB] Set Mssql Application name in connection string

2011-12-13 Thread Matijn Woudt
On Tue, Dec 13, 2011 at 1:33 PM, Dan Rowe wrote: > We needed to be able to set the application name in a mssql connection > string, but php doesn't current toy support it. > > This can be very helpful while debugging/profiling php-mssql from the SQL > server side of things. > > Without this patch

Re: [PHP-DB] Prepared Statements

2011-11-11 Thread Matijn Woudt
On Fri, Nov 11, 2011 at 5:41 PM, Ron Piggott wrote: > > I have two questions about Prepared Statements from the code below: > > #1: > The purpose of the first $query is to determine if the authorization code > supplied is both accurate and also live > - When the authorization code is generated it

Re: [PHP-DB] Exporting mySQL to Excel

2011-11-09 Thread Matijn Woudt
On Thu, Nov 10, 2011 at 12:32 AM, Ron Piggott wrote: > > I am wondering how phpmyadmin makes Excel files "on the fly" --- Is it a > class? > They used PHPExcel in the past, but they had to remove because of license issues. Don't know what they're currently using, but if you can live with LGPL, PH