Jumping tables on same script

[eagle0921]

Hi All,

I have some PHP scripting in a few HTML pages. Can someone tell me how I can jump from one table to another? In other words I have 2 tables in same MySQL database named Employees and TIme Worked. How can I in my scripts go to Employees and get some info and then leave that table and go to Time Worked and get some info out of that and display in the same table on the HTML page?

Thank You in Advance for your help.

Ron

[Anon]

you can if you're lazy like me, make two seperate mysql SELECT statements for each table and then assign the results to the same array, and then iterate over the array you made with a foreach..

like so:

$kwery = "SELECT crap FROM you1";
$result = php_query($kwery);
while ($row = mysql_fetch_object($result)){
$bigarray[crap] = $row->crap;
}

$kwery = "SELECT crap2 FROM you2";
$result = php_query($kwery);
while ($row = mysql_fetch_object($result)){
$bigarray[crap2] = $row->crap2;
}

now print_r($bigarray);

its all there..

the better way to do this tho is to combine the two table queries into one SELECT statement with the

select table.row as data1, table2.row as data2.. syntax that you can read all about at mysql.com

peace, love and crackiness.

dross

http://www.dross.com/

[eagle0921]

Thanks for the info on this. I will give it a shot.

Ron