[RESOLVED] Arrays and While Mysql Functions

Pezmc

How can I get this array to work? I am trying to add data to an array for every row of data? This is a sellection of queries that I need to parse into an array so a function can use the arra to draw a graph. I am new to arrays how can I get this to work? Please help?

		//Sql Query
			//Day Name
			$sql = "SELECT count(*) as cnt, DAYNAME(date) as dnr, TO_DAYS(date) as tdr FROM $dbsql WHERE date >= DATE_SUB( CURRENT_DATE, INTERVAL 6 day ) GROUP BY dnr,tdr ORDER BY tdr";
			$result = mysql_query($sql);
			while ($row = mysql_fetch_array($result)) {
				$comma = ","; 
				$xdata .= '"'.$row[dnr].'"'.$comma;
			}

		//Data
		$sql = "SELECT count(*) as cnt, DAYNAME(date) as dnr, TO_DAYS(date) as tdr FROM $dbsql
		WHERE date >= DATE_SUB( CURRENT_DATE, INTERVAL 6 day ) GROUP BY dnr,tdr ORDER BY tdr";
		$result = mysql_query($sql);
		while ($row = mysql_fetch_array($result)) {
			$comma = ","; 
			$ydata .= $row[cnt].$comma;
		}
		//Trim Extra Commas
			$ydata = substr($ydata, 0, strlen($ydata)-1);
			$xdata = substr($xdata, 0, strlen($xdata)-1);

	$y = array($ydata);
	$x = array($xdata);	 
	$title = "Unique Hits/Day";
	$labelx = "Day";
	$labely = "Unique Hits";

laserlight

You have the right idea, but your implementation needs to be fixed:

$sql = "SELECT count(*) as cnt, DAYNAME(date) as dnr, TO_DAYS(date) as tdr
        FROM $dbsql WHERE date >= DATE_SUB( CURRENT_DATE, INTERVAL 6 day )
        GROUP BY dnr,tdr ORDER BY tdr";
$result = mysql_query($sql);
$day_names = array();
$unique_hits = array();
while ($row = mysql_fetch_assoc($result)) {
    $day_names[] = $row['dnr'];
    $unique_hits[] = $row['cnt'];
}

$title = "Unique Hits/Day";
$day_name_label = "Day";
$unique_hit_label = "Unique Hits";

Now you can use the $day_names and $unique_hits arrays right away. There is no need to have to go through strings.

You might note that these arrays have much better names than $x and $y. $x and $y most likely applies for your graph, but before you actually translate the data into graphical form, use names that are appropriate to your data, not the graph as one particular way of representing the data.

Pezmc

Sweet thanks for your in depth help!
I could never get my head around arrays and you have really helped me alot!

Ps thank you for your long term advice so I can improve in the future.