[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

[PHP-DB] Performance question

2006-02-01 Thread Mathieu Dumoulin
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 Database Mailing List (http://www.php.net

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

2003-03-12 Thread Mathieu Dumoulin
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 Mathieu Dumoulin

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

2003-02-24 Thread Mathieu Dumoulin
, the id to to delete is in $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 a nice day Mathieu

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 PROTECTED] a écrit dans le

[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

[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 PROTECTED] More info

[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