Query works but can't echo the results

Hatch

Here's the code. I know the query is returning the right results because in the HTML source it prints the <br> tags where they should be. The echo statement right before it though doesn't print anything in the HTML.

			$cur_day = date("Y-m-d 00:00:00",mktime(0,0,0,$month,$day_sql,$year));
			// Guides NOT Available
			$sql = "SELECT gs_guide.* 
					FROM gs_guide, gs_group 
					WHERE gs_group.guideno = gs_guide.guideno 
					AND '$cur_day' BETWEEN arrdate AND depdate 
					GROUP BY guideno";
			$result = mysql_query($sql);
			if (!$result)
				echo mysql_error();
			$num_results = mysql_num_rows($result);
			if ($num_results < 1)
			{
				echo "&nbsp;";
			}
			else
			{
				for ($i = 0; $i < $num_results; $i++)
				{
					$row = mysql_fetch_row($result);
					echo $row["name"]."<br>";		
				}
			}

Hatch

I changed this...

$row = mysql_fetch_array($result);
echo $row["name"]."<br>";

to this...

$row = mysql_fetch_object($result);
echo $row->name."<br>";

Why does the second one work and not the first? Is it because I joined two tables in my query?

laserlight

Try and copy and paste the code you tested.

In your original example, you used mysql_fetch_row(), which returns an array based on numeric indices.
Using mysql_fetch_assoc() will return an associative array, which is what you want.
Using mysql_fetch_array() will return an array with both numeric and associative indices.

Hatch

totally overlooked that...weird because I never use that and I always use fetch_array().

Well thanks! Sometimes it just takes a couple pair of eyes.