BillRayDrums

Hi, I'm kinda a newbie to MySQL. I have a query that works, but am trying to now limit the results returned. Here's the query: SELECT c.avatar, c.user_id, u.id, c.cb_currentgig, u.username, u.name, c.cb_currentgig, u.usertype FROM #__comprofiler AS c, #__users AS u WHERE c.user_id = u.id AND u.usertype = 'author' AND c.confirmed = '1' AND c.approved = '1' AND c.banned = '0' AND u.block = '0' AND c.avatar NOT LIKE 'NULL' ORDER BY lastupdatedate DESC How do I make the limit work? I've tried everything that was given to me and it doesn't return anything if I add the LIMIT statement. Thanks!

Hello I'm a noob. I was tasked with setting up a site that's been prewritten. The site is basically a form that captures user's info on the frontpage. All the code is there except the ability to notify the admin upon record received. I need to write in a function that allows the admin when someone adds a record to the database. How do I go about doing this? Any help is greatly appreciated.