i want to select from "nume" where "gen" is actiune but i have a little problem it select only the second entry where "actiune" is the only word... i have tryed this code <?php require_once('config.php'); $cerereSQL = 'SELECT nume FROM test WHERE gen="actiune" '; $rezultat = mysql_query($cerereSQL); while($rand = mysql_fetch_array($rezultat)) { echo ' <b>Nume:</b> '.$rand['nume'].' <br> ' ; } ?> PHP: i have tried to entry in the table like this actiune aventura comedie actiune,aventura,comedie actiune/aventura/comedie PHP: but no result ...