Mailinglisten-Archive |
Danke fuer die hilfe junx :-)
Beste Grüße aus Sinzig,
Alexander Meis
pixelhouse media service
----------------------------------------------------------------
- Barbarossastraße 36 - 53489 Sinzig
- Tel: 02642-980330 - Fax: 02642-980215
- Internet: http://www.pixelhouse.de
-----------------------------------------------------------------
>-----Original Message-----
>From: php-admin_(at)_solix.wiso.Uni-Koeln.DE
>[mailto:php-admin_(at)_solix.wiso.Uni-Koeln.DE]On Behalf Of Axel Tietje
>Sent: Donnerstag, 25. März 1999 10:28
>To: php_(at)_solix.wiso.Uni-Koeln.DE
>Subject: Re: [php] besser suchen ?
>
>
>Hi,
>
>mein Vorschlag (nicht getestet):
>
>--snip--
>
>$suche .= $suche2 ;
>
>switch ($suche) {
> case 0: $q = "Titel like '%$name%' or $wo like '%$name%'"; break;
> case 1: $q = "Titel like '%$name%'"; break;
> case 2: $q = "Kata like '%$name%'"; break;
> case 3: $q = "Titel like '%$name%' or Kata like '%$name%'"; break;
>}
>
>$query = "SELECT * FROM $userstable WHERE " . $q . " order by Titel
>LIMIT $offset,$maxrows"
>$query1 = "SELECT * FROM $userstable WHERE " . $q . " order by Titel"
>
>--snap--
>
>Gruß, Axel.
>
>a.tietje_(at)_flynet.de
>--------------------------------------------------
> Source code equals power. Source code is sacred.
> Trust nobody...
>
> From: Software Developers Combat Manual
>--------------------------------------------------
>
>
>--
>Web-Seite: http://infosoc.uni-koeln.de/php/
>Listenadresse: php_(at)_infosoc.uni-koeln.de
>http://infosoc.uni-koeln.de/mailman/listinfo/php
>
php::bar PHP Wiki - Listenarchive