Показване на определени редове

[ReCoNeC7eD]

Здр

Имам този код

$query = " SELECT * FROM register ORDER BY serviceid DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('Error, query failed');
echo "<table border=1 width=300 align=center>";
echo '<tr><td>ID:</td><td>PC Naam </td><td>OS</td></tr>';
while($row = mysql_fetch_array($result))
{
echo '<tr><td>'.$row['serviceid'].'</td><td><a href='.$path.'='.$row['id'].'>'.$row['name'].'</a></td><td>'.$row['os'].'</td></tr>';
}
echo"</table>";

как да направя така в че таблицата да се показват само редове на който "serviceid" е "1" ?

благодаря ви предварително

 

[kulov]

	<?  $query = " SELECT * FROM register WHERE `serviceid` = '1' ORDER BY serviceid DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('Error, query failed');
echo "<table border=1 width=300 align=center>";
echo '<tr><td>ID:</td><td>PC Naam </td><td>OS</td></tr>';
while($row = mysql_fetch_array($result))
{
echo '<tr><td>'.$row['serviceid'].'</td><td><a href='.$path.'='.$row['id'].'>'.$row['name'].'</a></td><td>'.$row['os'].'</td></tr>';
}
echo"</table>";

 

[miro_94]

$query = " SELECT * FROM register WHERE serviceid='1' ORDER BY serviceid DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('Error, query failed');
echo "<table border=1 width=300 align=center>";
echo '<tr><td>ID:</td><td>PC Naam </td><td>OS</td></tr>';
while($row = mysql_fetch_array($result))
{
echo '<tr><td>'.$row['serviceid'].'</td><td><a href='.$path.'='.$row['id'].'>'.$row['name'].'</a></td><td>'.$row['os'].'</td></tr>';
}
echo"</table>";