Unable to get wp_get_attachment_url to show

That’s not going to work, instead just use wp_get_attachment_image_src , it takes a size parameter.

// get the $attachment_id
$attach_stuff = wp_get_attachment_image_src( $attachment_id, 'full');
var_dump($attach_stuff);

You will be returned an array fo values to work with:

[0] => url
[1] => width
[2] => height
[3] => boolean: true if $url is a resized image, false if it is the original.

Also turn on debugging.

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)