Can I create something like this?

[Corinthian]

I asked support this directly, and just got a simple yes back. I need more then that.

I'm trying to create a web site similar to this one.

http://www.qatarsale.com/EnMain.aspx

Not only that, but I want the person I'm building the web site for to be able to easily update the records (for instance if a new car model becomes available, I want them to be able to add that to a drop down list by themselves). I also want the drop down lists to change based on the previous selection, for instance, if a user selects 'toyota' in a drop down list in the search, I want the next drop down list to list only toyota models.

The idea is I leave them with a web site that they can easily administer themselves without my help.

If all this is possible, where can I start tutorial-wise? I've tried using PHPMagic, and it's unfortunately turned out to be a pretty rubbish program, with even worse support. They told me I could use PHPMagic to do what I'm asking, but it turns out after I bought it, that you can't even come close to simply recreating what I'm after.

Sorry if this sounds very vague, but I'm really stuck. I want to be able to build a useable website that uses MYSQL. I need to know that alpha 5 can do it.

Thank you in advance for your advice.

[Pat Bremkamp]

Re: Can I create something like this?

Will,

That can certainly be done. Look as www.INeedWheels.com. I wrote that a couple years ago using V8. Now days, with V10 and an SQL backend, you can do even more and faster!

To see the photo in the datafield concept, look at www.dalharttxmls.com This is a V10 app using a dbf backend.

In both cases,the dealers and the realtors enter their own data and upload their own photos. Neither site has a webmaster.

Pat

[Corinthian]

Re: Can I create something like this?

Will,

That can certainly be done. Look as www.INeedWheels.com. I wrote that a couple years ago using V8. Now days, with V10 and an SQL backend, you can do even more and faster!

To see the photo in the datafield concept, look at www.dalharttxmls.com This is a V10 app using a dbf backend.

In both cases,the dealers and the realtors enter their own data and upload their own photos. Neither site has a webmaster.

Pat

Hi Pat,

Thank you!

I know this is a big ask, but what is the chance of me taking a look at the database structure for those? They're both exactly what I'm trying to achieve.

[Pat Bremkamp]

Re: Can I create something like this?

Will,

I'm happy to answer (best I can!) specific questions of general interest on the message board, but, as you suggested, this is too much to answer. My customers have paid me to develop these applications and it would not be appropriate for me to give them away.

Pat

[The Mage]

Re: Can I create something like this?

It has been suggested quite often on these boards to get the book Database Design for Mere Mortals. I picked up a used copy myself, and I believe it helped me design a better, more solid database.

[GGandhi]

Re: Can I create something like this?

Hello

I am using version 9/2095_3264/web design.
I am able to create a view and show all records in a grid. I am also able to design search various fields as shown by Pat. As you can see in Pat's design the car model is not filtered to show only the models limiting to the make such as BMW, the list lists all the models available regardless of the make. Selwyn video shows how to do cascading drop down but based on a dbf where all data is stored, not based on a view combinig few tables. Is it possible, I am sure it is, and where do I insert the filter command.


Thanks.

[GGandhi]

Re: Can I create something like this?

edit:

I have attached the sample database zip file.

[Corinthian]

Re: Can I create something like this?

Will,

I'm happy to answer (best I can!) specific questions of general interest on the message board, but, as you suggested, this is too much to answer. My customers have paid me to develop these applications and it would not be appropriate for me to give them away.

Pat

I understand, I'd probably do the same. ;)

[Corinthian]

Re: Can I create something like this?

It has been suggested quite often on these boards to get the book Database Design for Mere Mortals. I picked up a used copy myself, and I believe it helped me design a better, more solid database.

Thank you Mage, I will have a look at that. :)

[Corinthian]

Re: Can I create something like this?

edit:

I have attached the sample database zip file.

Thank you so much GGhandhi! This is exacty what I'm trying to achieve. That's really very kind of you. :)