$colname_Recordset1 = "1"; mysql_select_db($database_tour, $tour); $query_Recordset1 = sprintf("SELECT * from programme_omra where id_prog='1' ", $colname_Recordset1); $Recordset1 = mysql_query($query_Recordset1, $tour) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); $colname_Recordset2 = "1"; mysql_select_db($database_tour, $tour); $query_Recordset2 = sprintf("SELECT * from programme_omra where id_prog='2' ", $colname_Recordset2); $Recordset2 = mysql_query($query_Recordset2, $tour) or die(mysql_error()); $row_Recordset2 = mysql_fetch_assoc($Recordset2); $totalRows_Recordset2 = mysql_num_rows($Recordset2); $colname_Recordset3 = "1"; mysql_select_db($database_tour, $tour); $query_Recordset3 = sprintf("SELECT * from programme_omra where id_prog='3' ", $colname_Recordset3); $Recordset3 = mysql_query($query_Recordset3, $tour) or die(mysql_error()); $row_Recordset3 = mysql_fetch_assoc($Recordset3); $totalRows_Recordset3 = mysql_num_rows($Recordset3); $colname_Recordset4 = "1"; mysql_select_db($database_tour, $tour); $query_Recordset4 = sprintf("SELECT * from programme_omra where id_prog='4' ", $colname_Recordset4); $Recordset4 = mysql_query($query_Recordset4, $tour) or die(mysql_error()); $row_Recordset4 = mysql_fetch_assoc($Recordset4); $totalRows_Recordset4 = mysql_num_rows($Recordset4); $colname_Recordset5 = "1"; mysql_select_db($database_tour, $tour); $query_Recordset5 = sprintf("SELECT * from programme_omra where id_prog='5' ", $colname_Recordset5); $Recordset5 = mysql_query($query_Recordset5, $tour) or die(mysql_error()); $row_Recordset5 = mysql_fetch_assoc($Recordset5); $totalRows_Recordset5 = mysql_num_rows($Recordset5); $colname_Recordset6 = "1"; mysql_select_db($database_tour, $tour); $query_Recordset6 = sprintf("SELECT * from programme_omra where id_prog='6' ", $colname_Recordset6); $Recordset6 = mysql_query($query_Recordset6, $tour) or die(mysql_error()); $row_Recordset6 = mysql_fetch_assoc($Recordset6); $totalRows_Recordset6 = mysql_num_rows($Recordset6); ?>