[SOLVED] Fetching Rows

[eugene2009]

heres the problem.. i have a table named "comments" and in this code i am fetching inputs "tutorialid" and "name" what i want to fetch is a certain id from the "tutorialid" how will i go about doing this.. heres part of the code.

 

$sql = "SELECT tutorialid, name FROM comments LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);


while ($list = mysql_fetch_assoc($result)) {
   
   echo $list['tutorialid'] . " : " . $list['name'] . "<br />";
} 

 

for instance.. i want all the rows with the tutorial id "3"

can somebody please help? thanks in advance

[monkeybidz]

$sql = "SELECT name FROM comments WHERE tutorialid='3' LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

$list = mysql_fetch_assoc($result);

$tutorialid=$list["tutorialid"];
$name= $list["name"];
   
   echo $tutorialid." : ". $name."<br />";
}

 

Is this something you can use?

[eugene2009]

monkeybidz, thanks alot!!!

even tho it didnt work i forgot the WHERE tutorialid='3' statement.. thats the only thing i needed to add to my original code. THANKKKS!