PHP function not working

Perhaps someone could look at this and tell me why it isn't working... cos I havent the feintest idea! =( It's really all I have left to do on something i've been working on for a long time now. Would be greatful for any help given. As to what's wrong... it's not showing the rows that should contain my products details... i'e not running the showProducts() function

Thanks

Stephen

Here is the code for the entire page...

if(isset($_COOKIE["myLoggedInCookie"])){

echo "

<html>

<head>

<title>View All Products</title>

table { background-color:#eeeeee; }
th { background-color:#cccccc; font-family:verdana; font-size:12pt; color:#333399; border-width:2px; border-color:#3333ff; }
td { background-color:#eeeeee; font-family:verdana; font-size:12pt; color:#333399; border-width:1px; border-color:#3333ff; }

</style>

</head>

<body>

<table width='600'>
<tr>
<th colspan='5'>Products</th>
</tr>
<tr>
<th>Section</th>
<th>Name</th>
<th>Price</th>
<th>Description</th>
<th>Image Url</th>
</tr>
<?php
showProducts();
?>

</table>

</center>

</body>
</html>

}

else {

echo "<script>alert('You are not logged in'); parent.location='index.php';</script>";

}

function showProducts(){

$db = mysql_connect("localhost", "username", "password");
mysql_select_db("databaseName");

$dbQuery="SELECT * FROM products order by section asc";
$result = mysql_query($dbQuery,$db);

while ($arrayVar=mysql_fetch_array($result)) {

$section=$arrayVar["section"];
$name=$arrayVar["name"];
$price=$arrayVar[price];
$desc=$arrayVar["desc"];
$imgurl=$arrayVar["imgurl"];

echo "<tr><td>$section</td>" .
" <td>$name</td>" .
" <td>$price</td>".
" <td>$desc</td>".
" <td>$imgurl</td></tr>";
}
}

PHP function not working

urbley

Robber

dreamcatcher

urbley

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week