How to I print record list with MySql

[timsharpe]

How do I print the results
I am using the following code, how do I print the results of the query on the page.

$db = mysql_connect("localhost", "user", "pass");
mysql_select_db("mysql",$db);
$sql = "SELECT headline, text, link from news";
$result = mysql_query($sql);

Also, I would like to limit the number of records, as well as have a next/previous ink, can someone please show me what to do.

Thanks

Tim

[ftrudeau]

Numerous ways to do this, one is ;

while  ($row = mysql_fetch_assoc($result)) {
     echo $row["headline"];
     echo $row["text"];
     echo $row["link"];
}

As for your second question, you can limit the number of results directly in the SQL query ;

SELECT headline, text, link FROM news LIMIT $start,$end

Hope this helps.