> Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > Hi! > > Probably an easy problem, but I couldn't find any solution on the > net.. > > > I have (about) this code: > "select * from tabell1 > where page regexp '$page' > and published is not null > order by pri desc, published desc > limit $this->fra, $this->ant" > > Then, I want to join another table who is has the same structure as > this one, except it has an extra row. > > I then tried this: > > "select * from tabell1, tabell2 > where tabell1.temaid = '$this->temaid' > and tabell2.temaid = '$this->temaid' > order by $this->tabell.pri desc, $this->tabell.published > desc > limit $this->fra, $this->ant" > > But then I got the same stories in this to tables a lot of times. > > What is wrong? > How do i do this right? > (a link to a page with a solution would bee fine). > > Henrik > > > > >
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php