New to MySQL - Day 2

[spoco]

I was able to get a page to write to a database, now I'm trying to get a page that will display all of the records. Why is this code not working?

<?php require_once("../databaseconn.php"); ?>

<?php
mysql_select_db('training', $databaseconn);

$SQLstring = "SELECT * FROM evaluation";
$QueryResult = mysql_query($SQLstring, $databaseconn) or die(mysql_error(Unable to execute query.));
$Row = mysql_fetch_row ($QueryResult);

echo "<p><strong>1a</strong>" {$Row[0}}<br />";
echo "<strong>1b</strong>" {$Row[1}}<br />";
echo "<strong>1c</strong>" {$Row[2}}<br />";
echo "<strong>2a</strong>" {$Row[3}}<br /></p>";
?>
</div></p>
</body>
</html>

[Mchl]

Because you have unpaired quotes (in last 4 ecgo lines). Use editor with code highlightning (Notepad++ is a popular one for Windows).

[spoco]

Okay. fixed that, but still no results. blank page.

 

<?php require_once("../databaseconn.php"); ?>

<?php
mysql_select_db('training', $databaseconn);

$SQLstring = "SELECT * FROM evaluation";
$QueryResult = mysql_query($SQLstring, $databaseconn) or die(mysql_error(Unable to execute query.));
$Row = mysql_fetch_row ($QueryResult);

echo "<p><strong>1a</strong>: {$Row[0}}<br />";
echo "<strong>1b</strong>: {$Row[1}}<br />";
echo "<strong>1c</strong>: {$Row[2}}<br />";
echo "<strong>2a</strong>: {$Row[3}}<br /></p>";
?>
</div></p>
</body>
</html>

[fenway]

Make sure error reporting is turned in php...

[Mchl]

You should enable error reporting. I can see at least one place that should give you a warning.

 

To enable error reporting add these two lines at the beginning of your script

 

ini_set("display_errors","1");
error_reporting(E_ALL);

 

 

[revraz]

Missing Quotes here

 

or die(mysql_error(Unable to execute query.));

 

 

[xtopolis]

<?php
echo "<strong>1b</strong>: {$Row[1}}<br />";
?>

That syntax doesn't look right, shouldn't it have a closing ]

<?php
echo "<strong>1b</strong>: {$Row[1]}<br />";
?>

 

Could be mistaken, I don't use that method.

[Mchl]

Yes it should be. It's an array after all.