Hi ,
i am trying to retrieve a row of data from a SQL table,but i dont get the results,i just get the variable($stock_code) that i use to search for the row on the screen.
<?php
include "dbaccess.php";
$stock_code=$_POST["txtStock"];
// Insert the required SQL query here.
$query = "SELECT STOCK_CODE FROM STOCKS WHERE STOCK_CODE = '$stock_code'";
$result = submitSQL($query, "read", 0, 0);
for ($i = 0; $i < count($result['STOCK_CODE']); $i++) {
// The for loop is used to display one result per row.
// Preferably use a key field for the count.
// Note: The fieldname must be UPPERCASE
// The next two lines are optional and are used only to help document the table structure
// in the resulting HTML code.
$row_number = $i + 1;
// For each row of SQL output, create a row in an HTML table and then
// add a data element for each field as required.
// Notes: 1. The \n additions are only to clean up the appearance of the HTML code
// but do not affect operation hence they are also optional.
// 2. The lines that contain $result need to have the appropriate field names
// in them in UPPERCASE.
echo "\n";
echo "";
echo $result['STOCK_CODE'][$i];
echo "\n";
echo $result['STOCK_NAME'][$i];
echo "\n";
echo $result['PRICE'][$i];
echo "\n";
echo $result['QUANTITY_AVAILABLE'][$i];
echo "\n";
echo "\n";
}
?>
Any suggestions???:(
