PHP / Mysql - Retreive“Next”行数据在“this”中。行 [英] PHP / Mysql - Retreive "Next" Row data in "this" row
问题描述
我想在一个循环中获取脚本的下一行我是
开发...
我需要显示一个最终表表格中显示的页面上有一行显示在页面上,但我只想显示
当前字段的值与下一行的值不同。
例如:
价值1
价值1
价值1
显示行
值2
值2
显示行
值3
值3
显示行
值4
值4
显示行
我尝试过运气很少的mysql_data_seek。
任何帮助都会感激不尽。
Craig >
I am trying to get the next row within a loop for a script i am
developing...
I need to display a final table row within the table that i have
displayed on the page, but i only want to show it if value of the
current field is not the same value of the next row.
eg:
value 1
value 1
value 1
SHOW ROW
value 2
value 2
SHOW ROW
value 3
value 3
SHOW ROW
value 4
value 4
SHOW ROW
I have tried mysql_data_seek with very little luck.
Any help would be grateful.
Craig
推荐答案
craig.keightley写道:
craig.keightley wrote:
value 1
value 1
value 1
SHOW ROW
value 2
value 2
SHOW ROW
价值3
价值3
显示行
价值4
价值4
SHOW ROW
value 1
value 1
value 1
SHOW ROW
value 2
value 2
SHOW ROW
value 3
value 3
SHOW ROW
value 4
value 4
SHOW ROW
横向思考,是SELECT DISTINCT一个选项?
如果没有,基本技术是这样的:
<?php
Thinking laterally, is "SELECT DISTINCT" an option?
If not, the basic technique is this:
<?php
oldvals = array();
while(
oldvals = array();
while (
newvals = fetch_row_from_db())
{
if(
newvals = fetch_row_from_db())
{
if (
这篇关于PHP / Mysql - Retreive“Next”行数据在“this”中。行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!