PULLIN MY HAIR OUT! stumped on $db->query_first

[Antivirus]

I have a query which works fine returning all my data using following method:
$sql = "
SELECT erc_artist.*, erc_artisttype.artisttype, MIN(erc_artistimage.artistimageid) AS artistimageid
FROM erc_artist
LEFT JOIN erc_artisttype ON erc_artist.artisttypeid = erc_artisttype.artisttypeid
LEFT JOIN erc_artistimage ON erc_artist.artistid = erc_artistimage.artistid
WHERE artistisactive = '1'
GROUP BY erc_artisttype.displayorder, artisttitle
";


But when i try to use the following $db->query_first method i get nada!
$sql = $db->query_first("
SELECT erc_artist.*, erc_artisttype.artisttype, MIN(erc_artistimage.artistimageid) AS artistimageid
FROM erc_artist
LEFT JOIN erc_artisttype ON erc_artist.artisttypeid = erc.artisttype.artisttypeid
LEFT JOIN erc_artistimage ON erc_artist.artistid = erc_artistimage.artistid
WHERE artistisactive = '1' AND erc_artistimage.image_type = 'artistpicture'
GROUP BY erc_artisttype.displayorder, artisttitle
");


Does anyone know what i am doing wrong here?

[calorie]

Try... $db->query_read($sql);

[Adrian Schneider]

$db->query_read() returns the MySQL result.

$db->query_first() returns the fetched array (and frees the MySQL result). This only works for single rows.

[Antivirus]

Thanks for the assistance Calorie & SirAdrian, the following works for me :)
I'm still getting used to vb's objects, taking me some time but persistance is my best learning aid... and the vborg community :banana:



$qryartists = $db->query_read("
SELECT erc_artist.*, erc_artisttype.artisttype, MIN(erc_artistimage.artistimageid) AS artistimageid
FROM erc_artist
LEFT JOIN erc_artisttype ON erc_artist.artisttypeid = erc_artisttype.artisttypeid
LEFT JOIN erc_artistimage ON erc_artist.artistid = erc_artistimage.artistid
WHERE artistisactive = '1'
GROUP BY erc_artisttype.displayorder, artisttitle
");