How do I display field in different table on same page?

cmdrBiggles

Hi all

I have a table (table1) which lists rows of records (repeat region). I have attached an HREF/ onClick event handeler to Col1 (1st field in record). Which when viewed in a browser, I can click on any of these links and a javascript alert pops up to show the record ID (record row), clicked. So far so good (the alert is temporary, just to display correct record selected).

But how can I use this onClick event to display col4/field4 only of selected row/record, in a different table on same page?

I thought it was a matter of saying (in english): onclick, display col4 of selected row in table called "table2". But I don't know how to turn that thought process into code.

Appreciate any help.

Regards
Brian

bad76

Hi,
you can JOIN the two tables and get only one as result.
To do this in FROM clause of any query you put the name of both, then you link it using the WHERE clause in SELECT statement:

SELECT a.filed1, a.field2, b.filed1, b.field2
FROM table1 a, table2 b
WHERE a.field1=b.field1

I hope this is what you searching for...

cmdrBiggles

Sorry, I should have been clearer. When I said tables I meant HTML tables 1 & 2.

So html table 1 selects from database table "phone":

col1="logID" (has onclick event), col2="spoketo", col3="date"

HTML table 2 is a seperat table waiting to display col4 = "conversation".

So I can click on logoID and the javascript 'alert' box appears, and displays the correctly selected row/record from within html table 1. Now I want this same onclick event to display col4 within html table 2.

I hope this is clearer. Can anyone help?

Regards

bad76

Oh! I'm sorry....
i'm confusing html table with mysql table...
You can show how work js for first table?

If the problem instead is to setup the second table content,
i think you can use mysql_data_seek() and re-do a while, or you can save the column in any array when output the first table, then output it in second table.