[cmoney12051]

on my website im working on implementing an avatar system, where basically users would input their avatar url and it would be saved to the mysql db and then when they login it would show the avatar but im not sure how to do it. I have a avatar row setup in my user table and have put in a test url but i cant figure out how to get it to show on the page. this is at i have so far

<?php
session_start();
require 'database.php';

$avatar = $_GET['avatar'];
$avatar = mysql_query("SELECT * FROM user WHERE avatar = '$avatar'");

if (isset($_SESSION['user'])){
echo "Welcome ".$_SESSION['user'];
echo "<img src=";
echo $avatar;
echo "></img>";
}

?>

but nothing shows up for the image. Please help

[ghqwerty]

where are you getting the 'get' data from ? i would also reccomend that you try changing the name of one of those avatar variables (i would say make the sql query called $sql or $avatar1 or something else. i think your problem might be that your overiding the variable.

id also make sure that the data in the database is correct too.

thirdly try manually making the avatar show, e.g. get the address of the avatar image and hardcode it into the html to see if it is a specific avatar image that is faulty.

[nick1200]

You should store the link of the image into the db

Have a table called user_avatars

Then have 2 collums user name and avatars

when they pick the 1 they want use my sql to fill in there user name and the link to the image e.g https://mysite.com/images/mypic.gif

Remember the https ( my site messed up because of it )

The use this bit of code to show the image

$userg      = mysql_query("SELECT * FROM user_avatars WHERE username='$myusername';")
					or die("Failed to fetch your details.");
$user       = mysql_fetch_array($userg);


<img src="http://<?php echo $user['Table_name of link to image'] ?>" width="77" height="80" />

That should work if it works can you thank me

This post has been edited by nick1200: 05 April 2010 - 12:17 PM

[cmoney12051]

well i have played with it for a while and i am still unable to get it to even read the image url i put into the database. this is what i have so far

<?php
session_start();
require 'database.php';

$username = $_GET['username'];

$userg      = mysql_query("SELECT avatar FROM user WHERE username = '$username'")

                                        or die("Failed to fetch your details.");
$user       = mysql_fetch_array($userg);


if (isset($_SESSION['user'])){
echo "Welcome ".$_SESSION['user'];
echo "<img src=";
echo $user;
echo "></img>";
echo $user;
echo $userg;

}



?>

and this is what i get

Welcome cmoney12051Resource id #3 

i just cant get this figured out

BTW: i know about the two echos at the bottom i put them there to see if i can atleast read the imge url from the db and then it puts out the Resource id #3 part

This post has been edited by cmoney12051: 05 April 2010 - 02:27 PM

[jrm402]

You are returning an array of information from the db with mysql_fetch_array.

When I want to just return one result, i.e., an avatar path, I use mysql_result($userg, '');.

Maybe this will help you in your troubles. GL

[cmoney12051]

Great! i got it, thanks guys!

<?php
session_start();
require 'database.php';

$username = $_GET['username'];

$userg      = mysql_query("SELECT avatar FROM user")

                                        or die("Failed to fetch your details.");
$user       = mysql_result($userg, '*');


if (isset($_SESSION['user'])){
echo "Welcome ".$_SESSION['user'];
echo "<img src=";
echo $user;
echo "></img>";


}



?>

[cmoney12051]

now i have to figure out how to have my users insert the image url into their mysql. Im not too good with mysql so any help would be appreciated. i just want to be able to let them insert their avatar url into their username row in the table. any help would be apreciated

[cmoney12051]

well i just realized that whenever i change users, the avatar stays the same, how do i get the avatar to change for each user that logs in? man this is getting tough

[jrm402]

What does the INSERT/UPDATE query look like? It would help us to help you if you could post the code of where you edit/save the avatar url to the database.