[SOLVED] Multiple tables

[MySQL_Narb]

Code:

 

$get = mysql_query("SELECT * FROM posts ORDER BY id DESC LIMIT $start, $per_page");
while ($row = mysql_fetch_assoc($get))
{
// get data
$id = $row['id'];
$name = $row['name'];
$message = $row['message'];

if ($name =="$owner") {
     $name = "<img src='$acrown'></img><b> $owner<br /></b>"; }

/* smiley replacer */
        str_replace("", "<img src=\"./smilies/happy.png\" alt=\"\" />", $message);
        str_replace(array("", ""), "<img src=\"./smilies/gasp.png\" alt=\"\" />", $message);
        str_replace(array(":S", ":s"), "<img src=\"./smilies/confused.png\" alt=\"\" />", $message);
        str_replace(array("", ""), "<img src=\"./smilies/p.png\" alt=\"\" />", $message);

echo "<center><b>($id)Posted by:</b> ".$name."</a><br /><b>".$message."<hr></b>";

}

 

Now, I also want to go to the table users and not just posts, how would I do it? To check the user account, and see if they are staff.

[MySQL_Narb]

PLEASE LOOK AT THE NEW CODE

 

<?php session_start(); ?>
<?php require "global_settings.php"; ?>
<title><?php echo $sitetitle; ?></title>
<font face='arial' size='2'></a>
<center>
<style>
a:link {
color:#24374C;
text-decoration:none;
}

a:visited {
color:#24374C;
text-decoration:none;
}

a:active {
outline: none;
color:#24374C;
text-decoration:none;
}

body {background-color:#b0c4de}

div.box {
width:250px;
padding:10px;
border:3px double #000000;
margin:10px;
background-color:#74AFF2;
}

p
{
border-top-style:dotted;
border-right-style:solid;
border-bottom-style:dotted;
border-left-style:solid;
}

div.menu-blue {



BORDER-RIGHT: #333366 1px solid;



BORDER-LEFT: #6699cc 1px solid;



BORDER-TOP: #6699cc 1px solid;



BORDER-BOTTOM: #333366 1px solid;



FONT-WEIGHT: normal;






COLOR: #ffffff;






BACKGROUND-COLOR: #23559C;



TEXT-DECORATION: none;



font-stretch : condensed;
}

.menu-top  {



BORDER-RIGHT: 1px solid #333366; BORDER-TOP: 1px solid #6699CC; FONT-WEIGHT: normal; BORDER-LEFT: 1px solid #6699CC; COLOR: #FFFFFF; BORDER-BOTTOM: 1px solid #333366; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif; BACKGROUND-COLOR: #23559C; TEXT-DECORATION: none;



font-stretch : condensed
}
</style>
<center>
<div class='menu-blue'>
<div align="center"> 
<table width="600" cellspacing="1" cellpadding="5" style="background-color:#23559C"> 
<tr> 
<td style="background-color:#FFFFFF"> 





    <div align="center"> 
    <table border="0"> 
    
    </form> 
    </table>

<p><a href="register.php"><img src="images/register.png"></img></a> <a href='login.php'><img src="images/log-in.png"></img></a> <a href="logout.php"><img src="images/logout.png"></img></a> <a href='search_input.php'><img src="images/search.png"></a> <a href="verification.php"><img src="images/demoacp.png"></img></a> <a href="profiles.php"><img src="images/profile.png"></a> <a href="ucp.php"><img src="images/UCP.png"></img></a></b></p>
<a href='http://www.strong-hold.net/forums/'><h3>Visit Strong-Hold</h3></a>
<?php
$count_my_page = ("hitcounter.txt");
$hits = file($count_my_page);
$hits[0] ++;
$fp = fopen($count_my_page , "w");
fputs($fp , "$hits[0]");
fclose($fp);
echo $hits[0];
?>
<br />
<?php 

if ($disabled==0) {
echo '<form action="post.php" method="POST"><div class="box">
Message <br><br><textarea name="message" rows="10">

</textarea><br>
<input type="submit" value="Post it!">
</form></center></span><hr>
<br>';
}
else {
   echo "<div class='box'>Posting disabled!</div>";
}

require "global_settings.php";

//connecting to the database
$connect = mysql_connect("$dbhost","$dbuser","$dbpassword") or die("Connection failed!");
mysql_select_db("$db") or die("Database fail!");

//max displayed per page
$per_page = 8;

//get start variable
$start = $_GET['start'];

//count records
$record_count = mysql_num_rows(mysql_query("SELECT * FROM posts"));

//count max pages
$max_pages = $record_count / $per_page; //may come out as decimal

if (!$start)
   $start = 0;
   
//display data
$get = mysql_query("SELECT * FROM posts ORDER BY id DESC LIMIT $start, $per_page");
while ($row = mysql_fetch_assoc($get))

{
// get data
$id = $row['id'];
$name = $row['name'];
$message = $row['message'];


//extract
$extract = mysql_query("SELECT * FROM users WHERE username='$name'");
$numrows = mysql_num_rows($extract);

while ($tr = mysql_fetch_assoc($extract))

{
       $sc = $tr[id]; 
}

if ($sc==2) {
    $name = " <img src='crown_gold.gif'></img><b> $name</b>";
}

/* smiley replacer */
        str_replace("", "<img src=\"./smilies/happy.png\" alt=\"\" />", $message);
        str_replace(array("", ""), "<img src=\"./smilies/gasp.png\" alt=\"\" />", $message);
        str_replace(array(":S", ":s"), "<img src=\"./smilies/confused.png\" alt=\"\" />", $message);
        str_replace(array("", ""), "<img src=\"./smilies/p.png\" alt=\"\" />", $message);

echo "<center><b>($id)Posted by:</b> ".$name."</a><br /><b>".$message."<hr></b>";

}

//setup prev and next variables
$prev = $start - $per_page;
$next = $start + $per_page;

//show prev button
if (!($start<=0))
       echo "<a href='bbdemo.php?start=$prev'>Prev</a> ";

//show page numbers

//set variable for first page
$i=1;

for ($x=0;$x<$record_count;$x=$x+$per_page)
{
if ($start!=$x)
    echo " <a href='bbdemo.php?start=$x'>$i</a> ";
else
    echo " <a href='bbdemo.php?start=$x'><b>$i</b></a> ";
$i++;
}

//show next button
if (!($start>=$record_count-$per_page))
       echo " <a href='bbdemo.php?start=$next'>Next</a>";

?>

 

Now tell me, why isn't it working?