Hi
I am having issues coding a new page which imports queried items on click of one of the tabs.
It works on the first tab but when I copy and change the query to suit the next tabe i get this error
This is now possible please try later.
Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch mysqli in C:\Program Files (x86)\EasyPHP-5.3.3\www\PHPfunctionality\products.php on line 96
Notice: Undefined variable: q in C:\Program Files (x86)\EasyPHP-5.3.3\www\PHPfunctionality\products.php on line 96
Query:
Warning: mysqli_close() [function.mysqli-close]: Couldn't fetch mysqli in C:\Program Files (x86)\EasyPHP-5.3.3\www\PHPfunctionality\products.php on line 100
<script src="SpryAssets/SpryTabbedPanels.js" type="text/javascript"></script>
<link href="SpryAssets/SpryTabbedPanels.css" rel="stylesheet" type="text/css" />
<?php
require ('mysqli_connect.php');
?>
<div id="TabbedPanels1" class="TabbedPanels">
<ul class="TabbedPanelsTabGroup">
<li class="TabbedPanelsTab" tabindex="1">Adventure</li>
<li class="TabbedPanelsTab" tabindex="2">Arcade</li>
<li class="TabbedPanelsTab" tabindex="3">Racing</li>
<li class="TabbedPanelsTab" tabindex="4">Virtual Life</li>
<li class="TabbedPanelsTab" tabindex="5">Family</li>
<li class="TabbedPanelsTab" tabindex="6">Fighting</li>
<li class="TabbedPanelsTab" tabindex="7">Music</li>
<li class="TabbedPanelsTab" tabindex="8">Roleplay</li>
<li class="TabbedPanelsTab" tabindex="9">Shooter</li>
<li class="TabbedPanelsTab" tabindex="10">Simulation</li>
<li class="TabbedPanelsTab" tabindex="11">Sport</li>
<li class="TabbedPanelsTab" tabindex="12">Strategy</li>
</ul>
<div class="TabbedPanelsContentGroup">
<div class="TabbedPanelsContent"> <?php
$sql = "SELECT *
FROM `products`
WHERE `Platform` LIKE 'Xbox 360'
AND `Genre` = 'Adventure'
LIMIT 0 , 30";
$r = @mysqli_query($dbc, $sql);
if ($r) {
echo '<table align="center" cellpadding="3" cellspacing="3" width="75%">
';
while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {
echo ' <TR><td>' . $row['Game_Title'] . '</td>
<td>' . $row['Price'] . '</td></tr>
';
}
echo '</table>';
mysqli_free_result ($r);
} else {
echo ' <p class="error">This is now possible please try later.</p>';
echo '<p>' . mysqli_error($dbc) . '<br><br>Query: ' . $q . '</p>';
}
mysqli_close($dbc);?></div>
<div class="TabbedPanelsContent">Content 2</div>
<div class="TabbedPanelsContent">Content 3</div>
<div class="TabbedPanelsContent">Content 4</div>
<div class="TabbedPanelsContent">Content 5</div>
<div class="TabbedPanelsContent">Content 6</div>
<div class="TabbedPanelsContent">Content 7</div>
<div class="TabbedPanelsContent">Content 8</div>
<div class="TabbedPanelsContent">Content 9</div>
<div class="TabbedPanelsContent">Content 10</div>
<div class="TabbedPanelsContent">Content 11</div>
<div class="TabbedPanelsContent">Content 12</div>
</div>
<script type="text/javascript">
var TabbedPanels1 = new Spry.Widget.TabbedPanels("TabbedPanels1");
</script>
