<?php
$rs_query=mysql_query("select * from software_descargas where id_cliente=".$_GET["id"]);
$datos_descarga=mysql_fetch_array($rs_query);
$rs_query=mysql_query("select * from software_versiones where id=".$datos_descarga["id_ver"]);
$datos_version=mysql_fetch_array($rs_query);
$rs_query=mysql_query("select * from software where id=".$datos_version["id_soft"]);
$datos_soft=mysql_fetch_array($rs_query);
echo $datos_soft["soft"];
?>
i would want to know how to do this only with on a query.
Thanks!!!!
Last edited by madpixel on Wed Oct 22, 2003 6:55 am, edited 1 time in total.
mysql> select * from name; select * from name1 ; select * from name3;select * from name2;
+------+
| n |
+------+
| a |
+------+
1 row in set (0.00 sec)
+------+
| n |
+------+
| a |
+------+
1 row in set (0.00 sec)
+------+
| n |
+------+
| a |
+------+
1 row in set (0.00 sec)
+------+------+
| n | b |
+------+------+
| a | d |
+------+------+
1 row in set (0.00 sec)
but have to keep track where the one query result ends...