mssql_fetch example

[seidel]

can someone show me a quick example of mssql_fetch

mssql_fetch()

[Anon]

<?
$database = "testDB";
$tablename = "testTable";

$connection = @mysql_connect("localhost","sandman","1234567") or die("could not connect");

$db = @mysql_select_db($database,$connection) or die("could not select the database");

$sql_statement = "SELECT id,format,title FROM $tablename ORDER BY id";

$result = @($sql_statement,$connection) or die("could not execute query");

while($row = mysql_fetch_array($result)){
$id = $row['id'];
$format = $row['format'];
$title = $row['title'];
}

echo($id." - id<BR>");
echo($format." - format<BR>");
echo($title." - title<BR>");

?>

---

i hope this works for ya.

i have some junk i'm trying to figure out as well. after you're tasks are done - will you look at the thread i posted titled: "CGI ERROR - header problems"? I would appreciate any pointers.

thanks.
[e-mail]