NEWBIE question
Posted: Wed Mar 25, 2009 5:06 pm
I am sorry for asking this but i need help. What i write is giving me correct result but i am very sure there is an easier and better way to write this code.
Code: Select all
$query_Recordset1 = "SELECT `name`,`pid` FROM list WHERE `sanid` = 14 ORDER BY name";
$query_Recordset2 = "SELECT `name`,`pid` FROM list WHERE `sanid` = 15 ORDER BY name";
$query_Recordset3 = "SELECT `name`,`pid` FROM list WHERE `sanid` = 16 ORDER BY name";
$query_Recordset4 = "SELECT `name`,`pid` FROM list WHERE `sanid` = 18 ORDER BY name";
$query_Recordset5 = "SELECT `name`,`pid` FROM list WHERE `sanid` = 19 ORDER BY name";
$Recordset1 = mysql_query($query_Recordset1, $French) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
$Recordset2 = mysql_query($query_Recordset2, $French) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
$Recordset3 = mysql_query($query_Recordset3, $French) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);
$Recordset4 = mysql_query($query_Recordset4, $French) or die(mysql_error());
$row_Recordset4 = mysql_fetch_assoc($Recordset4);
$totalRows_Recordset4 = mysql_num_rows($Recordset4);
$Recordset5 = mysql_query($query_Recordset5, $French) or die(mysql_error());
$row_Recordset5 = mysql_fetch_assoc($Recordset5);
$totalRows_Recordset5 = mysql_num_rows($Recordset5);