[INNER JOIN problem]

Psycho,

Thanks a lot! Thats works perfectly

[INNER JOIN problem]

Hello guys. Thanks a lot for any help with this.

My problem is that I'm trying to use MAX to get the last item in the portafolio table. This is my query:

$result = $db->prepare( "SELECT * FROM portafolio INNER JOIN imagenes ON imagenes.work = portafolio.idp WHERE work = ? ORDER BY iid DESC);
$result->execute(array($_GET['work']));

The main idea is not use $_GET['work'], because i want to display the last work (with their respective images) in my portafolio in the main page, so im not passing any variable by url.