mySQL query...x 2
HiJeg laver et udtræk fra min mySQL database tabel \"bruger_post\", hvor jeg får et ID men jeg vil bruge det ide til at få et navn fra en anden tabel \"bruger_profil\".
Der hvor der skal stå et navn er: {$row[\"til_Id\"]}
Min kode:
<?
include(\"templates/config.phtml\");
$filename=\"templates/udbakke_top.tpl\";
$fp = fopen($filename, \"r\");
$content = fread( $fp, filesize( $filename ));
fclose( $fp );
$res = mysql_query(\"SELECT * FROM bruger_post where fra_Id = \'$userid\' order by dato ASC\");
if ($slet == 1)
{
$res1 = mysql_query(\"DELETE FROM bruger_post, brugere where post_Id = \'$post_Id\' \");
$res = mysql_query(\"SELECT * FROM bruger_post where fra_Id = \'$userid\' order by dato ASC\");
}
while($row = mysql_fetch_array($res))
{
$content = $content . \"
<table width=440 border=0 cellspacing=0 cellpadding=0>
<tr>
<td align=center>
<table width=440 border=0 cellspacing=1 cellpadding=0>
<tr bgcolor=#FFCC66>
<td width=105 bgcolor=#FFCC66 align=left>
<p> <a href=se_profil.phtml?giverId={$row[\"til_Id\"]}>{$row[\"til_Id\"]}12</a></p>
</td>
<td width=15 bgcolor=#FFCC66 align=center>
<p> {$row[\"laest\"]}</p>
</td>
<td bgcolor=#FFCC66 align=left>
<p> <a href=show_post.phtml?post={$row[\"post_Id\"]}>{$row[\"emne\"]}</a></p>
</td>
<td width=125 bgcolor=#FFCC66 align=left>
<p> {$row[\"dato\"]}</p>
</td>
<td width=40 align=center>
<p><b><a href=\" . $PHP_SELF . \"?slet=1&post_Id=\" . $row[\"post_Id\"] . \">SLET</a></b></p>
</td>
</tr>
</table></td>
</tr>
</table>
\";
