Chao Shun Jenq asked 10 years ago


I tried to run the program "dropdown-dependent.php"
When I dropdown and choose one client data (client_id=1),
the data of "invoices" field will change but only display the data of client_id=0 .

I don't know that is a bug?


2 Answers
Chao Shun Jenq answered 10 years ago

mysql log file as below:
(the last line was not posted the correct value? ==>{client_id})

165 Connect root@localhost on
165 Init DB griddemo
165 Query SET NAMES 'utf8'
165 Query SET NAMES 'utf8'
165 Query select distinct client_id as k, name as v from clients
165 Query select note as k, note as v from invheader
165 Query SELECT id, invdate, invheader.client_id, amount, note FROM invheader INNER JOIN clients on clients.client_id = invheader.client_id WHERE 1=1 LIMIT 1 OFFSET 0
165 Query select distinct note as k, note as v from invheader WHERE client_id = '{client_id}'

Abu Ghufran answered 10 years ago

Emailing you working code sample.

Your Answer

19 + 15 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.

How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?