max_w1 Posted February 1, 2008 Share Posted February 1, 2008 i have a page which displayes the users image form the database.. i know the sql query for this buy it is not working!! can anyone help me pleeeese.... the code i am using is: $a = mysql_query ("SELECT `avatar` FROM `users` WHERE `username` = '$welcome'") or die(mysql_error()); print " $a "; but the output i am getting is: Resource id #7 Link to comment https://forums.phpfreaks.com/topic/88934-solved-problem-with-displaying-record/ Share on other sites More sharing options...
Illusion Posted February 1, 2008 Share Posted February 1, 2008 You need to use mysql functions in PHP to fetch the results. like mysql_fetch_assoc() Link to comment https://forums.phpfreaks.com/topic/88934-solved-problem-with-displaying-record/#findComment-455516 Share on other sites More sharing options...
max_w1 Posted February 1, 2008 Author Share Posted February 1, 2008 how do i use that ???? can you give me an example??? Link to comment https://forums.phpfreaks.com/topic/88934-solved-problem-with-displaying-record/#findComment-455521 Share on other sites More sharing options...
rhodesa Posted February 1, 2008 Share Posted February 1, 2008 <?php $result = mysql_query ("SELECT `avatar` FROM `users` WHERE `username` = '$welcome'") or die(mysql_error()); $user = mysql_fetch_assoc($result); print $user['avatar']; ?> Link to comment https://forums.phpfreaks.com/topic/88934-solved-problem-with-displaying-record/#findComment-455527 Share on other sites More sharing options...
max_w1 Posted February 1, 2008 Author Share Posted February 1, 2008 yes!!! i finally sorted out the problem; i had actually mentioned $welcome veriable below the Sql query thats why it was not reading any info... Link to comment https://forums.phpfreaks.com/topic/88934-solved-problem-with-displaying-record/#findComment-455529 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.