[RESOLVED] fetch_array problems

jamesjohnson88

For some reason, the code below is broken below the fetch_array function. Nothing looks wrong to me but i'm still fairly new. Can anybody see the problem? I would be very grateful for any help.

// Set variables.
$logID = mysql_real_escape_string($_POST['resultID']);

// Pull Scoring_Log data and assign variables.
$array = mysql_query("SELECT * FROM Scoring_Log WHERE logID='$logID'") or die(mysql_error());

$row=mysql_fetch_array($array, MYSQLI_BOTH); // CHECKPOINT 1 - CLEAR

// Players Involved.
$1stPlayer = $row['1stPlayer']; /*
$2ndPlayer = $row['2ndPlayer'];
$3rdPlayer = $row['3rdPlayer'];
$4thPlayer = $row['4thPlayer'];
$5thPlayer = $row['5thPlayer'];
$6thPlayer = $row['6thPlayer'];
$7thPlayer = $row['7thPlayer'];
$8thPlayer = $row['8thPlayer'];
// Points Awarded.
$1stPoints = $row['1stPoints'];
$2ndPoints = $row['2ndPoints'];
$3rdPoints = $row['3rdPoints'];
$4thPoints = $row['4thPoints'];
// League Involved.
$leagueName = $row['LeagueName']; 

echo ("$1stPlayer");
echo ("$2ndPlayer");
echo ("$3rdPlayer");
echo ("$4thPlayer");
echo ("$5thPlayer");
echo ("$6thPlayer");
echo ("$7thPlayer");
echo ("$8thPlayer");

echo ("$1stPoints");
echo ("$2ndPoints");
echo ("$3rdPoints");
echo ("$4thPoints");

echo ("$leagueName"); */

There is more code but it is all commented out, except from the mysql_close() function. I can post the entire thing if needed.

dagon

MYSQL_BOTH not MYSQLI_BOTH and its the default anwyay

jamesjohnson88

Doesn't have any effect.

dagon

print_r($row); returns ?

jamesjohnson88

It works but doesn't show anything.

dagon

then the query returned nothing

NogDog

After doing the query, do a [man]mysql_num_rows/man to see if anything was actually returned by the query. (No rows returned is not a MySQL error, so that will not trigger your "or die()".)

jamesjohnson88

Ok, was misspelt the column name. Printf now returns this -

Array ( [0] => 1 [resultID] => 1 [1] => test [LeagueName] => test [2] => Bjorn [1stPlayer] => Bjorn [3] => Dave [2ndPlayer] => Dave [4] => [3rdPlayer] => [5] => [4thPlayer] => [6] => [5thPlayer] => [7] => [6thPlayer] => [8] => [7thPlayer] => [9] => [8thPlayer] => [10] => [1stPoints] => [11] => [2ndPoints] => [12] => [3rdPoints] => [13] => [4thPoints] => [14] => 85 [logID] => 85 )

Still breaks once I move the comment start to after the first variable in the list. Is it because t=some of the table values are NULL?

jamesjohnson88

NogDog;10925507 wrote:
After doing the query, do a [man]mysql_num_rows/man to see if anything was actually returned by the query. (No rows returned is not a MySQL error, so that will not trigger your "or die()".)

Yes, I get 1. Which is correct.

dagon

can you be more specific than "breaks"

jamesjohnson88

Shows nothing. Just a blank white page. Whereas when the code runs through fully, the HTML at the bottom shows.

dagon

should of noticed before, php vars cant start with a number

jamesjohnson88

Ah, ok. So $player1 instead of $1stPlayer should do the trick?

dagon

jamesjohnson88;10925515 wrote:
Ah, ok. So $player1 instead of $1stPlayer should do the trick?

try it and find out, you of course could just use the array directly

echo $row['1stPlayer'];

i see no reason to add a new var

jamesjohnson88

I need the working variable for the rest of the code. Thanks for the help.