quick question

[Anon]

Can anyone tell me why the following isn't working? The query works fine but for some reason the index is still set to 1???

$query = "SELECT * FROM employee ORDER BY LastName";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
////if user coming in from FindContact page goto required record
if (isset($First) && isset($Last))
{
for ($i=1; $i<$num_results; $i++)
{
$row = mysql_fetch_array($result);
echo "$i "; echo ($row["FirstName"]); echo " ";echo ($row["LastName"]); echo "<br/>";

	$First = strtoupper($First);
	$Last = strtoupper($Last);
	if (($row->FirstName==$First) && ($row->LastName==$Last)) 
	{
  	$index=$i;
	}
}

}

$FirstName = addslashes($FirstName);
$LastName = addslashes($LastName);

//Set row number to one if no record present
//global index;
if (!isset($index))
{
$index=1;
}

[Anon]

Jo,

I'm in a hurry, but I have a page that gives a 100% working script. You use for($i=1;..++), I prefer to use:

while($recordData = mysql_fetch_array($query))

Because I don't have to worry about $i conflicting somewhereelse.

Here is the page that I am referring to:
http://www.samuelfullman.com/team/php/connection_code.htm

Also you should always have a standard for waht your recordData array is (that's my name), and it should be more descriptive than "row" so that you can find it. I ALWAYS use recordData for all my programs for harmony between functions and classes.

Best to you
Sam Fullman
Compass Point Media