$sql = "SELECT branch_name FROM LOCATION"; $res = mysql_query($sql); // doing this will give you an assoc array for EACH row while ($row = mysql_fetch_array($res)) { print $row["branch_name"] . "<br />\n"; } hth -- Darren Beale Freelance Web Developer Office: 0121 288 7197 Mobile: 07711 716 197 Skype: darren.beale http://www.siftware.co.uk