[RESOLVED] referencing array elements

[laurus]

This is driving me nuts;

I run a query and it brings back multiple result rows. I want to reference those results in various places on the site. I am having a heck of a time. I can display the results of the 1st row real easily;

echo $row[0];

but I can't display the second 'row' at all! I assumed it would be

echo $row[1][0];
echo $row[0][1];
echo $row[1]["site_name"];

or something like that but it ends getting something bad.

Here is my code at this stage;

$query = " select distinct(s.site_name), s.site_id ";
$query .= " from models m ";
$query .= " left join mod2ass m2a on m.model_id = m2a.model_id ";
$query .= " left join hosted h on m2a.asset_id = h.hosted_asset ";
$query .= " left join sites s on s.site_id = h.site_id ";
$query .= " where m.model_name = 'Brooke Banner' ";
$query .= " group by s.site_name order by s.site_name limit 10";

$result = mysql_query($query) or die("ERROR: <br>$query<br /> <strong>" . mysql_error()."</strong>");
echo $num_rows = mysql_num_rows($result)."<br>";

$row = mysql_fetch_row($result);
echo $row[0][/QUOTE]

thanks in advance!!!!

[laserlight]

If the first row is $row[0], then the second row is $row[1]. As simple as that.

[devinemke]

$result = mysql_query($query) or exit(mysql_error());
echo mysql_num_rows($result) . ' row(s)<br><br>';
while ($row = mysql_fetch_assoc($result))
{
	echo $row['site_id'] . ' ' . $row['site_name'] . '<br>';
}

[laurus]

nope. I can't do a while loop cuz I don't want to show all the results yet. Just the first line here,, second line there, third line there in a different section of the page..

If I just do $row[0] $row[1] is shows me the site name then the site_id. What I need to see is the second site name that the query returned.

[devinemke]

$result = mysql_query($query) or exit(mysql_error());
echo mysql_num_rows($result) . ' row(s)<br><br>';
while ($row = mysql_fetch_assoc($result))
{
	$models[$row['site_id']] = $row['site_name'];	
}

echo $models[1] . '<br>';
echo $models[5] . '<br>';
echo $models[88] . '<br>';
// etc...

[laserlight]

Sorry, I did not look carefully at your post and assumed that you had extracted the result set into an array named $row. You have not. Instead, you retrieved the first row from the result set into $row, thus $row is not an array of rows, but an array of fields.

The solution is as devinemke described. Change:

$row = mysql_fetch_row($result);
echo $row[0]

To something like:

while ($row = mysql_fetch_row($result)) {
    echo $row[0] . "<br />\n";
}

Though I would prefer devinemke's example of using mysql_fetch_assoc() instead of mysql_fetch_row() as it can improve readability.

[laurus]

I get the following error messages with devinemke's solution

Notice: Undefined offset: 1 in test.php on line 30

Notice: Undefined offset: 5 in test.php on line 31

Notice: Undefined offset: 88 in test.php on line 32

[laserlight]

I believe that is only an example, with the array indices chosen at random. Do you understand what is happening?

[devinemke]

if you do not wish to refer to the rows by their primary key ID's but simply by the order they were retuned in the query...

$result = mysql_query($query) or exit(mysql_error());
echo mysql_num_rows($result) . ' row(s)<br><br>';
while ($row = mysql_fetch_assoc($result))
{
	$models[] = $row;
}

echo $models[0]['site_name'] . '<br>';
echo $models[1]['site_name'] . '<br>';
echo $models[2]['site_name'] . '<br>';
// etc...

[laurus]

wow great!!!!!! perfect. I get it.

thanks a million!