Ive been trying to put together a stock search system with PHP and MySQL - so far so good. The data is displayed in a table and to aid usuability i want to populate some cells with a tabindex so users can tab through the results table - but im not sure how.
Here is (what i think is) the relevent part of my code:
// Search the database
$query = mysql_query("SELECT * FROM `Stock Search` WHERE `Part Number` LIKE '%$PartSearch%'") or die(mysql_error());
// Display the results
$NumberResults = mysql_num_rows($query);
// If no results are found
if ($NumberResults == 0) {
echo 'No results were found for: "' . $PartSearch . '"<br />';
echo '<a href="/search.php">Click here</a> to go back <br />';
}
// Display the reuslts that are found
else
{
echo $NumberResults . ' matching parts found: <br />';
// Show the results table and build a new form
echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="post">';
echo '<table border="1" align="center">';
echo '<tr>';
echo '<th>RFQ</th>';
echo '<th>Part Number</th>';
echo '<th>Manufacturer</th>';
echo '<th>Stock</th>';
echo '<th>Quantity</th>';
echo '<th>Delivery</th>';
echo '</tr>';
while ($rows = mysql_fetch_array($query))
{
echo '<tr>';
echo '<td><input type="checkbox" value="' . $rows['Part Number'] . '" name="RFQ[]"></td>';
echo '<td>' . $rows['Part Number'] . '</td>';
echo '<td>' . $rows['Manufacturer'] . '</td>';
echo '<td>' . $rows['Stock'] . '</td>';
echo '<td><input type="text" name="Quantity" /></td>';
echo '<td><select name="Delivery">
<option value="Any">Any</option>
<option value="Emergency">Emergency</option>
<option value="Next Day">Next Day</option>
<option value="2-3">2-3 Days</option>
<option value="4-6">4-6 Days</option>
<option value="7-10">7-10 Days</option>
<option value="10+">10+ Days</option>
</select></td>';
echo '</tr>';
}
echo '</table>';
I want to have a tabindex on each Quantity and Delivery cell, but im not sure how to achieve it? (To be honest i dont think it helps that i dont fully understand how the while query works).
Question
Bollard
Hello,
Ive been trying to put together a stock search system with PHP and MySQL - so far so good. The data is displayed in a table and to aid usuability i want to populate some cells with a tabindex so users can tab through the results table - but im not sure how.
Here is (what i think is) the relevent part of my code:
// Search the database $query = mysql_query("SELECT * FROM `Stock Search` WHERE `Part Number` LIKE '%$PartSearch%'") or die(mysql_error()); // Display the results $NumberResults = mysql_num_rows($query); // If no results are found if ($NumberResults == 0) { echo 'No results were found for: "' . $PartSearch . '"<br />'; echo '<a href="/search.php">Click here</a> to go back <br />'; } // Display the reuslts that are found else { echo $NumberResults . ' matching parts found: <br />'; // Show the results table and build a new form echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="post">'; echo '<table border="1" align="center">'; echo '<tr>'; echo '<th>RFQ</th>'; echo '<th>Part Number</th>'; echo '<th>Manufacturer</th>'; echo '<th>Stock</th>'; echo '<th>Quantity</th>'; echo '<th>Delivery</th>'; echo '</tr>'; while ($rows = mysql_fetch_array($query)) { echo '<tr>'; echo '<td><input type="checkbox" value="' . $rows['Part Number'] . '" name="RFQ[]"></td>'; echo '<td>' . $rows['Part Number'] . '</td>'; echo '<td>' . $rows['Manufacturer'] . '</td>'; echo '<td>' . $rows['Stock'] . '</td>'; echo '<td><input type="text" name="Quantity" /></td>'; echo '<td><select name="Delivery"> <option value="Any">Any</option> <option value="Emergency">Emergency</option> <option value="Next Day">Next Day</option> <option value="2-3">2-3 Days</option> <option value="4-6">4-6 Days</option> <option value="7-10">7-10 Days</option> <option value="10+">10+ Days</option> </select></td>'; echo '</tr>'; } echo '</table>';I want to have a tabindex on each Quantity and Delivery cell, but im not sure how to achieve it? (To be honest i dont think it helps that i dont fully understand how the while query works).
Any help would be greatly appreciated
Link to comment
Share on other sites
5 answers to this question
Recommended Posts