---
title: "Selecta i en loop?"
type: "forum-thread"
url: "https://www.webforum.nu/amne/php/15456-selecta-i-en-loop"
topic: "PHP"
topic_url: "https://www.webforum.nu/amne/php"
author: "mikaeled"
published: "2001-03-29T19:53:00.000Z"
updated: "2001-03-29T22:20:00.000Z"
replies: 1
views: 151
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/php/15456-selecta-i-en-loop"
---

# Selecta i en loop?

## #1 — mikaeled, 2001-03-29T19:53Z

Hej,

Så här skriver jag: 

$res2=mysql_query("select date from header WHERE id='$id' AND number='$number' ORDER by date DESC limit 0,10");
while($row2=mysql_fetch_array($res2, MYSQL_ASSOC))
{

$res2=mysql_query("select message from mess WHERE user='$id' AND number='$number' and date='$row2\[date\]'");
while($row2=mysql_fetch_array($res2, MYSQL_ASSOC))
echo "message: $row2\[message\]";
}

men det skrivs inte ut någonting. vad är fel?

Mikael

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

## #2 — haard, 2001-03-29T22:20Z

Såhär hade jag gjort iaf... 

\<?

$res1 = "SELECT date from header WHERE id = '$id' AND number = '$number' ORDER BY date DESC LIMIT 0,10";
$query1 = mysql_query($res1, $databas_connection)
or die("Funka inte 1");
while ($row1 = mysql_fetch_array($query1))
{

	$date =	$row1\['date'\];

$res2 = "SELECT message from mess WHERE user = '$id' AND number = '$number' AND date = '$date'";
$query2 = mysql_query($res2, $databas_connection)
or die("Funka inte 2");
while ($row2 = mysql_fetch_array($query2))

{

$message = $row2\['message'\];

echo "Message: $message";

}
}

?\>

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

---

Tråden på webben: https://www.webforum.nu/amne/php/15456-selecta-i-en-loop