Stalingrad Posted October 2, 2012 Share Posted October 2, 2012 Hey there. I will try my best not to confuse anybody here, lol! Okay, so.. I am trying to grab from multiple tables. I am involving 3 different tables here: trades, uitems, and items. Those are the three tables I am involving in the problem I am having. Keep those three tables in mind. I will post the code below. What I am trying to do is display all of the items from the trades table. I have 7 field names in the row (the names are: item1 - item7). I can onlyfigure out how to grab one of them, so I grabbed item1, which was the first one. There are other field names in the trades table, but I can grab those fine. The reason I am having trouble here, is because I need to get the data on what the item1 - item7 are from the other tables (uitems and items). Get my drift? Probably not. :s The items table has information on the item1 - item7. Since item1 - item7 are most likely all different, but they CAN be the same. All mixed. It depends, really. It doesn't matter. We;ll just assume item1 - item7 are all different. Here is my code: <?php session_start(); include("cofigfile.php"); ?> <html> <head> <link rel="stylesheet" type="text/css" href="style.css" /> </head> <?php if(!isset($_SESSION['username'])) { echo "<banner></banner><nav>$shownavbar</nav><ubar><a href=login.php>Login</a> or <a href=register.php>Register</a></ubar><content><center><font size=6>Error!</font><br><br>You are not Logged In! Please <a href=login.php>Login</a> or <a href=register.php>Register</a> to Continue!</center></content>"; } if(isset($_SESSION['username'])) { $view = $_GET['view']; $offers = $_GET['offers']; $create = $_GET['create']; echo "<nav>$shownavbar</nav><ubar>$ubear</ubar><content><center><font size=6>Trade Center</font><br><br>Hello there, and welcome to the Trade Center! It is advised you be careful when trading, as other users may try to scam you.<br><br><a href=trades.php>Home</a> | <a href=?create>Create a Trade</a> | <a href=?view=1>View Trades</a> | <a href=?offers>My Offers</a><br><br>"; if(isset($view)) { $per = 1; $thequer = mysql_query("SELECT COUNT(`tradeid`) FROM `trades`"); $pages = ceil(mysql_result($thequer, 0) / $per); $page = (isset($_GET['view'])) ? (int)$_GET['view'] : 1; $start = ($page - 1) * $per; $query1 = mysql_query("SELECT * FROM trades LIMIT $start, $per"); while($query = mysql_fetch_assoc($query1)) { ==============$getuitemsquery = "SELECT * FROM uitems WHERE uitemid=$query[item1]"; $uitems = mysql_query($getuitemsquery); while($i1 = mysql_fetch_array($uitems)) { $itemt1 = $i1['theitemid']; } $nowitemq = "SELECT * FROM items WHERE itemid='$itemt1'"; $nowq = mysql_query($nowitemq); while($row = mysql_fetch_array($nowq)) { $image = $row['image']; $name = $row['name']; $desc = $row['description']; $rarity = $row['rarity']; } ==============echo "<table border=1 cellpadding=1 cellspacing=0 width=305px bordercolor=black><tr><td><p>Owner: <a href=lookup.php?username=$query[user]>$query[user]</a></p></td></tr><tr><td><center><img src=images/items/$image><br>$name</center></tr></td>"; } if($pages >=1) { for ($x-1; $x<=$pages; $x++) { echo "<a href=?view=$x>$x</a> "; } } } if(isset($offers)) { echo "View Offers."; } if(isset($create)) { echo "Create a Trade."; } } ?> </html I have marked inside my code by =====----'s where the code part is for the problem I am habing so you know where to look for it. I am hoping somebody can understand my problem. I am thinking I MIGHT have to use an array, or whatever it is called? Thank you for your help and time. =] Link to comment https://forums.phpfreaks.com/topic/269007-having-trouble-grabbing-from-table-please-help-s/ Share on other sites More sharing options...
Jessica Posted October 2, 2012 Share Posted October 2, 2012 Don't run queries inside of loops! You need to use a JOIN. Link to comment https://forums.phpfreaks.com/topic/269007-having-trouble-grabbing-from-table-please-help-s/#findComment-1382282 Share on other sites More sharing options...
Stalingrad Posted October 2, 2012 Author Share Posted October 2, 2012 I don't understand that... can you please give me an example with my code and explain? Thank you. Link to comment https://forums.phpfreaks.com/topic/269007-having-trouble-grabbing-from-table-please-help-s/#findComment-1382284 Share on other sites More sharing options...
Jessica Posted October 2, 2012 Share Posted October 2, 2012 http://bit.ly/O2LNyD Link to comment https://forums.phpfreaks.com/topic/269007-having-trouble-grabbing-from-table-please-help-s/#findComment-1382286 Share on other sites More sharing options...
Stalingrad Posted October 2, 2012 Author Share Posted October 2, 2012 Okay, thank you. Link to comment https://forums.phpfreaks.com/topic/269007-having-trouble-grabbing-from-table-please-help-s/#findComment-1382287 Share on other sites More sharing options...
Barand Posted October 3, 2012 Share Posted October 3, 2012 While you are using Google, look up Data Normalization too. Link to comment https://forums.phpfreaks.com/topic/269007-having-trouble-grabbing-from-table-please-help-s/#findComment-1382520 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.