[PHP-DB] Performance question

2006-02-01 Thread Mathieu Dumoulin
tively fast without taking too much memory. This is my solution, how do you people see it without dumping everything to memory or by making recursive SQL calls (which will obviously slow everything down i'm pretty sure) Mathieu Dumoulin Programmer analyst in web solutions [EMAIL PROTECTED]

[PHP-DB] Re: Amount of characters a variable is able to contain

2006-02-01 Thread Mathieu Dumoulin
I'm not sure where you are heading with this, but here goes, if you want to keep lots of data in mysql (PHP should not truncate your data) just use a LONG TEXT or TEXT... If im not mistaken, TEXT take 2^16 characters, so approximately 4 million characters while LONG TEXTS can take several giga

[PHP-DB] Cannot execute php applications. Problems with required library mysql.so

2003-03-12 Thread Mathieu Dumoulin
ese options need to match in Unknown on line 0 PHP Warning: Unable to load dynamic library '/usr/lib/php4/mysql.so' - libmysqlclient.so.10: cannot open shared object file: No such file or directory in Unknown on line 0 === Please oh please, help me out on this

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread Mathieu Dumoulin
It is wrong to use that way of doing it John, cause this will delete ALL lines that where printed with a checkbox And also, if you are using a old version of PHP with register globals OFF, the _POST array will not be available Mathieu Dumoulin "1lt John W. Holmes" <[EMAIL PROTEC

[PHP-DB] Re: Checkboxes to gather rows to delete

2003-02-24 Thread Mathieu Dumoulin
$id } } The ${"id" . $id}is a way to get a variable by it's name even if you don't know it, all thats inside the {} are considered the variable name. Then check if that variable contains 1 or "". 1 meaning it was checked and "" meaning it wasn't Have

[PHP-DB] Re: Something is fishy in my selection

2003-02-06 Thread Mathieu Dumoulin
Oh crap, someone mailed me about having nulls in my field compared... you can no disregard this thread...its closed i got the culprit, it's a stupid NULL i found in a column Mathieu Dumoulin "Mathieu Dumoulin" <[EMAIL PROTECTED]> a écrit dans le message de news: [EMAIL PROT

[PHP-DB] Re: Something is fishy in my selection

2003-02-06 Thread Mathieu Dumoulin
n list: 6286 Not trimming and using not in list: 7 So no change... This seems to be a bug in mysql... Mathieu Dumoulin "Mathieu Dumoulin" <[EMAIL PROTECTED]> a écrit dans le message de news: [EMAIL PROTECTED] > Hi there, want to say this right off the start the calculations

[PHP-DB] Something is fishy in my selection

2003-02-06 Thread Mathieu Dumoulin
Hi there, want to say this right off the start the calculations here are used with the totals of the results and not the range so dont go telling me that i might have used a 0 based index, NO... I have 6294 lines in my table i query with a IN (...) statement and i get 6286 lines out of my DB i que

[PHP-DB] What is a mysql link ressource

2002-07-23 Thread Mathieu Dumoulin
Ok guys i got this problem here: I got a class i made that creates a link ressource for a mysql database. Stores it inside of itself with different login and password and other params. Other functions are also available for usage. When i start this class it connects fine, i can also use it no pr