presario

I have worked in some applications like oscommerce, wordpress. I have developed my own cms which is basically a product management system. I installed wordpress other day and amazed to see that they managed such an application with just 11 tables (talking about default installation). The installation of setup, skinning a new template, adding new plugin all are just a matter of few clicks. We develop product based websites so most of the time, our backend application is same. All we have to do is just loading a new skin to it. To convert a product management system into a shopping cart, all we have to do is just add checkout routine but currently all things are so messed up that we often have to perform repetitive tasks. Having a all that, I would like to have some expert advice on how can I program effectively that editing previous or addition of new features in application would not be that much hectic

keith, have you reviewed attached database? I'll modify database and then show you again. There is another thing about contact which I want to keep record is communication history. anyway, let me modify database. Then, I'll show you! Thanks for your time!

Thanks for the info. I'll revise my database structure and will discuss further. As I'll incorporate project, accounts, employees, lead management in this same application, I think It is much better to spend good amount of time in designing database? What do you say? Anyone willing to discuss this project or willing to suggest me throughout whole phase of development? Someone, I can communicate on IMs or PM?

I am sorry I am not getting you :-( What I decided was to use table joins to fetch all records relevant to a particular contact_id but in your suggested way, would not I have redundant information? I want to store each and every information of my contact. Number of phones/emails/urls/faxes he has. How we find him? Is he a prospect or customer or friend or an employee? When he was added in database? who referred him? how many prospect he has referred to us? how many times have to approached him and by which medium? Among all, there would be some default valuables which will be displayed at first and when we'll take details information of a contact, it would display all the information. I am attached database table print for you to review. Take your time to suggest me something. Thanks for your time [attachment deleted by admin]

I am new into php. I have developed a few applications. The biggest advantage of using framework as it appears to me is that it save you a lot of development time? I would like to have some recommendation for using framework with strong reasons. 1.) Which framework is better and why? 2.) Using a framework would limit my development skills to that particular framework? 3.) Should I spend some handsome time in developing real php applications before moving to a framework?

thanks for your quick response. I want to keep record of as many phone numbers/emails/faxes/urls/ as my contact would have. With your scheme, I could only store one phone number/email/fax/url against each contact? whereas in my situation, my one contact has many companies, phone numbers, faxes, emails, urls and I want to track them all

I am designing a contact management application. I have one contact who has many companies, many phone numbers, many emails and many urls. I designed database in this way:- 1.) There is one base table tbl_contacts. Its fields are:- contact_id, contact_name, contact_designation, type 2.) There is one separate table for separate information to store like tbl_companies, tbl_phones, tbl_emails tbl_companies - contact_id, co_id, co_name, default tbl_phones - contact_id, phone_id, phone, default tbl_emails - contact_id, email_id, email, default Am I in right direction?

More over, I want to design application which is somewhat similar to contact management system. Can anyone give me time to discuss it in pvt or by email?

As stated above, I have an application which is very well optimized and very well understood by us. As much as I know, It is a flat database design. I mean, I have one table to store a type of information. Like to store main categories, we have tbl_main....to store sub categories, we have tbl_sections...to store product related information, we have tbl_prods. I don't think Its a relational database design. I now want to add options to add information for different languages. I hope I have explained it well.