dropdown-dependent.php

Questions › dropdown-dependent.php

Chao Shun Jenq asked 11 years ago

Hi,Abu,

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?

Rgds,

2 Answers

0 Vote Up Vote Down

Chao Shun Jenq answered 11 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}'

0 Vote Up Vote Down