This is weird.....

J2Fox

<html>
<head>
<title>Player Lookup</title>
</head>
<body>
<h2>Player Info</h2>
<?php echo 'hello world' ?>
</body>
</html>

Ok that's pretty simple. But when I replace <?php echo 'hello world ?> with this:

<?php
$link = mysql_connect('localhost', 'root', '*********');
if (!$link) {
	die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully to database.';

// make player_db current db
$db_selected = mysql_select_db('player_db', $link);
if (!$db_selected) {
	die('error: Can not use player_db : ' . mysql_error());
}

// the table im querying is player_info
// a different script was used to get the value for id in _POST
$query = "select * from player_info where name = $_POST['id']";
if (!$query) {
	die('Player doesn\'t exist in database: ' . mysql_error());
}
$result = mysql_query($query);
if (!$result) {
   $message  = 'Invalid query: ' . mysql_error() . "\n";
   $message .= 'Whole query: ' . $query;
   die($message);
while ($row = mysql_fetch_assoc($result)) {
   echo $row['name'];
   echo $row['country'];
}
mysql_free_result($result);
mysql_close($link); ?>

all of the sudden nothing works. The <title>Player Lookup</title> nor the <h2>Player Info</h2> is not showing up. It's a total blank page.

Obviously, something is wrong with that second script. But what?? I appreciate your help. Btw, Im using PHP 4.3.

fire_cracker

I am not sure if this would cause the problem; however, everytime you reference the mySQL connection you use the $link opperator...except for when you call the query.

Also try turning error reporting on all the way and see if you get any errors, just put this line at the top of your script:

ini_set('error_reporting', E_ALL);

dgrinberg

This is most likely due to the following small syntax error!!!


$result = mysql_query($query);
if (!$result) {
   $message  = 'Invalid query: ' . mysql_error() . "\n";
   $message .= 'Whole query: ' . $query;
   die($message);

You are missing a close "}".

Try adding that and see if it works.

J2Fox

That's why this is weird. I put the error line at the top of the script and I fixed that syntax error but the same thing happens. Not even the <title>Player Lookup</title> tags are working, and that's BEFORE the php script!

fire_cracker

Is there maybe a typo in your basic HTML code? Sometimes that can result in no output.

maxpup979

I dont see any problems with the code, but Im just doing a quick scan. Try using basic debugging techniques...comment out all of it...make user the tags show...uncomment one section, test again etc.... its a small enough piece of code, that this should be quick and easy--and at least identify the problem area

LoganK

J2Fox wrote:

<html>
<head>
<title>Player Lookup</title>
</head>
<body>
<h2>Player Info</h2>
<?php echo 'hello world' ?>
</body>
</html>

Ok that's pretty simple. But when I replace <?php echo 'hello world ?> with this:

<?php
$link = mysql_connect('localhost', 'root', '*********');
if (!$link) {
	die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully to database.';

// make player_db current db
$db_selected = mysql_select_db('player_db', $link);
if (!$db_selected) {
	die('error: Can not use player_db : ' . mysql_error());
}

// the table im querying is player_info
// a different script was used to get the value for id in _POST
$query = "select * from player_info where name = $_POST['id']";
if (!$query) {
	die('Player doesn\'t exist in database: ' . mysql_error());
}
$result = mysql_query($query);
if (!$result) {
   $message  = 'Invalid query: ' . mysql_error() . "\n";
   $message .= 'Whole query: ' . $query;
   die($message);
while ($row = mysql_fetch_assoc($result)) {
   echo $row['name'];
   echo $row['country'];
}
mysql_free_result($result);
mysql_close($link); ?>

all of the sudden nothing works. The <title>Player Lookup</title> nor the <h2>Player Info</h2> is not showing up. It's a total blank page.

Obviously, something is wrong with that second script. But what?? I appreciate your help. Btw, Im using PHP 4.3.

Whoah. That's quite a lot of script to be jumping to. Allright. echo 'Hello world' works. Now don't just jump to the main script!!! Do small increments at a time - first connect to the DB, see if that works. Next make a query and very simply loop through the results, see if that works. Etc. Basic debugging! Maxpup's post above me explains this nicely.