Hi
Can someone help with few MySQL query's:
- From page ESTIMATES I want to click button "Calendar" redirecting me to page CALENDAR /add new event and I would like to see order number with its details taken from table ESTIMATES on edited calendar page.
How to link button "Calendar" to calendar/add new event page?
How to show estimate number ( can be just read only) on add event page?
- What will be the query to get estimate_no ( which is auto increment) in ESTIMATES table when I am adding new client details to CLIENTS table.
client_id in CLIENTS will be same value as estimate_no in ESTIMATES.
- What will be the query to show in table ORDERS:
Estimate No, Client Name, Client Surname
where estimate_no in ESTIMATES table belongs to client_id in CLIENTS table.
Hope is clear...
Thanks
Andrew