ulenie

[quote author=the_oliver link=topic=115807.msg471645#msg471645 date=1164149856] Are this charictors being typed as plain text or using the html number equivelent? If your just typing ® or anything slightly unusual like it thry using the html number equivelent. eg ® can be writen as [code]®[/code] Let me know if that works. [/quote] No, I actually download the csv from a site and its in plain text.  Anyways, i moved the file back to the sub-domian, like how it was and its working nicely.  I don't see how being a subdomain affects this but I guess I will keep it there, until I figure it out.

Ok, I have a csv parser file that parses the csv I put into a text box and stores it in a database.  I has been working nicely until yesterday, when I moved it from a sub-domain folder to the root folder.  I can't really see how that is causing the problem but what its doing is when ever it inputs a field from the csv that is called "Campaign" in to the database it keeps inputing this weird "Â" character in front of characters like "® ", "¢", "™" and other not every day characters.  So this is what it would do:  It stores "SunRocket® VoIP + Free Cordless Phones" instead of "SunRocket® VoIP + Free Cordless Phones".  I never touched the database structure, and this is how the campaign row is set up:    `name` varchar(255) NOT NULL default '',.  Does anyone know why its doing that?

[quote author=hvle link=topic=101323.msg400942#msg400942 date=1153448533] If you received error, post the whole error message. [/quote] It worked perfectly and was very easy to understand.  Thanks much.

[quote author=hvle link=topic=101323.msg400935#msg400935 date=1153446870] first of all, I suggested you should revise the query for viewing friendly.  After all, you're human. So what u wanted is along with inserting subid, ref, you'd like to insert name and paid with it. here is the code: [code] $sql = "insert into stats (subid,ref,name,paid) values     ('{$_POST['email']}',     '{$_REQUEST['ref']}',     'Registration Bonus',     '1.00')"; [/code] [/quote] Sorry, I didn't write the code.  When I looked at it, i thought the same thing.  That's why i couldnt figure it out.  I tried to do similar to what you wrote but it gave me an error.  Let me try exatly what you wrote.  Thanks.

The current code is $sql = 'INSERT INTO stats (subid,ref) VALUES (\''.$_POST['email'].'\',\''.$_REQUEST['ref'].'\')'; What i want to do is insert a "name" and "paid" column.  And I want to set name to 'Registration Bonus' and paid to '1.00'.  The table and everything is already created.  Someone help me please!