[RESOLVED] Recieving mysql data

[darko886]

Hello, I am doing a test and trying to make a script pick a row in a mysql table and then show me certain parts of it...
here is the script

<?php

$database="darko886_table"; 
mysql_connect ("supremecenter47.com", "darko886_table", "password") or die( "Unable to connect");; 
@mysql_select_db($database) or die( "Unable to select database"); 




$query = "SELECT * FROM table WHERE Player='darko886'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "Name :{$row['Player']} <br>" .
"Subject : {$row['Club']} <br>" . 
"Message : {$row['Pts']} <br><br>";
} 

?>

Dont look at the echo name subject and message i just took that and edited it from an example... what i want it to do is to select all of the rows from table table where the column "Player" is darko886. the rest of the script is just for me to see if it works... Player, Club, and Pts are all columns in my mysql table... What my end result is is a blank page... anyone know whats wrong with it?
Thanks
Darko

[cgraz]

Do you have errors turned on? Parse errors will cause a blank page if error settings are set to not display. Add this at the top of your script

error_reporting( E_ALL ^ E_NOTICE );
ini_set('display_errors',1);

If you get an error, then from now on include this at the top of your scripts when you have trouble, or better yet edit your php.ini file if you have access. An error when adding this will let you know that your error reporting is set to off, and you'll need to see errors to troubleshoot. That way when you get a blank page, you'll know why.

Once you've determined that parse errors are not the problem, you need to do some error checking.

I see two semi-colons after your call to mysql_connect()

mysql_connect ("supremecenter47.com", "darko886_table", "password") or die( "Unable to connect");; 

while($row = mysql_fetch_array($result, MYSQL_ASSOC))

If you want an associative array, why not use mysql_fetch_assoc()?

Why are your variable names enclosed in curly braces?

Also, make sure you ALWAYS use mysql_error() while trying to troubleshoot a mysql problem. Also you can use this to verify rows were even returned

if( mysql_num_rows( $result ) == 0 )
{
	print 'No Rows Found';
}

// Turn on Error Reporting
error_reporting( E_ALL ^ E_NOTICE );
ini_set('display_errors',1);

// Connect to Database (replace w/your real credentials)
mysql_connect ('supremecenter47.com', 'darko886_table', 'password') or die( mysql_error() );
mysql_select_db('darko886_table') or die( mysql_error() );

// Execute Query
$result = mysql_query("SELECT * FROM table WHERE Player='darko886'") or die( mysql_error() );

// Echo Results
while( $row = mysql_fetch_assoc( $result ) )
{
	print "Name: " . $row['Player'] . "<br>\n";
	print "Subject: " . $row['Club'] . "<br>\n";
	print "Message: " . $row['Pts'] . "<br><br>\n\n";
}

Also, your table isn't named "table", is it? This is where mysql_error() comes in handy.

[Weedpacket]

cgraz wrote:

Why are your variable names enclosed in curly braces?

That would be because of the quotes used around the array indices. Reasons why quoting rules for associative array indices inside string literals need to be so different can be written on the back of a postcard and sent to "Old Pink" c/o the Funny Farm.

[darko886]

Thanks for everyones help, my tables name was table, and after i changed it it worked. I guess it was getting confused.

[cgraz]

Odd. I always concatenate in my coding, so I wasn't aware of that.

Darko: Don't forget to mark this thread resolved (under thread tools).