Re: [PHP-DB] PHP, MySQL and Lookups

2008-02-27 Thread Tobias Franzén
Daniel Brown wrote: On Tue, Feb 26, 2008 at 8:55 AM, Henry Felton [EMAIL PROTECTED] wrote: Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the

Re: [PHP-DB] Help with MySql float

2008-02-17 Thread Tobias Franzén
Velen wrote: Hi Guys, When inserting a value like 123567.8956 in my table it is rounding it to 2 decimal place. The field type is set as float. Can anyone tell me why it's not taking all the decimals? and How to insert the number with all the decimals? Thanks Velen Hello Velen, Your

Re: [PHP-DB] independent session data for multiple browser windows

2008-02-16 Thread Tobias Franzén
Charles Whitaker wrote: Greetings, I have a nearly-completed accounts/billing database using PHP and MySQL, and was just informed that users will want to access the database via multiple windows in one browser on the same machine, so I'm looking for a way to have each browser window have its

Re: [PHP-DB] Mysqli returning result set from a function to calling script

2008-02-09 Thread Tobias Franzén
Hi Radek, Are you looking for something like the fetchAll function? http://php.net/manual/en/function.PDOStatement-fetchAll.php /Tobias Radek Zajkowski wrote: Hi all, we've trying to write a wrapper class that would execute a prepared statement and return obtained dataset/resultset to the

Re: [PHP-DB] Formatting in Text Area

2008-02-01 Thread Tobias Franzén
Hi Patricia, You can impose width restrictions on the textarea field and forcefully wrap lines longer than the desired length afterwards (if you save it, save it as-is for better portability). To wrap text with PHP when you print it, or want to send the e-mail, there is a function called

[PHP-DB] MySQLi and SSL in FreeBSD

2008-01-12 Thread Tobias Franzén
Hi. I'm trying to secure the connections to my MySQL server, since the MySQL server and most clients are on separate machines. I'm running a few FreeBSD 5.5 machines under VMware Server 1.0.4. I wrote a simple test script (I also tried it using the full mysqli_* functions): ?php $link =