100+ results results for 'mysql_query' (425 ms)
19} 20$req = mysql_query("SELECT * FROM `cms_album_cat` where `website` = '$website' AND `id` = '$al'"); 21if (!mysql_num_rows($req)) { 81 $kmess = 1; 82 $start = isset($_REQUEST['page']) ? $page - 1 : (mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` where `website` = '$website' AND `album_id` = '$al' AND `id` > '$img'"), 0)); 83 // Обрабатываем ссылку для возврата 88} 89$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` where `website` = '$website' AND `album_id` = '$al'"), 0); 90if ($total > $kmess) 92if ($total) { 93 $req = mysql_query("SELECT * FROM `cms_album_files` where `website` = '$website' AND `user_id` = '" . $user['id'] . "' AND `album_id` = '$al' ORDER BY `id` DESC LIMIT $start, $kmess"); 94 $i = 0; 115 // Счетчик просмотров 116 if (!mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_views` where `website` = '$website' AND `user_id` = '$user_id' AND `file_id` = '" . $res['id'] . "'"), 0)) { 117 mysql_query("INSERT INTO `cms_album_views` SET `user_id` = '$user_id', `file_id` = '" . $res['id'] . "', `time` = '" . time() . "', `website` = '$website'");delivery_list.php https://gitlab.com/Henaway/CLFC | PHP | 253 lines
25 route_name ASC'; 26$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 769302 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 27while ( $row = mysql_fetch_array($result) ) 73 last_name ASC'; 74$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 769302 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 75$num_orders = mysql_numrows($result); 188 sum_p DESC'; 189$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 860342 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 190while ($row = mysql_fetch_array($result))watch_brek_vid.php https://gitlab.com/msdusad/all_ones | PHP | 237 lines
49 $sd="select bann_news from banner"; 50 $ab=mysql_query($sd); 51 $df=mysql_fetch_array($ab); 69 70 $rf=mysql_query($df); 71 $row=mysql_fetch_array($rf); 111 112 $rf=mysql_query($df); 113 $row=mysql_fetch_array($rf);submit_track.php http://airscore.googlecode.com/svn/trunk/ | PHP | 332 lines
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()); 227events.php https://github.com/cybernet/CyBerFuN-CoDeX.git | PHP | 272 lines
114$sql = "DELETE FROM `events` WHERE `id` = $id LIMIT 1;"; 115$res = mysql_query($sql); 116if(mysql_error()!=0) 150//echo "<p>$sql</p>"; 151$res = mysql_query($sql); 152if(mysql_error()!=0)ebpls_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 ") ;log-2016-01-20.php https://gitlab.com/fcupen/PHP | PHP | 44 lines
20ERROR - 2016-01-20 12:20:54 --> Severity: error --> Exception: Configured database connection is persistent. Aborting. /usr/home/astfou/domains/astral-foundations.com/public_html/system/libraries/Session/drivers/Session_database_driver.php 94 21ERROR - 2016-01-20 12:37:40 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39 22ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39 22ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39 23ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_query(): A link to the server could not be established /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39 24ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40 24ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40 25ERROR - 2016-01-20 12:40:19 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39 26ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39 26ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39 27ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_query(): A link to the server could not be established /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39 28ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40 28ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40 29ERROR - 2016-01-20 12:40:55 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39 30ERROR - 2016-01-20 12:40:55 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39edit.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 122 lines
18 } 19 $req = mysql_query("SELECT * FROM `lib` where `website` = '$website' AND `id` = '" . $id . "'"); 20 $ms = mysql_fetch_array($req); 44 } 45 mysql_query("UPDATE `lib` SET 46 `name` = '" . mysql_real_escape_string(mb_substr(trim($_POST['name']), 0, 100)) . "', 66 $mod = intval($_POST['mod']); 67 mysql_query("UPDATE `lib` SET 68 `text` = '" . $text . "', 78 $text = functions::check($_POST['text']); 79 mysql_query("update `lib` set text='" . $text . "' where `website` = '$website' AND id='" . $id . "';"); 80 header("location: index.php?id=$ms[refid]");phorum.rb https://gitlab.com/Ruwan-Ranganath/discourse | Ruby | 218 lines
30 31 total_count = mysql_query("SELECT count(*) count FROM #{TABLE_PREFIX}users;").first['count'] 32 33 batches(BATCH_SIZE) do |offset| 34 results = mysql_query( 35 "SELECT user_id id, username, email, real_name name, date_added created_at, 59 60 categories = mysql_query(" 61 SELECT forum_id id, name, description, active 83 84 total_count = mysql_query("SELECT count(*) count from #{TABLE_PREFIX}messages").first["count"] 85 86 batches(BATCH_SIZE) do |offset| 87 results = mysql_query(" 88 SELECT m.message_id id,counters.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 203 lines
23 24 $albumcount = mysql_result(mysql_query("SELECT COUNT(DISTINCT `user_id`) FROM `cms_album_files` WHERE `website` = '$website'"), 0); 25 $photocount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `website` = '$website'"), 0); 25 $photocount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `website` = '$website'"), 0); 26 $newcount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` where `website` = '$website' AND `time` > '" . (time() - 259200) . "' AND `access` > '1'"), 0); 27 return $albumcount . ' / ' . $photocount . ($newcount ? ' / <span class="red"><a href="' . core::$system_set['homeurl'] . '/users/album.php?act=top">+' . $newcount . '</a></span>' : ''); 38 39 $total = mysql_result(mysql_query("SELECT COUNT(*) FROM `download` where `website` = '$website' AND `type` = 'file'"), 0); 40 $new = mysql_result(mysql_query("SELECT COUNT(*) FROM `download` where `website` = '$website' AND `time` > '" . (time() - 259200) . "' AND `type` = 'file'"), 0); 54 55 $total_thm = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` where `website` = '$website' AND `type` = 't'" . (core::$user_rights >= 7 ? "" : " AND `close` != '1'")), 0); 56 $total_msg = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` where `website` = '$website' AND `type` = 'm'" . (core::$user_rights >= 7 ? "" : " AND `close` != '1'")), 0); 78 if (core::$user_id) { 79 $req = mysql_query("SELECT COUNT(*) FROM `forum` 80 LEFT JOIN `cms_forum_rdm` ON `forum`.`id` = `cms_forum_rdm`.`topic_id` AND `cms_forum_rdm`.`user_id` = '" . core::$user_id . "'DBIMysql.class.php https://gitlab.com/qbarbosa/klindev | PHP | 468 lines
188 if ($options == ($options | PMA_DatabaseInterface::QUERY_STORE)) { 189 return mysql_query($query, $link); 190 } elseif ($options == ($options | PMA_DatabaseInterface::QUERY_UNBUFFERED)) { 192 } else { 193 return mysql_query($query, $link); 194 }customer_list.php https://gitlab.com/Henaway/CLFC | PHP | 280 lines
56 AND '.NEW_TABLE_PRODUCTS.'.product_version = "'.mysql_real_escape_string ($product_version).'"'; 57$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 738102 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 58if ( $row = mysql_fetch_object($result) ) 189 AND product_version = "'.mysql_real_escape_string ($product_version).'"'; 190 $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 155816 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 191 $bpid= mysql_insert_id(); 204 AND product_version = "'.mysql_real_escape_string ($product_version).'"'; 205 $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 731034 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 206 } 223 inventory_id = '.mysql_real_escape_string ($inventory_id); 224 $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 066934 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 225 } 235 AND product_version = "'.mysql_real_escape_string ($product_version).'"'; 236 $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 267490 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 237 }mysqldataprovider.cpp https://gitlab.com/ablu/invertika-backup-invertika | C++ | 454 lines
156 // actually execute the query. 157 if (mysql_query(mDb, sql.c_str()) != 0) { 158 throw DbSqlQueryExecFailure(mysql_error(mDb));camaras_productor.model.php https://gitlab.com/talueses/SIPVE | PHP | 197 lines
53 $link = DbLink::getLink(); 54 $result = mysql_query($sql, $link); 55 if (!$result) { 108 $str .= "\t\t\$link = DbLink::getLink();\n"; 109 $str .= "\t\t\$result = mysql_query(\$sql, \$link);\n"; 110 $str .= "\t\tif (!\$result) {\n"; 143 $str .= "\t\t\$link = DbLink::getLink();\n"; 144 $str .= "\t\t\$result = mysql_query(\$sql, \$link);\n"; 145 $str .= "\t\tif (!\$result) {\n"; 160 $str .= "\t\t\$link = DbLink::getLink();\n"; 161 $str .= "\t\t\$result = mysql_query(\$sql, \$link);\n"; 162 $str .= "\t\tif (!\$result) {\n";_stats_load.php https://gitlab.com/Etern4l/BitcoinDice | PHP | 238 lines
17 18$settings=mysql_fetch_array(mysql_query("SELECT * FROM `system` LIMIT 1")); 19 23 case 'my_bets': 24 if (empty($_GET['_unique']) || mysql_num_rows(mysql_query("SELECT `id` FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1"))==0) exit(); 25 $player=mysql_fetch_array(mysql_query("SELECT * FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1")); 26 27 $my_bets=mysql_query("SELECT * FROM `bets` WHERE `player`=$player[id] ORDER BY `time` DESC LIMIT 30"); 28 if (mysql_num_rows($my_bets)==0) $content.='<br><br><br><i>You haven\'t bet yet.</i>'; 44 45 $username=mysql_fetch_array(mysql_query("SELECT `alias` FROM `players` WHERE `id`=$my_bet[player] LIMIT 1")); 46 74 case 'all_bets': 75 $all_bets=mysql_query("SELECT * FROM `bets` WHERE `bet_amount`!=0 ORDER BY `time` DESC LIMIT 30"); 76 if (mysql_num_rows($all_bets)==0) $content.='<br><br><br><i>No one has bet yet.</i>';mysql.dbi.lib.php https://gitlab.com/albert925/lading-ach | PHP | 450 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 }heidelpay_response.php https://bitbucket.org/isaacoheneayisi/ecommerce.git | PHP | 190 lines
48 mysql_select_db($connect->db); 49 $result = mysql_query("SELECT virtuemart_order_id FROM ".$connect->dbprefix."virtuemart_orders"." WHERE order_number = '".mysql_real_escape_string($orderID)."';"); 50 $row = mysql_fetch_object($result); 169 "response_ip = \"".mysql_real_escape_string($_SERVER['REMOTE_ADDR']). "\";" ; 170 $dbEerror = mysql_query($sql); 171 }printprod_new.php https://gitlab.com/Henaway/CLFC | PHP | 201 lines
34 subcategory_name ASC'; 35$rs = @mysql_query($sql, $connection) or die("Couldn't execute category query: ".mysql_error()); 36while ( $row = mysql_fetch_array($rs) ) 98 '.TABLE_MEMBER.'.business_name'; 99 $resultp = @mysql_query($sqlp, $connection) or die("Couldn't execute query 2."); 100 while ( $row = mysql_fetch_array($resultp) ) 128 unit_price ASC'; 129 $result = @mysql_query($sql, $connection) or die("Couldn't execute search query: " . mysql_error()); 130 while ( $row = mysql_fetch_array($result) )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());index.php https://github.com/d3c0n808/MiningFarm.git | PHP | 276 lines
49 $fifteenMinutesAgo -= 60*15; 50 $userHashHistoryQ = mysql_query("SELECT DISTINCT `timestamp` FROM `stats_userMHashHistory` WHERE `username` LIKE '".$getCredientials->username.".%' AND `timestamp` >= '$fifteenMinutesAgo' AND `mhashes` > 0 ORDER BY `timestamp` ASC"); 51 $numRows = mysql_num_rows($userHashHistoryQ); 66 //Get all mhash results with this timestamp and average them up 67 $getAllWorkerHash = mysql_query("SELECT `mhashes` FROM `stats_userMHashHistory` WHERE `username` LIKE '".$getCredientials->username.".%' AND `timestamp` = '".$time["timestamp"]."' AND `mhashes` > 0"); 68 $numWorkersThisTime = mysql_num_rows($getAllWorkerHash); 74 //Get pool average results 75 $getPoolAverageResult = mysql_query("SELECT `averageMhash`, `totalMhash` FROM `stats_poolMHashHistory` WHERE `timestamp` = '".$time["timestamp"]."' LIMIT 0,1"); 76 102 //Go through the pool history and display that 103 $poolHistory = mysql_query("SELECT `averageMhash`, `totalMhash`, `timestamp` FROM `stats_poolMHashHistory` WHERE `timestamp` >= '".$fifteenMinutesAgo."' ORDER BY `timestamp` ASC"); 104 while($poolHash = mysql_fetch_array($poolHistory)){ 191 //retireve blogs 192 $blogs = mysql_query("SELECT `title`, `timestamp`, `message` FROM `blogPosts` ORDER BY `timestamp` DESC"); 193 while($blog = mysql_fetch_array($blogs)){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); 134companyclass.php https://github.com/samsonnguyen/CPSC471carinsurance.git | PHP | 280 lines
23 } 24 mysql_query($sql) or die(mysql_error()); 25 return true; 29 $sql="DELETE FROM `Company` WHERE Commercial_License_No='$companyno'"; 30 mysql_query($sql) or die(mysql_error()); 31 return true; 34 static function getAllCompanies($selection){ 35 $companies = mysql_query("SELECT * FROM `Company`");// or die(mysql_error()); 36 if($companies != null){ 89 } 90 return mysql_query($sql); 91 } 140 $sql = "SELECT * FROM `Company` ORDER BY Commercial_License_No ASC LIMIT $offset, $limit"; 141 $result = mysql_query($sql); 142 print "<table class=\"company\"><tr>";database.php https://gitlab.com/billyprice1/b374k | PHP | 343 lines
80 if(class_exists('mysqli')) return $con->query($query); 81 elseif(function_exists('mysql_query')) return mysql_query($query); 82 }spo.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 218 lines
14 <?php $selPle="select localitati.nume, localitati.id_localitate from spo inner join localitati on spo.id_oras = localitati.id_localitate inner join tari on localitati.id_tara = tari.id_tara where tari.nume = 'Romania' Group by localitati.id_localitate Order by localitati.nume "; 15 $quePle=mysql_query($selPle, $conn_tz) or die(mysql_error()); ?> 16 Localitate Plecare: 24 <?php $selPle="select tari.nume, tari.id_tara from spo inner join tari on spo.id_tara = tari.id_tara inner join localitati on spo.id_oras = localitati.id_localitate inner join tari as tari_plec on localitati.id_tara = tari_plec.id_tara where tari_plec.nume = 'Romania' Group by tari.id_tara Order by tari.nume "; 25 $quePle=mysql_query($selPle, $conn_tz) or die(mysql_error()); ?> 26 Tari sosire: 46 $insEx="INSERT INTO exceptii_lista_spo (spo) VALUES ('".$_GET['scoate']."') "; 47 $queEx=mysql_query($insEx, $connect->link) or die(mysql_error()); 48 @mysql_free_result($queEx); 52$selEX="SELECT spo FROM exceptii_lista_spo GROUP BY spo "; 53$queEX=mysql_query($selEX, $connect->link) or die(mysql_error()); 54while($rowEX=mysql_fetch_array($queEX)) { 89 90$rez=mysql_query($query); 91$numar_total=mysql_num_rows($rez);ebpls.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 ); 202todolist.php https://gitlab.com/jonz94/2016NCU_FreshWeb_HW | PHP | 187 lines
11 $query_RecUser = "SELECT `nickname`,`permission` FROM `user` WHERE `username`='".$username."'"; 12 $RecUser = mysql_query($query_RecUser); 13 $row_RecUser = mysql_fetch_assoc($RecUser); 30 $query_RecLogin = "SELECT * FROM `user` WHERE `username`='".$_POST["username"]."'"; 31 $RecLogin = mysql_query($query_RecLogin); 32 //取出帳號密碼的值install.php https://github.com/benbruscella/Grammafone.git | PHP | 424 lines
5 $query = "SELECT user_id FROM mp3act_users"; 6 $result = @mysql_query($query); 7 if(@mysql_num_rows($result) > 0){ 351foreach($querys as $key=>$query){ 352 if(mysql_query($query)){ 353 396 $query = "UPDATE mp3act_settings SET invite_mode=$_POST[invite],sample_mode=$_POST[sample_mode],downloads=$_POST[downloads],amazonid=\"$_POST[amazonid]\",mp3bin=\"$_POST[mp3bin]\",lamebin=\"$_POST[lamebin]\",phpbin=\"$_POST[phpbin]\",jukemode=\"$_POST[jukemode]\",mpdserver=\"$_POST[mpdserver]\",mpdport=\"$_POST[mpdport]\" WHERE id=1"; 397 mysql_query($query); 398 echo "<strong>Settings Saved....</strong><br/><br/>"; 409 $query = "INSERT INTO `mp3act_users` VALUES (NULL, 'admin', 'Admin', 'User', PASSWORD(\"$random_password\"), 10, NOW(), 1, '', 'streaming', 0, 's', '21232f297a57a5a743894a0e4a801fc3', '', '0000-00-00 00:00:00', 1,'','','',0)"; 410 mysql_query($query); 411 echo "<br/><strong>Username:</strong> Admin<br/><strong>Password:</strong> $random_password (Please change this password as soon as you login.)<br/><br/>";classes.php https://github.com/camlegleiter/Project-Pencl.git | PHP | 378 lines
26 $classid = mysql_real_escape_string($classid); 27 $padRow = mysql_query("SELECT name,description,password,owner FROM classes WHERE id='$classid'"); 28 $row = mysql_fetch_assoc($padRow); 54 $classid = mysql_real_escape_string($classid); 55 $padRow = mysql_query("SELECT notebookid FROM classbooks WHERE classid='$classid'"); 56 $notepadHTML = ""; 69 $classid = mysql_real_escape_string($classid); 70 $padRow = mysql_query("SELECT userid FROM classmates WHERE classid='$classid'"); 71 $notepadHTML = ""; 87 $id = mysql_real_escape_string($id); 88 $padRow = mysql_query("SELECT name,description,created,modified,userid FROM notebooks WHERE id='$id'"); 89 $row = mysql_fetch_assoc($padRow); 122 $id = mysql_real_escape_string($id); 123 $padRow = mysql_query("SELECT username FROM users WHERE userid='$id'"); 124 $row = mysql_fetch_assoc($padRow);mutate_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);simulador-comparador-pruebas.php https://gitlab.com/fredyteheranto/gestionet | PHP | 332 lines
70 $hoy = date("Y-m-d"); 71 $result = mysql_query("SELECT * FROM extranet_cash_productos WHERE id_tipo_producto = $tipoConsulta AND fecha_hasta >= '$hoy' ORDER BY cuantia_max ASC, anyos ASC;"); 72 while ($row=mysql_fetch_array($result)) { 73 $idBanco = $row['id_entidad']; 74 $resultBanco = mysql_query("SELECT * FROM extranet_cash_entidades WHERE id = $idBanco;"); 75 $rowBanco=mysql_fetch_array($resultBanco); 113 <?php 114 $resultFecha = mysql_query("SELECT MAX(f_user) AS fecha FROM extranet_cash_productos"); 115 $rowFecha=mysql_fetch_array($resultFecha); 152 <?php 153 $result = mysql_query("SELECT * FROM extranet_cash_productos WHERE id IN ($seleccion) ORDER BY cuantia_max ASC, anyos ASC;"); 154 while ($row=mysql_fetch_array($result)) { 155 $idBanco = $row['id_entidad']; 156 $resultBanco = mysql_query("SELECT * FROM extranet_cash_entidades WHERE id = $idBanco;"); 157 $rowBanco=mysql_fetch_array($resultBanco);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;parsetodb.php https://gitlab.com/bjwebb-codedump/plingconica.git | PHP | 219 lines
33 34 if ($result = mysql_query("SELECT * FROM `".$tablename."` WHERE id='".$array["id"]."'", $con)); 35 else die(mysql_error()); 66 if ($query) { 67 if (mysql_query($query)); 68 else { 215 216if (mysql_query("UPDATE `custom` SET `uptodate`=0 WHERE `uptodate`=1")); 217else die(mysql_error());xpdomanager.class.php https://github.com/Kleist/xPDO.git | PHP | 296 lines
81 if (!$rt= @ mysql_select_db($dsnArray['dbname'], $conn)) { 82 @ mysql_query($sql, $conn); 83 $errorNo= @ mysql_errno($conn); 105 if (@ mysql_select_db($dsnArray['dbname'], $conn)) { 106 if (@ mysql_query($sql, $conn)) { 107 $removed= 1;index.php https://github.com/michaelmwu/saratogahigh.com.git | PHP | 219 lines
15 if(is_numeric($_GET['delete'])) 16 mysql_query('DELETE FROM NOTEPAGE_LIST WHERE NOTEPAGE_OWNER=' . $userid . ' AND NOTEPAGE_ID=' . $_GET['delete']) or die("Delete failed."); 17 if($_POST['go'] == 'Save') 23 else 24 mysql_query('INSERT INTO NOTEPAGE_LIST (NOTEPAGE_OWNER, NOTEPAGE_CREATED, NOTEPAGE_MODIFIED, NOTEPAGE_VALUE, NOTEPAGE_DIGEST) VALUES (' . $userid . ', "' . date(TIME_FORMAT_SQL, CURRENT_TIME) . '", NOTEPAGE_CREATED, \'' . $_POST['entrytext'] . '\', \'' . makedigest($_POST['entrytext']) . '\')') or die("Insert failed."); 25 } 27 { 28 mysql_query('UPDATE NOTEPAGE_LIST SET NOTEPAGE_MODIFIED="' . date(TIME_FORMAT_SQL, CURRENT_TIME) . '", NOTEPAGE_VALUE=\'' . $_POST['entrytext'] . '\', NOTEPAGE_DIGEST=\'' . makedigest($_POST['entrytext']) . '\' WHERE NOTEPAGE_OWNER=' . $userid . ' AND NOTEPAGE_ID=' . $_GET['id']) or die("Insert failed."); 29 } 64 65 $entries = mysql_query('SELECT NOTEPAGE_ID, NOTEPAGE_DIGEST, UNIX_TIMESTAMP(NOTEPAGE_CREATED) as TS FROM NOTEPAGE_LIST WHERE NOTEPAGE_OWNER=' . $userid . ' AND MATCH(NOTEPAGE_VALUE) AGAINST (\'' . $_GET['query'] . '\')') or die('Query failed.'); 66 180 181 $entries = mysql_query('SELECT NOTEPAGE_LIST.*, NOTEPAGE_CREATED as CR, NOTEPAGE_MODIFIED as MO FROM NOTEPAGE_LIST WHERE NOTEPAGE_OWNER=' . $userid . ' AND NOTEPAGE_ID=' . $id) or die('Query failed.'); 182index.php https://github.com/adanganan/chits.git | PHP | 317 lines
72 73/*mysql_query("ALTER TABLE `m_patient` DROP PRIMARY KEY , ADD PRIMARY KEY (`patient_id`)"); 74mysql_query("ALTER TABLE `m_consult` DROP PRIMARY KEY , ADD PRIMARY KEY (`consult_id`)"); 74mysql_query("ALTER TABLE `m_consult` DROP PRIMARY KEY , ADD PRIMARY KEY (`consult_id`)"); 75mysql_query("ALTER TABLE `m_family` DROP PRIMARY KEY , ADD PRIMARY KEY (`family_id`)"); 76mysql_query("ALTER TABLE `m_consult_notes` DROP PRIMARY KEY , ADD PRIMARY KEY (`notes_id`)"); 76mysql_query("ALTER TABLE `m_consult_notes` DROP PRIMARY KEY , ADD PRIMARY KEY (`notes_id`)"); 77mysql_query("ALTER TABLE `content` DROP PRIMARY KEY , ADD PRIMARY KEY (`content_id`)"); 78mysql_query("ALTER TABLE `m_patient_mc` DROP PRIMARY KEY, ADD PRIMARY KEY(`mc_id`)"); 78mysql_query("ALTER TABLE `m_patient_mc` DROP PRIMARY KEY, ADD PRIMARY KEY(`mc_id`)"); 79mysql_query("ALTER TABLE `m_patient_fp` DROP PRIMARY KEY, ADD PRIMARY KEY(`fp_id`)"); 80mysql_query("ALTER TABLE `m_patient_ccdev` DROP PRIMARY KEY, ADD PRIMARY KEY(`ccdev_id`)"); 80mysql_query("ALTER TABLE `m_patient_ccdev` DROP PRIMARY KEY, ADD PRIMARY KEY(`ccdev_id`)"); 81mysql_query("ALTER TABLE `m_patient_ntp` DROP PRIMARY KEY, ADD PRIMARY KEY(`ntp_id`)"); 82mysql_query("ALTER TABLE `m_consult_appointments` DROP PRIMARY KEY, ADD PRIMARY KEY(`schedule_id`)");load_MySQL.c https://bitbucket.org/vrrm/brl-cad-copy-for-fast-history-browsing-in-git.git | C | 221 lines
69 sprintf (query, "select gid from project where pid = '%d'", pid); 70 mysql_query (&slave_load_mysql_db, query); 71 res = mysql_use_result (&slave_load_mysql_db); 84 snprintf (query, 256, "select trinum,meshnum,gsize,gdata from geometry where gid = '%d'", gid); 85 mysql_query (&slave_load_mysql_db, query); 86 res = mysql_use_result (&slave_load_mysql_db); 173 snprintf (query, 256, "select attr from meshattrmap where mesh='%s' and gid=%d", slave_load_mesh_list[i].name, gid); 174 if (!mysql_query (&slave_load_mysql_db, query)) { 175 char attr[48]; 186/* printf("query[%d]: %s\n", i, query); */ 187 if (!mysql_query (&slave_load_mysql_db, query)) { 188 res = mysql_use_result (&slave_load_mysql_db); 198 snprintf (query, 256, "select asize,adata from geometry where gid='%d'", gid); 199 mysql_query (&slave_load_mysql_db, query); 200 res = mysql_use_result (&slave_load_mysql_db);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); 311feedback.php https://bitbucket.org/maxpanzer/cred_katherine.git | PHP | 175 lines
28 echo $sql; 29 mysql_query($sql) or die(mysql_error()); 30?>mysql.php https://gitlab.com/ken3/bluSky | PHP | 443 lines
92 93 mysql_query('SET '.implode(', ', $variables), $this->_connection); 94 } 151 // PHP is compiled against MySQL 4.x 152 $status = (bool) mysql_query('SET NAMES '.$this->quote($charset), $this->_connection); 153 } 185 // Execute the query 186 if (($result = mysql_query($sql, $this->_connection)) === FALSE) 187 { 286 287 if ($mode AND ! mysql_query("SET TRANSACTION ISOLATION LEVEL $mode", $this->_connection)) 288 { 293 294 return (bool) mysql_query('START TRANSACTION', $this->_connection); 295 }panel_producer_admin.php https://gitlab.com/Henaway/CLFC | PHP | 308 lines
33 producer_id = "'.mysql_real_escape_string ($_SESSION['producer_id_you']).'"'; 34 $resultr = @mysql_query($sqlr,$connection) or die(debug_print ("ERROR: 904933", array ($sqlr,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 35 $message = 'Producer # '.$producer_id.' has been updated.<br>'; 48 producer_id = "'.mysql_real_escape_string ($_GET['producer_id_you']).'"'; 49 $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 860943 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 50 while ($row = mysql_fetch_object($result)) 73// LIMIT 0,1'; 74// $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 537557 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 75// while ($row = mysql_fetch_object($result)) 99 business_name'; 100$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 759326 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 101while ( $row = mysql_fetch_object($result) )adhesion.php https://gitlab.com/radicalcinema/AnarchistNewsroom | PHP | 369 lines
19$del=$_GET['del']; 20$sql = mysql_query("SELECT * FROM ".$prefix."cotisations WHERE id = '$del'"); 21 $nb_rep_request = mysql_num_rows($sql); 23 { 24 mysql_query("DELETE FROM ".$prefix."cotisations WHERE id = '$del'"); 25 } 262 263$sql_cotisations = mysql_query("SELECT * FROM ".$prefix."cotisations WHERE id_user = '$id_user_online' ORDER BY date_debut DESC"); 264while($cotis = mysql_fetch_array($sql_cotisations)) {class.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 functionslip.php https://gitlab.com/msdusad/all_ones | PHP | 324 lines
11{ 12 $inslipnos=mysql_query("SELECT * FROM slip;"); 13 while($sl=mysql_fetch_array($inslipnos)){ 18$_SESSION['number'] = $_SESSION['number'] + 1; 19 $inslipno=mysql_query("UPDATE slip SET slipno='{$_SESSION['number']}';"); 20} 121 $ms=$_GET['sl']; 122 $result=mysql_query("SELECT * FROM trregistration where id='$ms';"); 123if($result){Index.php https://gitlab.com/ElvisAns/tiki | PHP | 260 lines
21 $this->table = new Search_MySql_Table($db, $index); 22 $this->builder = new Search_MySql_QueryBuilder($db); 23 $this->tfTranslator = new Search_MySql_TrackerFieldTranslator(); 162 return $resultSet; 163 } catch (Search_MySql_QueryException $e) { 164 if (empty($e->suppress_feedback)) { 254 $this->table->ensureHasIndex($indexToRestore['Column_name'], $indexType); 255 } catch (Search_MySql_QueryException $exception) { 256 // Left blank on purposestudent_2.php https://bitbucket.org/deba666/accitsoftware.git | PHP | 93 lines
55 <?php $std_row="select * from student ORDER BY STUD_NO DESC"; 56 $q=mysql_query($std_row); 57 while($row=mysql_fetch_array($q))form3New.php https://gitlab.com/cesardemora/neaticketwebapphomeEs | PHP | 296 lines
54 $valor = $_GET['fecha_alta']; 55 $result = mysql_query("SELECT * FROM CLIENTES WHERE fecha_alta LIKE '$valor%' LIMIT $init, $limit_end"); 56 $count = "SELECT COUNT(*) FROM CLIENTES WHERE fecha_alta LIKE '$valor%'"; 62 $valor = $_GET['email']; 63 $result = mysql_query("SELECT * FROM CLIENTES WHERE mail LIKE '%$valor%' LIMIT $init, $limit_end"); 64 $count = "SELECT COUNT(*) FROM CLIENTES WHERE mail LIKE '%$valor%'";plugin.h.pp https://gitlab.com/envieidoc/tomato | Puppet | 142 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,prueba.php https://gitlab.com/gustCL/syscar | PHP | 268 lines
80 { 81 mysql_query('SET NAMES'.$this->charset); 82 } 95 $tables = array(); 96 $result = mysql_query('SHOW TABLES'); 97 while($row = mysql_fetch_row($result)) 116 117 $result = mysql_query('SELECT * FROM '.$table); 118 $numFields = mysql_num_fields($result); 120 $sql .= 'DROP TABLE IF EXISTS '.$table.';'; 121 $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table)); 122 $sql.= "\n\n".$row2[1].";\n\n"; 220 $tables = array(); 221 $result = mysql_query('SHOW TABLES'); 222 while($row = mysql_fetch_row($result))CMySQL.php https://github.com/stargazers/CMySQL.git | PHP | 401 lines
97 // Execute query 98 $ret = @mysql_query( $query, $this->_connection ); 99all_hotels.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 143 lines
2$sel_hoteluri = "SELECT Accommodation_UnitID, Accommodation_Name, Accommodation_Stars, Accommodation_City_Name, Accommodation_City_ID FROM preturi_transilvania GROUP BY Accommodation_UnitID "; 3$que_hoteluri = mysql_query($sel_hoteluri); 4while($row_hoteluri = mysql_fetch_array($que_hoteluri)) { 15 $sel_loc = "SELECT * FROM localitati_corespondent WHERE nume_furnizor = '".$hotels['localitate'][$key]."' AND code_furnizor = '".$hotels['localitate_id'][$key]."' AND id_furnizor = '".$id_furnizor."' "; 16 $que_loc = mysql_query($sel_loc); 17 $row_loc = mysql_fetch_array($que_loc); 19 $ins_city = "INSERT INTO localitati_corespondent (nume_furnizor, code_furnizor, id_furnizor) VALUES ('".$hotels['localitate'][$key]."', '".$hotels['localitate_id'][$key]."', '".$id_furnizor."') "; 20 $que_city = mysql_query($ins_city) or die(mysql_error()); 21 @mysql_free_result($que_city); 23 $sel_oras = "SELECT id FROM localitati_corespondent WHERE nume_furnizor = '".$hotels['localitate'][$key]."' AND code_furnizor = '".$hotels['localitate_id'][$key]."' AND id_furnizor = '".$id_furnizor."' "; 24 $que_oras = mysql_query($sel_oras); 25 $row_oras = mysql_fetch_array($que_oras); 34 $sel_hotels = "SELECT * FROM import_hoteluri WHERE nume_hotel = '".$value."' AND stele_hotel = '".$hotels['stele'][$key]."' AND city = '".$hotel_city."' "; 35 $que_hotels = mysql_query($sel_hotels); 36 $row_hotels = mysql_fetch_array($que_hotels);functions_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);index.php https://github.com/chacha13/runningmate.git | PHP | 399 lines
82 83 $query = mysql_query($sql); 84 167 168 $query = mysql_query($sql); 169postfooter.php https://github.com/karlforshaw/One-Panel.git | PHP | 217 lines
63 $sql .= 'LIMIT 3'; 64 $result = mysql_query( $sql ); 65index.php https://bitbucket.org/chadsaun/ifrogz-panel.git | PHP | 134 lines
19 WHERE username="'.mysql_real_escape_string(unstripslashes(trim(@$_COOKIE["WRITECKL"]))).'" and password="'.mysql_real_escape_string(unstripslashes(trim(@$_COOKIE["WRITECKP"]))).'"'; 20 $rs_rbi = mysql_query($rbiSQL); 21 if(mysql_num_rows($rs_rbi) > 0) { 34$sSQL = "SELECT adminEmail,adminStoreURL,adminShipping,adminVersion,adminUser,adminPassword FROM admin WHERE adminID=1"; 35$result = mysql_query($sSQL) or print(mysql_error()); 36$rs = mysql_fetch_assoc($result);core.php https://github.com/rezamoussavi/MouRe.git | PHP | 351 lines
25 if(!$osdbcon){ $_result=null; return;} 26 $_result= mysql_query(parseQuery($caller,$s),$osdbcon); 27 } 29 global $osdbcon,$_result; 30 if(!($_result= $osdbcon? mysql_query($s,$osdbcon):false)){ 31 osLog("os","query()","calling mysql_query() <b><font color=red>ERROR</font><br />Query:</b><br />".$s);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);DatabaseMysql.cpp https://github.com/freghar/mangos-svn-backup.git | C++ | 390 lines
181 182 if(mysql_query(mMysql, sql)) 183 { 247 248 if(mysql_query(mMysql, sql)) 249 { 265{ 266 if (mysql_query(mMysql, sql)) 267 {image_upload.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 108 lines
24// if ($al && $user['id'] == $user_id || $rights >= 7) { 25 // $req_a = mysql_query("SELECT * FROM `cms_album_cat` where `website` = '$website' AND `id` = '$al' AND `user_id` = '" . $user['id'] . "'"); 26 // if (!mysql_num_rows($req_a)) { 71 // $description = mb_substr($description, 0, 500); 72 // mysql_query("INSERT INTO `cms_album_files` SET 73 // `album_id` = '$al',search.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 279 lines
18 19$result = @mysql_query($sql,$conn); 20home_product.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 202 lines
22 23 @$result = mysql_query("delete from ".$tableConfig." where id='".$id."'",$conn); 24 42 43 @$result = mysql_query("delete from ".$tableConfig." where id='".$id."'",$conn); 44 126 127$result=mysql_query($sql,$conn); 128quan_ly.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 168 lines
121 $b_tv="select count(*) from hoadon"; 122 $b_tv_1=mysql_query($b_tv); 123 $b_tv_2=mysql_fetch_row($b_tv_1); 126 $tv="select * from hoadon order by id desc limit $vtbd,$sd"; 127 $tv_1=mysql_query($tv); 128?>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);editproduct.php https://bitbucket.org/shikhaupadhyay/advt.git | PHP | 208 lines
19 20 mysql_query($updatequery); 21 25 $sqlptype="select * from product_type where ProductId='".$_REQUEST['id']."'"; 26 $resptype=mysql_query($sqlptype); 27 $numptype=mysql_num_rows($resptype); 31 $Query = "update product_type set ProductId = '".$_GET['id']."' , ProductsType = '".$ProductType."' , SpicyType = '".$SpicyType."' , AddDate = '".date('Y-m-d H:i:s')."' where Id='".$rowptype['Id']."'"; 32 mysql_query($Query); 33 } 35 $Query = "insert into product_type set ProductId = '".$_GET['id']."' , ProductsType = '".$ProductType."' , SpicyType = '".$SpicyType."' , AddDate = '".date('Y-m-d H:i:s')."'"; 36 mysql_query($Query); 37 } 42$selectquery="select * from products where id='".$_GET['id']."'"; 43$result=mysql_query($selectquery) or die(mysql_error()); 44$row=mysql_fetch_object($result);MenuProduct.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 237 lines
4 5 mysql_query("INSERT INTO ".menu_product." SET 6 category='".$_POST['category']."',stt='".$_POST['order']."',parent='".$_POST['parent']."',,stthome='".$_SESSION['stthome']."'"); 13 14 mysql_query("UPDATE ".menu_product." SET 15 category='".$_POST['category']."',stt='".$_POST['order']."',parent='".$_POST['parent']."',,stthome='".$_SESSION['stthome']."' WHERE id='".intval($_GET['Edit'])."'"); 29 30 mysql_query("DELETE FROM ".menu_product." WHERE id in (".implode(",",$_POST['element']).")"); 31 mysql_query("DELETE FROM ".menu_product." WHERE parent in (".implode(",",$_POST['element']).")"); 43 44 mysql_query("UPDATE ".menu_product." SET status='false' WHERE id in (".implode(",",$_POST['element']).")"); 45 57 58 mysql_query("UPDATE ".menu_product." SET status='true' WHERE id in (".implode(",",$_POST['element']).")"); 59content_category.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 148 lines
6 $r = getRecord("tbl_content_category","id=".$id); 7 $resultParent = mysql_query("select id from tbl_content_category where parent='".$id."'",$conn); 8 if (mysql_num_rows($resultParent) <= 0){ 8 if (mysql_num_rows($resultParent) <= 0){ 9 @$result = mysql_query("delete from tbl_content_category where id='".$id."'",$conn); 10 if ($result){ 27 $r = getRecord("tbl_content_category","id=".$id); 28 $resultParent = mysql_query("select id from tbl_content_category where parent='".$id."'",$conn); 29 if (mysql_num_rows($resultParent) <= 0){ 29 if (mysql_num_rows($resultParent) <= 0){ 30 @$result = mysql_query("delete from tbl_content_category where id='".$id."'",$conn); 31 if ($result){ 97$sql="select *,DATE_FORMAT(date_added,'%d/%m/%Y %h:%i') as dateAdd,DATE_FORMAT(last_modified,'%d/%m/%Y %h:%i') as dateModify from tbl_content_category where parent<>0 and $where $sortby $direction limit ".($p*$MAXPAGE).",".$MAXPAGE; 98$result=mysql_query($sql,$conn); 99$i=0;user.php https://github.com/carlosefonseca/ER-client-webapp.git | PHP | 215 lines
48 49 $result = mysql_query($q); 50 if(!$result || (mysql_num_rows($result) != 1)){b3kicks.php https://github.com/xlr8or/echelon.git | PHP | 251 lines
29$query_limit_rs_activebans = sprintf("%s LIMIT %d, %d", $query_rs_activebans, $startRow_rs_activebans, $maxRows_rs_activebans); 30$rs_activebans = mysql_query($query_limit_rs_activebans, $b3connect) or die(mysql_error()); 31$row_rs_activebans = mysql_fetch_assoc($rs_activebans); 34} else { 35 $all_rs_activebans = mysql_query($query_rs_activebans); 36 $totalRows_rs_activebans = mysql_num_rows($all_rs_activebans);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;tara_new.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 340 lines
77 78$queZ=mysql_query($selZ) or die(mysql_error()); 79 189 190$queL=mysql_query($selL) or die(mysql_error()); 191 313 314$queL=mysql_query($selL) or die(mysql_error()); 315envio.php https://gitlab.com/merintec/barvo | PHP | 55 lines
42 $insertar="INSERT into contacto (nomb_ape_cont,email_cont,come_cont,fech_cont,status,telefono) value ('".$nombre."','".$correo."','".$contenido."','".date('Y-m-d')."','pendiente','".$telefono."')"; 43 $insertar=mysql_query($insertar); 44 echo mysql_error();upgrade_course_110.lib.php https://github.com/TeamRocketScience/Claroline-TRS-Edition.git | PHP | 285 lines
244 245 $sql = mysql_query($req); 246 256 257 $sql = mysql_query($req); 258deposit_history.php https://github.com/webegg/Zencart-CMS.git | PHP | 206 lines
41 //$cb=mysqli_fetch_object(mysqli_query($link, "SELECT deposit FROM ".$usertable." WHERE ".$userid." = ".$useridentify."")); 42 $cb=mysql_fetch_object(mysql_query("SELECT deposit FROM users WHERE id = '$user_id'")); 43 44//select all the history of the user 45$sql = mysql_query("SELECT * FROM deposit_history WHERE user_id = '$user_id'"); 46?>comprobar.php https://gitlab.com/FerSo/tesis | PHP | 171 lines
35// comprobamos que los datos ingresados en el formulario coincidan con los de la BD 36$sql = mysql_query("SELECT * FROM usuarios WHERE usuario_nombre='" . $usuario_nombre . "' AND usuario_clave='" . $usuario_clave . "'"); 37if ($row = mysql_fetch_array($sql)) { 46$accion = "Inicio de sesión"; 47$bit = mysql_query("INSERT INTO bitacora (id_usuario, fecha, modulo, accion) VALUES ('" . $_SESSION['id_usuario'] . "', NOW(),'" . $modulo . "' , '" . $accion . "')"); 48 118 // comprobamos que los datos ingresados en el formulario coincidan con los de la BD 119 $sql = mysql_query("SELECT * FROM usuarios WHERE usuario_nombre='" . $usuario_nombre . "' AND usuario_clave='" . $usuario_clave . "'"); 120 if ($row = mysql_fetch_array($sql)) { 131 $accion = "Inicio de sesión"; 132 $bit = mysql_query("INSERT INTO bitacora (id_usuario, fecha, modulo, accion) VALUES ('" . $_SESSION['id_usuario'] . "', NOW(),'" . $modulo . "' , '" . $accion . "')"); 133registrar.php https://gitlab.com/FerSo/tesis | PHP | 129 lines
50 51 $sql = mysql_query("SELECT usuario_nombre FROM usuarios WHERE usuario_nombre='" . $usuario_nombre . "'"); 52 if (mysql_num_rows($sql) > 0) { 56 // ingresamos los datos a la BD 57 $reg = mysql_query("INSERT INTO usuarios (usuario_nombre, nombre, apellido, usuario_clave, usuario_email, fecha_reg) VALUES ('" . $usuario_nombre . "', '" . $nombre . "', '" . $apellido . "', '" . $usuario_clave . "', '" . $usuario_email . "', NOW())"); 58 58 59 $consult = mysql_query("SELECT id_usuario FROM usuarios WHERE usuario_nombre = '" . $usuario_nombre . "'"); 60 $cons = mysql_fetch_array($consult); 64 65 $bit = mysql_query("INSERT INTO bitacora (id_usuario, fecha, modulo, accion) VALUES ('" . $cons[0] . "', NOW(),'" . $modulo . "' , '" . $accion . "')"); 66 if ($bit) {view.php https://gitlab.com/jonz94/2016NCU_FreshWeb_HW | PHP | 240 lines
12 $query_RecUser = "SELECT `nickname`, `permission` FROM `user` WHERE `username`='".$username."'"; 13 $RecUser = mysql_query($query_RecUser); 14 $row_RecUser = mysql_fetch_assoc($RecUser); 31 $query_Login = "SELECT * FROM `user` WHERE `username`='".$_POST["username"]."'"; 32 $Login = mysql_query($query_Login); 33 //取出帳號密碼的值 81 $query_RecComment = "SELECT `comment`.*, `user`.`nickname`, `user`.`username`, `user`.`sex` FROM `comment`,`user` WHERE `comment`.`id`='".$id."' AND `comment`.`user_id`=`user`.`id`"; 82 $RecComment = mysql_query($query_RecComment); 83 if(!$row_RecComment=mysql_fetch_assoc($RecComment)){ ?>content_news_m.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 264 lines
77 } 78 if (mysql_query($sql,$conn)){ 79 if(empty($_POST['id'])) $oldid = mysql_insert_id(); 109 $sqlUpdate = "update ".$tableConfig." set $sqlUpdateField where id='".$oldid."'"; 110 mysql_query($sqlUpdate,$conn); 111 } 123 $sql = "select * from ".$tableConfig." where id='".$oldid."'"; 124 if ($result = mysql_query($sql,$conn)) { 125 $row=mysql_fetch_array($result);players.php https://bitbucket.org/verax/to-ladder.git | PHP | 236 lines
13 14$playerinfo=mysql_query("SELECT * FROM users WHERE id='$playerid'"); 15$myinfo=mysql_fetch_array($playerinfo); 20 21$playerinfo=mysql_query("SELECT *,DATE_FORMAT(joindate, '%M %d, %Y') FROM users WHERE id='$playerid'"); 22$myinfo=mysql_fetch_array($playerinfo); 132</tr>"; 133$teamson=mysql_query("SELECT teamid,status,DATE_FORMAT(joindate, '%M %d, %Y') FROM teammembers WHERE playerid='$playerid' ORDER by joindate"); 134while(list($team,$status,$joindate)=mysql_fetch_row($teamson)){ 134while(list($team,$status,$joindate)=mysql_fetch_row($teamson)){ 135 $teaminfo=mysql_query("SELECT teamname,type FROM teams WHERE id='$team'"); 136 $tinfo=mysql_fetch_array($teaminfo); 177//GET COMMENTS 178$getcomments=mysql_query("SELECT comment,addedby,DATE_FORMAT(added, '%M %d, %l:%i %p') FROM staffcomments WHERE id='$playerid' AND isateam='0' AND display='1' ORDER by added"); 179while(list($comment,$addedby,$added)=mysql_fetch_row($getcomments)){subscribe.php https://gitlab.com/oded/kamailio | PHP | 500 lines
168 dbg_msg("$query <BR>"); 169 $result = mysql_query($query) or html_die("Invalid SQL query"); 170 if(mysql_num_rows($result) == 0) 186 $query = "UPDATE jusers SET tyep=1 WHERE sip_id='$sipuri'"; 187 $result = mysql_query($query, $dblink); 188 if(mysql_affected_rows() != 1) 197 $query = "SELECT jab_id FROM jusers WHERE sip_id='$sipuri'"; 198 $result = mysql_query($query, $dblink) or html_die("Invalid SQL query"); 199 if(mysql_num_rows($result) == 0) 247 $query = "INSERT INTO jusers (jab_id, jab_passwd, sip_id) VALUES ('$sipname', '$new_passwd', '$sipuri')"; 248 $result = mysql_query($query, $dblink); 249 if(mysql_affected_rows() != 1) 260 $query = "UPDATE jusers SET type=0 WHERE sip_id='$sipuri'"; 261 $result = mysql_query($query, $dblink); 262 if(mysql_affected_rows() != 1)class.timetracker.php https://gitlab.com/vectorci/Collabtive | PHP | 438 lines
69 70 $ins = mysql_query("INSERT INTO timetracker (user,project,task,comment,started,ended,hours,pstatus) VALUES ($user,$project,$task,'$comment','$started','$ended','$hours',0)"); 71 111 112 $upd = mysql_query("UPDATE timetracker SET task='$task',comment='$comment',started='$started',ended='$ended',hours='$hours' WHERE ID = $id"); 113 132 133 $del = mysql_query("DELETE FROM timetracker WHERE ID = $id"); 134 148 $id = (int) $id; 149 $upd = mysql_query("UPDATE timetracker SET pstatus = $pstatus WHERE ID = $id"); 150 169 170 $sel = mysql_query("SELECT * FROM timetracker WHERE ID = $id"); 171 $track = array();install.php https://github.com/benbruscella/Grammafone.git | PHP | 377 lines
6 $query = "SELECT user_id FROM mp3act_users"; 7 $result = @mysql_query($query); 8 if(@mysql_num_rows($result) > 0){ 309foreach($querys as $key=>$query){ 310 if(mysql_query($query)){ 311 349 $query = "UPDATE mp3act_settings SET invite_mode=$_POST[invite],sample_mode=$_POST[sample_mode],downloads=$_POST[downloads],amazonid=\"$_POST[amazonid]\",mp3bin=\"$_POST[mp3bin]\",lamebin=\"$_POST[lamebin]\",phpbin=\"$_POST[phpbin]\" WHERE id=1"; 350 mysql_query($query); 351 echo "<strong>Settings Saved....</strong><br/><br/>"; 362 $query = "INSERT INTO `mp3act_users` VALUES (NULL, 'admin', 'Admin', 'User', PASSWORD(\"$random_password\"), 10, NOW(), 1, '', 'streaming', 0, 's', '21232f297a57a5a743894a0e4a801fc3', '', '0000-00-00 00:00:00', 1,'','','',0)"; 363 mysql_query($query); 364 echo "<br/><strong>Username:</strong> Admin<br/><strong>Password:</strong> $random_password (Please change this password as soon as you login.)<br/><br/>";editUserNewEmp.php https://gitlab.com/cesardemora/neaticketwebapphomeEs | PHP | 236 lines
15 16 mysql_query("SET NAMES 'utf8'"); 17 $consulta = "SELECT * FROM SECTORES ORDER BY id ASC"; 17 $consulta = "SELECT * FROM SECTORES ORDER BY id ASC"; 18 $resultado = mysql_query($consulta); 19 20 $consulta2 = "SELECT * FROM CODIGOSBARRAS ORDER BY id ASC"; 21 $resultado2 = mysql_query($consulta2); 22 // Create the querymysql_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{download_4_1.php https://gitlab.com/optimistic_mamun/project1 | PHP | 269 lines
8 $query = "SELECT * FROM ice_4_1 WHERE roll='$roll'"; 9 $result = mysql_query($query) or die(mysql_error()); 10 $count = mysql_num_rows($result); 35 $query1 = "SELECT * FROM reg_info WHERE roll='$roll'"; 36 $result1 = mysql_query($query1) or die(mysql_error()); 37 $count1 = mysql_num_rows($result1);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 }ntunnel_mysql.php https://gitlab.com/hoanghung.dev/phunuvadoisong.com | PHP | 440 lines
214 } 215 $res = mysql_query($query, $conn); 216 $errno = mysql_errno();install.php https://bitbucket.org/nanomites_webdev/heroframework.git | PHP | 285 lines
112 // this query is finished, execute it 113 if (@mysql_query($query, $dbh)) 114 { 126 // update settings 127 mysql_query('UPDATE `settings` SET `setting_value`=\'' . $this->input->post('site_name') . '\' WHERE `setting_name`=\'site_name\' or `setting_name`=\'email_name\''); 128 mysql_query('UPDATE `settings` SET `setting_value`=\'' . $this->input->post('site_email') . '\' WHERE `setting_name`=\'site_email\'');_liste_commandes_8inc_8php_source.html https://github.com/rcampistron/ParagrapheCMS.git | HTML | 64 lines
33<a name="l00061"></a>00061 34<a name="l00062"></a>00062 <span class="comment">/*if ($this->formation) $result=mysql_query("SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE if_bo_com.numcom=if_bo_detail.numcom AND if_bo_detail.designation='Inscription formation' $fin_req ORDER BY hcrea DESC");</span> 35<a name="l00063"></a>00063 <span class="comment"> else $result=mysql_query("SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE etat $this->etat $fin_req AND if_bo_com.numcom=if_bo_detail.numcom ORDER BY hcrea DESC");*/</span> 35<a name="l00063"></a>00063 <span class="comment"> else $result=mysql_query("SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE etat $this->etat $fin_req AND if_bo_com.numcom=if_bo_detail.numcom ORDER BY hcrea DESC");*/</span> 36<a name="l00064"></a>00064 <span class="keywordflow">if</span> ($this->formation) { $result=mysql_query(<span class="stringliteral">"SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE if_bo_com.numcom=if_bo_detail.numcom AND if_bo_detail.designation='Inscription formation' $fin_req ORDER BY hcrea DESC"</span>); 37<a name="l00065"></a>00065 } <span class="keywordflow">else</span> { 37<a name="l00065"></a>00065 } <span class="keywordflow">else</span> { 38<a name="l00066"></a>00066 <span class="comment">//$result=mysql_query("SELECT if_bo_com.numcom FROM if_bo_com,if_bo_detail WHERE etat $this->etat $fin_req AND if_bo_com.numcom=if_bo_detail.numcom ORDER BY hcrea DESC"); </span> 39<a name="l00067"></a>00067 $result=mysql_query(<span class="stringliteral">"SELECT if_bo_com.numcom FROM if_bo_com WHERE etat $this->etat $fin_req ORDER BY hcrea DESC"</span>);novoUsuario.php https://bitbucket.org/leopublic/dataweb.git | PHP | 242 lines
32 $sql = $sql." from USUARIO as a, PERFIL as b where a.NU_PERFIL = b.NU_PERFIL and a.NU_USUARIO = $id "; 33 $resultado = mysql_query($sql); 34 if(mysql_errno() != 0) {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()) {admin_edituser.php https://github.com/leviself/Feedmailer.git | PHP | 152 lines
12 13 $userid = @mysql_result(mysql_query( 14 "SELECT `id` FROM `{$mysql->prefix}users`conf.php https://gitlab.com/m.mirsamie/arad_hotel | PHP | 220 lines
104 if(!(mysql_select_db($db,$conn)==FALSE)){ 105 mysql_query("SET NAMES 'utf8'"); 106 $q = mysql_query($sql,$conn); 118 if(!(mysql_select_db($db,$conn)==FALSE)){ 119 mysql_query("SET NAMES 'utf8'"); 120 $qq = mysql_query($sql,$conn); 131 if(!(mysql_select_db($db,$conn)==FALSE)){ 132 mysql_query("SET NAMES 'utf8'"); 133 $qqq = mysql_query($sql,$conn);MysqlAdapter.php https://github.com/andho/simdal.git | PHP | 301 lines
80 81 mysql_query($sql, $this->_conn); 82 126 127 $query = mysql_query($sql, $this->_conn) or error_log(mysql_error($this->_conn), 0); 128 145 146 $query = mysql_query($sql, $this->_conn) or error_log(mysql_error($this->_conn), 0); 147 164 165 if (!($query = mysql_query($sql, $this->_conn))) { 166 error_log(mysql_error($this->_conn), 0); 251 252 $result = mysql_query($sql, $this->_conn); 253producers_pending.php https://gitlab.com/Henaway/CLFC | PHP | 199 lines
25 producer_id = "'.mysql_real_escape_string($producer_id).'"'; 26 $sql = mysql_query($query, $connection) or die("Couldn't execute query 4."); 27 $producer_info = mysql_fetch_object($sql); 36 producer_id="'.mysql_real_escape_string($producer_id).'"'; 37 $sql = mysql_query($query); 38 80 producer_id="'.mysql_real_escape_string($producer_id).'"'; 81 mysql_query($query); 82 87 producer_id="'.mysql_real_escape_string($producer_id).'"'; 88 mysql_query($query); 89 102 member_id="'.mysql_real_escape_string($producer_info->member_id).'"'; 103 mysql_query($query); 104 }api.php https://gitlab.com/swimly/api | PHP | 76 lines
28function getLists($conn,$table,$size,$sort,$field){ 29 mysql_query("SET NAMES 'UTF8'",$conn); 30 $page =isset($_GET['page'])?$_GET['page']:1; //获取查询页数,如果没有get到page,默认就是第一页! 33 $pageSize =$size; //每页多少条 34 $result_pag_num = mysql_query("SELECT COUNT(*) AS count FROM $table"); //获取数据表中总记录条数 35 $row = mysql_fetch_array($result_pag_num); 40 $query_pag_data = "SELECT $field from $table order by id $sort LIMIT $start, $pageSize"; 41 $result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error()); 42 $arrList = array(); //初始化列表数组 58 $info=array(); 59 mysql_query("set names 'utf8'"); 60 mysql_query("SET CHARACTER SET UTF8"); 60 mysql_query("SET CHARACTER SET UTF8"); 61 mysql_query("SET CHARACTER_SET_RESULTS=UTF8'"); 62 $result=@mysql_query($sql) or die();moreinfo.php https://github.com/damanlovett/SEAHO.git | PHP | 145 lines
38$query_rsConference = sprintf("SELECT * FROM conference WHERE conference.deleted = 0 AND conference.conference_id = %s", GetSQLValueString($colname_rsConference, "text")); 39$rsConference = mysql_query($query_rsConference, $CMS) or die(mysql_error()); 40$row_rsConference = mysql_fetch_assoc($rsConference); 48$query_rsItems = sprintf("SELECT * FROM delegate_invoice WHERE delegate_invoice.conference_id=%s AND delegate_invoice.deleted = 0 AND delegate_invoice.type != 'registration' ORDER BY delegate_invoice.label", GetSQLValueString($colname_rsItems, "text")); 49$rsItems = mysql_query($query_rsItems, $CMS) or die(mysql_error()); 50$row_rsItems = mysql_fetch_assoc($rsItems); 58$query_rsFees = sprintf("SELECT * FROM delegate_invoice WHERE delegate_invoice.conference_id=%s AND delegate_invoice.deleted = 0 AND delegate_invoice.type = 'registration' ORDER BY delegate_invoice.amount", GetSQLValueString($colname_rsFees, "text")); 59$rsFees = mysql_query($query_rsFees, $CMS) or die(mysql_error()); 60$row_rsFees = mysql_fetch_assoc($rsFees);cometchat_receive.php https://github.com/chacha13/runningmate.git | PHP | 274 lines
70 $sql = ("select id from cometchat order by id desc limit 1"); 71 $query = mysql_query($sql); 72 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); } 102 $sql = updateLastActivity($userid); 103 $query = mysql_query($sql); 104 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); } 119 $sql = getUserStatus($userid); 120 $query = mysql_query($sql); 121 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); } 157 $sql = ("select id from cometchat order by id desc limit 1"); 158 $query = mysql_query($sql); 159 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); } 181 182 $query = mysql_query($sql); 183 if (defined('DEV_MODE') && DEV_MODE == '1') { echo mysql_error(); }GuestBook.php https://bitbucket.org/onlinechessportal/onlinechessgameportal | PHP | 215 lines
76 $insert = "INSERT INTO guestBook VALUES ('','$time','$gb_name','$gb_email','$gb_message')"; 77 if (mysql_query($insert)) { 78 $entries = mysql_query("SELECT `gb_timestamp`,gb_name,gb_email,gb_message FROM guestbook ORDER BY `gb_timestamp` DESC ");google_map_functions.php https://github.com/wesleyzhao/wheremyfriendsbe.git | PHP | 307 lines
28 $formattedAddress = mysql_escape_string($formattedAddress); 29 //$res = mysql_query("SELECT `lat`,`lng` FROM `geocodes` WHERE `location`='$formattedAddress'"); 30 $res = mysql_query_cache("SELECT `lat`,`lng` FROM `geocodes` WHERE `location`='$formattedAddress'"); 55 $location = $jsondata['results'][0]['geometry']['location']; 56 mysql_query("INSERT INTO geocodes (location,lat,lng) VALUES('$formattedAddress','{$location['lat']}','{$location['lng']}')"); 57 return $location; 225 $oauth_id = intval($oauth_id); 226 //$res = mysql_query("SELECT name FROM users WHERE oauth_id = '$oauth_id'"); 227 $res = mysql_query_cache("SELECT name FROM users WHERE oauth_id = '$oauth_id'"); 232 $location = mysql_escape_string($location); 233 mysql_query("INSERT INTO users (name,oauth_id,lat,lng,access_token,location) VALUES('$name','$oauth_id','$lat','$lng','$token','$location')"); 234 return true; 239 $location = mysql_escape_string($location); 240 mysql_query("UPDATE users SET lat = '$lat', lng='$lng',location='$location' WHERE oauth_id='$oauth_id'"); 241 return true;index.php https://gitlab.com/zanzilan/bgpanel.git | PHP | 427 lines
47$unixLastMin = time() - 1 * 60; 48$onlineClients = mysql_query( "SELECT `clientid`, `username` FROM `".DBPREFIX."client` WHERE `lastactivity` >= '".$unixLastMin."'" ); //We select all clients active in the last minute (based on unix timestamp) 49$onlineAdmins = mysql_query( "SELECT `adminid`, `username` FROM `".DBPREFIX."admin` WHERE `lastactivity` >= '".$unixLastMin."'" ); //Same 4 admins 53//Servers : 54$servers = mysql_query( "SELECT * FROM `".DBPREFIX."server` WHERE `status` = 'Active' && `panelstatus` = 'Started' ORDER BY `name`" ); 55 57//Boxes : 58$boxes = mysql_query( "SELECT `boxid`, `name`, `cache` FROM `".DBPREFIX."box` ORDER BY `name`" ); 59$cron = query_fetch_assoc( "SELECT `value` FROM `".DBPREFIX."config` WHERE `setting` = 'lastcronrun' LIMIT 1" ); 62//Last 15 Actions : 63$logs = mysql_query( "SELECT * FROM `".DBPREFIX."log` ORDER BY `logid` DESC LIMIT 15" ); 64projusers.php https://gitlab.com/JoshJ/AGORA | PHP | 231 lines
46 $query = "SELECT LAST_INSERT_ID()"; 47 $resultID = mysql_query($query, $linkID); 48 $row = mysql_fetch_assoc($resultID); 81 $query = "INSERT INTO projusers (proj_id, user_id, user_level) VALUES ($projID, $otheruserID, $level)"; 82 $success = mysql_query($query, $linkID); 83 if($success){ 124 } 125 mysql_query("START TRANSACTION"); 126 $query = "DELETE FROM projusers WHERE proj_id=$projID AND user_id=$otheruserID"; 127 128 $success = mysql_query($query, $linkID); 129 if($success){ 133 ($otheruserID, 'Automatically created project', NULL, 1)"; 134 $status = mysql_query($query, $linkID); 135 $newID = getLastInsert($linkID);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'"); 275pn4.php https://gitlab.com/bulwye/reliquerunt | PHP | 243 lines
25// Poll Check table creation 26$result = mysql_query("CREATE TABLE poll_check ( 27ip VARCHAR (20) NOT NULL, 30 31$result = mysql_query("CREATE TABLE blocks ( 32bid INT (10) DEFAULT '0' not null AUTO_INCREMENT, 44// Main Block data migration 45$result = mysql_query("SELECT title, content FROM mainblock"); 46list($title, $content) = mysql_fetch_row($result); 46list($title, $content) = mysql_fetch_row($result); 47$result = mysql_query("INSERT INTO blocks VALUES (NULL, 'main', '$title', '$content', '', 'l', '1', '1', '', '')"); 48// Block data creation 48// Block data creation 49$result = mysql_query("INSERT INTO blocks VALUES (NULL, 'online', 'Who\'s Online', '', '', 'l', '2', '1', '', '')"); 50// Admin Block data migrationclass.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);listCMS_ONLINE_RESOURCES.php https://github.com/juddy/GIP.git | PHP | 211 lines
39$sql = "SELECT * FROM CMS_ONLINE_RESOURCES".$orderByQuery.$limitQuery; 40$result = MYSQL_QUERY($sql); 41$numberOfRows = MYSQL_NUM_ROWS($result);listGridCMS_GROUPUSERS.php https://github.com/juddy/GIP.git | PHP | 225 lines
15 $sqlUpdate = "UPDATE CMS_GROUPUSERS SET GROUP_ID = '$thisGROUP_ID' , USER_ID = '$thisUSER_ID' , GROUPUSER_FLAGS = '$thisGROUPUSER_FLAGS' WHERE GROUP_ID = '$thisGROUP_ID'"; 16 $resultUpdate = MYSQL_QUERY($sqlUpdate); 17 echo "<b>Record with Id ".$thisGROUP_IDFromForm." has been Updated<br></b>"; 28 $sqlInsert = "INSERT INTO CMS_GROUPUSERS (GROUP_ID , USER_ID , GROUPUSER_FLAGS ) VALUES ('$thisGROUP_ID' , '$thisUSER_ID' , '$thisGROUPUSER_FLAGS' )"; 29 $resultInsert = MYSQL_QUERY($sqlInsert); 30 echo "<b>Record has been inserted in Database<br></b>"; 41 $sqlDelete = "DELETE FROM CMS_GROUPUSERS WHERE GROUP_ID = '$thisGROUP_ID'"; 42 $resultDelete = MYSQL_QUERY($sqlDelete); 43 81$sql = "SELECT * FROM CMS_GROUPUSERS".$orderByQuery.$limitQuery; 82$result = MYSQL_QUERY($sql); 83$numberOfRows = MYSQL_NUM_ROWS($result);listCMS_OFFLINE_RESOURCES.php https://github.com/juddy/GIP.git | PHP | 211 lines
39$sql = "SELECT * FROM CMS_OFFLINE_RESOURCES".$orderByQuery.$limitQuery; 40$result = MYSQL_QUERY($sql); 41$numberOfRows = MYSQL_NUM_ROWS($result);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)) {ppc_accounts.php https://github.com/lsd/prosper202.git | PHP | 289 lines
25 `ppc_network_time`='".$mysql['ppc_network_time']."'"; 26 $ppc_network_result = _mysql_query($ppc_network_sql) ; //($ppc_network_sql); 27 $add_success = true; 44 $ppc_network_sql = "SELECT COUNT(*) FROM `202_ppc_networks` WHERE `user_id`='".$mysql['user_id']."' AND `ppc_network_id`='".$mysql['ppc_network_id']."'"; 45 $ppc_network_result = _mysql_query($ppc_network_sql) ; //($ppc_network_sql); 46 if (mysql_result($ppc_network_result,0,0) == 0 ) { 56 $ppc_account_sql = "SELECT COUNT(*) FROM `202_ppc_accounts` WHERE `user_id`='".$mysql['user_id']."' AND `ppc_account_id`='".$mysql['ppc_account_id']."'"; 57 $ppc_account_result = _mysql_query($ppc_account_sql) ; //($ppc_account_sql); 58 if (mysql_result($ppc_account_result,0,0) == 0 ) { 78 if ($editing == true) { $ppc_account_sql .= "WHERE ppc_account_id='".$mysql['ppc_account_id']."'"; } 79 $ppc_account_result = _mysql_query($ppc_account_sql) ; //($ppc_account_sql); 80 $add_success = true; 101 AND `ppc_network_id`='".$mysql['ppc_network_id']."'"; 102 if ($delete_result = _mysql_query($delete_sql)) { //($delete_result)) { 103 $delete_success = true;producer_orders_byproduct.php https://gitlab.com/Henaway/CLFC | PHP | 332 lines
53 business_name ASC'; 54$resultp = @mysql_query($sqlp, $connection) or die(mysql_error() . "<br><b>Error No: </b>" . mysql_errno()); 55while ( $row = mysql_fetch_array($resultp) ) 96 97$rs = @mysql_query($sql, $connection) or die(mysql_error() . "<br><b>Error No: </b>" . mysql_errno()); 98while ( $row = mysql_fetch_array($rs) ) 137 '.TABLE_BASKET.'.item_date'; 138 $resultpr = @mysql_query($sql, $connection) or die(mysql_error() . "<br><b>Error No: </b>" . mysql_errno()); 139 while ( $row = mysql_fetch_array($resultpr) )orders_list.php https://gitlab.com/Henaway/CLFC | PHP | 211 lines
20 AND member_id = "'.mysql_real_escape_string ($member_id).'"'; 21 $resultf = @mysql_query($sqlf, $connection) or die(mysql_error()); 22 } 48 '.TABLE_BASKET_ALL.'.basket_id DESC'; 49$rs = @mysql_query($sql, $connection) or die(mysql_error()); 50$num_orders = mysql_numrows($rs); 126 '.TABLE_BASKET_ALL.'.basket_id DESC'; 127$rsf = @mysql_query($sqlfd, $connection) or die(mysql_error()); 128while ( $row = mysql_fetch_array($rsf) )installer_lib.php https://gitlab.com/rameshgurung/emi | PHP | 301 lines
165 { 166 mysql_query('CREATE DATABASE IF NOT EXISTS '.$database, $this->db); 167 } 185 186 mysql_query(sprintf( 187 "INSERT INTO core_sites (name, ref, domain, created_on) VALUES ('Default Site', '%s', '%s', '%s');", 229 230 @mysql_query($query, $this->db); 231func.get_product.php https://gitlab.com/Henaway/CLFC | PHP | 159 lines
68 AND '.NEW_TABLE_PRODUCTS.'.pvid != "0")'; 69 $result = mysql_query($query, $connection) or die(debug_print ("ERROR: 754004 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 70 if ($row = mysql_fetch_array($result)) 93 '.NEW_TABLE_PRODUCTS; 94 $result = mysql_query($query, $connection) or die (debug_print ("ERROR: 856249 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 95 if ($row = mysql_fetch_array($result)) 107 producer_id = "'.mysql_real_escape_string($producer_id).'"'; 108 $result = mysql_query($query, $connection) or die (debug_print ("ERROR: 460569 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 109 $pvid = mysql_insert_id(); 120 product_id = "'.mysql_real_escape_string($product_id).'"'; 121 $result = mysql_query($query, $connection) or die (debug_print ("ERROR: 311047 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 122 if ($row = mysql_fetch_array($result)) 138 pvid = "'.mysql_real_escape_string($pvid).'"'; 139 $result = mysql_query($query, $connection) or die (debug_print ("ERROR: 939523 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); 140 // And sync our external product_id variabledb_printview.php https://gitlab.com/a.loskutnikov/sitimobile | PHP | 264 lines
29 $local_query = 'SHOW OPEN TABLES FROM ' . PMA_backquote($db); 30 $result = mysql_query($query) or PMA_mysqlDie('', $local_query, '', $err_url); 31 // Blending out tables in use 42 $local_query = 'SHOW TABLES FROM ' . PMA_backquote($db); 43 $result = mysql_query($query) or PMA_mysqlDie('', $local_query, '', $err_url); 44 if ($result != FALSE && mysql_num_rows($result) > 0) { 47 $local_query = 'SHOW TABLE STATUS FROM ' . PMA_backquote($db) . ' LIKE \'' . addslashes($tmp[0]) . '\''; 48 $sts_result = mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url); 49 $sts_tmp = mysql_fetch_array($sts_result); 62 $local_query = 'SHOW TABLE STATUS FROM ' . PMA_backquote($db); 63 $result = mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url); 64 if ($result != FALSE && mysql_num_rows($result) > 0) {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);payment_info.php https://github.com/azeckoski/az-php-sandbox.git | PHP | 394 lines
39 $sql = "update conferences set activated='Y' where id='".$_REQUEST['activate']."'"; 40 $result = mysql_query($sql) or die("Update query failed ($sql): " . mysql_error()); 41 } else if ($_REQUEST['deactivate']) { 42 $sql = "update conferences set activated='N' where id='".$_REQUEST['deactivate']."'"; 43 $result = mysql_query($sql) or die("Update query failed ($sql): " . mysql_error()); 44 } 79$count_sql = "select count(*) " . $from_sql . $sqlsearch; 80$result = mysql_query($count_sql) or die('Count query failed: ' . mysql_error()); 81$row = mysql_fetch_array($result); 126//print "SQL=$sql<br/>"; 127$result = mysql_query($sql) or die("Fetch query failed ($sql): " . mysql_error()); 128$items_displayed = mysql_num_rows($result); 243 $count_sql = "SELECT count(*) FROM conferences where activated = 'Y' and confId = '$CONF_ID'"; 244 $count_result = mysql_query($count_sql) or die("Count failed ($count_sql): " . mysql_error()); 245 $row = mysql_fetch_array($count_result);reporte_genera_reporte.php https://bitbucket.org/redesvas/rceldas.git | PHP | 357 lines
53 $sql="SELECT * FROM ".$_db.".PROCESOS_STATUS WHERE PROCESO='GENERA_REPORTE' "; 54 $res = mysql_query($sql, $_link); 55 67 $sql="SELECT * FROM ".$_db.".PROCESOS_STATUS_DETALLE WHERE ID_PROCESO = 6 "; 68 $result = mysql_query($sql, $_link); 69 79 $sql_st="UPDATE ".$_db.".PROCESOS_STATUS SET STATUS = 'RUNNING' , OBS='' WHERE PROCESO='GENERA_REPORTE' "; 80 mysql_query($sql_st, $_link); 81 } 85 $sql_st="UPDATE ".$_db.".PROCESOS_STATUS SET STATUS = 'RUNNING' , OBS='' WHERE PROCESO='GENERA_REPORTE' "; 86 mysql_query($sql_st, $_link); 87 } 91 $sql_st="UPDATE ".$_db.".PROCESOS_STATUS SET STATUS = 'RUNNING' , OBS='' WHERE PROCESO='GENERA_REPORTE' "; 92 mysql_query($sql_st, $_link); 93 }listobservations.php https://github.com/pavanesh2009/seasonwatch.git | PHP | 301 lines
18//echo "sql1"; 19mysql_query($sql1,$link)or die("Insertion Failed:" .mysql_error()); 20echo "<div class=\"notice\">Successfully Deleted</div>"; 103 104$sql=mysql_query("SELECT DISTINCT(species_primary_common_name), Species_master.species_id FROM Species_master JOIN (trees, user_tree_table) ON trees.tree_id = user_tree_table.tree_id AND trees.species_id = Species_master.species_id AND user_tree_table.user_id = '$_SESSION[user_id]'"); 105 177 178//$user_tree_table_settings = mysql_query("SELECT tree_nickname, tree_id FROM user_tree_table WHERE user_id='".$_SESSION[user_id]."'"); 179if($speciesid=="") 180{ 181$user_tree_table_settings = mysql_query("SELECT user_tree_table.user_tree_id,tree_nickname, 182user_tree_observations.observation_id, 196{ 197 $user_tree_table_settings = mysql_query("SELECT user_tree_table.user_tree_id,tree_nickname, 198 user_tree_observations.observation_id,user_tree_observations.date,query_notes.php https://gitlab.com/Henaway/CLFC | PHP | 269 lines
26 last_name ASC'; 27$resultm = @mysql_query($sqlm, $connection) or die("Couldn't execute query -m."); 28while ( $row = mysql_fetch_array($resultm) ) 68 business_name ASC'; 69 $result = @mysql_query($sql, $connection) or die("Couldn't execute query 1."); 70 while ( $row = mysql_fetch_array($result) ) 204 AND '.TABLE_FUTURE_DELIVERY.'.future_delivery_id = '.TABLE_BASKET.'.future_delivery_id'; 205 $rs = @mysql_query($sqlfd, $connection) or die("Couldn't execute query."); 206 while ( $row = mysql_fetch_array($rs) )nt.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 204 lines
37 $thid = abs(intval(preg_replace('/(.*?)id=/si', '', $m[3]))); 38 $req = mysql_query("SELECT `text` FROM `soo_forum` where `website` = '$website' AND `id`= '$thid' AND `type` = 't' AND `close` != '1'"); 39 if (mysql_num_rows($req) > 0) { 68} 69$req_r = mysql_query("SELECT * FROM `soo_forum` where `website` = '$website' AND `id` = '$id' AND `type` = 'r' LIMIT 1"); 70if (!mysql_num_rows($req_r)) { 95 // Прверяем, есть ли уже такая тема в текущем разделе? 96 if (mysql_result(mysql_query("SELECT COUNT(*) FROM `soo_forum` where `website` = '$website' AND `type` = 't' AND `refid` = '$id' AND `text` = '$th'"), 0) > 0) 97 $error[] = $lng_forum['error_topic_exists']; 98 // Проверяем, не повторяется ли сообщение? 99 $req = mysql_query("SELECT * FROM `soo_forum` where `website` = '$website' AND `user_id` = '$user_id' AND `type` = 'm' ORDER BY `time` DESC"); 100 if (mysql_num_rows($req) > 0) { 107 // Добавляем тему 108 mysql_query("INSERT INTO `soo_forum` SET 109 `refid` = '$id',MySQL.class.php https://gitlab.com/Elron_MacBong/ecms | PHP | 229 lines
102 103 // Execute query. (mysql_query) 104 # @param string $sql 110 $this->query_counter++; 111 $this->result = @mysql_query($this->sql_query, $this->connection); 112main.php https://github.com/AtvirasAlus/Atviras-Alus.git | PHP | 408 lines
57 $db = mysql_select_db($conf['auth']['mysql']['database']); 58 $result = mysql_query("SET NAMES UTF8"); 59 $sql = "SELECT * FROM beer_patarles ORDER BY RAND() LIMIT 1"; 59 $sql = "SELECT * FROM beer_patarles ORDER BY RAND() LIMIT 1"; 60 $result = mysql_query($sql) or die(mysql_error()); 61 $row = mysql_fetch_assoc($result); 69 $sql = "SELECT * FROM users WHERE user_email = '".$umail."'"; 70 $result = mysql_query($sql) or die(mysql_error()); 71 $uid = mysql_fetch_assoc($result); 73 $sql = "SELECT * FROM mail_users WHERE user_id='".$uid."' AND mail_read='0'"; 74 $result = mysql_query($sql) or die(mysql_error()); 75 $msgs = mysql_num_rows($result);wizard.2.php https://github.com/zsalwen/Service-Interface.git | PHP | 143 lines
38 $qs="SELECT * FROM ps_users WHERE id='".$_COOKIE[psdata][user_id]."'"; 39 $rs=@mysql_query($qs) or die(mysql_error()); 40 $ds=mysql_fetch_array($rs,MYSQL_ASSOC); 115 if ($defendant == "ALL"){ 116 $history_items = @mysql_query("select * from ps_history where packet_id='$packet'") or die(mysql_error()); 117 }else{ 117 }else{ 118 $history_items = @mysql_query("select * from ps_history where packet_id='$packet' and defendant_id='$defendant'") or die(mysql_error()); 119 } 121 if ($defendant == "ALL"){ 122 $history_items = @mysql_query("select * from ps_history where packet_id='$packet' and serverID='".$_COOKIE[psdata][user_id]."'") or die(mysql_error()); 123 }else{ 123 }else{ 124 $history_items = @mysql_query("select * from ps_history where packet_id='$packet' and defendant_id='$defendant' and serverID='".$_COOKIE[psdata][user_id]."'") or die(mysql_error()); 125 }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;cronplus.php https://github.com/b123400/Auto-readdaily.git | PHP | 309 lines
100 101$result=mysql_query("SELECT * FROM ".$db_table_name); 102$i=0; 294 or die("Could not select examples"); 295 $result=mysql_query("SELECT * FROM ".$db_table_name." WHERE activated=1"); 296 while($row = mysql_fetch_array($result)){SupportOnline.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 233 lines
10 11 mysql_query("INSERT INTO ".support." SET 12 nick='".text($_POST['nick'])."' 25 26 mysql_query("UPDATE ".support." SET 27 nick='".text($_POST['nick'])."' 47 48 mysql_query("DELETE FROM ".support." WHERE id in (".implode(",",$_POST['element']).")"); 49 62 63 mysql_query("UPDATE ".support." SET status='false' WHERE id in (".implode(",",$_POST['element']).")"); 64 77 78 mysql_query("UPDATE ".support." SET status='true' WHERE id in (".implode(",",$_POST['element']).")"); 79resource_m3_modi.php https://gitlab.com/cigiko/brdnc.cafe24.com | PHP | 166 lines
57 $query="SELECT no, user_id, name, email, mobile, pj_seq, pj_where, pj_posi, pj_name FROM cms_member_table, cms_project1_info WHERE no='$edit_code' "; 58 $result=mysql_query($query, $connect); 59 $row=mysql_fetch_array($result); 84 $h_qry = "SELECT seq, pj_name FROM cms_project1_info WHERE is_end<>'1' ORDER BY seq "; 85 $h_rlt = mysql_query($h_qry, $connect); 86 while($h_rows = mysql_fetch_array($h_rlt)){ 99 $h_qry = "SELECT seq, headq FROM cms_resource_headq WHERE pj_seq='$pj' ORDER BY headq "; 100 $h_rlt = mysql_query($h_qry, $connect); 101 while($h_rows = mysql_fetch_array($h_rlt)){ 121 $t_qry = "SELECT seq, team FROM cms_resource_team WHERE pj_seq='$pj' AND headq_seq='$headq' ORDER BY team "; 122 $t_rlt = mysql_query($t_qry, $connect); 123 while($t_rows = mysql_fetch_array($t_rlt)){staffpanel.php https://github.com/cybernet/CyBerFuN-CoDeX.git | PHP | 347 lines
72 73 $res = mysql_query('SELECT av_class'.(!$sure || $staff_classes[$CURUSER['class']]['log'] ? ', page_name' : '').' FROM staffpanel WHERE id = '.sqlesc($id)) or sqlerr(__FILE__, __LINE__); 74 $arr = mysql_fetch_assoc($res); 81 82 mysql_query('DELETE FROM staffpanel WHERE id = '.sqlesc($id)) or sqlerr(__FILE__, __LINE__); 83 100 { 101 $res = mysql_query('SELECT '.implode(', ', $names).' FROM staffpanel WHERE id = '.sqlesc($id)) or sqlerr(__FILE__, __LINE__); 102 $arr = mysql_fetch_assoc($res); 148 { 149 $res = mysql_query("INSERT INTO staffpanel (page_name, file_name, description, av_class, added_by, added) ". 150 "VALUES (".implode(", ", array_map("sqlesc", array($page_name, $file_name, $description, (int)$av_class, (int)$CURUSER['id'], gmtime()))).")"); 161 { 162 $res = mysql_query("UPDATE staffpanel SET page_name = ".sqlesc($page_name).", file_name = ".sqlesc($file_name).", description = ".sqlesc($description).", av_class = ".sqlesc((int)$av_class)." WHERE id = ".sqlesc($id)) or sqlerr(__FILE__, __LINE__); 163room_edit.php https://bitbucket.org/deba666/accitsoftware.git | PHP | 144 lines
3 { 4 if(mysql_query("UPDATE `room` SET `ROOM_CODE`='".$_POST['room_code']."', `ROOM_DESC`='".$_POST['room_name']."', `ROOM_CAPACITY`='".$_POST['capacity']."', `LOCATION_NO`='".$_POST['location']."', `STATUS`='".$_POST['is_active']."' WHERE `ROOM_NO`=".$_GET['rid'])) 5 $_SESSION['s_msg']="<strong>Well done!</strong> room successfully updated";hourlySales.php https://github.com/maxolasersquad/FLOSS-POS.git | PHP | 116 lines
72 73$result1 = mysql_query($query1); 74$result2 = mysql_query($query2); 74$result2 = mysql_query($query2); 75$result3 = mysql_query($transCountQ); 76$num1 = mysql_num_rows($result1);album.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 131 lines
69 // Проверяем, имеет ли юзер право голоса 70 $req = mysql_query("SELECT * FROM `cms_album_votes` where `website` = '$website' AND `user_id` = '$user_id' AND `file_id` = '" . $arg['id'] . "' LIMIT 1"); 71 if (!mysql_num_rows($req)) 108 require('../incfiles/head.php'); 109 $albumcount = mysql_result(mysql_query("SELECT COUNT(DISTINCT `user_id`) FROM `cms_album_files`where `website` = '$website'"), 0); 110 $newcount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` where `website` = '$website' AND `time` > '" . (time() - 259200) . "' AND `access` > '1'"), 0);shoppingCart.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 196 lines
14 15 mysql_query("DELETE FROM ".shoppingCart." WHERE id in (".implode(",",$_POST['element']).")"); 16 26 $sqlstr = 'SELECT * FROM '.shoppingCart.' WHERE id='.intval($view).''; 27 $resultstr =mysql_query($sqlstr); 28 $rowstr = mysql_fetch_array($resultstr); 48 $sql = 'SELECT * FROM '.product.' WHERE id = '.intval($id); 49 $result =mysql_query($sql); 50 89 90 $sqlstr=mysql_query("SELECT * FROM ".shoppingCart." WHERE id=".intval($view)."" ); 91 mysql_query("UPDATE ".shoppingCart." SET status='true' WHERE id=".intval($view)."" ); 154 155 $page=mysql_query($sqlstr); 156 $n_record=mysql_num_rows($page);rezervare_sejur_succes.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 269 lines
47$sel_bnr="SELECT * FROM curs_valutar "; 48$que_bnr=mysql_query($sel_bnr) or die(mysql_error()); 49$row_bnr=mysql_fetch_array($que_bnr);base3.php https://github.com/crocus/virpl.git | PHP | 224 lines
165$num=0; 166$Recordset3 = @mysql_query($GenerQuery , $realtorplus) or die(mysql_error()); 167$row_Recordset3 = mysql_fetch_assoc($Recordset3);MySQLStorage.php https://bitbucket.org/maconeto/proman.git | PHP | 354 lines
144 { 145 if (!mysql_query( 146 "CREATE DATABASE IF NOT EXISTS `{$this->dbName}`", 154 155 $create = mysql_query( 156 "CREATE TABLE IF NOT EXISTS `{$this->dbName}`.`{$this->dbTable}` ( 251 $this->connect(); 252 $result = mysql_query( 253 "SELECT * FROM `{$this->dbName}`.`{$this->dbTable}`", 285 //Remove the pclass if it exists. 286 mysql_query( 287 "DELETE FROM `{$this->dbName}`.`{$this->dbTable}` 292 //Insert it again. 293 $result = mysql_query( 294 "INSERT INTO `{$this->dbName}`.`{$this->dbTable}`stock1.php https://gitlab.com/cigiko/brdnc.cafe24.com | PHP | 246 lines
40 AS cms_stock_main $add_where "; 41 $aaa=mysql_query($total_qty, $connect); 42 $bbb=mysql_fetch_array($aaa); 47 FROM cms_stock_main) AS cms_stock_main_ $add_where "; 48 $ccc=mysql_query($total_p_in, $connect); 49 $ddd=mysql_fetch_array($ccc); 54 FROM cms_stock_main) AS cms_stock_main $add_where "; 55 $eee=mysql_query($total_p_set, $connect); 56 $fff=mysql_fetch_array($eee); 78 $qry="select * from cms_stock_1st_classify"; 79 $rlt=mysql_query($qry, $connect); 80 for($i=0; $rs=mysql_fetch_array($rlt); $i++){ 88 $qry1="select * from cms_stock_2nd_classify where 1st_classify='$classify1' "; 89 $rlt1=mysql_query($qry1, $connect); 90 for($i=0; $rs1=mysql_fetch_array($rlt1); $i++){index.php https://bitbucket.org/3tierlogic/3tl.tabbuilder.git | PHP | 268 lines
74 $sql = "SELECT cp_companyID, cp_companyName FROM sp_company_info where cp_status='1' order by cp_companyName"; 75 $res = mysql_query($sql, $con); 76?>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);profile.php https://github.com/hovvit/Newsletter.git | PHP | 446 lines
70 WHERE userID='$userID'"; 71 $result_saveData = mysql_query($query_saveData, $cxn) 72 or die ("Couldn't execute query 1"); 89 $query_getID = "SELECT userID FROM userdata WHERE emailAddress='$currentUser'"; 90 $result_getID = mysql_query($query_getID, $cxn) 91 or die ("Couldn't execute query 1"); 96 $qInsert = "INSERT INTO userdata SET emailAddress='$currentUser'"; 97 $qResult= mysql_query($qInsert, $cxn) 98 or die ("Couldn't execute query 3"); 102 $query_getID = "SELECT userID FROM userdata WHERE emailAddress='$currentUser'"; 103 $result_getID = mysql_query($query_getID, $cxn) 104 or die ("Couldn't execute query 1"); 178 $query_getData = "SELECT * FROM userdata WHERE userID=$userID"; 179 $result_getData = mysql_query($query_getData, $cxn) 180 or die ("Couldn't execute query 1");installtables.php https://github.com/holsinger/openfloor.git | PHP | 357 lines
10$sql = 'DROP TABLE IF EXISTS `' . table_blogs . '`;'; 11mysql_query( $sql, $conn ); 12 24echo 'Creating table: \'blogs\'...<br />'; 25mysql_query( $sql, $conn ); 26 28$sql = 'DROP TABLE IF EXISTS `' . table_categories . '`;'; 29mysql_query( $sql, $conn ); 30 46echo 'Creating table: \'categories\'...<br />'; 47mysql_query( $sql, $conn ); 48 50$sql = 'DROP TABLE IF EXISTS `' . table_comments . '`;'; 51mysql_query( $sql, $conn ); 52master.php https://gitlab.com/suman0359/physiohealthrs.com.git | PHP | 175 lines
24 <?php 25 $sql = mysql_query("SELECT * FROM tbl_news_blog WHERE blog_publication_status=1 "); 26 while ($search = mysql_fetch_array($sql)) { ?> 118 119 $sql = mysql_query("SELECT * FROM tbl_menu where menu_dropdown='$menu' and menu_status=1 order by menu_serial asc"); 120 while ($dropdown = mysql_fetch_array($sql)) {enroll_credit_bank_charge.php https://bitbucket.org/deba666/accitsoftware.git | PHP | 250 lines
23{ 24 mysql_query("update `due_history` set `DELETE_DATE`='".date('Y-m-d')."' where `IND_NO`='".$_POST['IND_NO'][$i]."'");//update due history table after make psayment 25} 25} 26 mysql_query("update `due` set `AMOUNT`='".$due_amount."' where `IND_NO`='".$_POST['IND_NO'][$i]."'"); 27 $_SESSION['s_msg']="<strong>Fine!</strong>Payment Credited Successfully"; 113 $i++; 114 $add1a=mysql_query("SELECT * from due where `IND_NO`=".$std_row23['IND_NO']); 115 while($row2a = mysql_fetch_array($add1a))bp.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 207 lines
8 $query ='select * from '.$tblname.'_cat where id='.$_REQUEST['catID'].''; 9 $doquery=mysql_query($query,$link); 10 if ($doquery and mysql_num_rows($doquery)>0) 29 //echo $query1; 30 $doquery1=mysql_query($query1,$link); 31 if ($doquery1 and mysql_num_rows($doquery1)>0) 76 //echo $query2; 77 $doquery2=mysql_query($query2,$link); 78add.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))posts_controller.php https://github.com/jcalado/planetuga.git | PHP | 327 lines
186 // List all feeds 187 $sql = mysql_query("SELECT * FROM feeds ORDER BY id;"); 188 $numberfeeds = mysql_num_rows($sql); 231 // Check if it already exists using the permalink 232 $check = mysql_query("SELECT * FROM posts WHERE permalink = '$permalink'") or die(mysql_error()); 233 if (mysql_num_rows($check) == "0") { 236 $insert = "INSERT INTO posts (feed_id,user_id,title,slug,permalink,created_at,category,content) VALUES (\"$feed_id\",\"$user_id\",\"$title\",\"$slug\",'$permalink','$created_at','$category','$content')"; 237 mysql_query($insert) or die(mysql_error()); 238functions.php https://github.com/ellenoneill/lootjestrekmachine.git | PHP | 155 lines
23 $sql = "SELECT ".$field." FROM ".$table." WHERE ".$field." LIKE '".$value."' LIMIT 1"; 24 $res = mysql_query($sql) or echo_mysql_error($sql); 25 if(mysql_num_rows($res) > 0) 36 $sql = "SELECT id FROM mensen WHERE naam LIKE '".$naam."' AND groep_id = ".$gid." LIMIT 1"; 37 $res = mysql_query($sql) or echo_mysql_error($sql); 38 if(mysql_num_rows($res) > 0) 57 $sql = "SELECT id, naam FROM groepen ORDER BY naam"; 58 $res = mysql_query($sql) or echo_mysql_error($sql); 59 echo '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, ' ',manager.cpp https://github.com/luizribeiro/smaco.old.git | C++ | 421 lines
26MYSQL_RES* query(const char *q){ 27 int q_st = mysql_query(conn, q); 28 MYSQL_RES * r;config-catalogue-edit.php https://gitlab.com/manuperazafa/habbofa2 | PHP | 155 lines
7$user_id = $_GET['user']; 8$user_edit_a = mysql_query("SELECT * FROM catalog_pages WHERE id='$user_id'"); 9if (mysql_num_rows($user_edit_a) == 0) { 25$page_strings_2 = $_POST['page_strings_2']; 26mysql_query ("UPDATE catalog_pages SET id='$id', parent_id='$parent_id', caption='$caption', icon_image='$icon_image', visible='$visible', enabled='$enabled', min_rank='$min_rank', order_num='$order_num', page_link='$page_link', page_layout='$page_layout', page_strings_1='$page_strings_1', page_strings_2='$page_strings_2' WHERE id=$user_edit_q[id]"); 27header ("Location: config-catalogue.php?saved=$w"); 27header ("Location: config-catalogue.php?saved=$w"); 28mysql_query("INSERT INTO stafflogs (action, message, note, userid, timestamp) VALUES ('Catálogo', 'Ha editado el catálogo (". $user_edit_q['caption'] .").', '". $user_q['rank'] ."', '". $user_q['id'] ."', '". time() ."')"); 29} 120 <td style="font-size: 12px;"><b>RANGO</b></td> 121 <td><select name="min_rank"><?php $b = mysql_query("SELECT * FROM ranks"); while($a = mysql_fetch_assoc($b)){ ?><option value="<?php echo $a['id']; ?>"><?php echo $a['name']; ?></option><?php } ?></select></td> 122 </tr>DBIMysqlTest.php https://gitlab.com/luyxtran264/myproject | PHP | 331 lines
91 runkit_function_redefine('mysql_connect', '', 'return "mysql_connect";'); 92 runkit_function_redefine('mysql_query', '', 'return "mysql_query";'); 93 runkit_function_redefine( 190 $this->assertEquals( 191 'mysql_query', 192 $retadmin.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);final.php https://gitlab.com/javednayeem/grecenter | PHP | 220 lines
34 $query .= "('{$student_id}', '{$student_name}', '{$test_no}', '{$_SESSION["token"]}', '{$results_1}', '{$results_2}', '{$results_3}', '{$results_4}', '{$results_analytical}')"; 35 $admin_set = mysql_query($query); 36 //$admin = mysql_fetch_assoc($admin_set); 63 64 $query = mysql_query("SELECT * FROM gre WHERE `test`= $test AND `section` = $sec AND `id` = $id"); 65 while($result = mysql_fetch_array($query)){extension.cache.mysql.php https://gitlab.com/x33n/ampache | PHP | 190 lines
114 $SQLquery .= ' AND (`analyzetime` = -1)'; 115 if ($this->cursor = mysql_query($SQLquery, $this->connection)) { 116 list($version) = mysql_fetch_array($this->cursor); 129 130 $this->cursor = mysql_query('DELETE FROM `'.mysql_real_escape_string($this->table).'`', $this->connection); 131 $this->cursor = mysql_query('INSERT INTO `'.mysql_real_escape_string($this->table).'` VALUES (\''.getID3::VERSION.'\', -1, -1, -1, \''.getID3::VERSION.'\')', $this->connection); 150 $SQLquery .= ' AND (`filetime` = \''.mysql_real_escape_string($filetime).'\')'; 151 $this->cursor = mysql_query($SQLquery, $this->connection); 152 if (mysql_num_rows($this->cursor) > 0) { 169 $SQLquery .= ', \''.mysql_real_escape_string(base64_encode(serialize($analysis))).'\')'; 170 $this->cursor = mysql_query($SQLquery, $this->connection); 171 } 186 $SQLquery .= ', PRIMARY KEY (`filename`, `filesize`, `filetime`)) ENGINE=MyISAM'; 187 $this->cursor = mysql_query($SQLquery, $this->connection); 188 echo mysql_error($this->connection);files.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 181 lines
64 // Получаем имя нужной категории форума 65 $req = mysql_query("SELECT `text` FROM `forum` WHERE `website` = '$website' AND `id` = '$id'"); 66 if (mysql_num_rows($req) > 0) { 80 */ 81 $total = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_forum_files` WHERE `website` = '$website' AND " . (isset($_GET['new']) 82 ? " `time` > '$new'" : " `filetype` = '$do'") . $sql), 0); 86 : '') . '</div>' . ($do ? '<div class="bmenu">' . $types[$do] . '</div>' : ''); 87 $req = mysql_query("SELECT `cms_forum_files`.*, `forum`.`user_id`, `forum`.`text`, `topicname`.`text` AS `topicname` 88 FROM `cms_forum_files` 94 while ($res = mysql_fetch_assoc($req)) { 95 $req_u = mysql_query("SELECT `id`, `name`, `sex`, `rights`, `lastdate`, `status`, `datereg`, `ip`, `browser` FROM `users` WHERE `website` = '$website' AND `id` = '" . $res['user_id'] . "'"); 96 $res_u = mysql_fetch_assoc($req_u); 101 $text = preg_replace('#\[c\](.*?)\[/c\]#si', '', $text); 102 $page = ceil(mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `website` = '$website' AND `refid` = '" . $res['topic'] . "' AND `id` " . ($set_forum['upfp'] 103 ? ">=" : "<=") . " '" . $res['post'] . "'"), 0) / $kmess);@dbs.php https://bitbucket.org/comarius/buzznet.git | PHP | 549 lines
164 165 // Perform the query via std mysql_query function.. 166 $this->result = @mysql_query($query,$this->dbh);entretenimiento.php https://gitlab.com/merintec/barvo | PHP | 131 lines
5 $sql_tipos = "SELECT * FROM tipo_recetas tr, recetas rc WHERE tr.id_trece=rc.id_trece AND rc.stat_rece='A' GROUP BY tr.orden ORDER BY nomb_trece "; 6 $bus_tipos = mysql_query($sql_tipos); 7 while($reg_tipos = mysql_fetch_array($bus_tipos)){*/ 8 $sql_rece = "SELECT * FROM recetas WHERE stat_rece='A' ORDER BY defecto desc,orden"; 9 $bus_rece = mysql_query($sql_rece); 10 while($reg_rece = mysql_fetch_array($bus_rece)){ 22 $sql_videos= "SELECT * FROM videos WHERE stat_video='A' ORDER BY orden"; 23 $bus_videos = mysql_query($sql_videos); 24 while($reg_videos = mysql_fetch_array($bus_videos))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));upload2.php https://github.com/delete66/sikevux-s-tracker.git | PHP | 93 lines
32//==== offer dropdown for offer mod 33$res = mysql_query("SELECT id, name, allowed FROM offers WHERE userid = $CURUSER[id] ORDER BY name ASC") or sqlerr(__FILE__, __LINE__); 34if (mysql_num_rows($res) > 0) {database_mysql.php https://github.com/tigerdan/TinyIB.git | PHP | 220 lines
13// Create the posts table if it does not exist 14if (mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . TINYIB_DBPOSTS . "'")) == 0) { 15 mysql_query("CREATE TABLE `" . TINYIB_DBPOSTS . "` ( 44// Create the bans table if it does not exist 45if (mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . TINYIB_DBBANS . "'")) == 0) { 46 mysql_query("CREATE TABLE `" . TINYIB_DBBANS . "` ( 58function uniquePosts() { 59 $row = mysql_fetch_row(mysql_query("SELECT COUNT(DISTINCT(`ip`)) FROM " . TINYIB_DBPOSTS)); 60 return $row[0]; 63function postByID($id) { 64 $result = mysql_query("SELECT * FROM `" . TINYIB_DBPOSTS . "` WHERE `id` = '" . mysql_real_escape_string($id) . "' LIMIT 1"); 65 if ($result) { 72function threadExistsByID($id) { 73 return mysql_result(mysql_query("SELECT COUNT(*) FROM `" . TINYIB_DBPOSTS . "` WHERE `id` = '" . mysql_real_escape_string($id) . "' AND `parent` = 0 LIMIT 1"), 0, 0) > 0; 74}