i'm having trouble showing all the information that im pulling from mysql database with this array. this is a lot of code but i hope you can follow it. I want to show First Name and Last Name, and URL, but the array only shows the FIRST name and not both

// this is the first functionfunction get_user_urls($username){ //extract from the database all the URLs this user has stored if (!($conn = dbconnect())) return false; $result = mysql_query( "select usrfname, usrlname, usrurls from usrinfo where username = '$username'"); if (!$result) return false;

In this code you are basically saying "use column 1 of the database and store it in the array. Column 1 is first, if you were using mysql_fetch_array or mysql_fetch_assoc then you would've had $url_array[$count] = addslashes($row['firstname']). If you want to have a full result array then I think this is what you should do.