[SOLVED] display mysql table data

[gaza165]

try using this code....

 

<?php

$username = $_COOKIE['ID_my_site'] //this is the session variable containing the username of the person logged in.
$sql = mysql_query("SELECT username,skill FROM members WHERE username = '$username'") or die(mysql_error());

   while($row = mysql_fetch_array($sql)) {

                    echo $row['username']."<br/>";
                    echo $row['skill']."<br/>";
  
        }
?>

[Jiraiya]

its been added but its still blank

[gaza165]

are you using an include on player.php?? if so, what is the name of that file

 

try using teh code below...

 

<?php

$sql = mysql_query("SELECT username,skill FROM members WHERE username = 'tester'") or die(mysql_error());

   while($row = mysql_fetch_array($sql)) {

                    echo $row['skill'];
  
        }
?>

[Jiraiya]

i added the code and it told me this on the page "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)"

[gaza165]

you need to make the connection to your db first, what is the name of the database and what is the name of the table inside the database??? take a look at the code properly and look to see if everything is referenced with the right name..

 

username

password

table name

database name

 

etc

 

<?php

// Connects to your Database
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("members") or die(mysql_error());

$sql = mysql_query("SELECT username,skill FROM members WHERE username = 'tester'") or die(mysql_error());

   while($row = mysql_fetch_array($sql)) {

                    echo $row['skill'];
  
        }

[Jiraiya]

the table name is "users"

 

i added that and it still didnt work

[gaza165]

try this code and let me know...

 

 

<?php

// Connects to your Database
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("members") or die(mysql_error());

$sql = mysql_query("SELECT skill FROM users WHERE username = 'tester'") or die(mysql_error());

   while($row = mysql_fetch_array($sql)) {

                    echo $row['skill'];
  
        }
?>

[Jiraiya]

thanks that worked, is there anyway i can have it display in a row kinda like

 

Username: "username"

Skill: "skill

[gaza165]

<?php
$sql = mysql_query("SELECT skill FROM users WHERE username = 'tester'") or die(mysql_error());

   while($row = mysql_fetch_array($sql)) {

                    echo "Username:".$row['username'];
                    echo "Skill:".$row['skill'];
                    // Then just carry on
  
        }
?>

[Jiraiya]

ok but how do i change it so it dosnt show "testers" stats but the user who logged in?

[corbin]

Change tester to be the username of the user who is currently logged in.

[Jiraiya]

how would i go about doing that?

[gaza165]

<?php
$username = $_COOKIE['ID_my_site']; //this is the session variable containing the username of the person logged in.
$sql = mysql_query("SELECT username,skill FROM members WHERE username = '$username'") or die(mysql_error());

   while($row = mysql_fetch_array($sql)) {

                    echo "Username:".$row['username'];
                    echo "Skill:".$row['skill'];
                    // Then just carry on
  
        }
?>

 

[Jiraiya]

i replaced the last code with the the one above but now the page is blank ??? ???

 

 

this is the code i got going

 

 

 

Name:

<?php

echo $_COOKIE['ID_my_site'];

?>

<br>

 

 

<?php

 

// Connects to your Database

mysql_connect("localhost", "username", "password") or die(mysql_error());

mysql_select_db("members") or die(mysql_error());

 

$username = $_COOKIE['ID_my_site'] //this is the session variable containing the username of the person logged in.

$sql = mysql_query("SELECT username,skill FROM members WHERE username = '$username'") or die(mysql_error());

 

  while($row = mysql_fetch_array($sql)) {

 

                    echo "Username:".$row['username'];

echo "Level:".$row['level'];

                    echo "Skill:".$row['skill'];

                    // Then just carry on

 

        }

?>

[gaza165]

<?php
$username = $_COOKIE['ID_my_site']; 
$sql = mysql_query("SELECT username,skill FROM members WHERE username = '$username'") or die(mysql_error());

   while($row = mysql_fetch_array($sql)) {

                    echo "Username:".$row['username'];
                    echo "Skill:".$row['skill'];
                    // Then just carry on
  
        }
?>

 

realised i missed a ; out try that

[gaza165]

also forgot to change ur table name to users..

[Jiraiya]

Table 'members.members' doesn't exist

 

thats what i got

[gaza165]

<?php
$username = $_COOKIE['ID_my_site']; 
$sql = mysql_query("SELECT * FROM users WHERE username = '$username'") or die(mysql_error());

   while($row = mysql_fetch_array($sql)) {

                    echo "Username:".$row['username'];
                    echo "Skill:".$row['skill'];
                    // Then just carry on
  
        }
?>

[Jiraiya]

thank you that worked great 

[gaza165]

That was probably the longest most un co-ordinated solution i have ever given at PHP Freaks...

 

But, we got there in the end... dont forget to mark the topic as solved... good luck with the site..

 

Garry

[Jiraiya]

one more think is there anyway to make it do the <br> function after each thing is displayed

like

1

2

3

[gaza165]

<?php
$username = $_COOKIE['ID_my_site']; 
$sql = mysql_query("SELECT * FROM users WHERE username = '$username'") or die(mysql_error());

   while($row = mysql_fetch_array($sql)) {

                    echo "Username:".$row['username']."<br/>";
                    echo "Skill:".$row['skill']."<br/>";
                    // Then just carry on

}
?>

 

   

[Jiraiya]

thanks a lot for all the help