Código PHP:
<?php
include '../controllers/conexion.php';
$query = "SELECT td.TDOC_CODI, td.TDOC_NOMB, pa.TDOC_NOMB as PADRE
FROM csto_tdoc td
INNER JOIN csto_tdoc pa ON pa.TDOC_CODI = td.TDOC_PADR
ORDER BY PADRE desc";
$result = mysql_query($query);
$ingresos = array();
$egresos = array();
while ($fila = mysql_fetch_assoc($result)) {
if ($fila['PADRE'] == 'Ingreso') {
$ingresos[] = $fila['TDOC_NOMB'];
}
if ($fila['PADRE'] == 'Egreso') {
$egresos[] = $fila['TDOC_NOMB'];
}
}
echo '<select name="unmane">';
echo '<optgroup label="ingresos">';
foreach ($ingresos as $ingreso) {
echo '<option value="3">' . $ingreso . '</option>';
}
echo '</optgroup>';
echo '<optgroup label="egresos">';
foreach ($egresos as $egreso) {
echo '<option value="3">' . $egreso . '</option>';
}
echo '</optgroup>';
echo '</select>';
?>
esa es mi consulta
gracias