A:hola 1
B: ola 1
B: ola 1
B: ola 1
A:hola 1
B: ola 1
A:hola 1
A:hola 1
A:hola 1
A:hola 1
A:hola 1
A:hola 1
A:hola 1
Código PHP:
Ver original
$query = "SELECT * FROM mundo INNER JOIN mundo_c ON mundo.mids = mundo_c.mids2 order by mids2"; $x = ''; if ($row['mctexto'] != $x) { echo 'A '. $row['mctexto'] . '<br />'; } echo 'B '. $row['ctexto'] . '<br />'; $x = $row['mctexto']; }
CREATE TABLE `mundo` (
`mids` int(11) NOT NULL AUTO_INCREMENT,
`mctexto` text NOT NULL,
PRIMARY KEY (`mids`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
CREATE TABLE `mundo_c` (
`ids` int(11) NOT NULL AUTO_INCREMENT,
`mids2` text NOT NULL,
`ctexto` text NOT NULL,
PRIMARY KEY (`ids`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
Les agradesco mucho sus ayudas!