How to show up?

Question

i have a database and 2 tables
this is my code
<?php
$query=mysql_query("select *from cat where k1 like '$k1' and k2 like '$k2'");
while ($row=mysql_fetch_array($query))
$k1 = $row['k1'];
$k2 = $row['k2'];

?>
$k1 have a content and the calculation content $k1 in different table
how can i show up the calculation from other table?

Answer 1

Give your tables , sample data and explain in more detail what you want to do.

Answer 2

i have a 2 tables, the table name is cat and cat2
in table cat have k1 ,in attribute k1 include red,green and yellow and in table cat2 have the calculation from red, yellow,green
my question is how can i show up if from table cat contain red and show calculation from cat2 categori red