Tengo 2 tablas, una tabla A y otra tabla B de esta forma:
Cita:
Lo que pretendo es hacer una consulta de tal forma que me muestre los resultados de la fila 2 de la TABLA A y los resultados de la fila de la TABLA B.TABLA A
+---------+------------+------------+------------+
|----id----|--camp1A-|-camp2A--|--camp3A-|
+---------+------------+------------+------------+
+---------+------------+------------+------------+
|----1-----|-----a1----|-----a2-----|-----a3----|
+---------+------------+------------+------------+
+---------+------------+------------+------------+
|----2-----|-----b1----|-----b2-----|-----b3----|
+---------+------------+------------+------------+
+---------+------------+------------+------------+
|----3-----|------c1----|-----c2-----|-----c3----|
+---------+------------+------------+------------+
TABLA B
+---------+------------+------------+------------+
|----id----|--camp1B-|-camp2B--|--camp3B-|
+---------+------------+------------+------------+
+---------+------------+------------+------------+
|----1-----|-----a1B---|-----a2B---|-----a3B---|
+---------+------------+------------+------------+
+---------+------------+------------+------------+
|----id----|--camp1A-|-camp2A--|--camp3A-|
+---------+------------+------------+------------+
+---------+------------+------------+------------+
|----1-----|-----a1----|-----a2-----|-----a3----|
+---------+------------+------------+------------+
+---------+------------+------------+------------+
|----2-----|-----b1----|-----b2-----|-----b3----|
+---------+------------+------------+------------+
+---------+------------+------------+------------+
|----3-----|------c1----|-----c2-----|-----c3----|
+---------+------------+------------+------------+
TABLA B
+---------+------------+------------+------------+
|----id----|--camp1B-|-camp2B--|--camp3B-|
+---------+------------+------------+------------+
+---------+------------+------------+------------+
|----1-----|-----a1B---|-----a2B---|-----a3B---|
+---------+------------+------------+------------+
Lo hago de esta forma:
Código PHP:
$dia=date("j");
mysql_select_db($base, $con);
$condicion = "SELECT * FROM tabla_a, tabla_b LIMIT $dia,2";
$consulta = mysql_db_query($base,$condicion) or die (mysql_error());
$con=mysql_close($con);
Para obtener los resultados del la columna camp1A lo hago así de forma satisfactoria:
Código PHP:
while($array = mysql_fetch_array($consulta))
{
echo $array['camp1A'];
}
Muchas gracias y un saludo