<?
$dbusername = "hkjhkjh";
$dbpassword = "ghikhjkh";
$db_name = "crosse5_stringdoctororders";

$db = mysql_connect( "localhost", "$dbusername", "$dbpassword") or die( "Unable to connect to server!");
mysql_select_db("$db_name",$db);

if ($OrderNumber) {
$query = "SELECT ordernumber, name, emailaddy, dateupdate, timeupdate, status, received, predicted, express, mail, headnum, pocket, notes, payment FROM tracker where ordernumber='$OrderNumber'";
$insert = MYSQL_QUERY($query);
$number = MYSQL_NUMROWS($insert);
}
elseif ($EMail) {
$query = "SELECT ordernumber, name, emailaddy, dateupdate, timeupdate, status, received, predicted, express, mail, headnum, pocket, notes, payment FROM tracker where emailaddy='$EMail'";
$insert = MYSQL_QUERY($query);
$number = MYSQL_NUMROWS($insert);
}

$number = MYSQL_NUMROWS($insert);

if($number != 0) {

$i = 0;
$ordernumber = mysql_result($insert,$i,"ordernumber");
(variables set up)
}
?>

<?php

if ($number != 0) {
while ($myrow = mysql_fetch_array($insert)) {
echo ("bunch of display ****");
}
}

?>

It is returning $number as zero, or not at all, even though there is definitely a valid entry. Any obvious errors?