[SOLVED] Looping

[Akenatehm]

Hey Guys,

 

I need a bit of help.

 

Here's my code:

<?php
session_start();

$dbhost = "localhost";
$dbuser = "user";
$dbpass = "pass";
$dbname = "game";

$connect = mysql_connect($dbhost,$dbuser,$dbpass);
$selectdb = mysql_select_db($dbname);

if (!$connect | !$selectdb)
{
die('MySQL Error ' . mysql_error());
}

$selectplayerid = mysql_query("SELECT playerid FROM accounts");

if (!$selectplayerid)
{
die("MySQL Error: " . mysql_error());
}
else
{
$num= mysql_num_rows($selectplayerid);
$playerid = $filterplayerid['playerid'];
$i=0;
while($i<$num)
{
$filterplayerid = mysql_fetch_assoc($selectplayerid);
$getmineinfo = mysql_query("SELECT * FROM userbuildings WHERE playerid = '$playerid' AND buildingid = 1");
if(!$getmineinfo)
{
	die("MySQL Error: " . mysql_error());		
}
else
{
$filtermineinfo = mysql_fetch_assoc($getmineinfo);
$buildinglevel = $filtermineinfo['level'];
$gatherers = $filtermineinfo['gatherers'];

$increasegold = mysql_query("UPDATE resources SET gold = gold + 5 WHERE username = '$username'");
}
mysql_query($selectplayerid);
$i++;
}
}
?>

 

and it is not adding gold to the resource table in the DB. There seem to be no syntax errors but probably just the way I have written it.

 

Help wud be great.!

[Cal]

$playerid = $filterplayerid['playerid'];

 

What's the point in this? $filterplayerid hasn't been set...

 

Add mysql_error to the increase gold line to see if the query is wrong:

 

$increasegold = mysql_query("UPDATE resources SET gold = gold + 5 WHERE username = '$username'") or die(mysql_error());

[Akenatehm]

I get:

 

Unknown column 'username' in 'where clause'

[Cal]

Check your resources table, does the field 'username' exist or is it under a different name?

[Akenatehm]

ok its working. tyvm for ur help!