paulman888888 Posted June 24, 2008 Share Posted June 24, 2008 can someone please help make a script that will echo the ipaddress which is same to the gameid. eg http://somewhere.com/index.php?gameid=21 i would like it to find the gameid in mysql table and echo the ipaddress. Thankyou for all the help Paul Quote Link to comment Share on other sites More sharing options...
revraz Posted June 24, 2008 Share Posted June 24, 2008 Not without seeing your table structure. But you'll do something like SELECT `ipaddress` FROM `table` WHERE `gameid`= $gameid; Quote Link to comment Share on other sites More sharing options...
paulman888888 Posted June 24, 2008 Author Share Posted June 24, 2008 this is one i used for my table format but i would like it to echo the ipaddress only. this is one of my scripts <html> <center> <?php $result = mysql_query("SELECT * FROM intobattle1 ORDER BY id DESC") or die('O no. Theres an error'); echo "<table border='1'>"; echo "<tr><th>Game ID</strong></th><th><strong>Name</strong></th><th><strong>Date Started</strong></th><th><strong>Time Started</strong></th><th><strong>Current Players</strong></th></tr>"; // keeps getting the next row until there are no more to get while($row = mysql_fetch_array( $result )) { // Print out the contents of each row into a table echo "<tr>\n"; echo "<td>".$row['id']."</td>\n"; echo "<td>".$row['name']."</td>\n"; echo "<td>".$row['thedate']."</td>\n"; echo "<td>".$row['thetime']."</td>\n"; echo "<td>".$row['players']."</td>\n"; echo "</tr>\n"; } echo "</table>"; ?> </center> </html> I didn't atemt to make a new file because i though that everything would have to change. Thankyou all paul Quote Link to comment Share on other sites More sharing options...
revraz Posted June 24, 2008 Share Posted June 24, 2008 Doesn't really help. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.