PDA

View Full Version : Recordset not showing up in the bindings panel?


ijk76319396
11-17-2010, 12:48 PM
I have this recordset on my page which is functioning fine, however it doesn't appear in the recordset bindings panel. Is there an error or something in the code that is preventing it from doing so?

This is the code

mysql_select_db($database_con2com, $con2com);
$query_rsVOTES = "SELECT username, Sum(score) FROM points
GROUP BY username ORDER by Sum(score) DESC LIMIT 0,1";
$rsVOTES = mysql_query($query_rsVOTES, $con2com) or die(mysql_error());
$row_rsVOTES = mysql_fetch_assoc($rsVOTES);
$totalRows_rsVOTES = mysql_num_rows($rsVOTES);

I need it to show up because I am trying to run a repeat region too.

ijk76319396
11-18-2010, 01:22 AM
For anyone who might have had this problem it was due to the 2nd string of code not being on the same line. Really weird and simple fix. I guess they all have to be on the same line. So the correct code looks like





mysql_select_db($database_con2com, $con2com);
$query_rsVOTES = "SELECT username, descrpt, title, website, userID, Sum(score) FROM points GROUP BY username ORDER BY Sum(score) DESC LIMIT 0,1";
$rsVOTES = mysql_query($query_rsVOTES, $con2com) or die(mysql_error());
$row_rsVOTES = mysql_fetch_assoc($rsVOTES);
$totalRows_rsVOTES = mysql_num_rows($rsVOTES);

Jason Byrnes
11-18-2010, 10:48 AM
Glad to hear you have solved the issue.