Looking for php coder - small job.

[vps9Ryan]

Hello guys,


I currently have this (http://codecanyon.net/item/simple-we...comments/46483) script on dynamic pages of my site.

It gives the user 2 input fields, name and comment box.

Also it has gravatar support (as avatar).

What I need doing, is since we are running;

(mysql_query('select id,username,password,email,avatar from users where username="'.$_SESSION['username'].'"')); 

is that instead of user inputs his name, it can be gotten from that query and automatically inserted, and the avatar should also be imported from the mysql.

---------------

The script is one file.

If your interested let me know.

Cheers,
Ryan

vps9Ryan Reviewed by vps9Ryan on 31st Aug 2011. Looking for php coder - small job. Hello guys, I currently have this (http://codecanyon.net/item/simple-website-comments/46483) script on dynamic pages of my site. It gives the user 2 input fields, name and comment box. Also it has gravatar support (as avatar). What I need doing, is since we are running; Rating: 5

[jokerhacker]

i think your description is not clear

[vps9Ryan]

basically

assigning $avatar (which is from the db)

into the code of the comments script.

stuff like that

[soft2050]

basically

assigning $avatar (which is from the db)

into the code of the comments script.

stuff like that

you already have select avatar in the query

Make sure you have the table for it too in mysql db

You need to use row['avatar'] to grab the details from db

[vps9Ryan]

yes, i know those

just need modifications to the code to make use of the db strings...

[jokerhacker]

it's difficult to help you without having a idea about your code and your DB, exposing them publicly is dangerous too, so pm a dev here and he should help you

[lehoangson]

I want to help you but I don't understand what you want of your post, can by my English not good.

Your mean is you want get avatar from db after use submit name? Same bellow

$username = mysql_real_escape_string($_POST['username']);
$avatar = "";
$q = mysql_query("SELECT id,username,password,email,avatar FROM users WHERE username='$username' LIMIT 1");
$t = mysql_num_rows($q);
if ($t == 1) {
    $r = mysql_fetch_array($q);
    $avatar = $r['avatar'];
}

[Loonycgb2]

        $SQL = mysql_query("SELECT * users WHERE Table='something'");
        echo mysql_error();

        while ($db_field = mysql_fetch_assoc($SQL)) {
        $name = $db_field['name'];
        $avatar = $db_field['avatar'];

        echo "$name $avatar";

I know this isnt exactly what you wanted but all im showing you is how to output information already in the table... So if you use those 2 functions in your insert table you should be able to get the name and avatar from the database..

[vps9Ryan]

Yes, it works like u say (theoretically) and even works on other scripts that way.

But it just doesnt want to work on this script

Its doing my head in

[Loonycgb2]

If not then include a function where you can call the username and avatar from anywhere like a class.. then just add the function to the mysql code