SMALL TINY question here...

Inkybro

I need to echo how much "money" someone has. I tried putting:

echo "$chips";

I'm sure it has something to do with selecting the table and/or column, but what?

Valkrin

You should give more details about your problem if you want a helpful response.

If that data is being pulled from a database make sure that your query worked. If you are pulling the data from the database using mysql_fetch_array like so:
$row = $mysql_fetch_array($result, ASSOC);

Then you would refer to the pulled data by it column name for example:

$row["chips"];

Hope that helps.

Inkybro

Okay.. basically they log-in and go to the members area which I have done, now I want it to show how much money they have. The table name is users, database name is wizardduels_com and the column name is chips. The thing is I want it to display how much THEY have. Thanks everyone!

ElMongol

Then of course, a simple fetch_array, like Valkrin says should be the obvious way? Perhaps there's something unusual that you've not mentioned? As this looks like very rudimentary stuff!

Inkybro

Okay, I put exactly what you said, here's my code:

<?
            $row = $mysql_fetch_array($result, ASSOC); 

        echo "User:";
        echo " $user";
        echo "<BR>";
        echo "WC:";
        echo $row['chips'];
       ?>

Shouldn't this work? Is there something I need to change? I'm sitll a bit of a newbie so if someone could help, thanks.

reidme

<?
$query = mysql_query("SELECT User, chips FROM users");
$row = mysql_fetch_assoc($query);
echo "User: ".$user."<br>WC: ".$row[chips];
?>

Inkybro

Is the code to select a db:

mysql_db_select("DB NAME HERE");

Thanks.

Inkybro

I figured out the DB Selecting Dilemma. But now, no matter what it always tells people (everyone) they have the first person on the table's "money", I need it to show theirs! This also happens you're not even logged in!

daphreeek

You need to tell MySQL what entry you want using the WHERE command. Without a WHERE command, MySQL returns all the records in that table.

<?
            $query = mysql_query("SELECT chips FROM users WHERE user='$user'"); 
            $row = mysql_fetch_assoc($query); 

        echo "User:";
        echo " $user";
        echo "<BR>";
        echo "WC:";
        echo $row['chips'];
?>

Hope that helps
- Matt