This code works fine for most searchs and displays fine. But when a few fields are searched (only one comes to mind) it gives me a msql error on what would be line 11 here.
[PHP]$result = mysql_query("SE LECT * " . "FROM $_POST[table] " ."WHERE $_POST[col_select] = $_POST[search_text]");
echo "<table border='1'> <tr>";
$dataQuery=mysq l_query("SELECT * FROM $_POST[table]"); $TableFieldCoun t = mysql_num_field s($dataQuery);
for ($Fcount=0; $Fcount<$TableF ieldCount; $Fcount++)
{
$field2= mysql_fetch_fie ld($dataQuery, $Fcount);
$fieldname2= $field2->name;
echo"<th>".$fie ldname2."</th>";
}
echo "</tr>";
while($row = mysql_fetch_arr ay($result))
{
echo "<tr>";
for ($Fcount=0; $Fcount<$TableF ieldCount; $Fcount++)
{
$field3= mysql_fetch_fie ld($dataQuery, $Fcount); $fieldname3= $field3->name;
echo"<td>".$row[$fieldname3]."</td>";
}
echo "</tr>";
}
mysql_free_resu lt($dataQuery);[/PHP]
[PHP]$result = mysql_query("SE LECT * " . "FROM $_POST[table] " ."WHERE $_POST[col_select] = $_POST[search_text]");
echo "<table border='1'> <tr>";
$dataQuery=mysq l_query("SELECT * FROM $_POST[table]"); $TableFieldCoun t = mysql_num_field s($dataQuery);
for ($Fcount=0; $Fcount<$TableF ieldCount; $Fcount++)
{
$field2= mysql_fetch_fie ld($dataQuery, $Fcount);
$fieldname2= $field2->name;
echo"<th>".$fie ldname2."</th>";
}
echo "</tr>";
while($row = mysql_fetch_arr ay($result))
{
echo "<tr>";
for ($Fcount=0; $Fcount<$TableF ieldCount; $Fcount++)
{
$field3= mysql_fetch_fie ld($dataQuery, $Fcount); $fieldname3= $field3->name;
echo"<td>".$row[$fieldname3]."</td>";
}
echo "</tr>";
}
mysql_free_resu lt($dataQuery);[/PHP]
Comment