[SOLVED] Help selecting a specific value on a database

[alexguz79]

hey everybody

 

little help here pliz

 

i have this DDBB where the table sports have seven fields, on of them is d_sports and have diferents infos:

 

Baseball

Basketball

Hockey

etc..

 

i want to select and display only the ones with Baseball info.... how can i do this??

 

i know is something like this:

 

<?php
require_once('config_noticia.php');

$sql = "SELECT Baseball FROM sports ORDER BY ID DESC LIMIT 0,1";
$query = mysql_query($sql);
while ($row = mysql_fetch_array($query)){
echo $row['titulo'];
}
?>

 

thank people

[conker87]

$sql = "SELECT Baseball FROM sports WHERE d_sports = 'Baseball' ORDER BY ID DESC LIMIT 0,1";

[alexguz79]

thanx... that solve it