hi, i'm new to MySQL, but i've got some info set up and i'm trying to read it. this is my code:
<?php $db = mysql_connect("localhost", "root") or die ("could not connect to database");
mysql_select_db(cultsite, $db) or die (mysql_error());
$query = "select op_ID from ops";
$result = mysql_query($query, $db);
?>
<html>
<head>
<title>test</title>
</head>
<body>
<?php $i=0;
while ($rows = mysql_fetch_row($result)){
echo $rows[$i]. "\n\r<br />";
$i++;
}?>
</body>
</html>
the only problem i, it only returns the first result, a 1. why might that be?
i'm sure that this si a very basic question, and i'm sorry for asking it, but plz hlp?
