Forum


17:57

01/10/2011

In my jqgrid I have a list of invoices, adding a new invoice I want that the field customerID assume a value.
This is the sql:
SELECT Customers.CustomerID,
Invoices.FaID, Invoices.FaCustomerID,
Invoices.InvoiceNumber,
Invoices.InvoiceData
FROM Customers
LEFT JOIN Invoices ON Customers.CustomerID=Invoices.FaCustomerID
WHERE
Customers.CustomerID= '.$_SESSION["ID"]
I want in field Invoices.FaCustomerID the value of Customers.CustomerID
In my grid Customers.CustomerID and Invoices.FaCustomerID are hidden fields
thanks
Most Users Ever Online: 715
Currently Online:
40 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66