note 31713 added to function.mysql-fetch-object
| From: | matti dot schvili at semcon dot se | Date: | Thu, 01 May 2003 07:11:03 +0000 |
| Subject: | note 31713 added to function.mysql-fetch-object | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-47336@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);
?>
--
http://www.php.net/manual/en/function.mysql-fetch-object.php
http://master.php.net/manage/user-notes.php?action=edit+31713
http://master.php.net/manage/user-notes.php?action=delete+31713
http://master.php.net/manage/user-notes.php?action=reject+31713