Re: [PHP-DB] Importing CSV files to MySql Db issue.

Chris Carter wrote: I am not using spaces for closing. Every field is tightly packed with comma only. No spaces, no semicolon. The reason I used space is if I use space at least 3 or 4 fields get uploaded but not all. But we can ignore space for now as it happened earlier. Then your issue will

Re: [PHP-DB] Importing CSV files to MySql Db issue.

I am not using spaces for closing. Every field is tightly packed with comma only. No spaces, no semicolon. The reason I used space is if I use space at least 3 or 4 fields get uploaded but not all. But we can ignore space for now as it happened earlier. I am using the CSV import option from MySql

Re: [PHP-DB] Importing CSV files to MySql Db issue.

Gary Wardell wrote: Chris, If you're using spaces for enclosing then I'm sure you're not handling something properly. Chris,Carter,[EMAIL PROTECTED] <-- 3 records Chris Carter,[EMAIL PROTECTED] <-- 2 records Don't you mean: Chris,Carter,[EMAIL PROTECTED] <-- 3 *fields* Chris Carter,[EM

RE: [PHP-DB] Importing CSV files to MySql Db issue.

Chris, > If you're using spaces for enclosing then I'm sure you're not > handling > something properly. > > Chris,Carter,[EMAIL PROTECTED] <-- 3 records > Chris Carter,[EMAIL PROTECTED] <-- 2 records > Don't you mean: Chris,Carter,[EMAIL PROTECTED] <-- 3 *fields* Chris Carter,[EMAIL PROTEC

Re: [PHP-DB] Help with MySql float

Daniel Brown wrote: On Feb 17, 2008 10:59 AM, Velen <[EMAIL PROTECTED]> 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 numb

Re: [PHP-DB] Importing CSV files to MySql Db issue.

Chris Carter wrote: Is there something that has changed in the new MySql DB ? What new mysql? Has your host upgraded your database version or something? Mysql won't change the interface between versions except to improve it. I am trying to upload a data like this from my CSV file to a table

Re: [PHP-DB] Help with MySql float

On Feb 17, 2008 10:59 AM, Velen <[EMAIL PROTECTED]> 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

Re: [PHP-DB] Password decryption

On Feb 16, 2008 10:17 PM, Nasreen Laghari <[EMAIL PROTECTED]> wrote: > Hi, > > I'm junior in PHP and stuck on Encryption. > > I have encrypted password using SQL : > > $query = "insert into user (userid,password,) values > ('$username',Password('$pass'));"; It's a one-way encryption method, s

Re: [PHP-DB] Help with MySql float

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 qu

[PHP-DB] Help with MySql float

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 -- PHP Database Mailing List (http://ww

Re: [PHP-DB] Password decryption

Nasreen Laghari wrote: > Hi, > > I'm junior in PHP and stuck on Encryption. > > I have encrypted password using SQL : > > $query = "insert into user (userid,password,) values > ('$username',Password('$pass'));"; > > Which is working perfect. Now I'm working on Login page where I have to

RE: [PHP-DB] Password decryption

Hi, Note from the manual: PASSWORD() encryption is one-way (not reversible). Also note: === Note The PASSWORD() function is used by the authentication system in MySQL Server; you should not use it in your own applications. For that pu