note 23835 deleted from function.extract by dams

$query = "select one,two,three from table"; $res = mysql($dbname,$query); echo mysql_error(); for ($i=0;$i<mysql_num_rows($result);$i++) { extract(mysql_fetch_array($result),EXTR_OVERWRITE); echo "$one, two, three"; } //this will work for those, like myself, who have large databases and dont want to write mysql_result($result,$i,one) over and over again. And it does it row by row automatically. //Note that once you do an extract on an mysql array, and maybe regular arraries, it will destroy the array. //Also note that if you have multiple mysql arraries, you must call the extract for any particular mysql array BEFORE you send another mysql query. The typical extract error will pop up if you don't do this.