I dunno if anybody is familiar with LDU Seditio engine but i need help writing a short code.

i need a SQL & PHP code that will search the DB

PHP Code:

$SQL = Search db for user avatar and uder ID #

$results = user avarat = user id number

($row = mysql_fetch_array($results)) 


i know nothing about the code above is corrent except the concept which is my point. as long as u get what im tryin to do ive done my job lol.

so i want to search the db and match a user id or name with thats users Avatar and then display it on the page. via something like this

PHP Code:

$Buddies .= "<img src=\"$avatar\"> "; ($avatar = url) so its ok to do it that way
$buddies .= " ".sed_build_user($row["buddies_buddyid"], stripslashes($row["buddies_buddyname"]));
$buddies .= " "; 


i know i need to use the LEFT JOIN statement but i dunno how to get that implemented

anybody help is appreciated

I don't understand what you mean. But a basic MySQL search is done like so

SELECT * FROM table WHERE field LIKE 'value'

You can add % as a wildcard, as in

'%value' to search for entries that ends with value
'value%' to search for entries that starts with value
'%value%' to search for entries that contains value