espero alguna ayudita plz
Código PHP:
if ($_POST['autor'] == "0" AND $_POST['disco'] == "0" and $_POST['tema'] == "0") {
$query_props = sprintf("SELECT autor, tema, disco FROM musica");
} else {
while ($_POST['autor'] == "0" AND $_POST['disco'] != "0" and $_POST['tema'] != "0") {
$query_props = sprintf("SELECT autor, tema, disco FROM musica WHERE disco = %s AND tema = %s", $disco_musica, $tema_musica);
}while ($_POST['autor'] == "0" AND $_POST['disco'] == "0" and $_POST['tema'] != "0") {
$query_props = sprintf("SELECT autor, tema, disco FROM musica WHERE tema = %s", $tema_musica);
}while ($_POST['autor'] == "0" AND $_POST['disco'] != "0" and $_POST['tema'] == "0") {
$query_props = sprintf("SELECT autor, tema, disco FROM musica WHERE disco = %s", $disco_musica);
}while ($_POST['autor'] != "0" AND $_POST['disco'] == "0" and $_POST['tema'] != "0") {
$query_props = sprintf("SELECT autor, tema, disco FROM musica WHERE autor = %s AND tema = %s", $autor_musica, $tema_musica);
}while ($_POST['autor'] != "0" AND $_POST['disco'] == "0" and $_POST['tema'] == "0") {
$query_props = sprintf("SELECT autor, tema, disco FROM musica WHERE autor = %s", $autor_musica);
}while ($_POST['autor'] != "0" AND $_POST['disco'] != "0" and $_POST['tema'] == "0") {
$query_props = sprintf("SELECT autor, tema, disco FROM musica WHERE autor = %s AND disco = %s", $autor_musica, $disco_musica);
}while ($_POST['autor'] != "0" AND $_POST['disco'] != "0" and $_POST['tema'] != "0") {
$query_props = sprintf("SELECT autor, tema, disco FROM musica WHERE autor = %s AND disco = %s AND tema = %s", $autor_musica, $disco_musica, $tema_musica);
}
}