[SOLVED] Getting Certain Field From a Row Problems

[Akenatehm]

Hey Guys,

 

I am trying to find out how many points someone has and displaying it on the screen.

 

The code is here:

<?php

$host = "localhost";
$name = "username";
$pass = "pass";
$db = "db";

$con = mysql_connect($host,$name,$pass);
if (!$con)
{
die('Failed to Connect:' . mysql_error());
}

$selectdb = mysql_select_db($db);
if (!$selectdb)
{
die('Failed to Select Database:' . mysql_error());
}

$username = $_COOKIE['Username'];
$checkusername = mysql_query("SELECT * FROM points WHERE account = '$username' ");

if(!$checkusername)
{
die('Failed to Check Your Username' . mysql_error());
}
elseif(mysql_num_rows($checkusername) == 0)
{
echo "Your Username Does not Exist on the Database";
}
else 
{
$findpoints = mysql_query("SELECT * FROM points WHERE account = '$username'");

if(!$findpoints)
{
die('Failed to Find Your Points' . mysql_error());
}
else
{
while ($results = mysql_fetch_array($findpoints, MYSQL_NUM)){
echo "You have" . $row['points'] . "points";
}
}
}

?>

 

The output is just:

You havepoints

 

But I need it to say You have 50 points. Where 50 is the number from the DB.

 

Help would be Great!

[.josh]

you are using $row instead of $results

[Akenatehm]

Omg wow...such a stupid mistake..

 

Thanks for pointing out to me.

 

Much appreciated

[Akenatehm]

I fixed that. AND it still shows the same thing

 

<?php

$host = "localhost";
$name = "user";
$pass = "pass";
$db = "db";

$con = mysql_connect($host,$name,$pass);
if (!$con)
{
die('Failed to Connect:' . mysql_error());
}

$selectdb = mysql_select_db($db);
if (!$selectdb)
{
die('Failed to Select Database:' . mysql_error());
}

$username = $_COOKIE['Username'];
$checkusername = mysql_query("SELECT * FROM points WHERE account = '$username' ");

if(!$checkusername)
{
die('Failed to Check Your Username' . mysql_error());
}
elseif(mysql_num_rows($checkusername) == 0)
{
echo "Your Username Does not Exist on the Database";
}
else 
{
$findpoints = mysql_query("SELECT points FROM points WHERE account = '$username'");

if(!$findpoints)
{
die('Failed to Find Your Points' . mysql_error());
}
else
{
while ($results = mysql_fetch_array($findpoints, MYSQL_NUM)){
echo "You have" . $results['points'] . "points";
}
}
}

?>

[.josh]

okay well are you using the right column name?  You are using 'points' as the column name and in your query you are using 'points' as the table name.  Is that really how you have your table setup?

[Akenatehm]

Yes. The table name is points and the field name is points.

[Akenatehm]

Any Idea anyone?

[sasa]

change lipn

