php help

[Kezza]

Hi All,

I will admit I am not a programmer.. I just like to dabble in the black-arts of php now and again... 🙂 Trying to code a basic script, having a few problems..

I have a MySQL table which I am trying to drag values you from... I have a series of fields in which range from P1H1 through to P4H18... Ie, P1H1, P1H2 etc.. I have struck a problem - with using variables within arrays..

I am using the following:

for ($rows = 1; $rows <= $myrow[NumPlayers]; $rows++) {
echo "<td width = \"100\" BGCOLOR = \"#759CF3\"><b><center>_ " . $myrow["Player$rows"] . "</center></td>";
}
echo "</tr>";

for ($HoleNum = 1; $HoleNum <= $myrow[NumHolesPlayed]; $HoleNum++) {
printf ("<tr><td>$HoleNum< /td><td>$course[Par]< /td><td>$course[Distance]<_ /td>");
echo "<td>" . $myrow["P$rows"."H$HoleNum"] . "</td></tr>";
$course = mysql_fetch_array($rslt);
}

The Problem is I am trying to use two variables as array pointers in order to extract the values - I am not sure of the syntax or if it is even possible... Suggestions greatly appreciated.

Cheers,
Kezza.

[nemonoman]

Not entirely sure about your question...

Are you asking for advice about your approach?

The approach you are taking SHOULD work. I use it all the time.

Are you saying you've already tried this approach and it doesn't work?

In that case additionally post the code preceding this table building, i.e. the code where you hit the database.

remember you can manage two or more queries like this:

$playerResult=mysql_query("SELECT playerid FROM player");

While ($playerRow=mysql_fetch_array($playerResult)){
$playerId=$playerRow[0];
$gameResult =mysql_query("SELECT * FROM game WHERE playerid=$playerID");
While ($gameRow=mysql_fetch_array($gameResult)){
//mess around with game info
}//while there are game rows
}while there are player rows

[Kezza]

Thanks for the reply... I wasn't quite as clear as i should have been 🙂

The problem is with this line

echo "<td>" . $myrow["P$rows"."H$HoleNum"] . "</td></tr>";

Most importantly ^{^^^^^^^^} that bit 🙂

I am trying to pull out values from the SQL database using two variables and I am not sure of the syntax which should work.. The above doesn't. 🙂

Ie, using the for loops I want it to cycle from P1H1 -> P4H18 and use that in an array, but I am not sure how.

Hope this makes a bit more sense.

Thanks,
Kezza.

[nemonoman]

OK. I've had similar problems 'echo'ing a associated array element.

echo "$myrow[0]"; // works
echo "$myrow['H$myvariable']"; //fails

Try this:

$thisdammedstring=$myrow["P$rows"."H$HoleNum"];

echo "<td>$thisdammedstring</td></tr>";

You can even kill two birds with one stone and solve your second problem

$somedamnedarray[]=$myrow["P$rows"."H$HoleNum"];

$i=0;
while($i<count($somedamnedarray)){
echo "<td>$somedamnedarray[$i]</td></tr>";
$i++;
}