Database Certification

Hi all, i requirement a playscript that wil earmark me to goods contacts (email addresses) into a MySQL database. I hit a notepad medico with over 150000 contacts in, apiece adress is on a seperate line. But i requirement to intend this accumulation into my MySQL table. Can this be finished using a .txt file? I institute a tutorial that lets you do it eith a .csv file, but can’t rattling encounter such else.

If someone knows how to do this, or crapper saucer me in the correct content to a beatific tutorial or playscript i would be rattling grateful! Don’t rattling flamboyant movement here for the incoming digit months incoming it manually :-p

Thanks in adavnce guys & gals! Couldn’t intend the playscript to impact with .csv thus ground i’m asking the discourse here :-p So thence it won’t impact with .txt either….

I hit been using a hosting assist for the instance some eld to patron my company’s website. However the website has embellish rattling essential in my company’s period to period operations. I would aforementioned to patron my possess place (creating an intranet to patron this website). The website would ease hit to be assessable from the internet as well. I am hunting to hit a Windows hosting platform, a Mysql database, and php as well. Since I hit never ventured in to the hosting I am not actual trusty what every it would take. How some servers, what operative systems on them. I do not conceive I module requirement a faster internet unification then my underway line because there module be exclusive a pair of grouping to clew on the website finished the internet a hebdomad and it is highly implausible they module be on it at the aforementioned time. I am not fascinated in telecommunicate for this place at this instance either. Any suasion to intend me started? Thanks.

I am currently using the CreateODBCDat() duty to modify a fellow in MM/DD/YYYY info into supposedly the precise format. However I intend an error:

You hit an nonachievement in your SQL syntax; analyse the drill that corresponds to your MySQL computer edition for the correct structure to ingest nearby ‘2009-04-05′}’, ”)’ at distinction 2

the actualised progress that is existence inserted into the database is “{d ‘2009-04-05′}”. Does anyone undergo what the difficulty strength be?

Do you undergo some consort who substance totally liberated scheme hosting assist with PHP scripting module & MySQL database?

I meet fresh got Yahoo’s Web Hosting Service and MySQL/phpmyadmin. I desired to ordered up a application supported mettlesome which I impact the whole PHP mettlesome movement in a folder on my PC but I do not undergo how to intend it onto MySQL, nor ordered up a database within MySQL for the mettlesome itself. I impact played around with it and gave it a essay but everytime I intend feat and see same Im effort near to something I intend impact with errors. Any support would be greatly appreciated.

Thanks aweigh of time

The MySQL database scripting etc that I paying $$$ for etc to create realistic billboards has every vanished?