troubleshooting Question

How do I create a MySQL database & create simple Queries?

Avatar of scotia2k11
scotia2k11Flag for United Kingdom of Great Britain and Northern Ireland asked on
MySQL Server
48 Comments8 Solutions330 ViewsLast Modified:
Hello experts - hope you are well. I need to understand how to create a (I hope) simple database & basic funtionality for part of my uni course.  

I have never created anything in MySQL & since I have already missed the hand in date & will be capped, Im really struggling to get my head into it.

Bascially Ive to create a demo-website where users can see the current trading prices of a commodity & its locations. Results need to be able to be filtered by single geographical location & multiple & be able to sort from most to least expensive - we were given this example site for reference, but I dont understand it -

I have taken the infomation we were given in a PHP file & dropped it into a table on my webserver, (I also have wamp installed locally) & Ive created some basic pages to use as the website, but apart from that Ive no funcitonality & dont know where to start.

Sorry to seem so stupid, flash animaiton is more my thing & Im really really struggling to pass this module.

Many thanks, scotia
Join our community to see this answer!
Unlock 8 Answers and 48 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 8 Answers and 48 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros