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.
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.