is_null fix it help NightMare !!

skip

Ok picture the scene MySQL Table spec1, spec2, spec3 ... upto spec50

now they will contain data upto any given field and not beyond so if spec30 has a value and spec31 does not spec1 - spec30 will all contain data.

what I am trying to do is page the results in groups of 10 printing a more (Next) link for the next set of data if the first field in that group contains data if it does not I want to print a close window link instead..

of course I have made a right mess of it .. Please can someone help me out. 🙂

thanks all in advance...

<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); 
		$myPage = $ix+ 1;
		$npage = $page + 1;
		$nextpage = "spec$myPage";
		$Mnextpage = $row_Recordset1['spec$myPage'];
		echo $row_Recordset1['spec$myPage'];
		if(is_null($Mnextpage)){
		?>
		<br>
		<a href="javascript:window.close;">Close Window</a>
		<?php
		}else{
		?>
		<a href="fullspec_popup.php?handset=<?php echo $myTariff;?>&page=<?php echo $npage;?>">More</a>
		<?php } ?>

Trs2988

I'm having a bit of trouble following your code, but I do see something that could be making it go wrong.

First line should be:

while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)) {

Notice that it ends with a bracket ( { ) instead of a semicolon. If you just do the semicolon, it will end the while loop right there, and then only execute the stuff below it once.

Also, a couple suggestions:

1) Use the

 tag instead of the [code] tag, it makes the PHP look all pretty. Not to mention it's easier to read.
2) You may want to learn how to use [URL=http://www.php.net/echo]echo[/URL] or [URL=http://www.php.net/print]print[/URL]. You don't have to use the <? ?> tags every time you want to output something, that's just a waste of time and it makes your code more confusing.
3) Not sure why you need 50 columns, but there's probably a much better way to do it.

skip

Hi thanks for your response.

Its a product feed which goes into a mysql database each field contains a specifiaction there can be upto 50 per product what I would do in ASP is

grab the recordset and stuff it into an array using getrows then loop through the array testing the next value as I went for Null then exit the for loop in php I have no clue 🙂

somthing like:

for i = to Ubound(MyArray)
testVar = i + 1
if isNull(MyArray(testVar)) then
Exit for
else
response.write(MyArray(i)&"<br>")
End if
Next

of course I would page it as well

OOh Forgot to add I have all 50 fields open in a recordset thats why it ends there

I loop from $page (1 if $page is not set) to $page + 10 then in the bit pasted I check page+ 10 + 1 to see if it has a value then make the fieldnames up using 'spec$i' type thing 🙂

Sxooter

Here's pseudo code for how I'd do it:

while ($row = fetch_row($res)){
    foreach($row as $r){
        if (!is_null($r)){
            print $r;
        }
    }
}