 Hi, I'm making a few custom pages and SQL submission forms and have managed to get the user ID of the person thats created a row in to the SQL, but i want it to display the users Nickname when the results are printed instead of the user ID. i've tried getProfileInfo( $results['UserID'] ); but to no avail (the page just displays "Array"). I'm pretty new to php and cant yet get my head around arrays, if anyone can help i'd very much appreciate it! :) |
$nick = mysql_query("SELECT `NickName` FROM `Profiles` WHERE `ID` =1"); echo "$nick"; this for some reason is returning "Resource id #3" but when i run the command from within MySQL, it works fine, any ideas? |
Use function - function getNickName( $ID = '' ) its already in profiles.inc.php |
Thanks, i got it. for anyone else trying stuff similar to the bits i'm currently working on, here's how i got it working. $creator = getNickName( $results['UserID'] ); echo "$creator"; so: $creator = getNickName( 12 ); echo "$creator"; will echo the NickName of the user with the id 12 :) Thanks for your help AndreyP! |
I was looking around how can i echo the complete url of the user under the profile picture or into a block.. As lets say http://www.mysite.com/myusername I cant make it work.. anyone? |
