A newb trying to connect to a datebase

[omgitsmewazap]

Hello people 🙂 I need some help, I'm new to coding. I've been reading on and off this website now for the past 4 days
http://www.w3schools.com/
And gradually started to pick work at little things, I made my own html page, displayed a few things. But I only really want to learn php, I'm trying to learn what is neccasary atm. And after learn whatever I can, right now I want to display my information on a table on my website. But I'm having trouble, so far (I don't know how bad this is so please tell me) I have too this code of that website, and just edited the variables. But I'm struggling, in my datebase there are 5 tables. Inside of these tables there are the players information, for this one lets say it's the user. When you click on the user name it gives you 3 more tables, id, username and lastlogin. How can I display the username or the id? There id I think just links to there username, but if you could help me in anyway this would be great. Then I'd like to try myself with the other mcmmo_experiance, here's my code

<?php
$con = mysql_connect"---","---","---");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM Persons");

echo "<table border='3'>
<tr>
<th>Player</th>
<th>Stats</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['mcmmo_users(user(id))'] . "</td>";
  echo "<td>" . $row['mcmmo_skills'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>

Thanks so much!
Also, what program do you use to type your code? Any suggestions? I'm using notepad++, but I remeber ages ago I was messing around with code for AMXX (Counter strike scripting plugin) And when you typed lets say get it would show you all the options for get eg get_user get_weapon and stuff, is there any program like that for PHP? Thanks

[Weedpacket]

First of all, the MySQL extension you're using is being deprecated in favour of the [man]MySQLi[/man] and [man]PDO[/man] extensions. Second, I don't know what w3schools article you're following, but my experience is that the site isn't very reliable as a source of information, and you should look for something more authoritative (for PHP that would be the manual). It also means what I don't have any idea about half of what you're talking about when you say "there [sic] id just links to there [sic] username" or what an "mcmmo_experiance" is and whether it's legal in my jurisdiction.

[bradgrafelman]

All I have to say is: Stop being a W3Fool. 🙂

[Derokorian]

Your link made me sad, its not comprehensive! Of course to be comprehensive it would be almost as big a site as the site in question (will NOT link to it, or mention it by name - just a habit)