Javascript -how to display the details of a multiple field with common data in it?

See more:

Javascript

HTML

transaction.executeSql('SELECT t1.*,t2.Cust_name FROM invoice t1,customer t2 where t2.Cust_name="'+rname+'" and t1.Cust_code=t2.UserId', [],  function(transaction, result)
                                {
                                  le=result.rows.length;
                                  for (var i = 0; i < result.rows.length; i++)
                                      {
                                       var row = result.rows.item(i);
                                          rid=row.Invoice_number;
                                          console.log(rid);
                                          if(rid)
                                           document.location.href="invoice_data_list.html?rname="+rname+"&rid="+rid;
                                           console.log("s");
                                       }

                                   });

This is a code to select datas from two tables,below are the table descriptin.
table1-invoice(invoice_id,date,cust_code,amt)
table2-customer(userid,custname,bal_amt);

I have a list of invoices for the same and different customers.On clicking a particular invoice it should display the details of it in another page.That is my work here.
The problem here is:If I select a customer who has multiple invoices it displays the last invoice of the particular customer.If I click on a customer having a single invoice then it displays the correct details.
How can I get a solution please...