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 Link to comment https://forums.phpfreaks.com/topic/111688-php-mysql-problem/ 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; Link to comment https://forums.phpfreaks.com/topic/111688-php-mysql-problem/#findComment-573285 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 Link to comment https://forums.phpfreaks.com/topic/111688-php-mysql-problem/#findComment-573292 Share on other sites More sharing options...
revraz Posted June 24, 2008 Share Posted June 24, 2008 Doesn't really help. Link to comment https://forums.phpfreaks.com/topic/111688-php-mysql-problem/#findComment-573377 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.