Display a first record of two different columns on two separate inputs

Israel

Hi Sirs,

The code I wrote are fine. But I cannot display records after filter. The what I need it's simple. I have two separate records on top of my form or outside of my form. After the interval of year be filtered I would love to see the first record be displayed on those separated inputs (girls on input1 and boys on input2). Any filter I do the first record should be displayed separetly. Thank you!

if(isset($_POST['recherche']))

{

include('testdb.php');

$valueToSearch = $_POST['valueToSearch'];

// search in all table columns on a specific column

$query = "SELECT * FROM statflex_info WHERE year = '$valueToSearch'";

$search_result = filterTable($query);

}

else {

$query = "SELECT * FROM statflex_info ORDER BY id DESC LIMIT 10";

}

// function to connect and execute the query

function filterTable($query)

{

$connect = mysqli_connect("x","xx","xxx","xxxx");

$filter_Result = mysqli_query($connect, $query);

return $filter_Result;

}

Recherche

. Effectifs numériques total d'Elèves .

// $total_price = 0;

while($row = mysqli_fetch_array($search_result))

{

echo "

// add the price to the total

$total_girls += $row['sexe_girls_number'];

$total_boys += $row['sexe_boys_number'];

$total = ($total_girls + $total_boys);

}

// add a last row to display only the total price in the last column

echo "

// closeing table tag

echo "

code_city	girls	boys	total
" . $row['code_city'] . "	" . $row['girls_number'] . "	" . $row['boys_number'] . "
	$total_girls	$total_boys	$total

mysqli_close($con);

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Israel7mo ago
Not anyone to help one my codes please. I am stucked. Thanx!
Israel7mo ago
Hi Sirs,
code_city------------girls_number------------boys_number
paris002----------------------51---------------------------59
paris002----------------------30---------------------------33
Newdeli001------------------33---------------------------20
Newdeli001------------------125--------------------------85
Newdeli001-------------------66---------------------------25
paris002-----------------------77--------------------------100
When I filter the year he filter and display the first record as recommended. Unfortuntly the two last records disapear from the table and show ONLY the first row on the same table. My target is to filter the code's city without hidde others records from the table.
I am not sure if I am clear. Thank you.
Please could you see what I try to do. Its shown the first record but curiosly the table also show ONLY the single:
if(isset($_POST['recherche']))
{
include('testdb.php');
$valueToSearch = $_POST['valueToSearch'];
// search in all table columns on a specific column
$query = "SELECT * FROM statflex_info WHERE year = '$valueToSearch'";
$search_result = filterTable($query);
$firstRecordValue = "";
if ($search_result->num_rows > 0) {
$row = $search_result->fetch_assoc();
$firstRecordValue = $row['code_city'];
} else {
$firstRecordValue = "No records found";
}
}
else {
// function to connect and execute the query
function filterTable($query)
{
$connect = mysqli_connect("x","xx","xxx","xxxx");
$filter_Result = mysqli_query($connect, $query);
return $filter_Result;
}
?>
First Record Details
First Record Value:
Details:

Display a first record of two different columns on two separate inputs

. Effectifs numériques total d'Elèves .

First Record Details