function getthumbimagefromid($id) { $cn = connect_db(); $sql = "SELECT *,UNIX_TIMESTAMP(upload_time) as upload_time FROM `photo` WHERE id='" . $id . "'"; $link = mysql_query($sql, $cn) or die("Error : " . mysql_error()); $data = mysql_fetch_assoc($link); disconnect_db($cn); if ($data['thumb_url'] == "") { $str = get_domain_path() . "images/nophoto.gif"; } else { $str = $data['thumb_url']; } return $str; }
function getuserimage($uid) { $cn = connect_db(); $sql = "select * from `users` where userid='" . $uid . "'"; $link = mysql_query($sql, $cn) or die("Error : " . mysql_error()); $data = mysql_fetch_assoc($link); disconnect_db($cn); if ($data['photoid'] == "0") { $str = get_domain_path() . "images/nophoto.jpg"; } else { $str = getthumbimagefromid($data['photoid']); } return $str; }