$result not working

[kevinritt]

I cannot figure why this code will not work:

<?
require("connections/dbconn.php");
$sql = "SELECT name, url, title FROM nav";
$result = $conn -> query($sql) or die(mysqli_error());
	if($result) {
	while($row = $result->fetch_object()) {
		echo "<li><a href='{$row->url}' title='{$row->title}'>{$row->name}</a></li>";
	}
}
?>

I don't see an error so can I assume that the connection to the database is not being made? Here's the connection/dbconn.php file:

<?
$conn = new MySQLi("localhost", "root", "***", "suagustv") or die(mysqli_error());
?>

Can anyone direct me where I should be looking? This is what I see on the page:

query($sql) or die(mysqli_error()); if($result) { while($row = $result->fetch_object()) { echo "{$row->name}

"; } } ?>

[PFMaBiSmAd]

Use full opening php tags <?php in all your code. The short open tag <? is not always enabled and you won't always be on a server where you can turn it on. You will waste more time trying to use short open tags than the time you will save by not typing the extra three letters to make it <?php.

[kevinritt]

yes, dumb oversight. Now I get this error:

Notice: Undefined variable: conn in C:\wamp\www\saugustv_test\index.php on line 22

 

Fatal error: Call to a member function query() on a non-object in C:\wamp\www\saugustv_test\index.php on line 22

Is there somewhere I can see/understand what these errors mean?

[PFMaBiSmAd]

You need to use full <?php tags in connection/dbconn.php.

 

Use full opening php tags <?php in all your code.

[Cosizzle]

ha, only someone with a larry king avatar can quote themselves

[kevinritt]

alright, alright I get it -'Dumbass of the week award'