Re: [PHP-DB] Re: [PHP-WIN] Need Help with 2 MYSQL Table

2015-05-02 Thread Bastien Koert
Combine them in SQL and loop through the dataset select c.*, cd.* from customers c inner join customer_details cd on c.id = cd.customer_id [where clause as needed] loop thru the recordset from that query just as you would with a query from a single table and link the id to the edit page while (

[PHP-DB] Re: [PHP-WIN] Need Help with 2 MYSQL Table

2015-04-25 Thread Richard Quadling
On 25 April 2015 at 06:13, Guru wrote: > Hi All, > > Hope everyone is doing well. I need some help regarding a project. I have a > huge list of customers in a ledger in a mysql table (Table A). And in > another table I have their names and their ID number (Table B). What I want > is when I click