Hola, por las dudas posteo el codigo del buscador por palabras, por favor si alguien me puede ayudar con el del select, le agradeceria mucho.
gracias.
den_22
Código PHP:
Ver original<?php
include("connect.php");
$usuario=$_SESSION['usuario'];
if ($_GET['search']=="firstname"){
$firstname = $_POST['firstname'];
$query = mysql_query("SELECT * FROM prueba WHERE firstname LIKE '%$firstname%' ORDER BY firstname DESC LIMIT 40");
} else {
} } }
if ($_GET['search']=="lastname"){
$lastname = $_POST['lastname'];
$query = mysql_query("SELECT * FROM prueba WHERE lastname LIKE '%$lastname%' ORDER BY lastname DESC LIMIT 40");
} else {
} } }
if ($_GET['search']=="favourite_music"){
$favourite_music = $_POST['favourite_music'];
$query = mysql_query("SELECT * FROM prueba WHERE favourite_music LIKE '%$favourite_music%' ORDER BY favourite_music DESC LIMIT 40");
} else {
} } }
if ($_GET['search']=="favourite_movie"){
$favourite_movie = $_POST['favourite_movie'];
$query = mysql_query("SELECT * FROM prueba WHERE favourite_movie LIKE '%$favourite_movie%' ORDER BY favourite_movie DESC LIMIT 40");
} else {
} } }
?>
en el html pongo <?php echo $user_ok['favourite_movie']; ?>