Re: Repeats of values

Hi, Wednesday, January 1, 2003, 2:47:57 AM, you wrote: AR> I'm running the following sql query which outputs a repeat value for each AR> field in the html cell box. AR> Like this: AR> ...................... AR> 3.3 3.3 78 78 2002-06-11 2002-06-11 AR> ................... AR> which is not what I would like. AR> I was trying to get: AR> ............................. AR> 3.3 78 2002-06-11 AR> ........................ AR> I thought that by dropping off the $key in the $key - $value pair AR> to: AR> while(list (,$value) = each ($line)) AR> would accomplish that. AR> The SQL query is: AR> SELECT level, pm, date FROM daytime WHERE pm >=75 AR> ............................ AR> The php script is: AR> <?php AR> $link = mysql_connect("", "", "") AR> or die ("Could not connect"); AR> mysql_select_db ("water") AR> or die ("Could not select database"); AR> $query = "SELECT level, pm, date FROM daytime WHERE pm >= 75"; AR> $result = mysql_query ($query) AR> or die ("Query failed"); AR> // printing HTML result AR> print ("<Font Face=\"arial\" size=3>Dates where water exceeded AR> 75 AR> degrees<BR> at Callicoon, New York - 2002</FONT>"); AR> print("<P>"); AR> print "<table border=1>\n"; AR> while($line = mysql_fetch_array($result)){ AR> print "\t<tr><td bgcolor=\"#CCCCFF\"><Font AR> Face=\"arial\" size =2>\n"; AR> while(list (,$value) = each ($line)) { AR> print "<td bgcolor=\"CCCCFF\"><Font Face =\"arial\" size=2>>$value</td>\n"; AR> } AR> print "\t</tr>\n"; AR> } AR> print "</table>\n"; AR> mysql_close($link); ?>> AR> .......................................... AR> Any help would be greatly appreciated. AR> Happy New Year! AR> Tony Ritter change this line while($line = mysql_fetch_array($result)){ to while($line = mysql_fetch_assoc($result)){ mysql_fetch_array() builds a numerical and a associative array for each row. -- regards, Tom