How to validate variables from previous loop?



Here’s the problem:

I am selecting records in the MySQL db and outputing to the page.

You’ll find a screenshot of some data in my saved_alerts table at

Now, I want to display the data from the user “gzeus” to the page. Doing a while endoffile loop works great. However I want to display each field of every record with gzeus username with the same title just once not 3 times, like this:

mode, type, state, suburb, bedsmin, bedsmax, pricemin, pricemax

QLD 2-4
buy, house, QLD, arundel, helensvale, elanora, 2, 4, 100000, 400000


QLD 2-4
buy, house, QLD, arundel, 2, 4, 100000, 400000

QLD 2-4
buy, house, QLD, helensvale, 2, 4, 100000, 400000

QLD 2-4
buy, house, QLD, elanora, 2, 4, 100000, 400000

Here’s the code I have now. It outputs like the last example here, row by row. Again, how can I make it select the records that have the same username AND the same Title and output them in one line like the first example? Any ideas?



$query = (“SELECT * FROM savedalerts WHERE user_ID = ‘$total_user’”);

Connect to Mysql, select the correct database

$conn = mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());

$result = mysql_query($query);

get the number of hits, i.e. rows returned

$number_rows = mysql_num_rows($result);

if ($number_rows == 0) # if no alerts are present for this user
echo “You have not setup any property alerts yet.
Would you like to do so now?”;
echo “
Setup a new alert”;
else # if there are alerts extract them from the db and display them
while ($i < $number_rows) # while($row = mysql_fetch_array($result))
$title_alert = mysql_result($result,$i,“Title”);
$mode_alert = mysql_result($result,$i,“mode”);
$type_alert = mysql_result($result,$i,“type”);
$state_alert = mysql_result($result,$i,“state”);
$suburb_alert = mysql_result($result,$i,“suburb”);
$bedsmin_alert = mysql_result($result,$i,“bedsmin”);
$bedsmax_alert = mysql_result($result,$i,“bedsmax”);
$pricemin_alert = mysql_result($result,$i,“pricemin”);
$pricemax_alert = mysql_result($result,$i,“pricemax”);

	echo "$title_alert<br>$mode_alert, $type_alert, $state_alert, $suburb_alert, $bedsmin_alert, $bedsmax_alert, $pricemin_alert, $pricemax_alert";


Thanks so much.


Admin Edit: Changed IMG tag to a linked URL instead of over sized image forcing scrolling.
Changed CODE tags to PHP tags for syntax highlighting and easier readability.