Jump to content


Photo

Data truncated for column.......


  • Please log in to reply
23 replies to this topic

#21 Chetan

Chetan
  • Members
  • PipPipPip
  • Advanced Member
  • 162 posts
  • LocationIndia

Posted 14 August 2006 - 06:33 PM

You made it with NOT NULL remember, look at the code on the first page, it says fip is NOT NULL
I am a PHP Guru, ask me questions if you want to

#22 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 14 August 2006 - 07:02 PM

Well, your variables aren't interpolating.... I'm assuming that:

'VALUES ( "$fundname", "$starrating",'.

should be

'VALUES ( "'.$fundname.'", "'.$starrating.'",'.

If PHP is like Perl, nothing in single quotes will be ever be interpolated.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#23 Chetan

Chetan
  • Members
  • PipPipPip
  • Advanced Member
  • 162 posts
  • LocationIndia

Posted 15 August 2006 - 05:50 AM

Well that was done before~~, fenway, thats what I hav been saying and AndyB corrected it.
And did you think you had it NOT NULL as I said
I am a PHP Guru, ask me questions if you want to

#24 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 15 August 2006 - 01:54 PM

Sorry, I must have missed the second page of posts. ;-)

As for NOT NULL, assuming that fid is your PK column, don't even specify it in the column list, and you'll be fine.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users