Making SQL simpler...

bunker

Hi,

Instead of doing this:

$sql = mysql_query("SELECT * FROM content WHERE cat = '$cat'");
$row = mysql_fetch_array($sql);

$sql_menu = mysql_query("SELECT * FROM menu_der WHERE lang cat = '$cat'");
$row_menu = mysql_fetch_array($sql_menu);

echo $row_menu[cat];
echo $row[cat];

How could I simplfy the query and after display the results from one table or the other??

10000 thx in advanced!!

toxic_brain

try
SELECT c., m.
FROM
content c,

menu_der m
WHERE c.cat = '$cat'
AND c.cat = m.cat

the result will have all fields from two tables

bunker

ok,

i get that bit.... but imagine that in the table content and also in the table menu_izq there is a field called name... How would I display the value of content.name or menu_izq.name??
echo $row_menu[c.cat];
echo $row_menu[m.cat];

Would that be correct??

Thx again!!

toxic_brain

hey, remeber, u hav same value in both cat field for each record..
nd
u can take it as

$row_menu[cat]