phpbar.de logo

Mailinglisten-Archive

[php] 2Tabellen, 1 Abfrage

[php] 2Tabellen, 1 Abfrage

Kai Meder php_(at)_phpcenter.de
Thu, 10 May 2001 01:27:33 +0200


> >   $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



php::bar PHP Wiki   -   Listenarchive