pulling from two tables in db to two tables in php question

From: Date: Wed, 28 Jan 2004 05:17:51 +0000
Subject: pulling from two tables in db to two tables in php question
Groups: php.lang 
Request: Send a blank email to [email protected] to get a copy of this message 
What I need to do is this, I want to take the information from $i[3] in
table links and put it where $i[4] is in the table users. Basically, I query
the first table for some info, but to make the second table look pretty, I'd
like to use the info from $i[3] in place of the info I get from $i[4]. Does
this make sense? Here is my code:

#query the db
$query = "SELECT * FROM links ORDER BY ID";
$result = mysql_query($query)
or die(mysql_error());

#display column titles
echo "<table border align=center>";
echo "<tr>";
echo
"<td><center><small><b>Admin</b></small></td>";
echo
"<td><center><small><b>ID</b></small></td>";
echo
"<td><center><small><b>LINK</b></small></td>";
echo
"<td><center><small><b>CODE</b></small></td>";
echo "</tr>";

#display results
while($i = mysql_fetch_row($result)) {
echo "<tr>";
echo "<td><small><a href="/?originalUrl=https%3A%2F%2Fnews-web.php.net%2Fsearch.php%3FID%3D%26quot%3B%2C%24i%5B0%5D%2C%26quot%3B%26gt%3Bedit%26lt%3B%2Fa%26gt%3B%2520%7C%26quot%3B%3Becho%2520%26quot%3B%26lt%3Bahref%3Ddelete.php%3FID%3D%26quot%3B%2C%24i%5B0%5D%2C%26quot%3B%26gt%3Bdelete%26lt%3B%2Fa%26gt%3B%26lt%3B%2Fsmall%26gt%3B%26lt%3B%2Ftd%26gt%3B%26quot%3B%3Becho%2520%26quot%3B%26lt%3Btd%26gt%3B%26lt%3Bsmall%26gt%3B%26lt%3Bcenter%26gt%3B%26quot%3B%2C%2520%24i%5B0%5D%2C%26quot%3B%26lt%3B%2Fsmall%26gt%3B%26lt%3B%2Ftd%26gt%3B%26quot%3B%3Becho%2520%26quot%3B%26lt%3Btd%26gt%3B%26lt%3Bsmall%26gt%3B%26lt%3Bcenter%26gt%3B%26lt%3Ba%2520href%3D%26quot%3B%2C%24i%5B1%5D%2C%26quot%3B%26gt%3B%26quot%3B%2C%2520%24i%5B3%5D%2C%26quot%3B%26lt%3B%2Fa%26gt%3B%26lt%3B%2Fsmall%26gt%3B%26lt%3B%2Ftd%26gt%3B%26quot%3B%3Becho%2520%26quot%3B%26lt%3Btd%26gt%3B%26lt%3Bsmall%26gt%3B%26amp%3Blt%3Ba%2520href%3D%5C%26quot%3B%253Cahref%3D"http://www.vjg.cc/mylinks/link.php?un=%n&ln=",">http://www.vjg.cc/mylinks/link.php?un=%n&ln=",
$i[0], "\"&gt;", $i[2], "&lt;/a&gt;</small>";
echo "</tr>";
}
echo "</table><br>";

#query the db
$query = "SELECT * FROM users ORDER BY ID DESC";
$result = mysql_query($query)
or die(mysql_error());

#display column titles
echo "<table border align=center>";
echo "<tr>";
echo
"<td><center><small><b>Admin</b></small></td>";
echo
"<td><small><center><b>ID</b></small></td>";
echo
"<td><small><center><b>USERNAME</b></small></td>";
echo
"<td><small><center><b>LINK</b></small></td>";
echo
"<td><small><center><b>Date/Time</b></small></td>";
echo "</tr>";

#display results
while($i = mysql_fetch_row($result)) {
echo "<tr>";
echo "<td><small><a
href="/?originalUrl=https%3A%2F%2Fnews-web.php.net%2Fdeleteuser.php%3FID%3D%26quot%3B%2C%24i%5B0%5D%2C%26quot%3B%26gt%3Bdelete%26lt%3B%2Fa%26gt%3B%26lt%3B%2Fsmall%26gt%3B%26lt%3B%2Ftd%26gt%3B%26quot%3B%3Becho%2520%26quot%3B%26lt%3Btd%26gt%3B%26lt%3Bsmall%26gt%3B%26lt%3Bcenter%26gt%3B%26quot%3B%2C%2520%24i%5B0%5D%2C%26quot%3B%26lt%3B%2Fsmall%26gt%3B%26lt%3B%2Ftd%26gt%3B%26quot%3B%3Becho%2520%26quot%3B%26lt%3Btd%26gt%3B%26lt%3Bsmall%26gt%3B%26lt%3Bcenter%26gt%3B%26quot%3B%2C%2520%24i%5B1%5D%2C%26quot%3B%26lt%3B%2Fsmall%26gt%3B%26lt%3B%2Ftd%26gt%3B%26quot%3B%3Becho%2520%26quot%3B%26lt%3Btd%26gt%3B%26lt%3Bsmall%26gt%3B%26lt%3Bcenter%26gt%3B%26lt%3Ba%2520href%3D%5C%26quot%3B%26quot%3B%2C%2520%24i%5B2%5D%2C%2520%26quot%3B%5C%26quot%3Btarget%3D%5C%26quot%3B_blank%5C%26quot%3B%26gt%3BLink%2520ID%23%26quot%3B%2C%2520%24i%5B4%5D%2C%2520%26quot%3B%26lt%3B%2Fa%26gt%3B%26lt%3B%2Fsmall%26gt%3B%26lt%3B%2Ftd%26gt%3B%26quot%3B%3Becho%2520%26quot%3B%26lt%3Btd%26gt%3B%26lt%3Bsmall%26gt%3B%26lt%3Bcenter%26gt%3B%26quot%3B%2C%2520%24i%5B3%5D%2C%26quot%3B%26lt%3B%2Fsmall%26gt%3B%26lt%3B%2Ftd%26gt%3B%26quot%3B%3Becho%2520%26quot%3B%26lt%3B%2Ftr%26gt%3B%26quot%3B%3B%7Decho%2520%26quot%3B%26lt%3B%2Ftable%26gt%3B%26quot%3B%3B%253Cbr">

Thread (1 message)

  • Vinny Gullotta
« previous php.lang (#549) next »