<?php // Retrieve data $id = $_GET['id']; $id = stripslashes($id); $id = mysql_real_escape_string($id); if (is_numeric($id)){ $getid="SELECT first_name, last_name FROM users WHERE user_id = '$id'"; $result=mysql_query($getid) or die('<pre>' . mysql_error() . '</pre>' ); $num=mysql_numrows($result); $i=0; while ($i < $num) { $first=mysql_result($result,$i,"first_name"); $last=mysql_result($result,$i,"last_name"); echo "<pre>ID: $id<br>First name: $first<br>Surname: $last</pre>"; $i++; } } ?>