phpbar.de logo

Mailinglisten-Archive

AW: nocheinmal volltextsuche

AW: nocheinmal volltextsuche

Schneeweiß mysql_(at)_lists.phpcenter.de
Mon, 9 Apr 2001 21:42:55 +0200


------ =_NextPart_000_01C0C13E.0A4808C0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

$sql=3D"select * from enummern WHERE bezeichnung like=20
'%$bezeichnung%' or enr like '%$bezeichnung%' or art like=20
'%$bezeichnung%' or name like '%$bezeichnung%' and=20
beschreibung like '%$bezeichnung%' limit=20
$Anfangsposition,$Zeilen_pro_Seite";


dein AND in den select wird den fehler verursachen, sonst muss das =
gew=FCnschte herauskommen - allerdings nur "ein" suchwort.
Falko
------ =_NextPart_000_01C0C13E.0A4808C0
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IjkTAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAMAEAAAEAAAANAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAASwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAG15c3FsLWRlQGxpc3Rz
LjR0Mi5jb20AU01UUABteXNxbC1kZUBsaXN0cy40dDIuY29tAAAeAAIwAQAAAAUAAABTTVRQAAAA
AB4AAzABAAAAFwAAAG15c3FsLWRlQGxpc3RzLjR0Mi5jb20AAAMAFQwBAAAAAwD+DwYAAAAeAAEw
AQAAABkAAAAnbXlzcWwtZGVAbGlzdHMuNHQyLmNvbScAAAAAAgELMAEAAAAcAAAAU01UUDpNWVNR
TC1ERUBMSVNUUy40VDIuQ09NAAMAADkAAAAACwBAOgEAAAADAHE6AAAAAAIB9g8BAAAABAAAAAAA
AALwNgEEgAEAHQAAAEFXOiBub2NoZWlubWFsIHZvbGx0ZXh0c3VjaGUAygoBBYADAA4AAADRBwQA
CQAVACoANwABAFwBASCAAwAOAAAA0QcEAAkAFQApACMAAQBHAQEJgAEAIQAAADU2MzlFNEI5RDE2
NUIzNEY4QjZGMjEyRThFMzUyN0E2AC8HAQOQBgBMAwAAEwAAAAsAIwAAAAAAAwAmAAAAAAALACkA
AAAAAAMALgAAAAAAAwA2AAAAAABAADkAwBTLRS3BwAEeAHAAAQAAAB0AAABBVzogbm9jaGVpbm1h
bCB2b2xsdGV4dHN1Y2hlAAAAAAIBcQABAAAAFgAAAAHAwS1Fw8ZVo2iDq0+jk3M7UCLkv4YAAB4A
HgwBAAAABQAAAFNNVFAAAAAAHgAfDAEAAAAZAAAAZnNjaG5lZXdlaXNzQHQtb25saW5lLmRlAAAA
AAMABhBLoo/DAwAHEDYBAAAeAAgQAQAAAGUAAAAkU1FMPSJTRUxFQ1QqRlJPTUVOVU1NRVJOV0hF
UkVCRVpFSUNITlVOR0xJS0UlJEJFWkVJQ0hOVU5HJU9SRU5STElLRSUkQkVaRUlDSE5VTkclT1JB
UlRMSUtFJSRCRVpFSUNIAAAAAAIBCRABAAAAvAEAALgBAADNAgAATFpGdZzL0gADAAoAcmNwZzEy
Nf4yAP8CBgKkA+QF6wKDAFATA1QCAGNoCsBzZXT+MgYABsMCgw5QA9UHEwKDRjMDxQIAcHJxEuJz
qHRlbQKDNBPNfQqA2wjPCdk7GF8OMDUCgAqByw5xC2BuDhAwMwBQCwoDFoIB0CAkc3FsPZoiErBs
BZAFQCogA1IyIAnwdW0HgAShV0gARVJFIGJlemUNDeBoHlAbYCBsaWtEZSAKhSclJB85JfwnIAWx
CfAFwB/zIL8Fsc8KwAVAH/8hDW5hB4AiL7shZABwZCRGHzAE8GgYYJxpYh+3Jq8kAG1pBUAhCoUk
QW5mG1FzcBJvAJB0aQIgLCRakx9gHYBuXxWAb18GYPEqwGUiOwqPC5ETsgwBfmMAQCRGLaUOcAuA
FDBO/EQgMJEOcAOgHWUD8AsgsTEjZmVoHYAFwHYEkNUIcHMA0GgJ8CwxYAIgkRXwIG11BBFkYQQg
8mcH0FwnEmAAgBJwFgDSIDNgcmE0IGsDcAeA1QOgLSOwbDKhZAuAK8BTJfAIcCAiMIEiMWB11RJw
dxgBLi2lRgdANeALLaUXgQA5wAMAEBAAAAAAAwAREAAAAABAAAcwACNcFi3BwAFAAAgwACNcFi3B
wAEeAD0AAQAAAAUAAABBVzogAAAAAPPX

------ =_NextPart_000_01C0C13E.0A4808C0--

---
*** Weitere Infos zur Mailingliste und MySQL unter http://www.4t2.com/mysql 



php::bar PHP Wiki   -   Listenarchive