posted July 03, 2000 02:54 AM         

Does anybody know why this does´nt work?

<?
$y = 2;

$mysql = mysql_query ("SELECT * FROM statsMonth WHERE month='$y'");
if ($rad = mysql_fetch_array($mysql)) {
do {

$kategorinamn=$rad["namn"];
$kategoriid = $rad["id"];

echo "OK<br>";

} while($rad = mysql_fetch_array($mysql));
}?>

It says that it was unable to save the result set...
Maybe the problem is that the table have over 17000 records?

Please help!

posted July 03, 2000 04:48 AM            

one more thing ,you have missed a '=' sign in the end of the loop.

<?
$y = 2;

$sql = mysql_query ("SELECT * FROM statsMonth WHERE month='$y'");
if ($rad = mysql_fetch_array($sql)) {
do {

$kategorinamn=$rad["namn"];
$kategoriid = $rad["id"];

echo "OK<br>";

} while($rad ==mysql_fetch_array($sql));
}?>

------------------
SR -
webshiju.com

"The fear of the LORD is the beginning of knowledge..."