while ($results = mysql_fetch_array($findpoints, MYSQL_NUM)){

to

while ($results = mysql_fetch_array($findpoints, MYSQL_ASSOC)){

 

[Akenatehm]

OMG. Thank you so much!

 

It works like a charm.

 

Outputs: You have200points

 

Anyway I can put a space in there before and after 200?

[.josh]

Anyway I can put a space in there before and after 200?

 

no.

 

[Akenatehm]

Really.. Well ok..

 

Uhm I am getting a problem in using the same script on another document.

 

<?php

$host = "localhost";
$name = "username";
$pass = "pass";
$db = "db";

$con = mysql_connect($host,$name,$pass);
if (!$con)
{
die('Failed to Connect:' . mysql_error());
}

$selectdb = mysql_select_db($db);
if (!$selectdb)
{
die('Failed to Select Database:' . mysql_error());
}

$username = $_COOKIE['Username'];
$item = $_POST['item'];
$checkusername = mysql_query("SELECT * FROM points WHERE account = '$username' ");

if(!$checkusername)
{
die('Failed to Check Your Username' . mysql_error());
}
elseif(mysql_num_rows($checkusername) == 0)
{
echo "Your Username Does not Exist on the Database";
}
else 
{
$enoughpoints = mysql_query("SELECT requiredpoints FROM rewards WHERE name = '$item'");

if(!$enoughpoints)
{
die('Failed to Check Points of Item' . mysql_error());
}
else
{
while ($results = mysql_fetch_array($enoughpoints, MYSQL_ASSOC))
{	
$cost = $results['points'];
}
$userpoints = mysql_query("SELECT * FROM points WHERE account = '$username'");
$userpointsresults = mysql_fetch_array($userpoints, MYSQL_ASSOC);
$userhaspoints = $userpointsresults['points'];

if(!$userpoints)
{
die('Failed to Check Your Points' . mysql_error());
}
else
{
if($cost > $userhaspoints)
{
echo "You do not have enough points";
}
else{
$character = $_POST['charactername'];
$amount = $cost;
$deduct = mysql_query("UPDATE characters SET gold = gold - " . $amount . " WHERE name = '" . $character . "' AND gold >= '" . $amount . "';");
if (!$deduct)
{
die('Failed to Deduct Gold' . mysql_error());
}
else{
$getguid = mysql_query("SELECT guid FROM characters WHERE name = '$username'");
if(!$getguid)
{
die('Could Not Find GUID of User' . mysql_error());
}
else{
$sortguid = mysql_fetch_array($getguid, MYSQL_ASSOC);
$userhaspoints = $sortguid['guid'];

echo "$guid";
}
}
}
}
}
}

?>

 

That is outputting this error:

Failed to Deduct GoldYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE name = 'Cody' AND gold >= ''' at line 1

 

Where Cody is my username.

[Akenatehm]

Ok. Turns out I hadn't fixed the setting properly when transferring it from another script.

 

I am getting this weird error though:

 

Your Username Does not Exist on the Database

 

From this area of code:

$username = $_COOKIE['Username'];
$item = $_POST['item'];
$checkusername = mysql_query("SELECT * FROM points WHERE account = '$username' ");

if(!$checkusername)
{
die('Failed to Check Your Username' . mysql_error());
}
elseif(mysql_num_rows($checkusername) == 0)
{
echo "Your Username Does not Exist on the Database";
}

[Akenatehm]

Ok. Turns out I hadn't fixed the setting properly when transferring it from another script.

 

I am getting this weird error though:

 

Your Username Does not Exist on the Database

 

From this area of code:

$username = $_COOKIE['Username'];
$item = $_POST['item'];
$checkusername = mysql_query("SELECT * FROM points WHERE account = '$username' ");

if(!$checkusername)
{
die('Failed to Check Your Username' . mysql_error());
}
elseif(mysql_num_rows($checkusername) == 0)
{
echo "Your Username Does not Exist on the Database";
}

 

Wow..This is turning into a mess.

 

The cookie expired and that is why i was getting that error. The error still is the same.

 

Failed to Deduct GoldYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE account = 'Cody' AND points >= ''' at line 1

 

From

<?php

$host = "localhost";
$name = "username";
$pass = "pass";
$db = "db";

$con = mysql_connect($host,$name,$pass);
if (!$con)
{
die('Failed to Connect:' . mysql_error());
}

$selectdb = mysql_select_db($db);
if (!$selectdb)
{
die('Failed to Select Database:' . mysql_error());
}

$username = $_COOKIE['Username'];
$item = $_POST['item'];
$checkusername = mysql_query("SELECT * FROM points WHERE account = '$username' ");

if(!$checkusername)
{
die('Failed to Check Your Username' . mysql_error());
}
elseif(mysql_num_rows($checkusername) == 0)
{
echo "Your Username Does not Exist on the Database";
}
else 
{
$enoughpoints = mysql_query("SELECT requiredpoints FROM rewards WHERE name = '$item'");

if(!$enoughpoints)
{
die('Failed to Check Points of Item' . mysql_error());
}
else
{
while ($results = mysql_fetch_array($enoughpoints, MYSQL_ASSOC))
{	
$cost = $results['points'];
}
$userpoints = mysql_query("SELECT * FROM points WHERE account = '$username'");
$userpointsresults = mysql_fetch_array($userpoints, MYSQL_ASSOC);
$userhaspoints = $userpointsresults['points'];

if(!$userpoints)
{
die('Failed to Check Your Points' . mysql_error());
}
else
{
if($cost > $userhaspoints)
{
echo "You do not have enough points";
}
else{
$character = $_POST['charactername'];
$amount = $cost;
$deduct = mysql_query("UPDATE points SET points = points - " . $amount . " WHERE account = '" . $username . "' AND points >= '" . $amount . "';");
if (!$deduct)
{
die('Failed to Deduct Gold' . mysql_error());
}
else{
$getguid = mysql_query("SELECT guid FROM characters WHERE name = '$username'");
if(!$getguid)
{
die('Could Not Find GUID of User' . mysql_error());
}
else{
$sortguid = mysql_fetch_array($getguid, MYSQL_ASSOC);
$userhaspoints = $sortguid['guid'];

echo "$guid";
}
}
}
}
}
}

?>

[fLaVV]

well if you read the error, it says:

 

You have an error in your SQL syntax.

 

This means

 

$deduct = mysql_query("UPDATE characters SET gold = gold - " . $amount . " WHERE name = '" . $character . "' AND gold >= '" . $amount . "';");

 

is throwing an error because it isnt executing properly.

 

Just taking a quick stab, i would guess you need to change

 

UPDATE characters SET gold = gold - " . $amount . "

 

to

 

UPDATE characters SET gold = 'gold - " . $amount . "'

 

I think the "gold - " is messing up the query, maybe by adding the (') it MIGHT work.

 

I am not 100% sure, I am just trying to help ya out, may want some second advice, but thats what i would try first.

 

 

[Akenatehm]

well if you read the error, it says:

 

You have an error in your SQL syntax.

 

This means

 

$deduct = mysql_query("UPDATE characters SET gold = gold - " . $amount . " WHERE name = '" . $character . "' AND gold >= '" . $amount . "';");

 

is throwing an error because it isnt executing properly.

 

Just taking a quick stab, i would guess you need to change

 

UPDATE characters SET gold = gold - " . $amount . "

 

to

 

UPDATE characters SET gold = 'gold - " . $amount . "'

 

I think the "gold - " is messing up the query, maybe by adding the (') it MIGHT work.

 

I am not 100% sure, I am just trying to help ya out, may want some second advice, but thats what i would try first.

 

Unfortunately, that didn't work. Sorry.

[fLaVV]

$deduct = mysql_query("UPDATE characters SET gold = gold - " . $amount . " WHERE name = '" . $character . "' AND gold >= '" . $amount . "';");

 

At the end of the code, it looks like your double closing the query

 

;");

[Akenatehm]

$deduct = mysql_query("UPDATE characters SET gold = gold - " . $amount . " WHERE name = '" . $character . "' AND gold >= '" . $amount . "';");

 

At the end of the code, it looks like your double closing the query

 

;");

 

Still didn't work..

 

Anyone?

[sasa]

variable $amount is empty

try to echo it before query

[Akenatehm]

variable $amount is empty

try to echo it before query

 

Ok, It wasn't echoing. So I searched.

 

and realised that $cost = ['points']

 

when it needed to be $cost = ['requiredpoints']

 

So i fixed it. Now it echos it.

 

I removed teh echo.

 

But the final part of the script about getting the guid is not doing anything just showing up blank on the screen.. Help with that wud be great.

[Akenatehm]

Hmmmm. I just realised that I was echoing nothing on the last line lol. Fixed the variable and now everything works.!!

 

Thanks guys for all your help!

 

It's been great!

 

See you guys in the near future (hopefully not). Lol.

 

Thanks Again!