les agradesco mucho por su apoyo.
Código PHP:
Ver original/* AQUI TABLAS
----------------------------------------------------------------------------
CREATE TABLE `mundo` (
`mids` int(11) NOT NULL AUTO_INCREMENT,
`uids` text NOT NULL,
`usser` text NOT NULL,
`nombres` text NOT NULL,
`avatardos` text NOT NULL,
`mctexto` text NOT NULL,
`fecha` text NOT NULL,
`visto` text NOT NULL,
PRIMARY KEY (`mids`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
INSERT INTO `mundo` VALUES (1, '1', '', '', '', 'hola chile', '', '');
INSERT INTO `mundo` VALUES (2, '1', '', '', '', 'hola bolivia', '', '');
INSERT INTO `mundo` VALUES (3, '3', '', '', '', 'hola peru', '', '');
INSERT INTO `mundo` VALUES (4, '3', '', '', '', 'hola china', '', '');
INSERT INTO `mundo` VALUES (5, '5', '', '', '', 'hola japon', '', '');
INSERT INTO `mundo` VALUES (6, '5', '', '', '', 'hola cuba', '', '');
----------------------------------------------------------------------------
CREATE TABLE `mundo_c` (
`ids` int(11) NOT NULL AUTO_INCREMENT,
`mids2` text NOT NULL,
`uids` text NOT NULL,
`nombres` text NOT NULL,
`avatardos` text NOT NULL,
`ctexto` text NOT NULL,
`fecha` text NOT NULL,
`visto` text NOT NULL,
PRIMARY KEY (`ids`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
INSERT INTO `mundo_c` VALUES (1, '1', '', '', '', 'como stas chile 1', '', '');
INSERT INTO `mundo_c` VALUES (2, '2', '', '', '', 'como stas bolivia 1', '', '');
INSERT INTO `mundo_c` VALUES (3, '3', '', '', '', 'como stas peru 1', '', '');
INSERT INTO `mundo_c` VALUES (4, '4', '', '', '', 'como stas china 1', '', '');
INSERT INTO `mundo_c` VALUES (5, '5', '', '', '', 'como stas japon 1', '', '');
INSERT INTO `mundo_c` VALUES (6, '6', '', '', '', 'como stas cuba 1', '', '');
INSERT INTO `mundo_c` VALUES (7, '2', '', '', '', 'como stas bolivia 2', '', '');
INSERT INTO `mundo_c` VALUES (8, '2', '', '', '', 'como stas bolivia 3', '', '');
---------------------------------------------------------------------------- */
$query21 = "SELECT * FROM mundo INNER JOIN mundo_c ON mundo.mids = mundo_c.mids2 order by `mids2` ";
echo 'M '.$row21['mids'].''.$row21['mctexto'].'<br>';
if($row21['mids']==$row21['mids2']){
$hola=$row21['mids'];
$query22 = "select * from mundo_c where mids2='$hola' order by `ids`";
echo 'C '.$row22['mids2'].''.$row22['ctexto'].'<br>';
}
}else{
echo 'M '.$row21['mids'].''.$row21['mctexto'].'<br>';
}
}
# tengo errores en el resultado no me sale. nesesito que me ayuden por favor
/* El resultado mas o menos asi.