This query can sometimes draw back the whole database causing some, or all,
data that is extracted from the database to not show.

Can u experts scan through this for me?

I really need some help!
----------------------------SQL---------------------------------------------
------
SELECT DISTINCT $this->artikkeltbl.artikkelid as artikkelid,
$this->artikkeltbl.tittel as tittel,
$this->artikkeltbl.hovedingress as hovedingress,
$this->artikkeltbl.dato as dato
# Selects different parts of newsarticles: id field, date, title, toptext
and main text

FROM $this->artikkeltbl, $this->relasjonstbl
# from two different tables the article table and the relation table

WHERE $this->artikkeltbl.tittel LIKE '%$sqlx%'
OR $this->artikkeltbl.ingress LIKE '%$sqlx%'
OR $this->artikkeltbl.hovedingress LIKE '%$sqlx%'
OR $this->artikkeltbl.brodtekst LIKE '%$sqlx%'
# var $sqlx is the search string varying from page to page.

AND $this->artikkeltbl.artikkelid = $this->relasjonstbl.artikkelid
# Relation to the relation table

AND $this->relasjonstbl.portalid = $portalid
# Only selects articles within a spesific category.

ORDER by artikler.dato DESC LIMIT $x2,$x1
# u know...
----------------------------SQL---------------------------------------------
------

I have divided the website into different portions, and assigned them with
unique id`s ($portalid).
I am trying to search through articles that are only assosciated with that
spescific portalid.

What am I doing wrong?

This is meant to be a simple search utility on the page.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to