note 31713 rejected from function.mysql-fetch-object by spic
| From: | spic@php.net | Date: | Thu, 01 May 2003 07:49:12 +0000 |
| Subject: | note 31713 rejected from function.mysql-fetch-object by spic | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-47337@lists.php.net to get a copy of this message | ||
Does anyone know how to make this work with a JOIN? You can see a used two tables but how do I
change the line "while ($guestbookDb = mysql_fetch_object ($res))" ?
$sql="SELECT member.user ,guestbook.email ,guestbook.url ,guestbook.date ,guestbook.comments
FROM guestbook INNER JOIN member ON guestbook.name = member.id ORDER BY date DESC";
$res=mysql_query($sql, $ezine_db);
while ($guestbookDb = mysql_fetch_object ($res))
{
print "<b>Namn: </b>$memberDb->user<br>";
if ($guestbookDb->email != "")
{
print "<b>Epost: </b>$guestbookDb->email<br>";
}
if ($guestbookDb->url != "")
{
print "<b>Hemsida: </b>$guestbookDb->url<br>";
}
if ($guestbookDb->date != "")
{
print "<b>Skickat: </b>$guestbookDb->date<br>";
}
if ($guestbookDb->comments != "")
{
print "<i>$guestbookDb->comments</i><br><br><br>";
}
}
mysql_free_result ($res);
?>