a multiple database consult

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
madpixel
Forum Newbie
Posts: 4
Joined: Wed Oct 22, 2003 4:31 am

a multiple database consult

Post by madpixel »

hi! I have these querys :

Code: Select all

<?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.
User avatar
devork
Forum Contributor
Posts: 213
Joined: Fri Aug 08, 2003 6:44 am
Location: p(h) developer's network

Post by devork »

yes it is possible

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...
madpixel
Forum Newbie
Posts: 4
Joined: Wed Oct 22, 2003 4:31 am

i did it

Post by madpixel »

the query that i wanted is like this :

Code: Select all

<?php
$rs_query=mysql_query("SELECT * FROM software, software_versiones, software_descargas WHERE (
(software.id = software_versiones.id_soft) AND (software_versiones.id = software_descargas.id_ver) AND (software_descargas.id_cliente = ".$_GET["id"]."))");
?>
User avatar
devork
Forum Contributor
Posts: 213
Joined: Fri Aug 08, 2003 6:44 am
Location: p(h) developer's network

Post by devork »

have you tried running that query...
madpixel
Forum Newbie
Posts: 4
Joined: Wed Oct 22, 2003 4:31 am

works

Post by madpixel »

yes, i tried it and it seems that works fine
User avatar
devork
Forum Contributor
Posts: 213
Joined: Fri Aug 08, 2003 6:44 am
Location: p(h) developer's network

Post by devork »

so are you getting the correct data from row after fetching the record... from query result
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post by JAM »

How about you tried something like the following:

Code: Select all

-- applied linebreaks to make it abit readable...
$query = "
select 
    software_descargas.*, software_versiones.*, software.*
from 
    software_descargas
    inner join software_versiones on software_versiones.id = software_descargas.id_ver
    inner join software on software.id = software_versiones.id_soft
where
    software_descargas.id_cliente = '$_GET&#1111;id]'
";
User avatar
devork
Forum Contributor
Posts: 213
Joined: Fri Aug 08, 2003 6:44 am
Location: p(h) developer's network

Post by devork »

you can also do this by joins as
JAM has mentioned above
good technique to do stuff like this...;)
Post Reply