100+ results results for 'mysql_query repo:viollarr/alab' (163 ms)
19$query = "select *, unix_timestamp(comDateTo) as comUnixTo from tblCompetition where comPk=$comPk"; 20$result = mysql_query($query) or die('Query failed: ' . mysql_error()); 21$title = 'highcloud.net'; 123 $query = "select pilPk, pilHGFA from tblPilot where pilLastName='$name'"; 124 $result = mysql_query($query) or die('Query failed: ' . mysql_error()); 125 171 $query = "select T.tasPk, T.tasTaskType, C.comType from tblTask T, tblTrack TL, tblCompetition C where C.comPk=T.comPk and T.comPk=$comid and TL.traPk=$maxPk and TL.traStart > date_sub(T.tasDate, interval C.comTimeOffset hour) and TL.traStart < date_add(T.tasDate, interval (24-C.comTimeOffset) hour)"; 172 $result = mysql_query($query) or die('Query failed: ' . mysql_error()); 173 if (mysql_num_rows($result) > 0) 181 $query = "insert into tblComTaskTrack (comPk,tasPk,traPk) values ($comid,$tasPk,$maxPk)"; 182 $result = mysql_query($query) or die('ComTaskTrack failed: ' . mysql_error()); 183 225 $query = "update tblTrack set traGlider='$glider', traDHV='$dhv' where traPk=$maxPk"; 226 $result = mysql_query($query) or die('Update tblTrack failed: ' . mysql_error()); 227ebpls_abstractcoll.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 260 lines
72 73 $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference") 74 or die(mysql_error()); 75 $resulta=mysql_fetch_row($result); 76$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'"); 77$getlgu = @mysql_fetch_row($getlgu); 77$getlgu = @mysql_fetch_row($getlgu); 78$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'"); 79$getprov = @mysql_fetch_row($getprov); 112$prefset = FetchArray($dbtype,$staxfee); 113 // $result = mysql_query("select tfodesc from ebpls_buss_tfo limit 8") 114$sassess = $prefset[staxesfees]; 115 116 $result = mysql_query("select a.tfoid, a.tfodesc from ebpls_buss_tfo a, rpt_temp_abs b 117 where a.tfoid=b.tfoid ") ;ebpls_bus_indtaxdelinquent.html http://ebpls.googlecode.com/svn/trunk/ | HTML | 199 lines
28 29 $result=mysql_query("select lgumunicipality, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error()); 30 $resulta=mysql_fetch_row($result); 126 // unang gawang tama 127 $result=mysql_query("select ' ', ' ', ' ' , ' ', ' ' 128 from ebpls_business_enterprise") or die(mysql_error()); 131 /* sample/test ko lng 132 $result=mysql_query("select a.owner_id, a.business_name, a.business_city_code, a.business_type_code, 133 a.business_street, a.business_capital_investment, a.business_last_yrs_dec_gross_sales, b.fee_amount, 160 161 $result=mysql_query("select gs_name, gs_pos, gs_office from global_sign where sign_id =1") or die(mysql_error()); 162 $resulta=mysql_fetch_row($result);ebpls_ctc_issued.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 214 lines
82 83 $result=@mysql_query("select lguname, lguprovince from ebpls_buss_preference") 84 or die(mysql_error()); 85 $resulta=mysql_fetch_row($result); 86$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'"); 87$getlgu = @mysql_fetch_row($getlgu); 87$getlgu = @mysql_fetch_row($getlgu); 88$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'"); 89$getprov = @mysql_fetch_row($getprov); 115$date_to = date('Y-m-d', $xdate); 116 $result1=mysql_query("select concat(ctc_first_name, ' ', ctc_middle_name, ' ', ctc_last_name) as name, ctc_code, 117 ctc_address, ctc_date_issued, ctc_tax_due, ctc_tax_interest, ctc_additional_tax1, ctc_additional_tax2, ctc_additional_tax3 from ebpls_ctc_individual where ctc_date_issued between '$date_from' and '$date_to' order by name asc") 119 $x1 = @mysql_num_rows($result1); 120 $result2=mysql_query("select ctc_company, ctc_code, ctc_company_address, ctc_date_issued, ctc_tax_due, ctc_tax_interest, ctc_additional_tax1, ctc_additional_tax2 from ebpls_ctc_business where ctc_date_issued between '$date_from' and '$date_to' order by ctc_company asc") 121 or die(mysql_error());Database.singleton.php https://code.google.com/p/gctour/ | PHP | 311 lines
132 // do query 133 $this->query_id = @mysql_query($sql, $this->link_id); 134ebpls.reportgenerator.funcs.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 458 lines
84 85 $res = mysql_query( $sqlSelect, $dbLink ); 86 111 112 $res = mysql_query( $sqlSelect, $dbLink ); 113 139 140 $res = mysql_query( $sqlSelect, $dbLink ); 141 166 167 $res = mysql_query( $sqlSelect, $dbLink ); 168 200 201 $res = mysql_query( $sqlSelect, $dbLink ); 202mutate_htmlsnippet.dynamic.php https://github.com/garryn/evolution.git | PHP | 225 lines
35$sql = 'SELECT internalKey, username FROM '.$tbl_active_users.' WHERE action=78 AND id=\''.$id.'\''; 36$rs = mysql_query($sql); 37$limit = mysql_num_rows($rs); 51 $sql = 'SELECT * FROM '.$tbl_site_htmlsnippets.' WHERE id=\''.$id.'\''; 52 $rs = mysql_query($sql); 53 $limit = mysql_num_rows($rs);class.eyemysqladap.inc.php https://github.com/kevinroberts/snippetz.git | PHP | 438 lines
116 { 117 $result = mysql_query($query, $this->link); 118mysql.php http://seo-phpbb.googlecode.com/svn/trunk/ | PHP | 479 lines
58 { 59 @mysql_query("SET NAMES 'utf8'", $this->db_connect_id); 60 // enforce strict mode on databases that support it 62 { 63 $result = @mysql_query('SELECT @@session.sql_mode AS sql_mode', $this->db_connect_id); 64 $row = @mysql_fetch_assoc($result); 82 $mode = implode(',', $modes); 83 @mysql_query("SET SESSION sql_mode='{$mode}'", $this->db_connect_id); 84 } 114 case 'begin': 115 return @mysql_query('BEGIN', $this->db_connect_id); 116 break; 118 case 'commit': 119 return @mysql_query('COMMIT', $this->db_connect_id); 120 break;install.php https://code.google.com/p/ezrpg/ | PHP | 340 lines
170QUERY; 171 mysql_query($query1) or die('Something went wrong.'); 172 184QUERY; 185 mysql_query($query2) or die('Something went wrong.'); 186 309 $query = 'INSERT INTO `' . DB_PREFIX . 'players` (`username`, `password`, `email`, `secret_key`, `registered`, `rank`) VALUES(\'' . mysql_real_escape_string($_POST['username']) . '\', \'' . mysql_real_escape_string(sha1($secret_key . $_POST['password'] . SECRET_KEY)) . '\', \'' . mysql_real_escape_string($_POST['email']) . '\', \'' . mysql_real_escape_string($secret_key) . '\', ' . time() . ', 10)'; 310 mysql_query($query); 311class.Ticker.inc.php http://flaimo-php.googlecode.com/svn/trunk/ | PHP | 266 lines
211 $sql .= ' VALUES (' . $tm->getTimestamp() . ',"' . addslashes($tm->getText()) . '");'; 212 $result = mysql_query($sql, $this->conn) or die ('Request not possible! SQL Statement: ' . $sql . ' / ' . mysql_error()); 213 } // end functionfunctions_db.php https://github.com/justinmc/turkiball.com.git | PHP | 389 lines
34 35 $QUERY = mysql_query("SELECT * FROM $table WHERE Index = '$index'"); 36 $DATA = mysql_fetch_array($QUERY); 54 55 $QUERY = mysql_query("SELECT * FROM $table WHERE `Index` = $index"); 56 $DATA = mysql_fetch_array($QUERY); 74 75 $QUERY = mysql_query("SELECT * FROM smf_messages WHERE ID_MSG = $id"); 76 $DATA = mysql_fetch_array($QUERY); 94 95 $QUERY = mysql_query("SELECT * FROM smf_members WHERE ID_MEMBER = $id"); 96 $DATA = mysql_fetch_array($QUERY); 123 { 124 $QUERY = mysql_query("SELECT * FROM smf_members WHERE ID_MEMBER = $count"); 125 $DATA = mysql_fetch_array($QUERY);trainingNaiveBayes.php https://bitbucket.org/astahiam/penduduk.git | PHP | 300 lines
29 $tabel = "select * from penduduktrain"; 30 $hasilSelect = mysql_query($tabel) or die (mysql_error()); 31 $jumlahRow = mysql_num_rows($hasilSelect); 55 $querycek = "select * from hasiltrain where hasil is not null"; 56 $c = mysql_query($querycek) or die (mysql_error()); 57 if(mysql_num_rows($c) > 0 ) { 62 //echo $querySejahtera; 63 $s = mysql_query($querySejahtera) or die (mysql_error()); 64 $jmlSejahtera = mysql_num_rows($s); 71 //echo $querySejahtera; 72 $p = mysql_query($queryPraSejahtera) or die (mysql_error()); 73 $jmlPraSejahtera = mysql_num_rows($p); 84 $queryNikahSejahtera = "SELECT p.*,h.* FROM penduduktrain p, hasiltrain h WHERE p.nik = h.idpenduduk and p.status = 'MENIKAH' and h.hasil = 'SEJAHTERA'"; 85 $ns = mysql_query($queryNikahSejahtera) or die (mysql_error()); 86 $jmlNikahSejahtera = mysql_num_rows($ns);hours.inc.php https://bitbucket.org/websightdesigns/project-manager.git | PHP | 256 lines
60 //echo $insert_sql . "<br />"; 61 $q = mysql_query($insert_sql); 62 //$_SESSION["command_results"]["addhours"] = "Your hours were added."; 81 $project_sql = "SELECT id FROM projects WHERE project_name LIKE '%" . str_replace($search_project, "", $_POST['search']) . "%'"; 82 $project_q = mysql_query($project_sql); 83 while($i = mysql_fetch_object($project_q)) { 107 $client_sql = "SELECT id FROM clients WHERE fullname LIKE '%" . str_replace($search_client, "", $_POST['search']) . "%'"; 108 $client_q = mysql_query($client_sql); 109 while($i = mysql_fetch_object($client_q)) { 133 $task_sql = "SELECT id FROM tasks WHERE task_title LIKE '%" . str_replace($search_task, "", $_POST['search']) . "%'"; 134 $task_q = mysql_query($task_sql); 135 while($i = mysql_fetch_object($task_q)) { 182 //echo "<pre>".$sql."</pre><br />"; 183 $q = mysql_query($sql) or die(mysql_error()); 184 $total_numrows = mysql_num_rows($q);searchFriend.php http://projetwebdubail.googlecode.com/svn/trunk/ | PHP | 255 lines
104 105 $data=mysql_query($sql, $link); 106 158 $reqvote="SELECT COUNT(*) FROM voteutilisateur WHERE idVotant=".$_SESSION['userID']." AND idUtilisateur=".$id.";"; 159 $SQLVote=mysql_query($reqvote, $link); 160 $resultVote=mysql_result($SQLVote, 0); 246$req="SELECT COUNT(utilisateur.idUtilisateur) FROM utilisateur, estAmi WHERE estAmi.idUtilisateur=".$_SESSION['userID']." AND estAmi.idAmi=".$id." ; "; 247$sql=mysql_query($req, $link); 248$resultVote=mysql_result($sql, 0);mysql.inc git://pkgs.fedoraproject.org/mrbs | PHP | 508 lines
43 44 if (mysql_query($sql, $db_conn)) 45 { 57// a MIN or MAX aggregate function applied over no rows. 58function sql_mysql_query1 ($sql, $db_conn = null) 59{ 61 62 $r = mysql_query($sql, $db_conn); 63 if (! $r) 79// Returns 0 on error; use sql_error to get the error message. 80function sql_mysql_query ($sql, $db_conn = null) 81{ 83 84 $r = mysql_query($sql, $db_conn); 85 return $r;mysql_query.c git://github.com/xbmc/xbmc.git | C | 371 lines
48{ 49 cmyth_mysql_query_t * query = (cmyth_mysql_query_t *)p; 50 if(query->buf != NULL) 206int 207cmyth_mysql_query_param_long(cmyth_mysql_query_t * query,long param) 208{ 221int 222cmyth_mysql_query_param_ulong(cmyth_mysql_query_t * query,unsigned long param) 223{ 280int 281cmyth_mysql_query_param_str(cmyth_mysql_query_t * query, const char *param) 282{ 350int 351cmyth_mysql_query(cmyth_mysql_query_t * query) 352{task.php http://airscore.googlecode.com/svn/trunk/ | PHP | 430 lines
37 $sql = "select T.*, TW.* from tblTask T left outer join tblTaskWaypoint TW on T.tasPk=TW.tasPk and TW.tawType='goal' where T.tasPk=$tasPk"; 38 $result = mysql_query($sql,$link) 39 or die('Task not associated correctly with a competition: ' . mysql_error()); 73 $query = "select traPk from tblComTaskTrack where tasPk=$tasPk"; 74 $result = mysql_query($query,$link); 75 $tracks = array(); 98$query = "select comPk from tblTask where tasPk=$tasPk"; 99$result = mysql_query($query) or die('Task not associated with a competition: ' . mysql_error()); 100$comPk = mysql_result($result,0,0); 121 $query = "insert into tblTaskAirspace (tasPk, airPk) values ($tasPk, $airPk)"; 122 $result = mysql_query($query) or die('Failed to connect airspace to task ' . mysql_error()); 123} 130 $query = "delete from tblTaskAirspace where taPk=$taPk"; 131 $result = mysql_query($query) or die('Failed to delete airspace association ' . mysql_error()); 132 }index.php http://clients-oriented-ftp.googlecode.com/svn/trunk/ | PHP | 308 lines
20 foreach ($query as $i => $value) { 21 $result = mysql_query($query[$i]); 22 if (mysql_error()) {themes.php http://novaboard.googlecode.com/svn/trunk/ | PHP | 487 lines
103 104mysql_query("UPDATE {$db_prefix}settings SET theme_order='$order', theme_limit='$limit', theme_method='$method'"); 105 217 218mysql_query("DELETE FROM {$db_prefix}themes WHERE theme_name ='$theme_name'"); 219 219 220mysql_query("INSERT INTO {$db_prefix}themes (theme_name, installed) VALUES ('$theme_name', '1')"); 221 273 274mysql_query("DELETE FROM {$db_prefix}themes WHERE theme_name ='$theme_name'"); 275class.plugin.php https://bitbucket.org/icarito/pmc | PHP | 255 lines
28 29 $ins = mysql_query("INSERT INTO plugins (name,description) VALUES ('$name','$description')"); 30 if ($ins) 57 $plugin = (int) $plugin; 58 $del = mysql_query("DELETE FROM plugins WHERE ID = $plugin"); 59 $this->delAllPluginEvents($plugin); 79 $plugin = (int) $plugin; 80 $upd = mysql_query("UPDATE plugins SET state = 1 WHERE ID = $id"); 81 } 91 $plugin = (int) $plugin; 92 $upd = mysql_query("UPDATE plugins SET state = 0 WHERE ID = $id"); 93 } 104 105 $sel = mysql_query("SELECT ID FROM plugins WHERE name = '$pluginname'"); 106 $chk = mysql_fetch_row($sel);diff.php http://timoseven.googlecode.com/svn/trunk/ | PHP | 419 lines
55 $sql="SELECT distinct ISP from iplist"; 56 $result = mysql_query($sql); 57 if (isset($_POST['submit']) || isset($_POST['sort1']) ||isset($_POST['sort2'])) { 60 $sql1 = "SELECT distinct ISP from iplist where ISP <> '$subisp'"; 61 $result1 = mysql_query($sql1); 62 while($record = mysql_fetch_array($result1)) { 81 $sql="SELECT distinct province from iplist order by province"; 82 $result = mysql_query($sql); 83 while($record = mysql_fetch_array($result)) { 105 $sql="select distinct bestregion from stat order by bestregion"; 106 $result = mysql_query($sql); 107 if (isset($_POST['submit']) || isset($_POST['sort1']) ||isset($_POST['sort2'])) { 110 $sql1="select distinct bestregion from stat where bestregion <> '$subtest1' order by bestregion"; 111 $result1 = mysql_query($sql1); 112 while($record = mysql_fetch_array($result1)) {buscar_producto.php https://code.google.com/p/zapatillas-4-dsw1/ | PHP | 269 lines
35$query_Color = "SELECT * FROM Color"; 36$Color = mysql_query($query_Color, $db_zapatos) or die(mysql_error()); 37$row_Color = mysql_fetch_assoc($Color); 40$query_Talla = "SELECT * FROM Talla"; 41$Talla = mysql_query($query_Talla, $db_zapatos) or die(mysql_error()); 42$row_Talla = mysql_fetch_assoc($Talla); 45$query_Modelo = "SELECT mod_id, mod_descripcion FROM Modelo"; 46$Modelo = mysql_query($query_Modelo, $db_zapatos) or die(mysql_error()); 47$row_Modelo = mysql_fetch_assoc($Modelo); 50$query_PerfilCliente = "SELECT perfc_id, perfc_descripcion FROM Perfil_Cliente"; 51$PerfilCliente = mysql_query($query_PerfilCliente, $db_zapatos) or die(mysql_error()); 52$row_PerfilCliente = mysql_fetch_assoc($PerfilCliente); 55$query_Tipo = "SELECT * FROM Tipo"; 56$Tipo = mysql_query($query_Tipo, $db_zapatos) or die(mysql_error()); 57$row_Tipo = mysql_fetch_assoc($Tipo);database.php https://bitbucket.org/sspssp/akk-berlin.git | PHP | 578 lines
102 103 $out=mysql_query( $query , $this->db ) or die('something went wrong'); 104 126 127 mysql_query( $query , $this->db ) or die('somethnig went wrong'); 128 143 144 mysql_query( $query , $this->db ) or die('somethnig went wrong'); 145 163 164 mysql_query( $query , $this->db ) or die('somethnig went wrong'); 165 185 186 mysql_query( $query , $this->db ) or die('somethnig went wrong'); 187inc.openup.php http://dj-r-old-admin.googlecode.com/svn/trunk/ | PHP | 251 lines
39 40 $res_openup=mysql_query($sql_openup,$db); 41 while($ligne_openup=mysql_fetch_object($res_openup)) 113 ORDER BY date_out DESC, etat_num"; 114 $res_events=mysql_query($sql_events,$db); 115 $total_loc_out=0;class_db_mysql.php http://lansuite.googlecode.com/svn/trunk/ | PHP | 267 lines
31 $this->errorsFound = 1; 32 // Need to use mysql_querys here, to prevent loops!! 33 $query = 'INSERT INTO '. $config['database']['prefix'] .'log SET date = NOW(), userid = '. (int)$auth['userid'] .', type = 3, description = "'. strip_tags($error) .'", sort_tag = "SQL-Fehler"'; 34 if ($this->mysqli) mysqli_query($this->link_id, $query); 35 else mysql_query($query, $this->link_id); 36 91 if ($this->mysqli) @mysqli_query($this->link_id, "/*!40101 SET NAMES utf8_general_ci */;"); 92 else @mysql_query("/*!40101 SET NAMES utf8_general_ci */;", $this->link_id); 93 $this->success = true; 100 if ($this->mysqli) @mysqli_query($this->link_id, "/*!40101 SET NAMES utf8_general_ci */;"); 101 else @mysql_query("/*!40101 SET NAMES utf8_general_ci */;", $this->link_id); 102 } 138 } else { 139 $this->query_id = mysql_query($query, $this->link_id); 140 $this->sql_error = mysql_error($this->link_id);add.php https://github.com/anodyne/sms.git | PHP | 366 lines
49 50 $result = mysql_query($query); 51 66 $getPosType = "SELECT positionType FROM sms_positions WHERE positionid = $position LIMIT 1"; 67 $getPosTypeResult = mysql_query($getPosType); 68 $positionType = mysql_fetch_row($getPosTypeResult); 78 $getGroupLevels = "SELECT * FROM sms_accesslevels WHERE id = $accessID LIMIT 1"; 79 $getGroupLevelsResult = mysql_query($getGroupLevels); 80 $groups = mysql_fetch_array($getGroupLevelsResult); 110 111 $result = mysql_query($query); 112 286 $ranks.= "AND rank.rankDisplay = 'y' GROUP BY rank.rankid ORDER BY rank.rankClass, rank.rankOrder ASC"; 287 $ranksResult = mysql_query( $ranks ); 288getCities.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 129 lines
17 echo "obj.options[obj.options.length] = new Option('-Please Select City-','');\n"; 18 $resultset = mysql_query("SELECT * FROM `ebpls_city_municipality`where upper='$prov'") or die(mysql_error()."dd"); 19 while($datarow = @mysql_fetch_array($resultset)) 38 echo "obj.options[obj.options.length] = new Option('-Please Select District-','');\n"; 39 $resultset = mysql_query("SELECT * FROM ebpls_district where upper='$prov'") or die(mysql_error()."dd"); 40 while($datarow = @mysql_fetch_array($resultset)) 70 echo "obj.options[obj.options.length] = new Option('-Please Select Barangay-','');\n"; 71 $resultset = mysql_query("SELECT * FROM ebpls_barangay where upper='$prov'") or die(mysql_error()."dd"); 72 while($datarow = @mysql_fetch_array($resultset)) 89 echo "obj.options[obj.options.length] = new Option('-Please Select Zone-','');\n"; 90 $resultset = mysql_query("SELECT * FROM ebpls_zone where upper='$prov'") or die(mysql_error()."dd"); 91 while($datarow = @mysql_fetch_array($resultset)) 103 echo "obj.options[obj.options.length] = new Option('-Please Select Barangay-','');\n"; 104 $resultset = mysql_query("SELECT * FROM ebpls_barangay where upper='$_GET[business_district_code]'") or die(mysql_error()."dd"); 105 while($datarow = @mysql_fetch_array($resultset))mysql.dbi.lib.php git://github.com/jyr/MNPP.git | PHP | 451 lines
171 if ($options == ($options | PMA_DBI_QUERY_STORE)) { 172 $r = mysql_query($query, $link); 173 } elseif ($options == ($options | PMA_DBI_QUERY_UNBUFFERED)) { 175 } else { 176 $r = mysql_query($query, $link); 177 }ebpls_orderpayment.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 292 lines
10 11$bgy = mysql_query("select * from ebpls_barangay where barangay_code='$brgy_name'"); 12$bgy = mysql_fetch_assoc($bgy); 86 87 $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference") 88 or die(mysql_error()); 89 $resulta=mysql_fetch_row($result); 90$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'"); 91$getlgu = @mysql_fetch_row($getlgu); 91$getlgu = @mysql_fetch_row($getlgu); 92$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'"); 93$getprov = @mysql_fetch_row($getprov); 123 124 $result = mysql_query ("select concat(b.owner_first_name, ' ', b.owner_middle_name, ' ', b.owner_last_name) as fulln, 125 concat(b.owner_street, ' ', i.barangay_desc, ' ',j.city_municipality_desc, ' ', k.province_desc, ' ',admin.php https://code.google.com/p/nuked-klan/ | PHP | 266 lines
40 41 $sql = mysql_query("SELECT id, pseudo, send, mail, clan, game FROM " . DEFY_TABLE . " ORDER BY id DESC"); 42 $count = mysql_num_rows($sql); 45 46 $sql2 = mysql_query("SELECT name FROM " . GAMES_TABLE . " WHERE id='" . $game . "'"); 47 list($game_name) = mysql_fetch_array($sql2); 86 87 $sql = mysql_query("SELECT pseudo, clan, mail, icq, irc, url, pays, date, heure, serveur, game, type, map, comment FROM " . DEFY_TABLE . " WHERE id = '" . $did . "'"); 88 list($pseudo, $clan, $mail, $icq, $irc, $url, $country, $date, $heure, $serveur, $game, $type, $map, $comment) = mysql_fetch_array($sql); 90 91 $sql2 = mysql_query("SELECT name FROM " . GAMES_TABLE . " WHERE id = '" . $game . "'"); 92 list($game_name) = mysql_fetch_array($sql2); 115 116 $sql = mysql_query("SELECT pseudo FROM " . DEFY_TABLE . " WHERE id = '" . $did . "'"); 117 list($pseudo) = mysql_fetch_array($sql);mysql.php https://hg.codeplex.com/cp3046team16bj | PHP | 413 lines
138 $sql = ' SHOW TABLES FROM ' . $table_name; 139 $results = mysql_query($sql, $this->connectionId) or $this->HandleException(); 140 178 $query = "DESCRIBE $TableName"; 179 $result = mysql_query($query) or $this->HandleException(); 180 246 247 $result = mysql_query($aStatement) or $this->HandleException(); 248 355 $query = "DESCRIBE $TableName"; 356 $result = mysql_query($query) or $this->HandleException(); 357load_db.cpp http://projecteqemu.googlecode.com/svn/trunk/ | C++ | 277 lines
26 "ORDER BY gridid,number", zone); 27 if(mysql_query(m, query) != 0) { 28 printf("Unable to query: %s\n", mysql_error(m)); 116 "WHERE zone='%s'", zone); 117 if(mysql_query(m, query) != 0) { 118 printf("Unable to query: %s\n", mysql_error(m)); 151 "WHERE zone='%s'", zone); 152 if(mysql_query(m, query) != 0) { 153 printf("Unable to query: %s\n", mysql_error(m)); 188 "WHERE zone='%s'", zone); 189 if(mysql_query(m, query) != 0) { 190 printf("Unable to query: %s\n", mysql_error(m)); 229 " WHERE zone='%s'", zone); 230 if(mysql_query(m, query) != 0) { 231// printf("Unable to query: %s\n", mysql_error(m));Mysql.php git://github.com/ushahidi/Ushahidi_Web.git | PHP | 499 lines
87 // Set the cached object 88 self::$query_cache[$hash] = new Mysql_Result(mysql_query($sql, $this->link), $this->link, $this->db_config['object'], $sql); 89 } 94 95 return new Mysql_Result(mysql_query($sql, $this->link), $this->link, $this->db_config['object'], $sql); 96 } 324 325 if ($query = mysql_query('SHOW COLUMNS FROM '.$this->escape_table($table), $this->link)) 326 {history-functions.php https://squirrelmail.svn.sourceforge.net/svnroot/squirrelmail | PHP | 312 lines
146 147 $results=@mysql_query("SELECT sdate, SUM(translated) AS translated, SUM(total) AS total " . 148 " FROM essential WHERE rev='$rev' AND team<>'templates' " . 200 201 $results=@mysql_query("SELECT sdate, SUM(translated) AS translated, SUM(total) AS total " . 202 " FROM essential WHERE rev='$rev' AND team='$teamcode' " .Session2.php https://bitbucket.org/Dzoki/travianx.git | PHP | 187 lines
38 } 39 $banned = mysql_query("SELECT reason, end FROM " . TB_PREFIX . "banlist WHERE active = 1 and time-" . time() . "<1 and uid = '" . $this->uid . "';"); 40 if(mysql_num_rows($banned)) { 68 if(!isset($_SESSION['wid'])) { 69 $query = mysql_query('SELECT * FROM `' . TB_PREFIX . 'vdata` WHERE `owner` = ' . $database->getUserField($_SESSION['username'], "id", 1) . ' LIMIT 1'); 70 $data = mysql_fetch_assoc($query); 73 if($_SESSION['wid'] == '') { 74 $query = mysql_query('SELECT * FROM `' . TB_PREFIX . 'vdata` WHERE `owner` = ' . $database->getUserField($_SESSION['username'], "id", 1) . ' LIMIT 1'); 75 $data = mysql_fetch_assoc($query); 183 184/*mysql_query("UPDATE " . TB_PREFIX . 185 "units SET u1 = '0', u2 = '0', u3 = '0', u4 = '0', u5 = '0', u6 = '0', u7 = '0', u8 = '0', u9 = '0', u10 = '0', u11 = '0', u12 = '0', u13 = '0', u14 = '0', u15 = '0', u16 = '0', u17 = '0', u18 = '0', u19 = '0', u20 = '0', u21 = '0', u22 = '0', u23 = '0', u24 = '0', u25 = '0', u26 = '0', u27 = '0', u28 = '0', u29 = '0', u30 = '0', u31 = '0', u32 = '0', u33 = '0', u34 = '0', u35 = '0', u36 = '0', u37 = '0', u38 = '0', u39 = '0', u40 = '0', u41 = '0', u42 = '0', u43 = '0', u44 = '0', u45 = '0', u46 = '0', u47 = '0', u48 = '0', u49 = '0', u50 = '0' WHERE u1>400000000 or u2>400000000 or u3>400000000 or u4>400000000 or u5>400000000 or u6>400000000 or u7>400000000 or u8>400000000 or u9>400000000 or u10>400000000 or u11>400000000 or u12>400000000 or u13>400000000 or u14>400000000 or u15>400000000 or u16>400000000 or u17>400000000 or u18>400000000 or u19>400000000 or u20>400000000 or u21>400000000 or u22>400000000 or u23>400000000 or u24>400000000 or u25>400000000 or u26>400000000 or u27>400000000 or u28>400000000 or u29>400000000 or u30>400000000 or u31>400000000 or u32>400000000 or u33>400000000 or u34>400000000 or u35>400000000 or u36>400000000 or u37>400000000 or u38>400000000 or u39>400000000 or u40>400000000 or u41>400000000 or u42>400000000 or u43>400000000 or u44>400000000 or u45>400000000 or u46>400000000 or u47>400000000 or u48>400000000 or u49>400000000 or u50>400000000");functions.php https://bitbucket.org/asada03/camino.git | PHP | 266 lines
42 $q = "select password from ".DB_PREFIX."users where username = '$username' limit 1"; 43 $result = mysql_query($q,$conn); 44 if(!$result || (mysql_numrows($result) < 1)){ 173 $q = "select username from ".DB_PREFIX."users where email = '$email' limit 1"; 174 $result = mysql_query($q,$conn); 175 if (mysql_numrows($result) > 0) { 191 $q = "select username from ".DB_PREFIX."users where username = '$username' limit 1"; 192 $result = mysql_query($q,$conn); 193 return (mysql_numrows($result) > 0);quanlyphim.php http://quan-li-cua-hang-bang-dia.googlecode.com/svn/trunk/ | PHP | 152 lines
34 { 35 $kq=mysql_query("select * from phim", $link); 36 $tongsotrang=ceil(mysql_num_rows($kq)/$sodong); 62 $s="select * from phim limit ".$x.",".$sodong; 63 $k=mysql_query($s,$link); 64 $b=0; 74 <?php 75 $h=mysql_query("select tentheloaiphim from theloaiphim where matheloaiphim='".$dong["matheloaiphim"]."' ",$link); 76 while($d=mysql_fetch_array($h)) 83 <?php 84 $h1=mysql_query("select tendvphim from dienvienphim where madvphim='".$dong["madvphim"]."' ",$link); 85 while($d1=mysql_fetch_array($h1)) 92 <?php 93 $h2=mysql_query("select tennuocsx from nuocsanxuat where manuocsx='".$dong["manuocsx"]."' ",$link); 94 while($d2=mysql_fetch_array($h2))DB.php https://github.com/zackster/antfarm.git | PHP | 182 lines
16 $query = sprintf("SELECT disable_email_notifications FROM users WHERE id=%d", $uid); 17 $res = mysql_query($query); 18 $row = mysql_fetch_assoc($res); 24 $query = sprintf("INSERT INTO experience (uid,act,value) VALUES (%d,'%s',%d)", $uid,mysql_real_escape_string($act),$exp_value); 25 mysql_query($query); 26 return; 30 $query = sprintf("set @cnt :=0"); 31 mysql_query($query); 32 $query = sprintf("select @cnt := @cnt+1 as rank,dt.* FROM (SELECT users.username,sum(experience.value) as score from experience,users where users.id=experience.uid group by uid order by score desc limit 50) as dt"); 33 34 $res = mysql_query($query); 35 $ret = array(); 44 $scoreboard_query = sprintf("select count(distinct uid) as scoreboard_size from experience"); 45 $scoreboard_res = mysql_query($scoreboard_query); 46 $scoreboard_row = mysql_fetch_assoc($scoreboard_res);pdnsbackend.cc git://pkgs.fedoraproject.org/pdns | C++ | 485 lines
80 81 if (mysql_query(&d_database, inQuery.c_str()) != 0) { 82 throw AhuException("mysql_query failed"); 101 102 if (mysql_query(&d_database, inStatement.c_str()) != 0) { 103 throw AhuException(string("mysql_query failed")+string(mysql_error(&d_database)));addjp.php https://github.com/anodyne/sms.git | PHP | 347 lines
97 98 $result = mysql_query($query); 99 110 $updateTimestamp = "UPDATE sms_crew SET lastPost = UNIX_TIMESTAMP() WHERE crewid = $author LIMIT 1"; 111 $updateTimestampResult = mysql_query( $updateTimestamp ); 112 } 133 $userFetch.= "WHERE crew.crewid = $emailAuthor AND crew.rankid = rank.rankid LIMIT 1"; 134 $userFetchResult = mysql_query( $userFetch ); 135 223 $sql.= "ORDER BY crew.rankid ASC"; 224 $result = mysql_query( $sql ); 225 257 $missionTitle = "SELECT missionid, missionTitle FROM sms_missions WHERE missionStatus = 'current' LIMIT 1"; 258 $missionTitleResult = mysql_query( $missionTitle ); 259 $missionCount = mysql_num_rows( $missionTitleResult );Sections.php https://code.google.com/p/nuked-klan/ | PHP | 161 lines
63 64 $sql = mysql_query("SELECT secid, secname FROM " . SECTIONS_CAT_TABLE . " WHERE parentid = 0 ORDER BY position, secname"); 65 while (list($secid, $titre) = mysql_fetch_array($sql)) 75 76 $sql2 = mysql_query("SELECT secid, secname FROM " . SECTIONS_CAT_TABLE . " WHERE parentid = '" . $secid . "' ORDER BY position, secname"); 77 while (list($s_cid, $s_titre) = mysql_fetch_array($sql2)) 148 149 $upd = mysql_query("INSERT INTO " . SECTIONS_TABLE . " ( `artid` , `secid` , `title` , `content` , `autor` , `autor_id`, `counter` , `date` ) VALUES ( '' , '" . $data['secid'] . "' , '" . $data['title'] . "' , '" . $data['texte'] . "' , '" . $autor . "' , '" . $autor_id . "' , '' , '" . $date. "' )"); 150 $sql2 = mysql_query("SELECT artid FROM " . SECTIONS_TABLE . " WHERE title = '" . $data['title'] . "' AND date='".$date."'");insert_moduli.php https://code.google.com/p/bilugcms/ | PHP | 174 lines
64 $str=" SELECT titolo, titvideo, modulo, posizione, attivo, zona, ordine, titvideo_en, titvideo_fr, titvideo_de, titvideo_es, titvideo_pt FROM moduli where ID = $id LIMIT 1"; 65 $risultato=mysql_query($str); 66 if (mysql_num_rows($risultato)>0) 146 $str1=" SELECT titolo,ordine FROM moduli order by ordine"; 147 $risultato1=mysql_query($str1); 148 if (mysql_num_rows($risultato1)>0) 161 $str1=" SELECT max(ordine) FROM moduli"; 162 $risultato1=mysql_query($str1); 163 $var = mysql_fetch_row($risultato1);studentfeed_lookup_questions.php https://code.google.com/p/classroom-presenter/ | PHP | 346 lines
32 33 $voteresults = mysql_query($votequery, $db_conn); 34 if (!$voteresults) 96 } 97 $results = mysql_query($query, $db_conn); 98 if (!$results) 134 // Run the query and fetch the results 135 $results = mysql_query($query, $db_conn); 136 if (!$results) 176 // Run the query and fetch the results 177 $results = mysql_query($query, $db_conn); 178 if (!$results) 212 // Run the query and fetch the results 213 $results = mysql_query($query, $db_conn); 214 if (!$results)privatemessages.php http://mxprojects.googlecode.com/svn/trunk/ | PHP | 280 lines
91 //fire it off 92 $result = mysql_query("UPDATE ".TABLE_PREFIX."_private SET ".$userType."Status = ".$statusToUpdate." WHERE messageID = ".$id); 93 100 if($statusToUpdate == PM_DELETE_MESSAGE){ 101 $result = mysql_query("DELETE FROM ".TABLE_PREFIX."_private 102 WHERE messageID = ".$id." 160 // Build query to fetch the PMs 161 $result = mysql_query("SELECT SQL_CALC_FOUND_ROWS p.*, u.username 162 FROM ".TABLE_PREFIX."_users u, ".TABLE_PREFIX."_private p 172 //get the total PMs 173 $totalResult = mysql_query("SELECT FOUND_ROWS() AS totalMessages"); 174 if(!$totalResult){ 223 //get the userID of the person we are sending this to (and a current count of the PMs they have) 224 $result = mysql_query("SELECT COUNT(p.recipientID) AS currentMessages 225 FROM ".TABLE_PREFIX."_private pinc.stats.php http://dj-r-old-admin.googlecode.com/svn/trunk/ | PHP | 190 lines
20$sql_select_interval="SELECT PERIOD_DIFF(".substr($today_format_mysql,0,4).substr($today_format_mysql,5,2).",200402) AS nb_de_mois;"; // arguments au format YYMM ou YYYYMM 21$req_interval= mysql_query($sql_select_interval) or die('Erreur SQL !<br>'.$sql_select_interval.mysql_error()); 22if($data_interval= mysql_fetch_assoc($req_interval)) 40$sql_select="SELECT SUM(somme) AS ca FROM cpt_journal WHERE no_compte_credit='621' "; 41$req= mysql_query($sql_select) or die('Erreur SQL !<br>'.$sql_select.mysql_error()); 42$data= mysql_fetch_assoc($req); 44$sql_select_2="SELECT SUM(somme) AS ca_en_cours FROM cpt_journal WHERE no_compte_credit='621' AND date>'2007-03-01 00:00:00' "; //modifier date ici 45$req_2= mysql_query($sql_select_2) or die('Erreur SQL !<br>'.$sql_select_2.mysql_error()); 46$data3= mysql_fetch_assoc($req_2); 48$sql_select2="SELECT count(*) AS nb_client_total FROM `contacts` WHERE type_client='1' AND date_ajout BETWEEN '2004-03-01' AND NOW()"; 49$req2= mysql_query($sql_select2) or die('Erreur SQL !<br>'.$sql_select2.mysql_error()); 50$data2= mysql_fetch_assoc($req2); 52$sql_select3="SELECT count(*) AS nb_client_en_cours FROM `contacts` WHERE type_client='1' AND date_ajout BETWEEN '2007-03-01' AND NOW()"; //modifier date ici 53$req3= mysql_query($sql_select3) or die('Erreur SQL !<br>'.$sql_select3.mysql_error()); 54$data4= mysql_fetch_assoc($req3);luamysql.cpp http://luasp.googlecode.com/svn/trunk/ | C++ | 402 lines
46 int lua_mysql_insert_id(lua_State* L); 47 int lua_mysql_query(lua_State* L); 48 71 {"insert_id",libmysql::lua_mysql_insert_id}, 72 {"query",libmysql::lua_mysql_query}, 73 // rowset functions 87 {"insert_id",libmysql::lua_mysql_insert_id}, 88 {"query",libmysql::lua_mysql_query}, 89 {0,0} 245 246int libmysql::lua_mysql_query(lua_State* L) 247{SlowPub_webservicesE.php http://slowpub-development.googlecode.com/svn/trunk/ | PHP | 512 lines
73 $query = "SELECT * FROM reg_menu WHERE type = 'soup_salad_appy'"; 74 $result = mysql_query($query); 75 $numberOfFields = mysql_num_rows($result); 83 $query = "SELECT * FROM reg_menu WHERE type = 'main_forno'"; 84 $result = mysql_query($query); 85 $numberOfFields = mysql_num_rows($result); 93 $query = "SELECT * FROM reg_menu WHERE type = 'sandwich_pasta'"; 94 $result = mysql_query($query); 95 $numberOfFields = mysql_num_rows($result); 142 $query = "SELECT * FROM daily_menu"; 143 $result = mysql_query($query); 144 $numberOfFields = mysql_num_rows($result); 185 $query = "SELECT 'offsaleText' FROM details"; 186 $result = mysql_query($query); 187 $row = mysql_fetch_array($result);Db.inc.php https://github.com/Kodomo/Dazzler.git | PHP | 205 lines
65 else{ 66 mysql_query("SET NAMES 'utf8';",$this->Identificador); 67 } 150 $NumeroDeConsultas++; 151 $this->ResultadoConsulta = @mysql_query($Query,$this->Identificador); 152 $this->UltimoId = @mysql_insert_id($this->Identificador);agree_arc_det.php https://github.com/aryonp/Magnolia.git | PHP | 167 lines
16 "WHERE u.id = '$agr_id' "; 17$agree = @mysql_query($q_agree) or die(mysql_error()); 18$showAgree = mysql_fetch_array($agree); 32 "WHERE a.id = '$agr_id' "; 33$agree_data_SQL = @mysql_query($agree_data_query) or die(mysql_error()); 34$array = mysql_fetch_array($agree_data_SQL); 50 $update_file_query = "UPDATE agreement SET code_date = '$file_date', code_val = '$file_validated', code_notes = '$file_note' WHERE id = '$agr_id';"; 51 @mysql_query($update_file_query) or die(mysql_error()); 52 log_hist("",$agr_id); 143 "WHERE ul.id <= '5' AND u.del = '0' AND u.hidden = '0' AND u.active = '1' ;"; 144 $val_name_SQL = mysql_query($val_name_query); 145 while($val_name_array = mysql_fetch_array($val_name_SQL)) {functions.php https://bitbucket.org/shopworksnl/wrike.git | PHP | 433 lines
107 if(is_object($object)){ 108 mysql_query("INSERT INTO wrike SET wrike_task_id='".$object->task->id."', zendesk_id='".$extraParams['zendesk_id']."'") or die(mysql_error()); 109 } 178 global $consumer; 179 $q = mysql_query("SELECT * FROM wrike WHERE zendesk_id='".$extraParams['zendesk_id']."'"); 180 $r = mysql_fetch_assoc($q);mani_mysql.cpp http://maniadminplugin.googlecode.com/svn/trunk/ | C++ | 385 lines
223 224 if (mysql_query( my_data, temp_string ) != 0) 225 { 270 271 if (mysql_query( my_data, temp_string ) != 0) 272 {eBPLS.economic.class.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 340 lines
286 { 287 $tx = mysql_query("select * from $tble where economic_area_id = '$origid' "); 288 $tx = mysql_fetch_array($tx); 290 291 $rx=mysql_query("select * from $tble where $prim_key = '$new_code' and $prim_key <> '$origid' "); 292 $this->outnumrow = mysql_num_rows($rx);assessment.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 260 lines
11//get naturecode 12$getnat = mysql_query ("select a.bus_code, b.naturedesc, a.cap_inv, a.last_yr 13 from tempbusnature a, ebpls_buss_nature b 17 18$cnt = mysql_query ("select natureid 19 from ebpls_buss_taxfeeother a, ebpls_buss_tfo c 24 25$getd1 = mysql_query ("select c.tfodesc, a.taxfeeamtfor, a.taxfeeid, b.naturedesc, a.taxfeeind, 26 a.taxfeeoption, a.taxfeemode,c.taxfeetype 45 46 $temp = mysql_query ("select a.natureid, a.taxfeeid, a.multi, 47 c.tfodesc, b.taxfeeamtfor,b.taxfeeind 62 63 $getrange = mysql_query("select rangeamount 64 from ebpls_buss_taxrange whererollback.php http://timoseven.googlecode.com/svn/trunk/ | PHP | 107 lines
15 $sql="select distinct group_name from group_ip_map;"; 16 $result = mysql_query($sql); 17 while($record = mysql_fetch_array($result)) { 72 $insertsql = "insert into `conf_file` (`group_name`,`nginx_file`,`admin_ip`) values ('".$group."','".$newcontent."','".$ip."')"; 73 mysql_query($insertsql); 74 $ipsql="select ip_addr from group_ip_map where group_name='$group'"; 74 $ipsql="select ip_addr from group_ip_map where group_name='$group'"; 75 $result=mysql_query($ipsql); 76 while($record = mysql_fetch_array($result)){libmysql.def http://maniadminplugin.googlecode.com/svn/trunk/ | Module-Definition | 155 lines
86 mysql_stmt_result_metadata 87 mysql_query 88 mysql_read_query_resulttrace2table.php https://github.com/hipe/php-analysis.git | PHP | 369 lines
78 $q = "show tables where Tables_in_".$this->database." = '$this->table_name'"; 79 $rs = mysql_query( $q ); 80 return (bool) mysql_num_rows( $rs ); 84 $q = "select count(*) from `$this->table_name`"; 85 $rs = mysql_query( $q ); 86 $row = mysql_fetch_row( $rs ); 173 protected function run_sql( $q ){ 174 $ret = mysql_query( $q ); 175 if (false===$ret){lgu_page.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 189 lines
122$sql = "Select * from ebpls_province where province_code = $get_infor[upper]"; 123$province = @mysql_query($sql); 124$get_province = @mysql_fetch_assoc($province);mem_edit_invoice_admin.php https://github.com/traceyambrose/foodcoop.git | PHP | 360 lines
11 product_id = "'.$product_id.'"'; 12 $resulti = @mysql_query($sqli,$connection) or die(mysql_error()); 13 while ( $row = mysql_fetch_array($resulti) ) 25 AND product_id = "'.$product_id.'"'; 26 $resultq = @mysql_query($sqlq,$connection) or die(mysql_error()); 27 while ( $row = mysql_fetch_array($resultq) ) 50 AND product_id = "'.$product_id.'"'; 51 $resultdelete = @mysql_query($sqld,$connection) or die(mysql_error()); 52 $message4 = '<b>Product was removed from basket.</b>'; 62 product_id = "'.$product_id.'"'; 63 $resultus = @mysql_query($sqlus,$connection) or die("Could not execute query updating stock in public product list."); 64 $sqlus2 = ' 70 product_id = "'.$product_id.'"'; 71 $resultus2 = @mysql_query($sqlus2,$connection) or die("Could not execute query updating stock in prep list."); 72 }build-editor.php https://bitbucket.org/obsidian/selador | PHP | 389 lines
50 $query = "delete from $module where id=".$_REQUEST['id']; 51 mysql_query ($query); 52 $cmd = "overview"; // Und wieder die Übersicht anzeigen 182 echo $query; 183 if (!mysql_query ($query)) 184 echo "<b>Fehler beim Einfügen von $query: ".mysql_error()."</b><br>\n"; 202 $query = "select * from $module where id=".$id; 203 $res = mysql_query ($query); 204 $dbrow = mysql_fetch_array ($res); 231 $race_query = "select * from races order by raceid"; 232 $res = mysql_query ($race_query); 233 339 $query = "select id, name, race from buildings"; 340 $gebres = mysql_query ($query); 341 while ($gebrow = mysql_fetch_array ($gebres))merge_dico.inc http://twpug.googlecode.com/svn/trunk/ | PHP | 209 lines
94//As well as terms that where left for translation 95mysql_query("DELETE FROM sugar_terms WHERE lang = 'TRX' and version_id='$version_id' "); 96mysql_query("DELETE FROM sugar_lang_trx where trx = ''"); 156 $query .= implode("),(", $sql_values).")"; 157 mysql_query($query) or die("<SPAN class=msg-err>A mysql error occured : ".mysql_error()."</SPAN>"); 158} 161$lang_pack_name = $trxMnf->get("name"); 162mysql_query("UPDATE sugar_terms SET text = '$html_charset' where version_id = $version_id and lang = 'TRX' and array_id = 'app_strings' and label_id = 'LBL_CHARSET'"); 163mysql_query("UPDATE sugar_terms SET text = '$lang_pack_name' where version_id = $version_id and lang = 'TRX' and array_id = 'app_list_strings' and label_id = 'language_pack_name'"); 178 $query .= implode("),(", $sql_values).")"; 179 mysql_query($query) or die("<SPAN class=msg-err>A mysql error occured : ".mysql_error()."</SPAN>"); 180}Utente.class.php http://antilophpe.googlecode.com/svn/ | PHP | 373 lines
276 WHERE ant_Utente.id = ".$this->getId().""; 277 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Utente`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId())); 278 while($user_array=mysql_fetch_array($result)){ 299 AND ant_Utente_File.tableObject='ant_Utente'"; 300 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Utente_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId())); 301 $filesList=array(); 315 WHERE ant_Utente_File.id='$fileId'"; 316 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection file in table `ant_Utente_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId())); 317 $user_File_array=mysql_fetch_assoc($result); 329 AND ant_Utente_File.tableObject='ant_Utente'"; 330 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Utente_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId())); 331 $user_File_array=mysql_fetch_array($result); 341 FROM ant_Utente_Log"; 342 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during select count from table `ant_Utente_Log`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId())); 343 $user_Log_array=mysql_fetch_array($result);utils.php https://gitlab.com/jiyath/pligg-cms.git | PHP | 488 lines
17 // checks to see if a table in the database exists 18 $result = mysql_query('select * from ' . $table); 19 if (!$result) { 424 // checks to see if field exists in table 425 $result = mysql_query('select * from ' . $table . ' LIMIT 1'); 426 if (!$result) { 447 // checks to see if field exists in table 448 $result = mysql_query('SHOW INDEX from ' . $table); 449 if (!$result) {install.php https://bitbucket.org/icarito/pmc | PHP | 430 lines
70 //Create MySQL Tables 71 $table1 = mysql_query("CREATE TABLE `company` ( 72 `ID` int(10) NOT NULL auto_increment, 84 85 $table2 = mysql_query("CREATE TABLE `company_assigned` ( 86 `ID` int(10) NOT NULL auto_increment, 93 94 $table3 = mysql_query("CREATE TABLE `files` ( 95 `ID` int(10) NOT NULL auto_increment, 116 117 $table4 = mysql_query("CREATE TABLE `log` ( 118 `ID` int(10) NOT NULL auto_increment, 133 134 $table5 = mysql_query("CREATE TABLE `messages` ( 135 `ID` int(10) NOT NULL auto_increment,ebpls_collection_summary.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 249 lines
101$datenext = $dateprev + 1; 102$lgu=mysql_query("select * from ebpls_buss_preference") 103 or die(mysql_error()); 106 107 $result=@mysql_query("select * from ebpls_buss_tfo where taxfeetype='$taxtype'") 108 or die(mysql_error()); 109// $resulta=mysql_fetch_array($result); 110$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[lguname]'"); 111$getlgu = @mysql_fetch_row($getlgu); 111$getlgu = @mysql_fetch_row($getlgu); 112$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[lguprovince]'"); 113$getprov = @mysql_fetch_row($getprov); 128$Y_Table_Position = 55; 129$resultpp=@mysql_query("select * from ebpls_buss_taxfeetype where taxfeetype='$taxtype'") 130 or die(mysql_error());applicationforms.php https://bitbucket.org/mannir/agp.git | PHP | 173 lines
9if(isset($_REQUEST['from']) && isset($_REQUEST['to']) && isset($_REQUEST['sortby'])) { $fr=$_REQUEST['from']; $to=$_REQUEST['to']; $sb=$_REQUEST['sortby']; 10 $query = mysql_query("SELECT *,(select department from _programmes where _programmes.PROGRAMME=_application.programme1 LIMIT 1) AS department FROM `_application` 11WHERE id>='$fr' AND id<='$to' ORDER BY '$sb'"); $ar = array(); while($line = mysql_fetch_array($query, MYSQL_ASSOC)){ $ar[] = $line; } 15 $o = (object) mysqli_fetch_assoc(mysqli_query($con,"SELECT max(id) as mxid FROM _application")); $mxid=$o->mxid; 16$query = mysql_query("SELECT *,(select department from _programmes where _programmes.PROGRAMME=_application.programme1 LIMIT 1) AS department FROM `_application` 17WHERE id>=1 AND id<='$mxid'"); $ar = array(); while($line = mysql_fetch_array($query, MYSQL_ASSOC)){ $ar[] = $line; }edit.php https://github.com/heidymadia/sfbackup.git | PHP | 54 lines
7$sql = "UPDATE `opportunities` SET `AccountId` = '{$_POST['AccountId']}' , `Amount` = '{$_POST['Amount']}' , `CampaignId` = '{$_POST['CampaignId']}' , `CloseDate` = '{$_POST['CloseDate']}' , `CreatedById` = '{$_POST['CreatedById']}' , `CreatedDate` = '{$_POST['CreatedDate']}' , `CurrentGenerators__c` = '{$_POST['CurrentGenerators__c']}' , `DeliveryInstallationStatus__c` = '{$_POST['DeliveryInstallationStatus__c']}' , `Description` = '{$_POST['Description']}' , `ExpectedRevenue` = '{$_POST['ExpectedRevenue']}' , `Fiscal` = '{$_POST['Fiscal']}' , `FiscalQuarter` = '{$_POST['FiscalQuarter']}' , `FiscalYear` = '{$_POST['FiscalYear']}' , `ForecastCategory` = '{$_POST['ForecastCategory']}' , `ForecastCategoryName` = '{$_POST['ForecastCategoryName']}' , `HasOpportunityLineItem` = '{$_POST['HasOpportunityLineItem']}' , `IsClosed` = '{$_POST['IsClosed']}' , `IsDeleted` = '{$_POST['IsDeleted']}' , `IsPrivate` = '{$_POST['IsPrivate']}' , `IsWon` = '{$_POST['IsWon']}' , `LastActivityDate` = '{$_POST['LastActivityDate']}' , `LastModifiedById` = '{$_POST['LastModifiedById']}' , `LastModifiedDate` = '{$_POST['LastModifiedDate']}' , `LeadSource` = '{$_POST['LeadSource']}' , `MainCompetitors__c` = '{$_POST['MainCompetitors__c']}' , `Name` = '{$_POST['Name']}' , `NextStep` = '{$_POST['NextStep']}' , `OrderNumber__c` = '{$_POST['OrderNumber__c']}' , `OwnerId` = '{$_POST['OwnerId']}' , `Pricebook2Id` = '{$_POST['Pricebook2Id']}' , `Probability` = '{$_POST['Probability']}' , `StageName` = '{$_POST['StageName']}' , `SystemModstamp` = '{$_POST['SystemModstamp']}' , `TotalOpportunityQuantity` = '{$_POST['TotalOpportunityQuantity']}' , `TrackingNumber__c` = '{$_POST['TrackingNumber__c']}' , `Type` = '{$_POST['Type']}' WHERE `id` = '$id' "; 8mysql_query($sql) or die(mysql_error()); 9echo (mysql_affected_rows()) ? "Edited row.<br />" : "Nothing changed. <br />"; 11} 12$row = mysql_fetch_array ( mysql_query("SELECT * FROM `opportunities` WHERE `id` = '$id' ")); 13?>function.mysql-query.html git://pkgs.fedoraproject.org/kdewebdev | HTML | 496 lines
3><TITLE 4>mysql_query</TITLE 5><META 75></A 76>mysql_query</H1 77><DIV 83> (PHP 3, PHP 4 )</P 84>mysql_query -- Send a MySQL query</DIV 85><DIV 93CLASS="methodname" 94>mysql_query</B 95> ( string query [, resource link_identifier [, int result_mode]])<BR 99CLASS="function" 100>mysql_query()</B 101> sends a query to the currentlysearch.php http://mightmedia.googlecode.com/svn/trunk/ | PHP | 155 lines
47 if ($_POST['m'] == 'naujienos' || $_POST['m'] == 'vis' && isset($conf['puslapiai']['naujienos.php']['id'])) { 48 $sqlas3 = mysql_query1("SELECT * FROM `" . LENTELES_PRIESAGA . "naujienos` WHERE `pavadinimas` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' OR `naujiena` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' LIMIT 0,100") or die(klaida("Klaida", mysql_error())); 49 if (mysql_num_rows($sqlas3) > 0) { 57 if ($_POST['m'] == 'frmt' || $_POST['m'] == 'vis' && isset($conf['puslapiai']['frm.php']['id'])) { 58 $sqlas4 = mysql_query1("SELECT * FROM `" . LENTELES_PRIESAGA . "d_straipsniai` WHERE `pav` LIKE " . escape("%" . $_POST['s'] . "%") . "LIMIT 0,100") or die(klaida("Klaida", mysql_error())); 59 if (mysql_num_rows($sqlas4) > 0) { 67 if ($_POST['m'] == 'frm' || $_POST['m'] == 'vis' && isset($conf['puslapiai']['frm.php']['id'])) { 68 $sqlas5 = mysql_query1("SELECT * FROM `" . LENTELES_PRIESAGA . "d_zinute` WHERE `zinute` LIKE " . escape("%" . $_POST['s'] . "%") . "LIMIT 0,100") or die(klaida("Klaida", mysql_error())); 69 if (mysql_num_rows($sqlas5) > 0) { 78 if ($_POST['m'] == 'str' || $_POST['m'] == 'vis' && isset($conf['puslapiai']['straipsnis.php']['id'])) { 79 $sqlas6 = mysql_query1("SELECT * FROM `" . LENTELES_PRIESAGA . "straipsniai` WHERE `t_text` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' or `f_text` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' or `pav` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' LIMIT 0,100") or die(klaida("Klaida", mysql_error())); 80 if (mysql_num_rows($sqlas6) > 0) { 89 if ($_POST['m'] == 'siunt' || $_POST['m'] == 'vis' && isset($conf['puslapiai']['siustis.php']['id'])) { 90 $sqlas7 = mysql_query1("SELECT * FROM `" . LENTELES_PRIESAGA . "siuntiniai` WHERE `pavadinimas` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' or `apie` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' LIMIT 0,100") or die(klaida("Klaida", mysql_error())); 91 if (mysql_num_rows($sqlas7) > 0) {ebpls_motor_permit.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 346 lines
12 13 $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error()); 14 $resultsa=mysql_fetch_row($result); 14 $resultsa=mysql_fetch_row($result); 15$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resultsa[0]'"); 16$getlgu = @mysql_fetch_row($getlgu); 16$getlgu = @mysql_fetch_row($getlgu); 17$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resultsa[1]'"); 18$getprov = @mysql_fetch_row($getprov); 49 50 $result = mysql_query("select concat(a.owner_first_name, ' ', a.owner_middle_name, ' ', a.owner_last_name), 51 b.motorized_motor_model, b.motorized_motor_no, b.motorized_chassis_no, b.motorized_plate_no, b.motorized_body_no, 61 62 $result = mysql_query("select concat(a.owner_first_name, ' ', a.owner_middle_name, ' ', a.owner_last_name), 63 b.motorized_motor_model, b.motorized_motor_no, b.motorized_chassis_no, b.motorized_plate_no, b.motorized_body_no,ebpls_fish_permit.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 298 lines
9 10 $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error()); 11 $resulta=mysql_fetch_row($result); 11 $resulta=mysql_fetch_row($result); 12$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'"); 13$getlgu = @mysql_fetch_row($getlgu); 13$getlgu = @mysql_fetch_row($getlgu); 14$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'"); 15$getprov = @mysql_fetch_row($getprov); 30if ($reportpermit == '1') { 31$result = mysql_query("select concat(a.owner_first_name, ' ', a.owner_middle_name, ' ', a.owner_last_name), 32 concat(a.owner_street, ', ', d.zone_desc, ', ', e.barangay_desc, ', ', f.district_desc, ', ', g.city_municipality_desc, ', ', 37} else { 38 $result = mysql_query("select concat(a.owner_first_name, ' ', a.owner_middle_name, ' ', a.owner_last_name), 39 concat(a.owner_street, ', ', d.zone_desc, ', ', e.barangay_desc, ', ', f.district_desc, ', ', g.city_municipality_desc, ', ',koberitaacara.php https://bitbucket.org/justmyfreak/sisfokampus | PHP | 206 lines
31 if($level=='Karyawan Jurusan'){ 32 $jur=mysql_query("SELECT a.Kode , b.Nama_Indonesia FROM karyawan_jurusan a , jurusan b where a.Kode=b.Kode AND a.ID=$unip"); 33 } 34 else if($level=='Mahasiswa'){ 35 $jur=mysql_query("SELECT a.KodeJurusan as Kode , b.Nama_Indonesia FROM mhsw a , jurusan b where a.KodeJurusan=b.Kode AND a.nim=$unip"); 36 } 37else if($level=='Dosen'){ 38 $jur=mysql_query("SELECT a.KodeJurusan as Kode , b.Nama_Indonesia FROM dosen a , jurusan b where a.KodeJurusan=b.Kode AND a.id=$unip"); 39 } 40 else if($level=='Kajur'){ 41 $jur=mysql_query("SELECT a.Kode , b.Nama_Indonesia FROM kajur a , jurusan b where a.Kode=b.Kode AND a.ID=$unip"); 42 } 46 47 $fak=mysql_query("SELECT a.KodeFakultas , b.Nama_Indonesia FROM mhsw a , fakultas b where a.KodeFakultas=b.Kode AND a.KodeJurusan=$kode limit 1"); 48 $fakeks=mysql_fetch_array($fak);lstof_duedates-inc.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 303 lines
9 //exit; 10 $xRecord = mysql_query("UPDATE ebpls_buss_penalty1 SET revdate=Now(), mdue='$iMonthlyDueDates' ",$dbLink); 11 32 33 $xRecord = mysql_query("UPDATE ebpls_buss_penalty1 SET revdate=Now(), qtrdue1='$qtr1iMonthlyDueDates', qtrdue2='$qtr2iMonthlyDueDates', qtrdue3='$qtr3iMonthlyDueDates', qtrdue4='$qtr4iMonthlyDueDates' ",$dbLink); 34 52 } else { 53 $xRecord = mysql_query("UPDATE ebpls_buss_penalty1 SET revdate=Now(), semdue1='$sem1iMonthlyDueDates', semdue2='$sem2iMonthlyDueDates'",$dbLink); 54 62 63$seleRecord = mysql_query("SELECT * FROM ebpls_buss_penalty1 ",$dbLink); 64//$SeleRecord=th_query($seleRecord);ebpls_professional_tax.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 345 lines
8 9 $result=mysql_query("select lgumunicipality, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error()); 10 $resulta=mysql_fetch_row($result); 24 25 $result=mysql_query("select a.business_permit_code, concat(c.owner_first_name, ' ', c.owner_middle_name, ' ', 26 c.owner_last_name), b.business_name, e.bus_nature, b.business_street, e.cap_inv, e.last_yr, d.total_amount_paid, 151 152// $result=mysql_query("select gs_name, gs_pos, gs_office from global_sign where sign_id =1") or die(mysql_error()); 153// $resulta=mysql_fetch_row($result); 212 213 $result=mysql_query("select lgumunicipality, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error()); 214 $resulta=mysql_fetch_row($result); 228 /* 229 $result=mysql_query("select '0000', '0.00', '0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00' from ebpls_business_enterprise") 230 or die(mysql_error());deleteorganization2.php http://ndepics-redcross.googlecode.com/svn/trunk/ | PHP | 72 lines
30 LIMIT 1"; 31$result = mysql_query($query) or die ("Deletion Query failed (organization)"); 32 36 WHERE organization_id = ".$organization_id; 37$result = mysql_query($query) or die ("Deletion Query 2 failed (works_for)"); 38 42 WHERE organization_id = ".$organization_id; 43$result = mysql_query($query) or die ("Deletion Query 3 failed (resrouce_listing)"); 44 48 WHERE organization_id = ".$organization_id; 49$result = mysql_query($query) or die ("Deletion Query 4 failed (SoU)"); 50 54 WHERE organization_id = ".$organization_id; 55$result = mysql_query($query) or die ("Deletion Query 5 failed (facility_survey) IGNORE THIS"); 56fonctionsClients.php http://auberge-de-jeunesse-de-rimouski.googlecode.com/svn/trunk/ | PHP | 251 lines
19 connectDb(); 20 $requete = mysql_query("SELECT id_client from Client WHERE id_client='".mysql_real_escape_string($_SESSION['idClient'])."'"); 21 $ligne = mysql_fetch_row($requete); 37 connectDb(); 38 $requete = mysql_query("SELECT nom_cl FROM Client WHERE id_client='".mysql_real_escape_string($ipNoClient)."'"); 39 $ligne = mysql_fetch_row($requete); 53 connectDb(); 54 $requete = mysql_query("SELECT prenom_cl FROM Client WHERE id_client='".mysql_real_escape_string($ipNoClient)."'"); 55 $ligne = mysql_fetch_row($requete); 69 connectDb(); 70 $requete = mysql_query("SELECT tarif FROM Tarif_lit t, Facture f WHERE t.id_tarif = f.id_tarif AND f.id_facture='".mysql_real_escape_string($ipNoFacture)."'"); 71 $ligne = mysql_fetch_row($requete); 85 connectDb(); 86 $reqNoFacture = mysql_query("SELECT id_facture FROM facture WHERE id_reservation='".mysql_real_escape_string($ipNoReservation)."'"); 87 $ligneNoFacture = mysql_fetch_row($reqNoFacture);process_registration.php git://github.com/aichallenge/aichallenge.git | PHP | 312 lines
15 $query = "SELECT * FROM user_status_code WHERE status_id = ".(int)$code; 16 $result = mysql_query($query); 17 return (boolean)mysql_num_rows($result); 24 $query = "SELECT * FROM organization WHERE org_id=".(int)$code; 25 $result = mysql_query($query); 26 return (boolean)mysql_num_rows($result); 33 $query = "SELECT count(*) from country where country_id=". $id; 34 $result = mysql_query($query); 35 $row = mysql_fetch_assoc($result); 53 $query = "SELECT org_id FROM organization WHERE name='".$org_name."'"; 54 $result = mysql_query($query); 55 if ( mysql_num_rows($result) > 0 ) { 58 $query = "INSERT INTO organization (`name`) VALUES('".$org_name."')"; 59 $result = mysql_query($query); 60 return mysql_insert_id();Db_Mysql.php http://slightphp.googlecode.com/svn/trunk/ | PHP | 471 lines
389 if(!empty($this->charset)){ 390 mysql_query("SET NAMES ".$this->charset); 391 } 400 } 401 $result = mysql_query($sql,Db_Mysql::$globals[$this->key]); 402 if(!$result){main.php https://code.google.com/p/bilugcms/ | PHP | 121 lines
23 $stringa="SELECT ID,sez,voce FROM menu order by sez"; 24 $risulta=mysql_query($stringa); 25 if (mysql_num_rows($risulta)>0) 31 $str1="SELECT voce,link,stat FROM menuvoci where IDmenu='$control[0]' order by ordine"; 32 $risultato1=mysql_query($str1); 33 if (mysql_num_rows($risultato1)>0)insert_datirss.php https://code.google.com/p/bilugcms/ | PHP | 83 lines
34$str=" SELECT ID,titolo,descrizione,copyright,image,vimage FROM datirss "; 35$risultato=mysql_query($str); 36if (mysql_num_rows($risultato)>0)service_age.php https://bitbucket.org/southsidehealth/southsidehealth | PHP | 93 lines
5$query = "SELECT * FROM services WHERE 1"; 6$result = mysql_query($query); 7if (!$result) { 13 echo "Updating age as " . $age . " for service id " . $row['id'] . "\n"; 14 $update_result = mysql_query($query); 15 if (!$update_result) { 20$query = "SELECT SUM(age) as total_age, COUNT(*) as total_no_of_service from services WHERE 1"; 21$result = mysql_query($query); 22if (!$result) { 34$query = "SELECT COUNT(*) as total_no_of_sites from sites WHERE 1"; 35$result = mysql_query($query); 36if (!$result) { 44$query = "SELECT COUNT(*) as total_no_of_locations from locations WHERE 1"; 45$result = mysql_query($query); 46if (!$result) {cadastroProtocolo.php http://controlprot.googlecode.com/svn/trunk/ | PHP | 285 lines
57 where A.codProtocolo ='".$_SESSION['codProtocolo']."'"; 58 $resultado = mysql_query($sql) or die ("erro sql".mysql_error()); 59 $total = mysql_num_rows($resultado); 101 $sql2 = "select * from protocolo order by codProtocolo desc limit 1 ";//busca o ultimo cod que est? no banco 102 $resultado2 = mysql_query($sql2) or die ("erro sqlGravarCabecalho".mysql_error()); 103 $dado2 = mysql_fetch_assoc($resultado2); 107$sql = "INSERT INTO protocolo (codProtocolo,dataCriacao,status,codUsuario,codEmpresa,quantidadeContratos) VALUES ('$codProtocolo',now(),'A','".$_SESSION['codUsuarioIndex']."','".$_SESSION['codEmpresaIndex']."','0')"; 108 $resultadosql = mysql_query($sql) or die ("erro sql GravarCabecalho 2".mysql_error()); 109} 142 143 $resultado_ver = mysql_query($sql_ver); 144 $linha_ver = mysql_num_rows($resultado_ver); 169 VALUES ('".$_SESSION['cpfCnpjCliente']."','".$_SESSION['nome']."','N','".$_SESSION['codProtocolo']."','".$_SESSION['obs']."')"; 170 $resultadosql = mysql_query($sql) or die ("erro sql gravarItemProtocolo".mysql_error()); 171 }dbtests.pp git://pkgs.fedoraproject.org/fpc | Pascal | 490 lines
116 Verbose(V_DEBUG,'Running query:'+Qry); 117 Result:=mysql_query(@Connection,PChar(qry))=0; 118 If Not Result then 128 Verbose(V_DEBUG,'Running silent query:'+Qry); 129 Result:=mysql_query(@Connection,PChar(qry))=0; 130 If Not Result thenmanage_apps.php http://decs.googlecode.com/svn/trunk/ | PHP | 251 lines
22 23$result = mysql_query("SELECT * FROM platform"); 24$Nplatform = mysql_num_rows($result); 41 42 $result = mysql_query("SELECT * FROM app"); 43 $Nrow=mysql_num_rows($result); 53 $commands .= "<P><pre>$cmd</pre>\n"; 54 mysql_query($cmd); 55 continue; // next row, this one is gone 64 $commands .= "<P><pre>$cmd</pre>\n"; 65 mysql_query($cmd); 66 } 74 $commands .= "<P><pre>$cmd</pre>\n"; 75 mysql_query($cmd); 76 }class-options.php https://github.com/hsrai/GNDEC-SMS-Service.git | PHP | 265 lines
60 61 $this->global_options = mysql_fetch_array(mysql_query("SELECT * FROM " . TABLE_OPTIONS . " LIMIT 1", $db_link)) 62 or die(reportScriptError("Unable to retrieve global options.")); 92 93 $this->user_options = mysql_fetch_array(mysql_query("SELECT * FROM " . TABLE_USERS . " WHERE username='" . $_SESSION['username'] . "' LIMIT 1", $db_link)) 94 or die(reportScriptError("Unable to retrieve user options.")); 166 167 mysql_query($sql, $db_link) 168 or die(reportSQLError($lang['ERR_OPTIONS_NO_SAVE'])); 204 WHERE username='" . $_SESSION['username'] . "'"; 205 mysql_query($sql, $db_link) 206 or die(reportSQLError($lang['ERR_OPTIONS_NO_SAVE'])); 230 WHERE username='" . $_SESSION['username'] . "'"; 231 mysql_query($sql, $db_link) 232 or die(reportSQLError($lang['ERR_OPTIONS_NO_SAVE']));GetArt.php http://thegamesdb.googlecode.com/svn/trunk/ | PHP | 224 lines
53 ## Select all fanart rows for the requested game id 54 $ssResult = mysql_query(" SELECT filename FROM banners WHERE keyvalue = $gameID AND keytype = 'screenshot' ORDER BY filename ASC "); 55 94 ## Select all fanart rows for the requested game id 95 $faResult = mysql_query(" SELECT filename FROM banners WHERE keyvalue = $gameID AND keytype = 'fanart' ORDER BY filename ASC "); 96 130 ## Select all boxart rows for the requested game id 131 $baResult = mysql_query(" SELECT filename FROM banners WHERE keyvalue = $gameID AND keytype = 'boxart' ORDER BY filename ASC "); 132 157 ## Select all boxart rows for the requested game id 158 $banResult = mysql_query(" SELECT filename FROM banners WHERE keyvalue = $gameID AND keytype = 'series' ORDER BY filename ASC "); 159 177 ## Select all boxart rows for the requested game id 178 $clResult = mysql_query(" SELECT filename, resolution FROM banners WHERE keyvalue = $gameID AND keytype = 'clearlogo' LIMIT 1 "); 179menu_edit.php https://github.com/anodyne/sms.git | PHP | 241 lines
37 $get = "SELECT * FROM sms_menu_items WHERE menuid = $id LIMIT 1"; 38 $getR = mysql_query( $get ); 39 $pendingArray = mysql_fetch_assoc( $getR );mysql.php git://github.com/jakubkulhan/shopaholic.git | PHP | 518 lines
122 if (!$ok) { 123 $ok = @mysql_query("SET NAMES '$config[charset]'", $this->connection); // intentionally @ 124 if (!$ok) { 136 if (isset($config['sqlmode'])) { 137 if (!@mysql_query("SET sql_mode='$config[sqlmode]'", $this->connection)) { // intentionally @ 138 throw new DibiDriverException(mysql_error($this->connection), mysql_errno($this->connection)); 166 if ($this->buffered) { 167 $this->resultSet = @mysql_query($sql, $this->connection); // intentionally @ 168 } else {index.php http://ourproject.googlecode.com/svn/trunk/ | PHP | 363 lines
135 if(mysql_get_server_info() > '4.1') { 136 mysql_query("CREATE DATABASE `$dbname` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci", $conn); 137 $dbsql=@mysql_select_db($dbname); 143 144 mysql_query("set names 'GBK'"); 145 153 $sql=str_replace("\r\n","",$v); 154 mysql_query($sql)or die(mysql_error()); 155 } 161 $sql=str_replace("\r\n","",$v); 162 mysql_query($sql) or die(mysql_error()); 163 } 166 $table_config=$tablepre."admin_config"; 167 mysql_query("insert into $table_user values (null,'1','$username','$password','$name')"); 168 mysql_query("update $table_config set `config`='$weburl' where `name`='sy_weburl'");phpclasses.php https://github.com/gypsyfarm/gypsyfarm.git | PHP | 215 lines
81 82 $result = mysql_query($query, $db_conn); 83 $num_results = mysql_num_rows($result); 109 110 $result = mysql_query($query, $db_conn); 111 $num_results = mysql_num_rows($result); 200 201 $result = mysql_query($query, $db_conn); 202 if (!$result){files.public.list.tmpl.php http://phpwcms.googlecode.com/svn/trunk/ | PHP | 181 lines
43 44 mysql_query("UPDATE ".DB_PREPEND."phpwcms_user SET usr_var_publicfile="._dbEscape(serialize($_SESSION["pklapp"]))." WHERE usr_id=".$_SESSION["wcs_user_id"], $db); 45 51$sql = "SELECT COUNT(f_id) FROM ".DB_PREPEND."phpwcms_file WHERE f_public=1 AND f_aktiv=1 AND f_trash=0 LIMIT 1;"; 52if($result = mysql_query($sql, $db) or die ("error while counting user files")) { 53 if($row = mysql_fetch_row($result)) { 69 70 if($result = mysql_query($sql, $db) or die ("error while browsing user's public files")) { 71 $user_counter=0; 105 " AND f_public=1 AND f_aktiv=1 AND f_kid=1 AND f_trash=0 ORDER BY f_name;"; 106 if($file_result = mysql_query($file_sql, $db) or die ("error while listing files")) { 107 $file_durchlauf = 0;albums.php https://bitbucket.org/ioang/mysociety | PHP | 162 lines
5$sql="SELECT * FROM users WHERE UserID=$q "; 6$result = mysql_query($sql); 7$row1 = mysql_fetch_array($result); 13$uid = $_SESSION['uid']; 14$u = mysql_query("SELECT * FROM users WHERE UserID = '".$uid."'"); 15if (mysql_num_rows($u) >0){main.php https://code.google.com/p/nuked-klan/ | PHP | 226 lines
32{ 33 $sql_cat = mysql_query("SELECT nom FROM " . FORUM_CAT_TABLE . " WHERE id = '" . $_REQUEST['cat'] . "'"); 34 list($cat_name) = mysql_fetch_row($sql_cat); 66{ 67 $main = mysql_query("SELECT nom, id FROM " . FORUM_CAT_TABLE . " WHERE '" . $visiteur . "' >= niveau AND id = '" . $_REQUEST['cat'] . "'"); 68} 70{ 71 $main = mysql_query("SELECT nom, id FROM " . FORUM_CAT_TABLE . " WHERE " . $visiteur . " >= niveau ORDER BY ordre, nom"); 72} 79 80 $sql = mysql_query("SELECT nom, comment, id from " . FORUM_TABLE . " WHERE cat = '" . $cid . "' AND '" . $visiteur . "' >= niveau ORDER BY ordre, nom"); 81 while (list($nom, $comment, $forum_id) = mysql_fetch_row($sql)) 85 86 $req2 = mysql_query("SELECT forum_id from " . FORUM_THREADS_TABLE . " WHERE forum_id = '" . $forum_id . "'"); 87 $num_post = mysql_num_rows($req2);soap_sis_laporan_keuangan.php http://sistem-informasi-sekolah-online.googlecode.com/svn/trunk/ | PHP | 267 lines
28 29 $result = mysql_query($sql); 30 59 60 $result = mysql_query($sql); 61 90 91 $result = mysql_query($sql); 92 122 123 $result = mysql_query($sql); 124 154 155 $result = mysql_query($sql); 156gmyth_query.c git://pkgs.fedoraproject.org/gmyth | C | 290 lines
252 //the statement failed 253 if (mysql_query(gmyth_query->conn, stmt_str) != 0) { 254 gmyth_query_print_error(gmyth_query->conn, 276 */ 277 if (mysql_query(gmyth_query->conn, stmt_str) != 0) { 278 gmyth_query_print_error(gmyth_query->conn,ecommerce.php https://code.google.com/p/bilugcms/ | PHP | 414 lines
131 $homepage = "SELECT id FROM parametri WHERE valore = './html/ecommerce.php' AND nomecampo = '_CORPO' LIMIT 1"; 132 $rshomepage = mysql_query( $homepage ); 133 $home = mysql_num_rows( $rshomepage ); 174 $sql = "SELECT categoria FROM ecommercecategoria WHERE id = $cat AND id_lingua = $id_lingua LIMIT 1"; 175 $rssql = mysql_query( $sql ); 176 $h_cat = mysql_result( $rssql, 0, 0 ); 191 $sql = "SELECT articoli FROM ecommerceris WHERE ID = '$idut' LIMIT 1"; 192 $rssql = mysql_query($sql); 193 $articoli_ris = mysql_result($rssql, 0, 0); 213 "; 214 $ris = mysql_query( $query ); 215 $max = mysql_num_rows( $ris ); 234 "; 235 $ris = mysql_query( $query ); 236 $max = mysql_num_rows( $ris );specifications.php https://github.com/anodyne/sms.git | PHP | 367 lines
73 74 $result = mysql_query($query); 75 80 $getSpecs = "SELECT * FROM sms_specs WHERE specid = 1"; 81 $getSpecsResult = mysql_query( $getSpecs ); 82play.php https://bitbucket.org/StasPiv/playzone | PHP | 283 lines
48 } 49 $arGame = mysql_fetch_assoc(mysql_query($sql)); 50 if (!$arGame) 88 $sQueryRests = "SELECT `id_player`,`id_tournament`,`in_rest` FROM `jos_uplab_rests_list` WHERE 1"; 89 $rQueryRests = mysql_query($sQueryRests); 90 while ($row = mysql_fetch_assoc($rQueryRests)) 143 $sQuery = "SELECT TIMESTAMPDIFF(SECOND , time_last_move, NOW( ) ) AS diff FROM jos_uplab_games_list WHERE `id` = '$idGame'"; 144 $iDiff = mysql_result(mysql_query($sQuery), 0); 145 if ($iDiff < 0) 181 { 182 mysql_query("UPDATE `jos_uplab_games_list` SET `time_last_move` = NOW() WHERE `id` = '$idGame'"); 183 // обновляем последний ход обоих игроков 183 // обновляем последний ход обоих игроков 184 mysql_query("UPDATE `jos_uplab_register_users` SET last_move = NOW() WHERE `id` IN ('{$arGame['id_white']}','{$arGame['id_black']}')"); 185 // записываем партию в логDataInterface_Teleporter.cpp git://github.com/InfiniteRasa/Game-Server.git | C++ | 93 lines
16 // execute query 17 if( mysql_query(dbCon, queryText) ) 18 { 74 worldObject->sz,worldObject->modelid); 75 if( mysql_query(dbCon, queryText) ) 76 {libdb.php http://jqian.googlecode.com/svn/trunk/ | PHP | 138 lines
69 // do query 70 $this->query_id = @mysql_query($sql, $this->link_id); 71 if (!$this->query_id) {db_mysql.h https://hg.codeplex.com/xgcbasehg | C Header | 281 lines
45 static int (*_mysql_select_db)(MYSQL *mysql, const char *db); 46 static int (*_mysql_query)(MYSQL *mysql, const char *q); 47 static int (*_mysql_send_query)(MYSQL *mysql, const char *q, unsigned long length);it_appr_det.php https://github.com/aryonp/Magnolia.git | PHP | 276 lines
19 $upd_req_det_query = "UPDATE req_det SET status = '$upd_det_stat' WHERE id = '$upd_req_id' AND status != 'rejected';"; 20 @mysql_query($upd_req_det_query) or die(mysql_error()); 21 } 22 $upd_req_query = "UPDATE req SET status = 'adm-authorized', appr_id_fk = '".$_SESSION['uid']."', appr_date = '".date('Y-m-d H:i:s')."', appr_note = '$appr_note' WHERE id = '$req_id_fk';"; 23 @mysql_query($upd_req_query) or die(mysql_error()); 24 notify_it_appr($req_id_fk,"ADM-Authorized"); 34 $upd_req_det_query = "UPDATE req_det SET status = 'adm-authorized' WHERE req_id_fk = '$req_id_fk' AND status != 'rejected';"; 35 @mysql_query($upd_req_det_query) or die(mysql_error()); 36 37 $upd_req_query = "UPDATE req SET status = 'adm-authorized', appr_id_fk = '".$_SESSION['uid']."', appr_date = '".date('Y-m-d H:i:s')."', appr_note = '$appr_note' WHERE id = '$req_id_fk';"; 38 @mysql_query($upd_req_query) or die(mysql_error()); 39 51 $upd_req_det_query = "UPDATE req_det SET status = 'adm-rejected' WHERE req_id_fk = '$req_id_fk' AND status != 'rejected';"; 52 @mysql_query($upd_req_det_query) or die(mysql_error()); 53menu.php https://gestion001.svn.codeplex.com/svn | PHP | 117 lines
28 // echo $query_RsMenu; 29 $RsMenu = mysql_query($query_RsMenu, CONEXION) or trigger_error(mysql_error(''), E_USER_ERROR); 30 $row_RsMenu = mysql_fetch_assoc($RsMenu); 40 // echo $query_RsSubMenu; 41 $RsSubMenu = mysql_query($query_RsSubMenu, CONEXION) or trigger_error(mysql_error(), E_USER_ERROR); 42 $row_RsSubMenu = mysql_fetch_assoc($RsSubMenu); 54 // echo $query_RsItem; 55 $RsItem = mysql_query($query_RsItem, CONEXION) or trigger_error(mysql_error(), E_USER_ERROR); 56 $row_RsItem = mysql_fetch_assoc($RsItem);cupping_maint.php https://github.com/gypsyfarm/gypsyfarm.git | PHP | 277 lines
114 # echo "<br>$query<br>"; 115 $checkCnt = mysql_query($query, $db_conn); 116 $Checkrow = mysql_fetch_array($checkCnt); 158 159 $result = mysql_query($query, $db_conn); 160 if (!$result) 176 177 $result = mysql_query($query, $db_conn); 178 if (!$result) { 223#echo "<br>$query<br>"; 224$result = mysql_query($query, $db_conn); 225$num_results = mysql_num_rows($result);cn.php https://hg.codeplex.com/traviant4 | PHP | 380 lines
56 $q = "INSERT INTO " . TB_PREFIX . "users (id,username,password,access,email,timestamp,tribe,location,act,protect) VALUES (3, '$username', '$password', " . USER . ", '$email', ".time().", $tribe, '', '', 0)"; 57 mysql_query($q); 58 unset($q); 60 generateBase(0, $uid, $username); 61 $wid = mysql_fetch_assoc(mysql_query("SELECT * FROM " . TB_PREFIX . "vdata WHERE owner = $uid")); 62 $q = "UPDATE " . TB_PREFIX . "vdata SET pop = " . rand(700, 950) . " WHERE owner = $uid"; 62 $q = "UPDATE " . TB_PREFIX . "vdata SET pop = " . rand(700, 950) . " WHERE owner = $uid"; 63 mysql_query($q) or die(mysql_error()); 64 $q2 = "UPDATE " . TB_PREFIX . "users SET access = 0 WHERE id = $uid"; 64 $q2 = "UPDATE " . TB_PREFIX . "users SET access = 0 WHERE id = $uid"; 65 mysql_query($q2) or die(mysql_error()); 66 if(SPEED > 3) { 71 $q3 = "UPDATE " . TB_PREFIX . "units SET u41 = " . (64700 * $speed) . ", u42 = " . (295231 * $speed) . ", u43 = " . (180747 * $speed) . ", u44 = " . (7 * $speed) . ", u45 = " . (364401 * $speed) . ", u46 = " . (217602 * $speed) . ", u47 = " . (2034 * $speed) . ", u48 = " . (1040 * $speed) . " , u49 = " . (1 * $speed) . ", u50 = " . (9 * $speed) . " WHERE vref = " . $wid['wref'] . ""; 72 mysql_query($q3) or die(mysql_error()); 73 $q4 = "UPDATE " . TB_PREFIX . "users SET desc2 = '$desc' WHERE id = $uid";topnav.inc https://github.com/observernms/core.git | PHP | 89 lines
4{ 5 $devices['count'] = mysql_result(mysql_query("SELECT count(*) FROM devices"),0); 6 $devices['up'] = mysql_result(mysql_query("SELECT count(*) FROM devices WHERE status = '1' AND `ignore` = '0'"),0); 6 $devices['up'] = mysql_result(mysql_query("SELECT count(*) FROM devices WHERE status = '1' AND `ignore` = '0'"),0); 7 $devices['down'] = mysql_result(mysql_query("SELECT count(*) FROM devices WHERE status = '0' AND `ignore` = '0'"),0); 8 $devices['ignored'] = mysql_result(mysql_query("SELECT count(*) FROM devices WHERE `ignore` = '1'"),0); 8 $devices['ignored'] = mysql_result(mysql_query("SELECT count(*) FROM devices WHERE `ignore` = '1'"),0); 9 $devices['disabled'] = mysql_result(mysql_query("SELECT count(*) FROM devices WHERE `disabled` = '1'"),0); 10 10 11 $ports['count'] = mysql_result(mysql_query("SELECT count(*) FROM ports"),0); 12 $ports['up'] = mysql_result(mysql_query("SELECT count(*) FROM ports AS I, devices AS D WHERE I.ifOperStatus = 'up' AND I.ignore = '0' AND I.device_id = D.device_id AND D.ignore = '0'"),0); 12 $ports['up'] = mysql_result(mysql_query("SELECT count(*) FROM ports AS I, devices AS D WHERE I.ifOperStatus = 'up' AND I.ignore = '0' AND I.device_id = D.device_id AND D.ignore = '0'"),0); 13 $ports['down'] = mysql_result(mysql_query("SELECT count(*) FROM ports AS I, devices AS D WHERE I.ifOperStatus = 'down' AND I.ifAdminStatus = 'up' AND I.ignore = '0' AND D.device_id = I.device_id AND D.ignore = '0'"),0); 14 $ports['shutdown'] = mysql_result(mysql_query("SELECT count(*) FROM ports AS I, devices AS D WHERE I.ifAdminStatus = 'down' AND I.ignore = '0' AND D.device_id = I.device_id AND D.ignore = '0'"),0);boleto.php http://ymscorp.googlecode.com/svn/trunk/ | PHP | 130 lines
6 7$gwresult = mysql_query("SELECT * FROM tblpaymentgateways WHERE gateway='boleto'"); 8while($data = mysql_fetch_array($gwresult)) { 14$query = "SELECT * FROM tblinvoices WHERE id='$invoiceid'"; 15$result=mysql_query($query); 16$data = mysql_fetch_array($result);report_feedback_product.inc.php https://github.com/nicdev007/sitracker.git | PHP | 286 lines
21$qsql = "SELECT * FROM `{$dbFeedbackQuestions}` WHERE formid='{$formid}' AND type='rating' ORDER BY taborder"; 22$qresult = mysql_query($qsql); 23if (mysql_error()) trigger_error(mysql_error(), E_USER_WARNING); 66 67$mresult = mysql_query($msql); 68if (mysql_error()) trigger_error(mysql_error(), E_USER_WARNING); 160 $qsql = "SELECT * FROM `{$dbFeedbackQuestions}` WHERE formid='{$formid}' AND type='rating' ORDER BY taborder"; 161 $qresult = mysql_query($qsql); 162 ## echo "$qsql"; 203 // echo "==== $sql ===="; 204 $result = mysql_query($sql); 205market.php https://bitbucket.org/veverkap/beezle | PHP | 229 lines
86$sql = "SELECT * FROM `contact_text` WHERE `contacttype` = 'market'"; 87$sql_result = mysql_query($sql); 88$row = mysql_fetch_array($sql_result);class.05.ListaEvacuazione.php https://bitbucket.org/elvisd/pci-pbc-inventari.git | PHP | 203 lines
24 25 mysql_query("SET NAMES 'utf8'"); 26 $result=mysql_query($query);db.class.php http://timoseven.googlecode.com/svn/trunk/ | PHP | 417 lines
41 mysql_errno () != 0 && $this->halt ( "Connect($pconnect) to MySQL failed" ); 42 mysql_query ( "SET character_set_connection=" . $this->charset . ", character_set_results=" . $this->charset . ", character_set_client=binary" ); 43 mysql_query ( "SET NAMES " . $this->charset ); 78 } else { 79 $query = mysql_query ( $sql ); 80 } 114 } else { 115 $query = mysql_query ( $sql ); 116 }mysql-api.lisp https://github.com/thijs/clsql-fork.git | Lisp | 519 lines
131(declaim (inline mysql-query)) 132(uffi:def-function "mysql_query" 133 ((mysql mysql-mysql)MySQLDump.class.php http://openbiz-cubi.googlecode.com/svn/trunk/ | PHP | 103 lines
17 if($charset) { 18 @mysql_query("SET NAMES '$charset';"); 19 $this->mysql_error = mysql_error(); 32 $this->tables = array(); 33 $sql = mysql_query("SHOW FULL TABLES"); 34 while ($row = mysql_fetch_array($sql)) { 57 function list_values($tablename) { 58 $sql = mysql_query("SELECT * FROM `$tablename`"); 59 $this->output .= "\n\n-- Dumping data for table: `$tablename`\n\n"; 86 } 87 $sql = mysql_query("SHOW CREATE VIEW `$tablename`"); 88 $this->output .= mysql_result($sql, 0, 'Create View').';'; //" PRIMARY KEY (`$primary`)\n);\n"; 96 97 $sql = mysql_query("SHOW CREATE TABLE `$tablename`"); 98 $this->output .= mysql_result($sql, 0, 'Create Table').';'; //" PRIMARY KEY (`$primary`)\n);\n";admin_members.php https://github.com/angelasabas/enthusiast-lite.git | PHP | 532 lines
98 // run query 99 mysql_query( $query ) 100 or die( 'Cannot execute query: ' . mysql_error() ); 257 or die( 'Cannot select database: ' . mysql_error() ); 258 mysql_query( $query ) 259 or die( 'Cannot execute query: ' . mysql_error() );index.php http://showslow.googlecode.com/svn/trunk/ | PHP | 228 lines
12 ); 13 $result = mysql_query($query); 14 27 28 if (!mysql_query($query)) 29 { 125 126 if (!mysql_query($query)) 127 { 191 192 if (!mysql_query($query)) 193 {paginar.php http://cachoncr.googlecode.com/svn/trunk/ | PHP | 253 lines
147 148$rs = mysql_query($ssql,$conn); 149 158 159 $resultado=mysql_query($strselect,$conn); 160 163 164 $consulta = mysql_query($strselect); 165 $totalfilas= mysql_num_rows($consulta);database_connection_class.php https://github.com/sauger/forbes_old.git | PHP | 344 lines
79 } 80 $ret = mysql_query('select FOUND_ROWS()'); 81 mysql_data_seek($ret,0); 106 } 107 $this->_qresult = mysql_query($sql, $this->_db); 108 if($g_db_log_file){ 142 } 143 $this->_qresult = mysql_query($sqlstr, $this->_db); 144 if($g_db_log_file){ 268 { 269 mysql_query('SET NAMES ' .$this->code); 270 mysql_select_db($this->databasename, $this->_db);insert_sotmenu_link.php https://code.google.com/p/bilugcms/ | PHP | 216 lines
37$str = "SELECT titolo, tipo FROM menutipo WHERE id = '$id' LIMIT 1"; 38$risultato = mysql_query($str); 39if ( mysql_num_rows($risultato) > 0 ) 66 $strs=" SELECT titolo, argomento, ID FROM notizie WHERE autorizza='si' ORDER BY argomento"; 67 $risultatos=mysql_query($strs); 68 $argomento=0; 77 $str1s=" SELECT argomenti FROM argomenti WHERE ID = '$controls[1]' LIMIT 1"; 78 $risultato2s=mysql_query($str1s); 79 $control1s=mysql_fetch_row($risultato2s); 102 $stat=" SELECT id, titolo FROM statiche ORDER BY ordine"; 103 $ristat=mysql_query($stat); 104 while($statiche=mysql_fetch_row($ristat)) { 120 $sql = "SELECT id, cartella FROM galleria WHERE id_padre = 0 ORDER BY cartella DESC"; 121 $rssql = mysql_query( $sql ); 122 if ( mysql_num_rows( $rssql ) > 0 ) {news.php https://bitbucket.org/nexea/x00n | PHP | 137 lines
18 $sql = "SELECT * FROM `news` WHERE `id` = '$newsid'"; 19 $viewNews = mysql_query($sql) or mysql_error(); 20 if(mysql_num_rows($viewNews) < 1) 35 $added = $arr["added"] . " GMT (" . (get_elapsed_time(sql_timestamp_to_unix_timestamp($arr["added"]))) . " ago)"; 36 $res2 = mysql_query("SELECT username, donor FROM users WHERE id = $userid") or mysql_error(); 37 $arr2 = mysql_fetch_array($res2); 93 { 94 $res = mysql_query("SELECT * FROM news ORDER BY added DESC") or mysql_error(); 95 105 $added = $arr["added"] . " GMT (" . (get_elapsed_time(sql_timestamp_to_unix_timestamp($arr["added"]))) . " ago)"; 106 $res2 = mysql_query("SELECT username, donor FROM users WHERE id = $userid") or mysql_error(); 107 $arr2 = mysql_fetch_array($res2);resources.inc https://bitbucket.org/rbonesource1234/no2co2 | PHP | 172 lines
9 $sql = "SELECT * FROM resources Where ResourceId= " . $resourceid; 10 $result = mysql_query($sql,$dblink); 11 25 $sql = "SELECT * FROM resourcesinfo r1, resources r2 Where r1.KeyWordId= '".$keywordid."' AND r1.ResourceId=r2.ResourceId"; 26 $result = mysql_query($sql,$dblink); 27 $i=0; 43 $sql = "SELECT * FROM resources Where City IN('".$city."', 'All India')"; 44 $result = mysql_query($sql,$dblink); 45 57 $sql = "SELECT * FROM resourcesinfo Where KeyWordId= '".$keyword."' Order by KeyWordId"; 58 $result = mysql_query($sql,$dblink); 59 $i=0; 70 $sql = "Select * from resources Where ResourceId = '" . $arayres[$j]['ResourceId'] . "' "; 71 $result = mysql_query($sql,$dblink); 72ebpls_bus_masterlist.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 288 lines
10 11$bgy = mysql_query("select * from ebpls_barangay where barangay_code='$brgy_name'"); 12$bgy = mysql_fetch_assoc($bgy); 94 95 $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference") 96 or die(mysql_error()); 97 $resulta=mysql_fetch_row($result); 98$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'"); 99$getlgu = @mysql_fetch_row($getlgu); 99$getlgu = @mysql_fetch_row($getlgu); 100$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'"); 101$getprov = @mysql_fetch_row($getprov); 154 if ($trans == 'Retire') { 155 $result = mysql_query ("select distinct (c.business_permit_code) as pid, a.business_name, 156 concat(a.business_lot_no, ' ', a.business_street, ' ', f.barangay_desc, ' ',request_as_friend.php https://gitlab.com/JLHasson/Wordflow.git | PHP | 190 lines
23 24 $sql_frnd_arry_mem1 = mysql_query("SELECT friend_array FROM myMembers WHERE id='$mem1' LIMIT 1"); 25 31 32 $sql = mysql_query("SELECT id FROM friends_requests WHERE mem1='$mem1' AND mem2='$mem2' Limit 1"); 33 40 41 $sql = mysql_query("SELECT id FROM friends_requests WHERE mem1='$mem2' AND mem2='$mem1' Limit 1"); 42 49 50 $sql = mysql_query("INSERT INTO friends_requests (mem1, mem2, timedate) VALUES('$mem1','$mem2',now())") or die (mysql_error("Friend Request Insertion Error")); 51 51 52 //$sql = mysql_query("INSERT INTO pms (to, from, time, sub, msg) VALUES('$mem2','XXXXX',now(),'New Friend Request','You have a new Friend Request waiting for approval.<br /><br />Navigate to your profile and check your friend requests. <br /><br />Thank you.')") or die (mysql_error("Friend Request PM Insertion Error")); 53 //$id = mysql_insert_id();DatabaseMysql.cpp https://bitbucket.org/raiden/neocore | C++ | 410 lines
162 163 if(mysql_query(mMysql, sql)) 164 { 264 265 if(mysql_query(mMysql, sql)) 266 { 282{ 283 if (mysql_query(mMysql, sql)) 284 {Mysql.hx http://caffeine-hx.googlecode.com/svn/trunk/ | Haxe | 408 lines
234 public function request( s : String ) : ResultSet { 235 var h = untyped __call__("mysql_query", s, c); 236 if(untyped __physeq__(h, false))uotd.inc http://decs.googlecode.com/svn/trunk/ | PHP | 182 lines
62 } 63 $result = mysql_query($query); 64 84 // 85 $result = mysql_query("SELECT * FROM profile,user WHERE profile.userid=user.id AND verification=1 ORDER BY uotd_time ASC LIMIT 1"); 86 } 96 $sql = "UPDATE profile SET uotd_time = ".time()." WHERE userid=$user->id"; 97 mysql_query($sql); 98 140 141 $result = mysql_query($query); 142 if($result) {plugin.h.pp https://bitbucket.org/oregon/oregoncore/ | Puppet | 0 lines
136void thd_get_xid(const void* thd, MYSQL_XID *xid); 137void mysql_query_cache_invalidate4(void* thd, 138 const char *key, unsigned int key_length,ebpls_activity_log1.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 182 lines
74 75 $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error()); 76 $resulta=mysql_fetch_row($result); 76 $resulta=mysql_fetch_row($result); 77 $getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'"); 78$getlgu = @mysql_fetch_row($getlgu); 78$getlgu = @mysql_fetch_row($getlgu); 79$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'"); 80$getprov = @mysql_fetch_row($getprov); 135$date_to = date('Y-m-d', $xdate); 136/* $result=mysql_query("select userid, userlevel, username, action, remoteip, lastupdated 137 from ebpls_activity_log where lastupdated between '$date1' and '$date2' ") or die(mysql_error()); 138*/ 139 $result=mysql_query("select userid, userlevel, username, action, remoteip, lastupdated,querystring from ebpls_activity_log where 140 username like '$owner_last%' and lastupdated between '$date_from' and '$date_to'") or die(mysql_error());backup_compress.php https://bitbucket.org/meerdevelopersoffice/bolivia.git | PHP | 492 lines
263 { 264 $result = mysql_query($sql, $this->link_id); 265 } 267 { 268 $result = mysql_query($sql); 269 }competition.php http://airscore.googlecode.com/svn/trunk/ | PHP | 327 lines
16$query = "select comName from tblCompetition where comPk=$comPk"; 17$result = mysql_query($query) or die('Task add failed: ' . mysql_error()); 18$comName = mysql_result($result,0); 39 $query = "insert into tblTask (comPk, tasName, tasDate, tasTaskStart, tasFinishTime, tasStartTime, tasStartCloseTime, tasSSInterval, tasTaskType, regPk, tasDeparture, tasArrival) values ($comPk, '$Name', '$Date', '$Date $TaskStart', '$Date $TaskFinish', '$Date $StartOpen', '$Date $StartClose', $Interval, '$TaskType', $regPk, '$depart', '$arrival')"; 40 $result = mysql_query($query) or die('Task add failed: ' . mysql_error()); 41 48 $query = "select CTT.traPk from tblComTaskTrack CTT, tblTask T, tblTrack TR, tblCompetition C where CTT.comPk=$comPk and C.comPk=CTT.comPk and T.tasPk=$tasPk and CTT.traPk=TR.traPk and CTT.tasPk is null and TR.traStart > date_sub(T.tasDate, interval C.comTimeOffset hour) and TR.traStart < date_add(T.tasDate, interval (24-C.comTimeOffset) hour)"; 49 $result = mysql_query($query,$link); 50 $tracks = array(); 59 $sql = "update tblComTaskTrack set tasPk=$tasPk where comPk=$comPk and traPk in (" . implode(",",$tracks) . ")"; 60 $result = mysql_query($sql,$link); 61 81 $query = "delete from tblTask where tasPk=$id"; 82 $result = mysql_query($query) or die('Task delete failed: ' . mysql_error()); 83php_mysql_structs.h git://github.com/infusion/PHP.git | C Header | 136 lines
69#endif 70PHP_FUNCTION(mysql_query); 71PHP_FUNCTION(mysql_unbuffered_query);lib_db.php http://pixie-cms.googlecode.com/svn/trunk/ | PHP | 432 lines
56 global $DB, $pixieconfig, $message, $dst, $tzHM, $timezone; 57 $method = (!$unbuf) ? 'mysql_query' : 'mysql_unbuffered_query'; 58 if (!$q) 92 // if ( (first_word($q) == 'SELECT' or 'SHOW' or 'EXPLAIN' or 'DESCRIBE') ) { 93 // mysql_free_result( mysql_query($q) ); 94 // } 95 // } 96 // } /* Don't need to do this for php 4 */ /* While this works, something else is causing an Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query() in Unknown on line 0 error */ 97 return $result; 364 $query_names = "SET NAMES '{$charset}'"; 365 $set_db_names_charset = mysql_query($query_names); 366 /* Set the name character set for database connection */ 367 $query_char = "SET CHARACTER SET '{$charset}'"; 368 $set_db_charset = mysql_query($query_char); 369 /* Set the character set for database connection */ebpls_buslist_category.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 471 lines
70 71 $result=mysql_query("select lgumunicipality, lguprovince, lguoffice from ebpls_buss_preference") 72 or die(mysql_error()); 102 103// $result=mysql_query("select ' ', business_name, ' ' , business_street, ' ' from ebpls_business_enterprise") or die(mysql_error()); 104 104 105 $result = mysql_query("select a.business_name, concat(a.business_lot_no, ' ', a.business_street, ' ', 106 a.business_city_code, ' ', a.business_province_code, ' ', a.business_zip_code), a.employee_male, a.employee_female, 115 116 $result2 = mysql_query("select last_yr 117 from ebpls_business_enterprise a, ebpls_owner b, ebpls_business_enterprise_permit c, tempbusnature d 161//new signatories table 162// $result=mysql_query("select gs_name, gs_pos, gs_office from global_sign where sign_id =1") or die(mysql_error()); 163// $resulta=mysql_fetch_row($result);index.php https://bitbucket.org/molusc/sma-website.git | PHP | 300 lines
47 $query_categories = "SELECT categoryid, category.coursecategory, Count(catalog_id) AS CountOfCourseCatalogID FROM catalog, category WHERE category.id=categoryid GROUP BY categoryid ORDER BY category.coursecategory"; 48$categories = mysql_query($query_categories, $bryanmadge) or die(mysql_error()); 49$row_categories = mysql_fetch_assoc($categories); 57$query_catalog = sprintf("SELECT catalog.catalog_id, catalog.title, catalog.categoryid, category.coursecategory, catalog.subcategoryid, subcategory.subcategory FROM (catalog INNER JOIN category ON catalog.categoryid = category.id) LEFT JOIN subcategory ON catalog.SubCategoryid = subcategory.id WHERE (((catalog.categoryid)=%s)) ORDER BY category.coursecategory, subcategory.subcategory, catalog.title", GetSQLValueString($catid_catalog, "int")); 58$catalog = mysql_query($query_catalog, $bryanmadge) or die(mysql_error()); 59$row_catalog = mysql_fetch_assoc($catalog); 68$query_subcategories = sprintf("SELECT subcategory.id, subcategory.subcategory, subcategory.parentcategoryid FROM subcategory WHERE subcategory.parentcategoryid=%s ORDER BY subcategory.subcategory", $catid_subcategories); 69$subcategories = mysql_query($query_subcategories, $bryanmadge) or die(mysql_error()); 70$row_subcategories = mysql_fetch_assoc($subcategories); 193 <?php 194 $subcategories = mysql_query($query_subcategories, $bryanmadge) or die(mysql_error()); 195ta_logindatabase.inc http://collman.googlecode.com/svn/trunk/ | PHP | 294 lines
58 $q = "SELECT password FROM ".TBL_USERS." WHERE username = '$username'"; 59 $result = mysql_query($q, $this->connection); 60 if(!$result || (mysql_numrows($result) < 1)){ 93 $q = "SELECT userid FROM ".TBL_USERS." WHERE username = '$username'"; 94 $result = mysql_query($q, $this->connection); 95 if(!$result || (mysql_numrows($result) < 1)){ 121 $q = "SELECT username FROM ".TBL_USERS." WHERE username = '$username'"; 122 $result = mysql_query($q, $this->connection); 123 return (mysql_numrows($result) > 0); 134 $q = "SELECT username FROM ".TBL_BANNED_USERS." WHERE username = '$username'"; 135 $result = mysql_query($q, $this->connection); 136 return (mysql_numrows($result) > 0); 152 $q = "INSERT INTO ".TBL_USERS." VALUES ('$username', '$password', '0', $ulevel, '$email', '$userlanguage', $time)"; 153 return mysql_query($q, $this->connection); 154 }ARC2_StoreDeleteQueryHandler.php https://code.google.com/p/goodrelations-for-joomla/ | PHP | 197 lines
68 if ($g_id = $this->getTermID($g, 'g')) { 69 $rs = mysql_query('DELETE FROM ' . $tbl_prefix . 'g2t WHERE g = ' .$g_id, $con); 70 $r += mysql_affected_rows($con); 122 } 123 $rs = mysql_query($sql, $con); 124 if ($er = mysql_error($con)) { 156 '; 157 if (($rs = mysql_query($sql, $con)) && mysql_num_rows($rs)) { 158 /* delete unconnected triples */ 164 '; 165 mysql_query($sql, $con); 166 } 172 '; 173 if (($rs = mysql_query($sql, $con)) && mysql_num_rows($rs)) { 174 /* delete unconnected graph refs */txplib_db.php https://bitbucket.org/dragondz/adminlog | PHP | 520 lines
41 if ( isset($txpcfg['dbcharset']) && (intval($version[0]) >= 5 || preg_match('#^4\.[1-9]#',$version)) ) 42 mysql_query("SET NAMES ". $txpcfg['dbcharset']); 43 } 48 49 $method = (!$unbuf) ? 'mysql_query' : 'mysql_unbuffered_query'; 50 if (!$q) return false;index.php https://github.com/gcummins/searchsite_backend.git | PHP | 380 lines
52 53 $result = mysql_query($query, $adminLink) or returnError(902, $query, 'true', $adminLink); 54 $row = mysql_fetch_object($result); 168 $query = "SELECT id, name, display_name FROM " . DB_NAME . ".menu_sections ORDER BY `order` ASC;"; 169 if (false === ($result = mysql_query($query, $adminLink))) 170 { 233 $query = "SELECT name, display_name FROM modules WHERE id=$module LIMIT 1;"; 234 $result = mysql_query($query, $adminLink) or handle_error("Query failed: $query. MySQL said: <em>" . mysql_error($adminLink) . "</em>"); 235 244 $query = "SELECT script_name, title FROM modules_pages WHERE module_id=$module AND `default`=1 LIMIT 1;"; 245 $result = mysql_query($query, $adminLink) or handle_error("Query failed: $query. MySQL said: <em>" . mysql_error($adminLink) . "</em>"); 246 if (mysql_num_rows($result)) 351 } 352 $result = mysql_query($query, $adminLink) or returnError(902, $query, true, $adminLink); 353 $row = mysql_fetch_object($result);db_mysql.c http://bsp2.googlecode.com/svn/trunk/ | C | 462 lines
173 // Set default charset 174 mysql_query(curr->conn, "SET NAMES 'utf8'"); 175 225 226int db_mysql_query(int conn_id, const char *query, size_t stmt_len) 227{mysql.dbconnection.php git://github.com/jelix/jelix.git | PHP | 189 lines
91 && isset($this->_charsets[jApp::config()->charset])){ 92 mysql_query("SET NAMES '".$this->_charsets[jApp::config()->charset]."'", $cnx); 93 } 113 114 if ($qI = mysql_query ($query, $this->_connection)){ 115 return new mysqlDbResultSet ($qI); 124 125 if ($qI = mysql_query ($query, $this->_connection)){ 126 return mysql_affected_rows($this->_connection);mass_email.php http://decs.googlecode.com/svn/trunk/ | PHP | 113 lines
65 66 $result = mysql_query($query); 67 while ($user = mysql_fetch_object($result)) {invoice_list.php git://git.savannah.nongnu.org/gcourrier.git | PHP | 261 lines
27$requeteInit = "Select id from facture Limit 1;"; 28$result = mysql_query($requeteInit) or die(mysql_error()); 29if(mysql_num_rows($result) == 0){AloneDB.php http://phpfor.googlecode.com/svn/trunk/ | PHP | 269 lines
53 54 if($rs = mysql_query($sql,$db_lnk)){ 55 $db_result = array('rs'=>&$rs,'sql'=>$sql); 146 if(constant('DB_CHARSET')){ 147 mysql_query('SET NAMES \''.DB_CHARSET.'\'',$lnk); 148 }Set.php https://bitbucket.org/siwawong/tomatocms | PHP | 228 lines
34 mysql_real_escape_string($id)); 35 $rs = mysql_query($sql); 36 $return = (0 == mysql_num_rows($rs)) ? null : new Multimedia_Models_Set(mysql_fetch_object($rs)); 61 mysql_real_escape_string($set->is_active)); 62 mysql_query($sql); 63 return mysql_insert_id(); 81 mysql_real_escape_string($set->set_id)); 82 mysql_query($sql); 83 return mysql_affected_rows(); 110 111 $rs = mysql_query($sql); 112 $rows = array(); 140 $sql .= " LIMIT 1"; 141 $rs = mysql_query($sql); 142 $row = mysql_fetch_object($rs);class.mysql.php http://seekstudio.googlecode.com/svn/trunk/ | PHP | 257 lines
41 $get_charset = str_replace('-', '', $this->character); 42 mysql_query("SET NAMES '".$get_charset."'"); 43 mysql_query("SET CHARACTER_SET_CLIENT = '$get_charset';"); 43 mysql_query("SET CHARACTER_SET_CLIENT = '$get_charset';"); 44 mysql_query("SET CHARACTER_SET_RESULTS = '$get_charset';"); 45 } 46 if(mysql_get_server_info() > '5.0'){ 47 mysql_query("SET sql_mode=''"); 48 } 65 } 66 if(!($query = mysql_query($sql)) && $query_type != 'SILENT') { 67 $this->halt('MySQL Query Error', $sql); 87 } 88 if(!($query = mysql_query($sql)) && $query_type != 'SILENT') { 89 $this->halt('MySQL Query Error', $sql);block_login.php https://code.google.com/p/nuked-klan/ | PHP | 213 lines
35 if ($avatar != 'off'){ 36 $sql_avatar=mysql_query('SELECT avatar FROM ' . USER_TABLE . ' WHERE id = \'' . $user[0] . '\' '); 37 list($avatar_url) = mysql_fetch_array($sql_avatar); 47 48 $sql2 = mysql_query('SELECT mid FROM ' . USERBOX_TABLE . ' WHERE user_for = \'' . $user[0] . '\' AND status = 1'); 49 $nb_mess_lu = mysql_num_rows($sql2); 74 75 $sql_users = mysql_query('SELECT id FROM ' . USER_TABLE . ' WHERE niveau < 3'); 76 $nb_users = mysql_num_rows($sql_users); 77 78 $sql_admin = mysql_query('SELECT id FROM ' . USER_TABLE . ' WHERE niveau > 2'); 79 $nb_admin = mysql_num_rows($sql_admin); 80 81 $sql_lastmember = mysql_query('SELECT pseudo FROM ' . USER_TABLE . ' ORDER BY date DESC LIMIT 0, 1'); 82 list($lastmember) = mysql_fetch_array($sql_lastmember);Query.php https://bitbucket.org/mstetson/obiblio/ | PHP | 373 lines
88 } 89 $r = mysql_query($sql, $this->_link); 90 if ($r === false) {pet.php http://ccmtc-chen.googlecode.com/svn/trunk/ | PHP | 282 lines
25$sql="select * from pet where user_id='".$userid."'"; 26$result=mysql_query($sql,$DB->my_connect); 27$pet_num=@mysql_num_rows($result);validate.php https://bitbucket.org/verax/to-ladder.git | PHP | 203 lines
38 $year=date("Y"); 39 $check = mysql_fetch_array(mysql_query("SELECT ipaddress,DATE_FORMAT(requestdate, '%j'),DATE_FORMAT(requestdate, '%Y') FROM passrequests WHERE ipaddress='$ip'")); 40 if((($check[1]-1) == $day)&&($check[2] == $year)){ 50 $tday=date("Y-m-d H:i:s"); 51 mysql_query("INSERT INTO passrequests VALUES ( 52 '', 55 '$playerid');"); 56 $resa=mysql_query("SELECT alias,pass,email FROM users WHERE id='$playerid'"); 57 $resb=mysql_fetch_array($resa); 124 error_check($errormessage); 125 $validatecode=mysql_query("SELECT * FROM validate WHERE vcode='$code'"); 126 $vc=mysql_fetch_array($validatecode); 132 $tday=date("Y-m-d H:i:s"); 133 mysql_query("INSERT INTO users VALUES (NULL, 134 '$vc[alias]',index.php http://sairuk-misc.googlecode.com/svn/trunk/ | PHP | 448 lines
65//Main Table Query 66$result = mysql_query("SELECT * FROM ". $tblnm ." ORDER BY Title"); 67$types = mysql_query("SELECT * FROM Types ORDER BY types"); 76 $delete_ids = implode(",",$dtitle); 77 mysql_query("DELETE FROM ". $tblnm ." WHERE Title IN ($delete_ids)"); 78 $dtitle = ''; 87 $delDate = date(c, strtotime("+$deldays day", time())); 88 mysql_query("UPDATE ". $tblnm ." SET Actioned='Y',Compdate='$delDate' WHERE Title='$key' "); 89 wrtRSSItem($uri,$key,'','COMPLETED','COMPLETED'); 102 //Add to DB 103 mysql_query("INSERT INTO ". $tblnm ." (Title,Comment,Type,Date,Actioned) VALUES ('" . $atitle ."','" . $acomm ."','" . $atype ."','" . $adate ."','N')"); 104 286 { 287 mysql_query("DELETE FROM ". $tblnm ." WHERE Title='".$row['Title']."' "); 288 }MySql.cpp http://upp-mirror.googlecode.com/svn/trunk/ | C++ | 495 lines
124 *trace << btrans << ";\n"; 125 if(mysql_query(mysql, btrans)) 126 SetError(mysql_error(mysql), btrans); 134 *trace << ctrans << ";\n"; 135 if(mysql_query(mysql, ctrans)) 136 SetError(mysql_error(mysql), ctrans); 144 *trace << rtrans << ";\n"; 145 if(mysql_query(mysql, rtrans)) 146 SetError(mysql_error(mysql), rtrans); 267 time = GetTickCount();*/ 268 if(mysql_query(mysql, query)) { 269 session.SetError(mysql_error(mysql), query);uploadmultgrades.php https://github.com/xiongchiamiov/IMathAS.git | PHP | 297 lines
28 $query = "SELECT imas_users.id,imas_users.SID FROM imas_users JOIN imas_students ON imas_students.userid=imas_users.id WHERE imas_students.courseid='$cid'"; 29 $result = mysql_query($query) or die("Query failed : $query; " . mysql_error()); 30 while ($row = mysql_fetch_row($result)) { 49 $query = "SELECT id FROM imas_gbitems WHERE id='{$_POST["coloverwrite$col"]}' AND courseid='$cid'"; 50 $result = mysql_query($query) or die("Query failed : " . mysql_error()); 51 if (mysql_num_rows($result)>0) { //if this fails, we'll end up creating a new item 54 //$query = "DELETE FROM imas_grades WHERE gbitemid={$gbitemid[$col]}"; 55 //mysql_query($query) or die("Query failed : " . mysql_error()); 56 $gradestodel[$col] = array(); 61 $query .= "('$cid','$name','$pts',$showdate,'$gbcat','$cnt',0) "; 62 mysql_query($query) or die("Query failed : " . mysql_error()); 63 $gbitemid[$col] = mysql_insert_id(); 108 $query = "DELETE FROM imas_grades WHERE gbitemid={$gbitemid[$col]} AND userid IN ($stulist)"; 109 mysql_query($query) or die("Query failed : " . mysql_error()); 110 }QueryBuilder.class.php http://antilophpe.googlecode.com/svn/ | PHP | 308 lines
210 $query = "show columns from $table"; 211 $result = mysql_query($query, $db); 212 while ($row = mysql_fetch_array($result)){ 274 $query = "SELECT DISTINCT $field FROM $table"; 275 $result = mysql_query($query, $db); 276 while ($row = mysql_fetch_array($result)){ 300 $query = "SELECT DISTINCT $labelField FROM $table WHERE id ='$foreignKey'"; 301 $result = mysql_query($query, $db); 302 $row = mysql_fetch_array($result);Authorization.class.php http://antilophpe.googlecode.com/svn/ | PHP | 329 lines
234 WHERE ant_Authorization.id = ".$this->getId().""; 235 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Authorization`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId())); 236 while($authorization_array=mysql_fetch_array($result)){ 255 AND ant_Authorization_File.tableObject='ant_Authorization'"; 256 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Authorization_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId())); 257 $filesList=array(); 271 WHERE ant_Authorization_File.id='$fileId'"; 272 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection file in table `ant_Authorization_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId())); 273 $authorization_File_array=mysql_fetch_assoc($result); 285 AND ant_Authorization_File.tableObject='ant_Authorization'"; 286 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Authorization_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId())); 287 $authorization_File_array=mysql_fetch_array($result); 297 FROM ant_Authorization_Log"; 298 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during select count from table `ant_Authorization_Log`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId())); 299 $authorization_Log_array=mysql_fetch_array($result);connection.php git://github.com/UCF/fuelphp-crash-course.git | PHP | 438 lines
168 // PHP is compiled against MySQL 4.x 169 $status = (bool) mysql_query('SET NAMES '.$this->quote($charset), $this->_connection); 170 } 201 // Execute the query 202 if (($result = mysql_query($sql, $this->_connection)) === false) 203 {lgsl_add.php http://lansuite.googlecode.com/svn/trunk/ | PHP | 265 lines
132 $ip_check = gethostbyname($ip); 133 $mysql_result = mysql_query("SELECT `ip`,`disabled` FROM `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` WHERE `type`='{$type}' AND `q_port`='{$q_port}'"); 134 193 $mysql_query = "INSERT INTO `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` (`type`,`ip`,`c_port`,`q_port`,`s_port`,`disabled`,`cache`,`cache_time`) VALUES ('{$type}','{$ip}','{$c_port}','{$q_port}','{$s_port}','{$disabled}','','')"; 194 $mysql_result = mysql_query($mysql_query) or die(mysql_error()); 195