---
title: "Random med flera villkor"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/165660-random-med-flera-villkor"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Nova"
published: "2007-10-20T10:59:01.000Z"
updated: "2007-10-21T12:03:56.000Z"
replies: 1
views: 246
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/165660-random-med-flera-villkor"
---

# Random med flera villkor

## #1 — Nova, 2007-10-20T10:59Z

Den här frågan tar ut de 25 nyaste produkterna (Mysql, php) 

```
$wt_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by products_date_added desc limit " . 25);
```

 
Men jag skulle vilja kunna sortera resultatet en gång till typ ORDER BY RAND() LIMIT 4. Jag får inte till det.

Permalänk: https://www.webforum.nu/p/165660

## #2 — Nova, 2007-10-21T12:03Z

Tänkte lite galet där, det är ju enklare att sätta ena villkoret i "where" kommandot.

```
  $wt_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and p.products_date_added >= date_add(curdate(), interval -1 month) and pd.language_id = '" . (int)$languages_id . "'  order by  RAND() limit " . 4);
```

Permalänk: https://www.webforum.nu/p/2043347

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/165660-random-med-flera-villkor