• 0

[PHP] Need Help with MySQL Query


Question

Hi Everyone,

I've googled, i've used books, but no matter how hard I try the only thing I can find is how to print the entire contents of a MySQL table. What I need to do is query the database, and select specific entries. I'm making an inventory database for all the computers for the car dealerships that I work for, and have a selection page that allows you to chose which dealership you want to view the inventory for. I've been able to add things to the database without an issue, it's just that picking out those individual entries that I can't do. Any help you guys could provide, whether it be code, or links to sites that can help would be greatly appreciated!!!

Thanks,

Mike

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

What you require is a statement along these lines:

SELECT dealership, address, phone
FROM dealership
WHERE location = 'liverpool'

It's just a small example, but I think it'll help with what you asked :)

This will give a better explanation.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.