mysql数字显示,如何从MySQL显示数据

梦里梦外; 2022-10-04 12:56 206阅读 0赞

![Image 1][]

I created an Online Time Table and it's working fine and user or me can add new time-table row by using some data and my end result is like.

This is my SQL query (Please don't warn me to use MySQLi or PDO, I know about them, but this is a private application and I can write unsafe codes thought.)

$date = date("d/m/y");

$sql = "SELECT \* FROM \`s\_timetable\` WHERE \`date\` = '$date'";

$res = mysql\_query($sql) or die(mysql\_error());

while ($fetch\_data = mysql\_fetch\_array($res)) \{

echo "

" .$fetch\_data\['batch\_info'\]. "";

echo "

" .$fetch\_data\['class\_info'\]. "";

echo "

" .$fetch\_data\['subject\_info'\]. "";

echo "

" .$fetch\_data\['teacher\_info'\]. "";

echo "

but after querying this to database, I got lots of results with same value, how can i show them as group.

Example:

LDC batch - 08:09 - science - Ashok B.

LDC batch - 09-10 - English - Jaky

LDC batch - 10-11 - Maths - Bella

Now how i can display these data as table, with title of LDC batch as that repeat in all and then time subject and teacher info with table body.

解决方案

One option here is to present a 3 column HTML table containing the time, subject, and teacher data for each batch. When the batch type changes in the result set, a new row can be printed as a header.

$header = "";

while ($fetch\_data = mysql\_fetch\_array($res)) \{

if ($header = "" || $header != $fetch\_data\['batch\_info'\]) \{

echo "

".$fetch\_data\['batch\_info'\]."";

$header = $fetch\_data\['batch\_info'\];

echo "

" .$fetch\_data\['class\_info'\]. "";

echo "

" .$fetch\_data\['subject\_info'\]. "";

echo "

" .$fetch\_data\['teacher\_info'\]. "";

echo "

Update:

As @apokryfos pointed out, you should order your result set by the batch\_info column to ensure that records belonging to the same batch are always adjacent. So your query might become:

SELECT \*

FROM s\_timetable

WHERE date = '$date'

ORDER BY batch\_info

[Image 1]: