Need help specifying my echo

Stavo16

So I have a newb problemo. Im learning PHP, and there seems to be something I don't get. Everytime I use this script, it takes all of the names in that Column, where I just want one. This is what I started with. Please correct me.

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

mysql_select_db("Garrysmod_Data", $con);

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

while($row = mysql_fetch_array($result))
  {
      echo $row['In_Game_Name']; ;

  }

mysql_close($con);
?>

dagon

"SELECT * FROM Bans"

as it says get (*) EVERYTHING from Bans, you have to tell it which row you want by adding a WHERE clause

Stavo16

But do the rows have names? When I go check them out i only see names inside the Tables. In the columns. But not on the left, defining each row.

dagon

the rows don't have names, most tables have column 1 as an id, which would be what is used as the 'name' in most cases. Its up to you to define the table structure including a unique id field if needed.

mblack0508

Stavo16;10922993 wrote:
But do the rows have names? When I go check them out i only see names inside the Tables. In the columns. But not on the left, defining each row.

The row is the dataset, not the identifier. You have the columns with the data providing the identifier. As Dagon pointed out, usually each table has a unique identifier for each row which is usually "id".

Now depending on how you want to use the data can mean different code. In the code you provided all its going to do is list each person's in game name that is banned. If you want to do something differently, then specify it.

Stavo16

I figured it out. Thanks for the help. I definately did help.