The Joomla! Forum™

Iv taken a bit of time and have managed to get it working but im having a little trouble with the HTML inside the echo command. How would I change it so that it will be displayed with the avator on the right and title to the left and username under the avator image. $query = "SELECT c.id, c.title, c...

Tried it,  all it changed was the error message to this : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'22:35:43) AND ( publish_down = \'0000-00-00 00:00:00\' OR publish SQL=SELECT c.id, c.title, c.created...

Okey this is how I think I could implement the code but im still getting the above sql syntax error. $query = "SELECT id FROM #__menu WHERE link='index.php?option=com_mamblog'"; $database->setQuery($query); $Itemid = $database->LoadResult(); $query = 'SELECT c.id, c.title, c.created_by, u.username, ...

LOL sorry I get it  The dot has worked Now I just need to figure out the foreach part. getting this but im guessing thats because the foreach part of the code is nots setup yet. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right sy...

now getting this error

Parse error: parse error, unexpected '[' in W:\www\joomlaplazza\modules\mod_mamblog_latest.php on line 30

getting the following error


Parse error: parse error, unexpected T_INT_CAST in
mod_mamblog_latest.php on line 30

ok I know i need to incorporate this into the query : SELECT avatar, avatarapproved FROM #__comprofiler WHERE id =

But i cant get the sql syntax to work. Ill obviously need some kind of IF statement in their to determine if the avator is approved or not.

Yeah I did look at the code in that module before asking, I looked at a couple of different modules doing similar things, Most of them were missing an important function. They were simply calling up the avator they were not taking into account if the avator had been approved or not. So even if the m...

Hey man sorry to bother you again but I just thought id ask  . You would'nt happen know how to call up the cb avator and display it as a little thumbnail next to posts?

Thanx alot man works perfectly 

Okey this the HTML: