Here a sql statement that I use in my current solution that I want to migrate to your address book.
$rs = mysql_query("select * from cart inner join items on cart.itemId = items.itemId where cart.clientId = $cid order by items.itemType, items.itemName asc");
How would I fold in this query so I can populate fields and such. I have a client table and cart table. I thought I might have the search form be a client page where I can see the date and amounts for a given client. Clicking the EDIT icon would take me to the details form where the order(s) for that client are itemized.
If I already know my sql queries can this be implemented fairly easily?
Here a sql statement that I use in my current solution that I want to migrate to your address book.
$rs = mysql_query("select * from cart inner join items on cart.itemId = items.itemId where cart.clientId = $cid order by items.itemType, items.itemName asc");
How would I fold in this query so I can populate fields and such. I have a client table and cart table. I thought I might have the search form be a client page where I can see the date and amounts for a given client. Clicking the EDIT icon would take me to the details form where the order(s) for that client are itemized.
If I already know my sql queries can this be implemented fairly easily?