Total newb question

Hylian

well I've been foling around with damn chunk of code for the past few days...and I'm stumped. Basically what I'm trying to achieve is to display actions (to affect rpg stats for my forum) if the person who posted, equals the one in the database for the specific thread. Sounds simple right? Well there can be 2 to 6 people battling in the same thread, yet I only want the stats to show for the battling people, and not for the people who post their comments on how the battle is going. What I thought I could do is just the following:

1) Select all the fields from the rpg table where the logged threadid is equal to the current threadid
2) If #1 is true...continue to count rows returned (for the ammount of users)
3) Do a loop for each user to get their stats

Yet #3 is the problem. Here is my code:

$query = "SELECT rpgusers,rpgthreadid FROM bb".$n."_rpgregisterlog WHERE rpgthreadid=".$threadid;
$r = mysql_query($query) or die(mysql_error());
//!!!!!!!!!!!!!!!!!!!!
$datac = mysql_fetch_array($r);
if($boardid==9 && $datac==$posts[userid]){
//!!!!!!!!!!!!!!!!!!!!
$rpgstatquery = $db_zugriff->query("SELECT * FROM bb".$n."_rpgregisterlog WHERE rpgusers=".$posts[userid]) or exit("Can't Connect!");
$data = $db_zugriff->fetch_array($rpgstatquery);
$levela = $data['rpglevel'];
$ep = floor (100 * ($levela - floor ($level)));
$showlevel = floor ($levela + 1);
$rpgphyatt = $data['rpgphyatt'];
$rpgphydef = $data['rpgphydef'];
$rpgmagatt = $data['rpgmagatt'];
$rpgmagdef = $data['rpgmagdef'];
$rpgspeed = $data['rpgspeed'];
$rpgevade = $data['rpgevade'];
eval ("\$rpgactions = \"".gettemplate("rpgactions")."\";");
eval ("\$rpgstaticstats = \"".gettemplate("rpgstaticstats")."\";");
} elseif($boardid!=9){
$rpgstatquery = $db_zugriff->query("SELECT * FROM bb".$n."_user_table WHERE userid=".$posts[userid]) or exit("Can't Connect!");
$datab = $db_zugriff->fetch_array($rpgstatquery);
$levelb = pow (log10 ($posts[userposts]), 3);
$ep = floor (100 * ($levelb - floor ($level)));
$showlevel = floor ($levelb + 1);
$rpgphyatt = $datab['rpgphyatt'];
$rpgphydef = $datab['rpgphydef'];
$rpgmagatt = $datab['rpgmagatt'];
$rpgmagdef = $datab['rpgmagdef'];
$rpgspeed = $datab['rpgspeed'];
$rpgevade = $datab['rpgevade'];
eval ("\$rpgstaticstats = \"".gettemplate("rpgstaticstats")."\";");
}

the part I outlined is the part I'm having trouble with. $datac returns the correct values in the database, yet it returns them as so:
1
2
It puts a line break inbetween them. How would I get it to split the $datac into two variables? I've tried $datac[0], $datac[1] AND $datac[rpgusers][0], $datac[rpgusers][0] yet they didn't work. And if I do solve that problem, how would I do the if statement below the $datac variable if there can be upto 6 players? Would I do a for loop? Yet is that possible in the if statements conditions area ( if(I'm talking about this area in here) )? Please help me!

planetsim

you have fetch_array try mysql_fetch_array() if your using a Mysql Database

nemonoman

Hylian, this may sound strange at first, but I THINK the problem may be with your DATA, not your code.

I'm going to guess without looking that you are storing linebreaks in your data.

You need to try some other method of looking at your data to prove that it isn't a data problem. For example, count how many characters are being returned --my guess it's one more than what you expect -- the extra char being a line break.

PS -- just saw planetsim's reply which was posted while I wrote this. I hadn't notice the 'fetch_array' part, and he could easily have nailed it. IF NOT, check your data.

Hylian

Actually...the fetch_array part is correct. It's function I believe that my board has. It returns the values...and that's not the part I'm having trouble with. I'll check to see if I have line break errors right now

Hylian

actually it turns out that the second userid isn't in the array. only the first one. I check it using the in_array() fuction. Yet the thing is...when i use mysql_row_count...it returns "2" (2 users in rpg, where both thier threadid's = the current one). So how come the second userid isn't thrown into the array? Is it because the mysql_fetch_array is only for ONE row, where the array is just filled with the column values? And it's not because of that "fetch_array" coding because that's for a different part of the coding. What could be wrong?

nemonoman

Some db languages can fetch all the values from all the rows with one statement. PHP/MYSQL works differently.

mysql_fetch_array doesn't fetch all the rows at once. It fetches only ONE row The array it fetches is the array of the values in that row (the values you specified in the SELECT part of your query.

You have to loop through all the rows. You can do this 2 ways: find the number of rows being returned (mysql_num_rows) and do some sort of FOR loop;

Or use a construct like

while($myrow=mysql_fetch_array($result)){echo $myarray[0];}

This is pretty standard PHP fare.

Some people build a function like

function GetAllTheResultRowsInOneBigArray($theresult) {
while($myBigArray[]=mysql_fetch_array($result)){//}
return $myBigArray;
}

Hylian

$query = "SELECT rpgusers FROM bb".$n."_rpgregisterlog WHERE rpgthreadid=".$threadid;
$r = mysql_query($query) or die(mysql_error());
$datac = mysql_fetch_array($r);
$maxplayers = mysql_num_rows($r);
while($myrow=mysql_fetch_array($r)){
$userss = $myrow[0];
}

What I want to do exactely is tel each retrieved userid to it's own variable. Is that possible, or would I have to do $userss[0], $userss[1], etc? Is the above coding right?

nemonoman

the $users[0], $users[1] approach is right (actually, you Have this array already as $myusers).

If your game has a flexible number of players, this is what you want. If it's like chess (always only 2 player) or bridge (always only 4 player) then you could do it differently.

$result=mysql_query('SELECT player FROM bridgetable ORDER BY position");
$row=mysql_fetch_array($result);
$EAST=$row[0];

$row=mysql_fetch_array($result);
$NORTH=$row[0];

etc

The array of players is easier and faster.

Hylian

Originally posted by nemonoman
ORDER BY position

What do you mean by position? is that a valid MySQL arguement?
When i tried it it said it couldn't find the column id in the order clause.

/////////////////////EDITED

Nvm...I got it to work! I just ordered it by the rpgusers, I hope that will still work 🙂

/////////////////Another edit
WOOOOOOOOOOOOOOT! It finally works! Yeah! Thank you soo much nemonoman!! How many times is that you helped me out?