[quote author=kenrbnsn link=topic=99918.msg393801#msg393801 date=1152408061] You either have to return them back to the calling scope or declare them global inside your routine. I prefer to return them in an array: [code]<?php list ($fname, $lname, $dob) = chk_member(); function chk_member() { $location = "localhost"; $username = "root"; $password = "2dollarbill"; $database = "gold"; $conn = mysql_connect($location, $username, $password); if (!$conn) { die ("Could not connect to MySQL"); } mysql_select_db($database,$conn) or die ("Could not open database"); $sql = mysql_query("SELECT `memid`, `fname`, `lname` FROM `membership` WHERE `memid` = 1234567891"); $row = mysql_fetch_row($sql); return (array($row[0], $row[1], $row[3])); } ?>[/code] Ken [/quote] sweet that works, is there any way I can break up the those variables to echo them out seperatly?