trying to do a if function but wont work.

[digitus78]

ok im trying to get this IF command to work right so if a user doesnt have a avatar it goes to the default one but if the do it will display it.

 

$avatarinfo = mysql_query("SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,customavatar.width, customavatar.height FROM vb_user AS user LEFT JOIN vb_avatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN vb_customavatar AS customavatar ON customavatar.userid = user.userid WHERE user.userid = '$userid'");
while ($query_row=mysql_fetch_array($avatarinfo)) {

if (!$avatarinfo) {
$avatarurl= imagecreatefromgif('forums/images/avatars/noavatar.gif');
} else {
$avatarurl= imagecreatefromgif("forums/$query_row[avatarpath]");
}

}

 

any help is appreciated

[LiamProductions]

Not sure...

 

but you could give it a try:

 

$avatarinfo = mysql_query("SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,customavatar.width, customavatar.height FROM vb_user AS user LEFT JOIN vb_avatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN vb_customavatar AS customavatar ON customavatar.userid = user.userid WHERE user.userid = '$userid'");
while ($query_row=mysql_fetch_array($avatarinfo)) {

if (!$avatarinfo == "") {
$avatarurl= imagecreatefromgif('forums/images/avatars/noavatar.gif');
} else {
$avatarurl= imagecreatefromgif("forums/$query_row[avatarpath]");
}

}

[digitus78]

using that version makes it to where all users show a noavatar.gif hmmmm im confused over this one and its probably so simple.

[LiamProductions]

I thought that what you wanted if they didnt have an avartar ^o)

[digitus78]

what i was wanting is the code above calls to the DB and gets the avatar path

then the code below displays the avatar but if the the avatar path field is empty i want it to desplay the noavatar.gif

 

hope that makes sense lol

[digitus78]

fixed just took a bit of tinkering thanks for your help

 

$avatarinfo = mysql_query("SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,customavatar.width, customavatar.height FROM vb_user AS user LEFT JOIN vb_avatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN vb_customavatar AS customavatar ON customavatar.userid = user.userid WHERE user.userid = '$userid'");
while ($query_row=mysql_fetch_array($avatarinfo)) {
$avatarpat = "$query_row[avatarpath]";

if ($avatarpat == "") {
$avatarurl= imagecreatefromgif('forums/images/avatars/noavatar.gif');
} else {
$avatarurl= imagecreatefromgif("forums/$avatarpat");
}

}