MySQL Help Needed. Newbie. Please Help?

Bizza · 03-12-2010, 06:26 AM

I recently tried to upload my CSV excel file into the MySQL database (everything was exactly in order and matched to a tee), but it failed. I then asked my host to help and they uploaded it for me. I don't know exactly why the CSV doesn't work from MyphpAdmin but my host said I could if I knew about SSH??? I didn't know it was that difficult?

Now that they have done this for me, I just wanted to ask:
1. How do I query the data in the db from a webpage?
2. How do I enter new data into the db from here on?

Any help would be so appreciated. I'm a total noob when it comes to databases, but an expert in Excel. I really want to learn the basics of database construction and php development. If anyone has any ideas or can link me in the right direction, that would be awesome.
????: NamePros.com http://www.namepros.com/programming/644494-mysql-help-needed-newbie-please-help.html

Thanks gang!

nasaboy007 · 03-12-2010, 09:56 AM

PHP/MySQL Tutorial - Part 1 should give you the basics of reading/writing to your database using PHP.

It's really straightforward, and once you get the hang of it, you'll be a pro.

Bizza · 03-12-2010, 10:40 AM

NasaBoy, thank you so very much. That is one of the best links I've received for a long time. Cheers mate!

03-12-2010, 06:26 AM	THREAD STARTER #1 (permalink)
Bizza NamePros Regular Join Date: Jun 2005 Location: Australia Posts: 203	MySQL Help Needed. Newbie. Please Help? I recently tried to upload my CSV excel file into the MySQL database (everything was exactly in order and matched to a tee), but it failed. I then asked my host to help and they uploaded it for me. I don't know exactly why the CSV doesn't work from MyphpAdmin but my host said I could if I knew about SSH??? I didn't know it was that difficult? Now that they have done this for me, I just wanted to ask: 1. How do I query the data in the db from a webpage? 2. How do I enter new data into the db from here on? Any help would be so appreciated. I'm a total noob when it comes to databases, but an expert in Excel. I really want to learn the basics of database construction and php development. If anyone has any ideas or can link me in the right direction, that would be awesome. ????: NamePros.com http://www.namepros.com/programming/644494-mysql-help-needed-newbie-please-help.html Thanks gang!

03-12-2010, 09:56 AM	#2 (permalink)
nasaboy007 Senior Member Join Date: Jul 2005 Location: NJ Posts: 1,219	PHP/MySQL Tutorial - Part 1 should give you the basics of reading/writing to your database using PHP. It's really straightforward, and once you get the hang of it, you'll be a pro. __________________ Hacksar.com - Your source for random computer tips and tricks! MySiteMemberships.com - Keep track of your site registration information! Like my post? Rep is appreciated!

03-12-2010, 10:40 AM	THREAD STARTER #3 (permalink)
Bizza NamePros Regular Join Date: Jun 2005 Location: Australia Posts: 203	NasaBoy, thank you so very much. That is one of the best links I've received for a long time. Cheers mate!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)