Google Answers Logo
View Question
 
Q: PHP output of two simple databases ( No Answer,   0 Comments )
Question  
Subject: PHP output of two simple databases
Category: Computers > Programming
Asked by: lunarexpress-ga
List Price: $2.00
Posted: 24 Aug 2005 13:03 PDT
Expires: 27 Aug 2005 22:26 PDT
Question ID: 559878
Who will do this for less than $100?


I have a database with a project tracking table and a contact table that I need
to output to two seperate formatted pages with "sort", "search", with a login
and a welcome page to select contacts or projects pages from.

"edit", and "add" functions. All users may view "all" or "user1" "user2" etc..
Users may add anyting but only edit entries they created.

"Contacts" should not be user editable period. updates will be
performed using a db manager or on
the cli.
 
PHP/MySQL scheme preffered, although any programming type is acceptable. 
Concise simple code only, no fluff or complex operations please.







Project Tracking should use css and tables, no graphics neccesary,
only color coding of rows (which should be setup in css but left blank
for my customization)
It should be arranged as follows with the status field being a
different color for different status levels (there being 4 total).
"sort" by status +/- user +/- either date field.

------------------------------------------------------------------------------
User      Jeff
Status 	  Post-Bid
Name 	  Classroom Addition Westside High School
Date Bid  8/3/2005
Contacted 8/17/2005
Bidders    [co. name and ph1 and fax1] from contact table
           [co. name and ph1 and fax1] from contact table
           [co. name and ph1 and fax1] from contact table
           [co. name and ph1 and fax1] from contact table
           [co. name and ph1 and fax1] from contact table
           [co. name and ph1 and fax1] from contact table
           etc, as many as neccessary

Contractor [Co. Name, selectable by a drop down box related to the contact table]

Items 	  H20=9.6k, Ampco=4.8k, HT=2k,  NEBB=9k Starters=5k

Notes 	  Rock said the low H20 was $3,900, Dennis TAB was $5700, high on stack,    
          low on starters and VFDs. 
          Try Calling Lowery in one week to follow-up
          Blah Blah Blah

Files: upload button to add files to be related to this project
------------------------------------------------------------------------------






Contact Databse should use css and tables as well, no graphics
neccesary, only color coding of rows.
I would like the Colors of each entry to alternate, set this up in
CSS, but leave it blank and I will fill in as needed later.
I would also like <br><hr><br> betwen each entry as well. 
A "show only" option which shows specific state name and associated
region (selectable from a drop down box or hyperlink) is required.
Entry on drop down box or hyperlink would be State"-"Region

------------------------------------------------------------------------------
Region

Name                  area-code+phone1  area-code+Fax1    contactname1 c1notes
Streetaddr.           area-codephone2  area-code+Fax2     contactname2 c1notes
city, State zip       area-codephone3  area-code+Fax3     contactname3 c1notes
                      area-codephone4  area-code+Fax4     contactname4 c1notes
POaddress             area-codephone5  area-code+Fax5     contactname5 c1notes
city, state zip       area-codephone6  area-code+Fax6     contactname6 c1notes
                      area-codephone7  area-code+Fax7     contactname7 c1notes

notes:  varchar 255
project: [insert "user" "status" and "name"] from project table if this contractor
is listed as THE contractor in the project table
--------------------------------------------------------------------------------
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy