[php] 2Tabellen, 1 Abfrage

[Kai Meder]

> >   $query = "SELECT a.* , b.* from news a, auth_user b where
> > a.author=b.user_id AND $searchin LIKE '%$searchfor%' ORDER BY a.id
> > DESC LIMIT $start,$end";


fehlt da nit ein AS ?
SELECT
    a.*,
    b.*
FROM
    news AS a,
    auth_user AS b
WHERE
    a.author = b.user_id AND
    searchin LIKE '%$searchfor%'
ORDER
    BY a.id DESC
LIMIT $start,$end

-- 
Kai Meder
kai.meder_(at)_cn-media.de