retrieving one specific value from many rows

[tito]

I am using the below to retrieve and increment values from the db. I need to display in the last line the $i value for one specific $ID. How can I do so? Thanks...

<?
$target=$values[Cat_ID];
$target2=$values[ID];
$query = mysql_query("select * From listings where Cat_ID = $target");
$count = mysql_num_rows($query);
for ($i = 1; $i <= $count; $i++) {
extract(mysql_fetch_array($query));
echo "addLocation($Cat_ID,$i,$x,$y,\"$Name\",\"index.php?GoToID=$ID\",\"$Address1 $Address2 Phone: $Phone1\");";
echo "\n";
}
showLocation("$target","$i_value_for_$target2");
?>

[tomhath]

You mean something like:

 
if ($ID == $target2) {
  $this_is_the_one = $i
}
...
echo $this_is_the_one;

[tito]

yes, but that does not work. The php does not display at all

[tito]

I am a newbie, but I know the basics, and I am puzzled on why the below in bold, when added anywhere, will not even display the php

<?
$target=$values[Cat_ID];
$target2=$values[ID];
$query = mysql_query("select * From listings where Cat_ID = '$target'");
$count = mysql_num_rows($query);
for ($i = 1; $i <= $count; $i++){
extract(mysql_fetch_array($query));
// is this $i for current listing?
if ($ID == $target2) {
$ID_$i = $i;
}
echo "addLocation($Cat_ID,$i,$x,$y,\"$Name\",\"index.php?GoToID=$ID\",\"$Address1 $Address2 Phone: $Phone1\");";
echo "\n";
}

echo "showLocation($Cat_ID,$ID_$i)";
?>

[tomhath]

Hmmm. When I tried to run it, the result was:

Parse error: parse error, unexpected T_VARIABLE in C:\Inetpub\wwwroot\test.php on line 10

Line 10 is this:

$ID_$i = $i;

You have an extra $ in two places (here and in th echo a few lines later). Should be:

$ID_i = $i;
...
echo "showLocation($Cat_ID,$ID_i)";

[tito]

I thought so too, and had tried without also

[tito]

just did a quick test and replaced $ID$i = $i; with the value of 3
$ID$i = 3;

that worked and seemed to indicate that the problem could line at $target2=$values[ID];