[Resolved] Problems with <?

[rcoursey]

Please check this code and let me know the problem. For some reason the PHP open tag is not causing the script to read the PHP code:

while($rowplay=mysql_fetch_array($resultplay))
{
?>
	<tr>
	<td></td>
	<td colspan="2"><div align="left"><? echo $row['title'];?></div></td>
	<td><input type="checkbox" name="playlist[]" value="<? echo $rowlst['playid'];?>" <?
		while($rowlst=mysql_fetch_array($resultlst))
			{
				echo $rowlist['playid']==$rowplay['playid']? checked:'';
			} //end While
	?>></td>
	<td></td>
	</tr>
<?
}
?>
<tr>

[webhamster]

Instead of doing it that way (which can be very messy when you run into problems like this, from my experience 🙂 ) why not format it something more like this:

while($rowplay=mysql_fetch_array($resultplay)) { 
	print "<tr>\n<td>\n</td>\n";
	print "<td colspan=\"2\">\n";
	print "<div align=\"left\">\n$row['title']\n</div>\n";
	print "</td>\n";
	print "<td>\n";
	print "<input type=\"checkbox\" name=\"playlist[]\" value=\"$rowlst['playid']\" ";
	while($rowlst=mysql_fetch_array($resultlst)) 
	{ 
		if ($rowlst['playid'] == $rowplay['playid']) {
			print "CHECKED"; 
			}
	} 
	print ">\n";
	print "</td>\n<td>\n</td>\n</tr>\n";
}

I would also be interested in seeing your queries because I think you could format them a little more efficiently.

Hope this helps.

[rcoursey]

I tried the code.

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /var/www/html/dunhill/admin/pkg-edit.php on line 164

Line 164 is:

print "<div align=\"left\">\n$rowplay['title']\n</div>\n";

[webhamster]

I think that error applies specifically to this: $rowplay['title'] which is coming from one of your queries. I copied that out of what you supplied so I'm just assuming it's correct. You might want to check that... 😉

[lanjoky]

<?
while($rowplay=mysql_fetch_array($resultplay)) 
{ 
?> 
<tr> 
<td></td> 
<td colspan="2"><div align="left"><? echo $row['title'];?></div></td> 
<td><input type="checkbox" name="playlist[]" value="<? echo $rowlst['playid'];?>" <? 
while($rowlst=mysql_fetch_array($resultlst)) 
{ 
         if($rowlist['playid']==$rowplay['playid']){
                echo "Checked"; 
         }// TRY it this way
} //end While 
?>></td> statement -->
<td></td> 
</tr> 
<? 
} 
?> 
<tr>

OK try it the way I have it above and see if that works for you!!

[rcoursey]

My goal here is to fill in a series of checkboxes.

If I run the query directly into the pkg_items table I have multiple rows of pkgid's and the associated playid. The table can have multiple pkgid's that are the same associated with playid's which are unique to the same pkgid.

ie.

pkgid = x playid = 2
pkgid = x playid = 3
pkgid = x playid = 4
pkgid = x playid = 7

pkgid x cannot have two playid's = 7.

pkgid = y playid = 2
pkgid = y playid = 5
pkgid = y playid = 7
pkgid = y playid = 3

pkgid y can have the same playid's as pkgid x but cannot repeat the playid's.

When the query runs in the script it only gets one record for the pkgid even I know there are 3.

[rcoursey]

The issue changed so I started another thread.