So far I have:
Code: Select all
$suffix = '0';
while ($check!= 'no duplicates')
{
$suffix ++;
$query = "
SELECT passenger_name
FROM passengers, journey
WHERE journey.shuttle_id = '$id'
AND journey.id = passengers.journey_id
AND passengers.passenger_name = '$name'
";
$qry_result = mysql_query($query) or die(mysql_error());
$num_rows = mysql_num_rows($qry_result);
if ($num_rows > 0) {
while($row = mysql_fetch_array($qry_result)){
$name = $row[passenger_name];}
$name .= "$suffix";
}
else {
$check = 'no duplicates';
}
}