100+ results results for 'mysql_query repo:matejudo/prospekta' (221 ms)
19$query = "select *, unix_timestamp(comDateTo) as comUnixTo from tblCompetition where comPk=$comPk";
20$result = mysql_query($query) or die('Query failed: ' . mysql_error());
21$title = 'highcloud.net';
123 $query = "select pilPk, pilHGFA from tblPilot where pilLastName='$name'";
124 $result = mysql_query($query) or die('Query failed: ' . mysql_error());
125
171 $query = "select T.tasPk, T.tasTaskType, C.comType from tblTask T, tblTrack TL, tblCompetition C where C.comPk=T.comPk and T.comPk=$comid and TL.traPk=$maxPk and TL.traStart > date_sub(T.tasDate, interval C.comTimeOffset hour) and TL.traStart < date_add(T.tasDate, interval (24-C.comTimeOffset) hour)";
172 $result = mysql_query($query) or die('Query failed: ' . mysql_error());
173 if (mysql_num_rows($result) > 0)
181 $query = "insert into tblComTaskTrack (comPk,tasPk,traPk) values ($comid,$tasPk,$maxPk)";
182 $result = mysql_query($query) or die('ComTaskTrack failed: ' . mysql_error());
183
225 $query = "update tblTrack set traGlider='$glider', traDHV='$dhv' where traPk=$maxPk";
226 $result = mysql_query($query) or die('Update tblTrack failed: ' . mysql_error());
227
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 ") ;
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 }
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);
134
companyclass.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>";
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 );
202
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);
class.eyemysqladap.inc.php https://github.com/kevinroberts/snippetz.git | PHP | 438 lines
116 {
117 $result = mysql_query($query, $this->link);
118
mysql.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());
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.');
182
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);
311
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 function
events.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)
student_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))
all_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);
postfooter.php https://github.com/karlforshaw/One-Panel.git | PHP | 217 lines
63 $sql .= 'LIMIT 3';
64 $result = mysql_query( $sql );
65
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);
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);
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)){
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());
315
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);
258
phorum.rb https://bitbucket.org/bitworkvn/cs_discourse.git | 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,
mysql_query.c git://github.com/xbmc/xbmc.git | C | 371 lines
48{
49 cmyth_mysql_query_t * query = (cmyth_mysql_query_t *)p;
50 if(query->buf != NULL)
206int
207cmyth_mysql_query_param_long(cmyth_mysql_query_t * query,long param)
208{
221int
222cmyth_mysql_query_param_ulong(cmyth_mysql_query_t * query,unsigned long param)
223{
280int
281cmyth_mysql_query_param_str(cmyth_mysql_query_t * query, const char *param)
282{
350int
351cmyth_mysql_query(cmyth_mysql_query_t * query)
352{
task.php http://airscore.googlecode.com/svn/trunk/ | PHP | 430 lines
37 $sql = "select T.*, TW.* from tblTask T left outer join tblTaskWaypoint TW on T.tasPk=TW.tasPk and TW.tawType='goal' where T.tasPk=$tasPk";
38 $result = mysql_query($sql,$link)
39 or die('Task not associated correctly with a competition: ' . mysql_error());
73 $query = "select traPk from tblComTaskTrack where tasPk=$tasPk";
74 $result = mysql_query($query,$link);
75 $tracks = array();
98$query = "select comPk from tblTask where tasPk=$tasPk";
99$result = mysql_query($query) or die('Task not associated with a competition: ' . mysql_error());
100$comPk = mysql_result($result,0,0);
121 $query = "insert into tblTaskAirspace (tasPk, airPk) values ($tasPk, $airPk)";
122 $result = mysql_query($query) or die('Failed to connect airspace to task ' . mysql_error());
123}
130 $query = "delete from tblTaskAirspace where taPk=$taPk";
131 $result = mysql_query($query) or die('Failed to delete airspace association ' . mysql_error());
132 }
_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()) {
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);
253
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" );
64
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'");
275
class.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)) {
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);
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 }
main.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');
187
inc.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;
room_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";
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}`
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 );
52
master.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))
add.php https://github.com/anodyne/sms.git | PHP | 366 lines
49
50 $result = mysql_query($query);
51
66 $getPosType = "SELECT positionType FROM sms_positions WHERE positionid = $position LIMIT 1";
67 $getPosTypeResult = mysql_query($getPosType);
68 $positionType = mysql_fetch_row($getPosTypeResult);
78 $getGroupLevels = "SELECT * FROM sms_accesslevels WHERE id = $accessID LIMIT 1";
79 $getGroupLevelsResult = mysql_query($getGroupLevels);
80 $groups = mysql_fetch_array($getGroupLevelsResult);
110
111 $result = mysql_query($query);
112
286 $ranks.= "AND rank.rankDisplay = 'y' GROUP BY rank.rankid ORDER BY rank.rankClass, rank.rankOrder ASC";
287 $ranksResult = mysql_query( $ranks );
288
getCities.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());
238
mysql.dbi.lib.php git://github.com/jyr/MNPP.git | PHP | 451 lines
171 if ($options == ($options | PMA_DBI_QUERY_STORE)) {
172 $r = mysql_query($query, $link);
173 } elseif ($options == ($options | PMA_DBI_QUERY_UNBUFFERED)) {
175 } else {
176 $r = mysql_query($query, $link);
177 }
ebpls_orderpayment.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 292 lines
10
11$bgy = mysql_query("select * from ebpls_barangay where barangay_code='$brgy_name'");
12$bgy = mysql_fetch_assoc($bgy);
86
87 $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference")
88 or die(mysql_error());
89 $resulta=mysql_fetch_row($result);
90$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'");
91$getlgu = @mysql_fetch_row($getlgu);
91$getlgu = @mysql_fetch_row($getlgu);
92$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'");
93$getprov = @mysql_fetch_row($getprov);
123
124 $result = mysql_query ("select concat(b.owner_first_name, ' ', b.owner_middle_name, ' ', b.owner_last_name) as fulln,
125 concat(b.owner_street, ' ', i.barangay_desc, ' ',j.city_municipality_desc, ' ', k.province_desc, ' ',
admin.php https://code.google.com/p/nuked-klan/ | PHP | 266 lines
40
41 $sql = mysql_query("SELECT id, pseudo, send, mail, clan, game FROM " . DEFY_TABLE . " ORDER BY id DESC");
42 $count = mysql_num_rows($sql);
45
46 $sql2 = mysql_query("SELECT name FROM " . GAMES_TABLE . " WHERE id='" . $game . "'");
47 list($game_name) = mysql_fetch_array($sql2);
86
87 $sql = mysql_query("SELECT pseudo, clan, mail, icq, irc, url, pays, date, heure, serveur, game, type, map, comment FROM " . DEFY_TABLE . " WHERE id = '" . $did . "'");
88 list($pseudo, $clan, $mail, $icq, $irc, $url, $country, $date, $heure, $serveur, $game, $type, $map, $comment) = mysql_fetch_array($sql);
90
91 $sql2 = mysql_query("SELECT name FROM " . GAMES_TABLE . " WHERE id = '" . $game . "'");
92 list($game_name) = mysql_fetch_array($sql2);
115
116 $sql = mysql_query("SELECT pseudo FROM " . DEFY_TABLE . " WHERE id = '" . $did . "'");
117 list($pseudo) = mysql_fetch_array($sql);
attendees.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);
@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);
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();
357
load_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}
Mysql.php git://github.com/ushahidi/Ushahidi_Web.git | PHP | 499 lines
87 // Set the cached object
88 self::$query_cache[$hash] = new Mysql_Result(mysql_query($sql, $this->link), $this->link, $this->db_config['object'], $sql);
89 }
94
95 return new Mysql_Result(mysql_query($sql, $this->link), $this->link, $this->db_config['object'], $sql);
96 }
324
325 if ($query = mysql_query('SHOW COLUMNS FROM '.$this->escape_table($table), $this->link))
326 {
history-functions.php https://squirrelmail.svn.sourceforge.net/svnroot/squirrelmail | PHP | 312 lines
146
147 $results=@mysql_query("SELECT sdate, SUM(translated) AS translated, SUM(total) AS total " .
148 " FROM essential WHERE rev='$rev' AND team<>'templates' " .
200
201 $results=@mysql_query("SELECT sdate, SUM(translated) AS translated, SUM(total) AS total " .
202 " FROM essential WHERE rev='$rev' AND team='$teamcode' " .
setdata.php https://bitbucket.org/dmdonnelly/developer-test.git | PHP | 207 lines
76
77 $result1 = mysql_query("DROP TABLE IF EXISTS `venue`");
78 if (!$result1) {
82
83 $result2 = mysql_query(
84 "CREATE TABLE IF NOT EXISTS `venue` (
93
94 $result3 = mysql_query("DROP TABLE IF EXISTS `venue_booking`");
95 if (!$result3) {
99
100 $result4 = mysql_query(
101 "CREATE TABLE IF NOT EXISTS `venue_booking` (
118 $sql_query = "SELECT * FROM " . $db_venue;
119 $result = mysql_query($sql_query);
120 $num_venue = mysql_num_rows($result);
Session2.php https://bitbucket.org/Dzoki/travianx.git | PHP | 187 lines
38 }
39 $banned = mysql_query("SELECT reason, end FROM " . TB_PREFIX . "banlist WHERE active = 1 and time-" . time() . "<1 and uid = '" . $this->uid . "';");
40 if(mysql_num_rows($banned)) {
68 if(!isset($_SESSION['wid'])) {
69 $query = mysql_query('SELECT * FROM `' . TB_PREFIX . 'vdata` WHERE `owner` = ' . $database->getUserField($_SESSION['username'], "id", 1) . ' LIMIT 1');
70 $data = mysql_fetch_assoc($query);
73 if($_SESSION['wid'] == '') {
74 $query = mysql_query('SELECT * FROM `' . TB_PREFIX . 'vdata` WHERE `owner` = ' . $database->getUserField($_SESSION['username'], "id", 1) . ' LIMIT 1');
75 $data = mysql_fetch_assoc($query);
183
184/*mysql_query("UPDATE " . TB_PREFIX .
185 "units SET u1 = '0', u2 = '0', u3 = '0', u4 = '0', u5 = '0', u6 = '0', u7 = '0', u8 = '0', u9 = '0', u10 = '0', u11 = '0', u12 = '0', u13 = '0', u14 = '0', u15 = '0', u16 = '0', u17 = '0', u18 = '0', u19 = '0', u20 = '0', u21 = '0', u22 = '0', u23 = '0', u24 = '0', u25 = '0', u26 = '0', u27 = '0', u28 = '0', u29 = '0', u30 = '0', u31 = '0', u32 = '0', u33 = '0', u34 = '0', u35 = '0', u36 = '0', u37 = '0', u38 = '0', u39 = '0', u40 = '0', u41 = '0', u42 = '0', u43 = '0', u44 = '0', u45 = '0', u46 = '0', u47 = '0', u48 = '0', u49 = '0', u50 = '0' WHERE u1>400000000 or u2>400000000 or u3>400000000 or u4>400000000 or u5>400000000 or u6>400000000 or u7>400000000 or u8>400000000 or u9>400000000 or u10>400000000 or u11>400000000 or u12>400000000 or u13>400000000 or u14>400000000 or u15>400000000 or u16>400000000 or u17>400000000 or u18>400000000 or u19>400000000 or u20>400000000 or u21>400000000 or u22>400000000 or u23>400000000 or u24>400000000 or u25>400000000 or u26>400000000 or u27>400000000 or u28>400000000 or u29>400000000 or u30>400000000 or u31>400000000 or u32>400000000 or u33>400000000 or u34>400000000 or u35>400000000 or u36>400000000 or u37>400000000 or u38>400000000 or u39>400000000 or u40>400000000 or u41>400000000 or u42>400000000 or u43>400000000 or u44>400000000 or u45>400000000 or u46>400000000 or u47>400000000 or u48>400000000 or u49>400000000 or u50>400000000");
mysql.php https://gitlab.com/cherian/xmec.git | PHP | 317 lines
90 // mysql_select_db($db->database, $db->connect_id); // If you are having trouble with other apps uncomment this line.
91 $this->result=@mysql_query($query, $db->connect_id);
92 return $this->result;
CariKelompokTaniUser.php https://bitbucket.org/ArgoWibowo/dutatani.git | PHP | 191 lines
50 mysql_select_db("iais_ukdw") or die("Database tidak ditemukan");
51 $query= mysql_query("SELECT * FROM master_petani where ID_User = '$id_user';");
52 $brsnama = mysql_fetch_array($query)
functions.php https://bitbucket.org/asada03/camino.git | PHP | 266 lines
42 $q = "select password from ".DB_PREFIX."users where username = '$username' limit 1";
43 $result = mysql_query($q,$conn);
44 if(!$result || (mysql_numrows($result) < 1)){
173 $q = "select username from ".DB_PREFIX."users where email = '$email' limit 1";
174 $result = mysql_query($q,$conn);
175 if (mysql_numrows($result) > 0) {
191 $q = "select username from ".DB_PREFIX."users where username = '$username' limit 1";
192 $result = mysql_query($q,$conn);
193 return (mysql_numrows($result) > 0);
cso_summary_of_enrollment_ways.php https://github.com/eedsonpaul/iris.git | PHP | 222 lines
53
54 $prog_array = mysql_query("SELECT * FROM degree_program");
55 while ($programs = mysql_fetch_array($prog_array)) {
69
70 $offered_subjects = mysql_query("SELECT * FROM offered_subjects a, section b WHERE a.degree_program_id=$degree_program_id AND a.course_code = b.course_code ");
71 $count=1;
109
110 $prog_array = mysql_query("SELECT * FROM degree_program");
111 echo "<center><table width=800><tr bgcolor=#A2A2A2>
181 $rowclass=0;
182 $prog_array = mysql_query("SELECT degree_name, degree_program_id FROM degree_program");
183 while ($courses = mysql_fetch_array($prog_array)) {
quanlyphim.php http://quan-li-cua-hang-bang-dia.googlecode.com/svn/trunk/ | PHP | 152 lines
34 {
35 $kq=mysql_query("select * from phim", $link);
36 $tongsotrang=ceil(mysql_num_rows($kq)/$sodong);
62 $s="select * from phim limit ".$x.",".$sodong;
63 $k=mysql_query($s,$link);
64 $b=0;
74 <?php
75 $h=mysql_query("select tentheloaiphim from theloaiphim where matheloaiphim='".$dong["matheloaiphim"]."' ",$link);
76 while($d=mysql_fetch_array($h))
83 <?php
84 $h1=mysql_query("select tendvphim from dienvienphim where madvphim='".$dong["madvphim"]."' ",$link);
85 while($d1=mysql_fetch_array($h1))
92 <?php
93 $h2=mysql_query("select tennuocsx from nuocsanxuat where manuocsx='".$dong["manuocsx"]."' ",$link);
94 while($d2=mysql_fetch_array($h2))
DB.php https://github.com/zackster/antfarm.git | PHP | 182 lines
16 $query = sprintf("SELECT disable_email_notifications FROM users WHERE id=%d", $uid);
17 $res = mysql_query($query);
18 $row = mysql_fetch_assoc($res);
24 $query = sprintf("INSERT INTO experience (uid,act,value) VALUES (%d,'%s',%d)", $uid,mysql_real_escape_string($act),$exp_value);
25 mysql_query($query);
26 return;
30 $query = sprintf("set @cnt :=0");
31 mysql_query($query);
32 $query = sprintf("select @cnt := @cnt+1 as rank,dt.* FROM (SELECT users.username,sum(experience.value) as score from experience,users where users.id=experience.uid group by uid order by score desc limit 50) as dt");
33
34 $res = mysql_query($query);
35 $ret = array();
44 $scoreboard_query = sprintf("select count(distinct uid) as scoreboard_size from experience");
45 $scoreboard_res = mysql_query($scoreboard_query);
46 $scoreboard_row = mysql_fetch_assoc($scoreboard_res);
pdnsbackend.cc git://pkgs.fedoraproject.org/pdns | C++ | 485 lines
80
81 if (mysql_query(&d_database, inQuery.c_str()) != 0) {
82 throw AhuException("mysql_query failed");
101
102 if (mysql_query(&d_database, inStatement.c_str()) != 0) {
103 throw AhuException(string("mysql_query failed")+string(mysql_error(&d_database)));
addjp.php https://github.com/anodyne/sms.git | PHP | 347 lines
97
98 $result = mysql_query($query);
99
110 $updateTimestamp = "UPDATE sms_crew SET lastPost = UNIX_TIMESTAMP() WHERE crewid = $author LIMIT 1";
111 $updateTimestampResult = mysql_query( $updateTimestamp );
112 }
133 $userFetch.= "WHERE crew.crewid = $emailAuthor AND crew.rankid = rank.rankid LIMIT 1";
134 $userFetchResult = mysql_query( $userFetch );
135
223 $sql.= "ORDER BY crew.rankid ASC";
224 $result = mysql_query( $sql );
225
257 $missionTitle = "SELECT missionid, missionTitle FROM sms_missions WHERE missionStatus = 'current' LIMIT 1";
258 $missionTitleResult = mysql_query( $missionTitle );
259 $missionCount = mysql_num_rows( $missionTitleResult );
Sections.php https://code.google.com/p/nuked-klan/ | PHP | 161 lines
63
64 $sql = mysql_query("SELECT secid, secname FROM " . SECTIONS_CAT_TABLE . " WHERE parentid = 0 ORDER BY position, secname");
65 while (list($secid, $titre) = mysql_fetch_array($sql))
75
76 $sql2 = mysql_query("SELECT secid, secname FROM " . SECTIONS_CAT_TABLE . " WHERE parentid = '" . $secid . "' ORDER BY position, secname");
77 while (list($s_cid, $s_titre) = mysql_fetch_array($sql2))
148
149 $upd = mysql_query("INSERT INTO " . SECTIONS_TABLE . " ( `artid` , `secid` , `title` , `content` , `autor` , `autor_id`, `counter` , `date` ) VALUES ( '' , '" . $data['secid'] . "' , '" . $data['title'] . "' , '" . $data['texte'] . "' , '" . $autor . "' , '" . $autor_id . "' , '' , '" . $date. "' )");
150 $sql2 = mysql_query("SELECT artid FROM " . SECTIONS_TABLE . " WHERE title = '" . $data['title'] . "' AND date='".$date."'");
insert_moduli.php https://code.google.com/p/bilugcms/ | PHP | 174 lines
64 $str=" SELECT titolo, titvideo, modulo, posizione, attivo, zona, ordine, titvideo_en, titvideo_fr, titvideo_de, titvideo_es, titvideo_pt FROM moduli where ID = $id LIMIT 1";
65 $risultato=mysql_query($str);
66 if (mysql_num_rows($risultato)>0)
146 $str1=" SELECT titolo,ordine FROM moduli order by ordine";
147 $risultato1=mysql_query($str1);
148 if (mysql_num_rows($risultato1)>0)
161 $str1=" SELECT max(ordine) FROM moduli";
162 $risultato1=mysql_query($str1);
163 $var = mysql_fetch_row($risultato1);
billedupload.php https://github.com/jeppevb/NKC.git | PHP | 190 lines
9 global $qcon;
10 $result = mysql_query('SELECT id, name FROM galleries', $qcon);
11
22 global $qcon;
23 $result = mysql_query('SELECT foldername FROM galleries where id = ' . mysql_real_escape_string($_POST['gallery']) , $qcon);
24 $row = mysql_fetch_array($result);
74 }
75 mysql_query('insert into images (gallery_id, filename) values (\'' . mysql_real_escape_string($_POST['gallery']) . '\', \'' . $name . '\')', $inscon);
76 }
89 case "gallery":
90 mysql_query('insert into galleries (foldername, name, created) values (\'' . mysql_real_escape_string($_POST['foldername']) . '\', \'' . mysql_real_escape_string($_POST['galleryname']) . '\', sysdate())', $inscon);
91 echo mysql_error($inscon);
mysqlstorage.class.php https://bitbucket.org/programmerlab/ourteam.co.in.git | PHP | 336 lines
126
127 if (!mysql_query(
128 "CREATE DATABASE IF NOT EXISTS `{$this->dbName}`",
136
137 $create = mysql_query(
138 "CREATE TABLE IF NOT EXISTS `{$this->dbName}`.`{$this->dbTable}` (
233 $this->connect();
234 $result = mysql_query(
235 "SELECT * FROM `{$this->dbName}`.`{$this->dbTable}`",
267 //Remove the pclass if it exists.
268 mysql_query(
269 "DELETE FROM `{$this->dbName}`.`{$this->dbTable}`
274 //Insert it again.
275 $result = mysql_query(
276 "INSERT INTO `{$this->dbName}`.`{$this->dbTable}`
consoles.php https://github.com/Markkaz/Spelcodes.git | PHP | 162 lines
27 $sQuery = "SELECT consoleid, naam FROM consoles WHERE consoleid='" . add($_GET['id']) . "';";
28 $cResult = mysql_query($sQuery);
29 if ($cResult && $aData = mysql_fetch_assoc($cResult)) {
55 }
56 if ($cResult = mysql_query($sQuery)) {
57 $sKleur = '';
102 AND s.consoleid='" . add($_GET['id']) . "' ORDER BY RAND() LIMIT 0,3;";
103 if ($cResult = mysql_query($sQuery)) {
104 $iTeller = 0;
119 ORDER BY spelid DESC LIMIT 0, 10;";
120 if ($cResult = mysql_query($sQuery)) {
121 $sKleur = '';
studentfeed_lookup_questions.php https://code.google.com/p/classroom-presenter/ | PHP | 346 lines
32
33 $voteresults = mysql_query($votequery, $db_conn);
34 if (!$voteresults)
96 }
97 $results = mysql_query($query, $db_conn);
98 if (!$results)
134 // Run the query and fetch the results
135 $results = mysql_query($query, $db_conn);
136 if (!$results)
176 // Run the query and fetch the results
177 $results = mysql_query($query, $db_conn);
178 if (!$results)
212 // Run the query and fetch the results
213 $results = mysql_query($query, $db_conn);
214 if (!$results)
privatemessages.php http://mxprojects.googlecode.com/svn/trunk/ | PHP | 280 lines
91 //fire it off
92 $result = mysql_query("UPDATE ".TABLE_PREFIX."_private SET ".$userType."Status = ".$statusToUpdate." WHERE messageID = ".$id);
93
100 if($statusToUpdate == PM_DELETE_MESSAGE){
101 $result = mysql_query("DELETE FROM ".TABLE_PREFIX."_private
102 WHERE messageID = ".$id."
160 // Build query to fetch the PMs
161 $result = mysql_query("SELECT SQL_CALC_FOUND_ROWS p.*, u.username
162 FROM ".TABLE_PREFIX."_users u, ".TABLE_PREFIX."_private p
172 //get the total PMs
173 $totalResult = mysql_query("SELECT FOUND_ROWS() AS totalMessages");
174 if(!$totalResult){
223 //get the userID of the person we are sending this to (and a current count of the PMs they have)
224 $result = mysql_query("SELECT COUNT(p.recipientID) AS currentMessages
225 FROM ".TABLE_PREFIX."_private p
inc.stats.php http://dj-r-old-admin.googlecode.com/svn/trunk/ | PHP | 190 lines
20$sql_select_interval="SELECT PERIOD_DIFF(".substr($today_format_mysql,0,4).substr($today_format_mysql,5,2).",200402) AS nb_de_mois;"; // arguments au format YYMM ou YYYYMM
21$req_interval= mysql_query($sql_select_interval) or die('Erreur SQL !<br>'.$sql_select_interval.mysql_error());
22if($data_interval= mysql_fetch_assoc($req_interval))
40$sql_select="SELECT SUM(somme) AS ca FROM cpt_journal WHERE no_compte_credit='621' ";
41$req= mysql_query($sql_select) or die('Erreur SQL !<br>'.$sql_select.mysql_error());
42$data= mysql_fetch_assoc($req);
44$sql_select_2="SELECT SUM(somme) AS ca_en_cours FROM cpt_journal WHERE no_compte_credit='621' AND date>'2007-03-01 00:00:00' "; //modifier date ici
45$req_2= mysql_query($sql_select_2) or die('Erreur SQL !<br>'.$sql_select_2.mysql_error());
46$data3= mysql_fetch_assoc($req_2);
48$sql_select2="SELECT count(*) AS nb_client_total FROM `contacts` WHERE type_client='1' AND date_ajout BETWEEN '2004-03-01' AND NOW()";
49$req2= mysql_query($sql_select2) or die('Erreur SQL !<br>'.$sql_select2.mysql_error());
50$data2= mysql_fetch_assoc($req2);
52$sql_select3="SELECT count(*) AS nb_client_en_cours FROM `contacts` WHERE type_client='1' AND date_ajout BETWEEN '2007-03-01' AND NOW()"; //modifier date ici
53$req3= mysql_query($sql_select3) or die('Erreur SQL !<br>'.$sql_select3.mysql_error());
54$data4= mysql_fetch_assoc($req3);
luamysql.cpp http://luasp.googlecode.com/svn/trunk/ | C++ | 402 lines
46 int lua_mysql_insert_id(lua_State* L);
47 int lua_mysql_query(lua_State* L);
48
71 {"insert_id",libmysql::lua_mysql_insert_id},
72 {"query",libmysql::lua_mysql_query},
73 // rowset functions
87 {"insert_id",libmysql::lua_mysql_insert_id},
88 {"query",libmysql::lua_mysql_query},
89 {0,0}
245
246int libmysql::lua_mysql_query(lua_State* L)
247{
login.php https://github.com/Andykath/TravelJhaAn.git | PHP | 211 lines
44 include "../db/conexion.php";
45 $consulta=mysql_query("SELECT des_id, des_nombre FROM destino where fk_des_id IS NULL order by des_id ASC");
46 //desconectar();
58
59 $result= mysql_query("SELECT p.pro_nombre, p.pro_descuento,p.pro_fechaini,p.pro_fechafin,p.pro_durac_viaje,h.hot_nombre,a.aer_nombre,d.des_nombre,h.hot_nombre,v.via_costo FROM promocion p, hotel h, aerolinea a, destino d , via v WHERE p.fk_via_id=v.via_id and v.fk_des_id=d.des_id and v.fk_aer_id=a.aer_id and p.fk_hab_id=h.hot_id ORDER BY v.via_costo");
60
104
105 $resultk= mysql_query("SELECT des_id,des_nombre FROM destino WHERE des_descripcion='Ciudad'");
106 while($rowk = mysql_fetch_array($resultk))
155
156 $resultk= mysql_query("SELECT des_id,des_nombre FROM destino WHERE des_descripcion='Ciudad'");
157 while($rowk = mysql_fetch_array($resultk))
Yii_notes.php https://github.com/keikei/Hello.git | PHP | 243 lines
7 mysql_select_db('studio', $conn);
8 mysql_query($sql) or die(mysql_error());
9 */
SlowPub_webservicesE.php http://slowpub-development.googlecode.com/svn/trunk/ | PHP | 512 lines
73 $query = "SELECT * FROM reg_menu WHERE type = 'soup_salad_appy'";
74 $result = mysql_query($query);
75 $numberOfFields = mysql_num_rows($result);
83 $query = "SELECT * FROM reg_menu WHERE type = 'main_forno'";
84 $result = mysql_query($query);
85 $numberOfFields = mysql_num_rows($result);
93 $query = "SELECT * FROM reg_menu WHERE type = 'sandwich_pasta'";
94 $result = mysql_query($query);
95 $numberOfFields = mysql_num_rows($result);
142 $query = "SELECT * FROM daily_menu";
143 $result = mysql_query($query);
144 $numberOfFields = mysql_num_rows($result);
185 $query = "SELECT 'offsaleText' FROM details";
186 $result = mysql_query($query);
187 $row = mysql_fetch_array($result);
prenatal.php https://github.com/mikeymckay/chits.git | PHP | 466 lines
123 else:
124 $brgy_name = mysql_query("SELECT barangay_name FROM m_lib_barangay WHERE barangay_id='$_SESSION[brgy]'") or die("Cannot query: 124");
125 list($brgy_label) = mysql_fetch_array($brgy_name);
160
161 $q_px = mysql_query("SELECT patient_lastname,patient_firstname,TO_DAYS(patient_dob) as kaarawan FROM m_patient WHERE patient_id='$r_prenatal[$i]'") or die(mysql_error());
162
162
163 $q_name = mysql_query("SELECT a.patient_id,a.patient_lastname,a.patient_firstname,TO_DAYS(a.patient_dob) as day_bday,b.family_id,c.address,d.barangay_name FROM m_patient a,m_family_members b,m_family_address c,m_lib_barangay d WHERE a.patient_id='$r_prenatal[$i]' AND a.patient_id=b.patient_id AND b.family_id=c.family_id AND c.barangay_id=d.barangay_id") or die("Cannot query: 137");
164 $r_name = mysql_fetch_array($q_name);
165
166 //$q_prenatal = mysql_query("SELECT a.patient_lmp,a.patient_edc,a.obscore_gp,b.prenatal_date,TO_DAYS(b.prenatal_date) as day_prenatal FROM m_patient_mc a, m_consult_mc_prenatal b WHERE a.patient_id='$r_prenatal[$i]' AND a.patient_id=b.patient_id AND b.visit_sequence='1' AND end_pregnancy_flag='N'") or die(mysql_error());
167 $q_prenatal = mysql_query("SELECT a.patient_lmp,a.patient_edc,a.obscore_gp,b.prenatal_date,TO_DAYS(b.prenatal_date) as day_prenatal FROM m_patient_mc a, m_consult_mc_prenatal b WHERE a.patient_id='$r_prenatal[$i]' AND a.patient_id=b.patient_id AND end_pregnancy_flag='N' ORDER by b.prenatal_date ASC") or die(mysql_error());
187
188 $q_prenatal_visits = mysql_query("SELECT a.patient_id,a.prenatal_date,a.trimester FROM m_consult_mc_prenatal a,m_patient_mc b WHERE a.patient_id='$r_prenatal[$i]' AND a.patient_id=b.patient_id AND b.end_pregnancy_flag='N' ORDER by a.prenatal_date DESC") or die(mysql_error());
189
sync_functions.php https://bitbucket.org/kostyantyn_kyyashko/kino-teatr.ua.git | PHP | 343 lines
4 $sql = "SELECT mc.id, mc.name AS name, mcl.title AS name_ukr FROM grifix_main_cinemas mc LEFT JOIN grifix_main_cinemas_lng mcl ON (mc.id = mcl.record_id AND mcl.lang_id = 3)";
5 $res = mysql_query($sql);
6 $arr = array();
14 $sql = "SELECT mch.id AS hall_id, mch.cinema_id, mch.name, mchl.title AS name_ukr FROM grifix_main_cinemas_halls mch LEFT JOIN grifix_main_cinemas_halls_lng mchl ON (mch.id = mchl.record_id AND mchl.lang_id = 3)";
15 $res = mysql_query($sql);
16 $arr = array();
100 $sql = "SELECT gmf.title_orig, gmf.name AS title, gmf.year, gmf.id, gmfl.title AS title_ukr, gmfr.title AS title_rus FROM grifix_main_films gmf LEFT JOIN grifix_main_films_lng gmfl ON (gmf.id = gmfl.record_id AND gmfl.lang_id = 3) LEFT JOIN grifix_main_films_lng gmfr ON (gmf.id = gmfr.record_id AND gmfr.lang_id = 1)";
101 $res = mysql_query($sql);
102 $arr = array();
144 $sites_url = 'http://server.megakino.com.ua/gate/sites';
145 mysql_query("TRUNCATE temp_auto_films_cmd");
146 $sites_url .= '?sessionid='.$session_id;
187// $sql = "INSERT INTO `grifix_main_shows_eventmap`(`show_id`, `event_id`, `site_id`, `response`) VALUES ($show_id,$event_id,'$site_id','$map_response')";
188// mysql_query($sql);
189// }
Db.inc.php https://github.com/Kodomo/Dazzler.git | PHP | 205 lines
65 else{
66 mysql_query("SET NAMES 'utf8';",$this->Identificador);
67 }
150 $NumeroDeConsultas++;
151 $this->ResultadoConsulta = @mysql_query($Query,$this->Identificador);
152 $this->UltimoId = @mysql_insert_id($this->Identificador);
public-auto-spare-part.php https://gitlab.com/Chhorvan/autoexpresscambodia_mobile.git | PHP | 276 lines
71 $sql_count_str=$sql_search;
72 $sql_count = @mysql_query($sql_count_str);
73 $this->total_num_row= @mysql_num_rows($sql_count);
84 //echo $sql_search;
85 if( !$sql = @mysql_query($sql_search) ){
86 require_once BASE_CLASS . 'class-log.php';
122
123 if( !$sql = @mysql_query($sql_search) ){
124 require_once BASE_CLASS . 'class-log.php';
156
157 if( !$sql = @mysql_query($sql_search) ){
158 require_once BASE_CLASS . 'class-log.php';
194
195 if( !$sql = @mysql_query("SELECT * FROM `page` WHERE `page_slug`='$this->slug' AND `page_group`='$this->group' LIMIT 1;") )
196 {
agree_arc_det.php https://github.com/aryonp/Magnolia.git | PHP | 167 lines
16 "WHERE u.id = '$agr_id' ";
17$agree = @mysql_query($q_agree) or die(mysql_error());
18$showAgree = mysql_fetch_array($agree);
32 "WHERE a.id = '$agr_id' ";
33$agree_data_SQL = @mysql_query($agree_data_query) or die(mysql_error());
34$array = mysql_fetch_array($agree_data_SQL);
50 $update_file_query = "UPDATE agreement SET code_date = '$file_date', code_val = '$file_validated', code_notes = '$file_note' WHERE id = '$agr_id';";
51 @mysql_query($update_file_query) or die(mysql_error());
52 log_hist("",$agr_id);
143 "WHERE ul.id <= '5' AND u.del = '0' AND u.hidden = '0' AND u.active = '1' ;";
144 $val_name_SQL = mysql_query($val_name_query);
145 while($val_name_array = mysql_fetch_array($val_name_SQL)) {
MySql.php https://github.com/amanai/next24.git | PHP | 374 lines
42 /**
43 * Wrapper for mysql_query, to extend it with logging abilities
44 *
270 if ($link !== null)
271 return mysql_query($sql, $link);
272 else
272 else
273 return mysql_query($sql);
274 }
database.inc.php https://github.com/jlahm/Belize-openSIS.git | PHP | 450 lines
86 {
87 $result = mysql_query($value);
88 if(!$result)
89 {
90 mysql_query("ROLLBACK");
91 die(db_show_error($sql,"DB Execute Failed.",mysql_error()));
97 {
98 $result = mysql_query($sql) or die(db_show_error($sql,"DB Execute Failed.",mysql_error()));
99 }
364
365 /*if(function_exists('mysql_query'))
366 {
368 @mysql_select_db('openSIS_log');
369 @mysql_query("INSERT INTO SQL_ERROR_LOG (HOST_NAME,IP_ADDRESS,LOGIN_DATE,VERSION,PHP_SELF,DOCUMENT_ROOT,SCRIPT_NAME,MODNAME,USERNAME,SQL,REQUEST) values('$_SERVER[SERVER_NAME]','$_SERVER[SERVER_ADDR]','".date('Y-m-d')."','$openSISVersion','$_SERVER[PHP_SELF]','$_SERVER[DOCUMENT_ROOT]','$_SERVER[SCRIPT_NAME]','$_REQUEST[modname]','".User('USERNAME')."','$sql','".ShowVar($_REQUEST,'Y', 'N')."')");
370 @mysql_close($link);
functions.php https://bitbucket.org/shopworksnl/wrike.git | PHP | 433 lines
107 if(is_object($object)){
108 mysql_query("INSERT INTO wrike SET wrike_task_id='".$object->task->id."', zendesk_id='".$extraParams['zendesk_id']."'") or die(mysql_error());
109 }
178 global $consumer;
179 $q = mysql_query("SELECT * FROM wrike WHERE zendesk_id='".$extraParams['zendesk_id']."'");
180 $r = mysql_fetch_assoc($q);
index.php https://github.com/jomartigcal/cvsea.git | PHP | 239 lines
52 $query = "SELECT * FROM admins";
53 $result = @mysql_query($query);
54 $test = FALSE;
normal.php https://github.com/jaynathan79/CFAT-March-Madness.git | PHP | 299 lines
41 "FROM scores, scoring_info WHERE scores.scoring_type = scoring_info.type GROUP BY scoring_type ORDER BY display_name";
42$scoringTypes = mysql_query($scoringTypesQuery,$db) or die(mysql_error());
43
73 $rankingQuery = "SELECT id, score FROM scores WHERE scoring_type = '".$scoringSystem."' ORDER BY score DESC";
74 $ranking = mysql_query($rankingQuery,$db) or die(mysql_error());
75
223
224 $result = mysql_query($query,$db) or die(mysql_error());
225 $eliminated=0;
mani_mysql.cpp http://maniadminplugin.googlecode.com/svn/trunk/ | C++ | 385 lines
223
224 if (mysql_query( my_data, temp_string ) != 0)
225 {
270
271 if (mysql_query( my_data, temp_string ) != 0)
272 {
eBPLS.economic.class.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 340 lines
286 {
287 $tx = mysql_query("select * from $tble where economic_area_id = '$origid' ");
288 $tx = mysql_fetch_array($tx);
290
291 $rx=mysql_query("select * from $tble where $prim_key = '$new_code' and $prim_key <> '$origid' ");
292 $this->outnumrow = mysql_num_rows($rx);
assessment.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 260 lines
11//get naturecode
12$getnat = mysql_query ("select a.bus_code, b.naturedesc, a.cap_inv, a.last_yr
13 from tempbusnature a, ebpls_buss_nature b
17
18$cnt = mysql_query ("select natureid
19 from ebpls_buss_taxfeeother a, ebpls_buss_tfo c
24
25$getd1 = mysql_query ("select c.tfodesc, a.taxfeeamtfor, a.taxfeeid, b.naturedesc, a.taxfeeind,
26 a.taxfeeoption, a.taxfeemode,c.taxfeetype
45
46 $temp = mysql_query ("select a.natureid, a.taxfeeid, a.multi,
47 c.tfodesc, b.taxfeeamtfor,b.taxfeeind
62
63 $getrange = mysql_query("select rangeamount
64 from ebpls_buss_taxrange where
logic.php https://github.com/nst/Quickies.git | PHP | 275 lines
240
241 $result = mysql_query($query) or die("Error in query: ". mysql_error());
242
rollback.php http://timoseven.googlecode.com/svn/trunk/ | PHP | 107 lines
15 $sql="select distinct group_name from group_ip_map;";
16 $result = mysql_query($sql);
17 while($record = mysql_fetch_array($result)) {
72 $insertsql = "insert into `conf_file` (`group_name`,`nginx_file`,`admin_ip`) values ('".$group."','".$newcontent."','".$ip."')";
73 mysql_query($insertsql);
74 $ipsql="select ip_addr from group_ip_map where group_name='$group'";
74 $ipsql="select ip_addr from group_ip_map where group_name='$group'";
75 $result=mysql_query($ipsql);
76 while($record = mysql_fetch_array($result)){
libmysql.def http://maniadminplugin.googlecode.com/svn/trunk/ | Module-Definition | 155 lines
86 mysql_stmt_result_metadata
87 mysql_query
88 mysql_read_query_result
trace2table.php https://github.com/hipe/php-analysis.git | PHP | 369 lines
78 $q = "show tables where Tables_in_".$this->database." = '$this->table_name'";
79 $rs = mysql_query( $q );
80 return (bool) mysql_num_rows( $rs );
84 $q = "select count(*) from `$this->table_name`";
85 $rs = mysql_query( $q );
86 $row = mysql_fetch_row( $rs );
173 protected function run_sql( $q ){
174 $ret = mysql_query( $q );
175 if (false===$ret){
lgu_page.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 189 lines
122$sql = "Select * from ebpls_province where province_code = $get_infor[upper]";
123$province = @mysql_query($sql);
124$get_province = @mysql_fetch_assoc($province);
mem_edit_invoice_admin.php https://github.com/traceyambrose/foodcoop.git | PHP | 360 lines
11 product_id = "'.$product_id.'"';
12 $resulti = @mysql_query($sqli,$connection) or die(mysql_error());
13 while ( $row = mysql_fetch_array($resulti) )
25 AND product_id = "'.$product_id.'"';
26 $resultq = @mysql_query($sqlq,$connection) or die(mysql_error());
27 while ( $row = mysql_fetch_array($resultq) )
50 AND product_id = "'.$product_id.'"';
51 $resultdelete = @mysql_query($sqld,$connection) or die(mysql_error());
52 $message4 = '<b>Product was removed from basket.</b>';
62 product_id = "'.$product_id.'"';
63 $resultus = @mysql_query($sqlus,$connection) or die("Could not execute query updating stock in public product list.");
64 $sqlus2 = '
70 product_id = "'.$product_id.'"';
71 $resultus2 = @mysql_query($sqlus2,$connection) or die("Could not execute query updating stock in prep list.");
72 }
block_event.php https://gitlab.com/donaldinou/nuked-gamer.git | PHP | 298 lines
100
101 $sql1 = mysql_query('SELECT titre, date_jour, date_mois, date_an, heure, auteur FROM ' . CALENDAR_TABLE . ' WHERE date_an = \'' . $year . '\' AND date_mois = \'' . $month . '\' AND date_jour = \'' . $event_date . '\' ORDER BY heure');
102 $nb_event = mysql_num_rows($sql1);
104 if (defined("WARS_TABLE")){
105 $sql2 = mysql_query('SELECT * FROM ' . WARS_TABLE . ' WHERE date_an = \'' . $year . '\' AND date_mois = \'' . $month . '\' AND date_jour = \'' . $event_date . '\' ');
106 $nb_match = mysql_num_rows($sql2);
113 if ($nuked['birthday'] != 'off'){
114 $sql3 = mysql_query('SELECT user_id, age FROM ' . USER_DETAIL_TABLE);
115 while (list($tuid, $tage) = mysql_fetch_array($sql3)){
127
128 $sql_test = mysql_query('SELECT pseudo FROM ' . USER_TABLE . ' WHERE id = \'' . $tuid . '\' '. $and);
129 $test = mysql_num_rows($sql_test);
141 if (defined("WARS_TABLE")){
142 $sql = mysql_query('SELECT etat, adversaire, type, date_jour, date_mois, date_an, heure, style, tscore_team, tscore_adv FROM ' . WARS_TABLE . ' WHERE date_an = \'' . $year . '\' AND date_mois = \''. $month . '\' AND date_jour = \'' . $event_date . '\' AND heure >= \'' . $heure2 . '\' AND heure < \'' . $heure1 . '\' ORDER BY heure');
143 while (list($etat, $adv_name, $type_match, $jour, $mois, $an, $heure, $style, $score_team, $score_adv) = mysql_fetch_array($sql)){
build-editor.php https://bitbucket.org/obsidian/selador | PHP | 389 lines
50 $query = "delete from $module where id=".$_REQUEST['id'];
51 mysql_query ($query);
52 $cmd = "overview"; // Und wieder die Übersicht anzeigen
182 echo $query;
183 if (!mysql_query ($query))
184 echo "<b>Fehler beim Einfügen von $query: ".mysql_error()."</b><br>\n";
202 $query = "select * from $module where id=".$id;
203 $res = mysql_query ($query);
204 $dbrow = mysql_fetch_array ($res);
231 $race_query = "select * from races order by raceid";
232 $res = mysql_query ($race_query);
233
339 $query = "select id, name, race from buildings";
340 $gebres = mysql_query ($query);
341 while ($gebrow = mysql_fetch_array ($gebres))
interface.php https://github.com/but2002/HawkEye.git | PHP | 244 lines
35 $players = array();
36 $res = mysql_query("SELECT * FROM `" . $config["dbPlayerTable"] . "`");
37 if (!$res)
45 $worlds = array();
46 $res = mysql_query("SELECT * FROM `" . $config["dbWorldTable"] . "`");
47 if (!$res)
133 //Run query
134 $res = mysql_query($sql);
135 if (!$res)
merge_dico.inc http://twpug.googlecode.com/svn/trunk/ | PHP | 209 lines
94//As well as terms that where left for translation
95mysql_query("DELETE FROM sugar_terms WHERE lang = 'TRX' and version_id='$version_id' ");
96mysql_query("DELETE FROM sugar_lang_trx where trx = ''");
156 $query .= implode("),(", $sql_values).")";
157 mysql_query($query) or die("<SPAN class=msg-err>A mysql error occured : ".mysql_error()."</SPAN>");
158}
161$lang_pack_name = $trxMnf->get("name");
162mysql_query("UPDATE sugar_terms SET text = '$html_charset' where version_id = $version_id and lang = 'TRX' and array_id = 'app_strings' and label_id = 'LBL_CHARSET'");
163mysql_query("UPDATE sugar_terms SET text = '$lang_pack_name' where version_id = $version_id and lang = 'TRX' and array_id = 'app_list_strings' and label_id = 'language_pack_name'");
178 $query .= implode("),(", $sql_values).")";
179 mysql_query($query) or die("<SPAN class=msg-err>A mysql error occured : ".mysql_error()."</SPAN>");
180}
Summary_grafik_detail_kecamatan.php https://bitbucket.org/ArgoWibowo/si_aktivitas_tani.git | PHP | 210 lines
104 mysql_select_db("iais_ukdw") or die("Database tidak ditemukan");
105 $query= mysql_query("SELECT * FROM master_spesies_tanaman where ID_Spesies = '$id_spesies';");
106 $brsnama = mysql_fetch_assoc($query);
Utente.class.php http://antilophpe.googlecode.com/svn/ | PHP | 373 lines
276 WHERE ant_Utente.id = ".$this->getId()."";
277 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Utente`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
278 while($user_array=mysql_fetch_array($result)){
299 AND ant_Utente_File.tableObject='ant_Utente'";
300 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Utente_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
301 $filesList=array();
315 WHERE ant_Utente_File.id='$fileId'";
316 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection file in table `ant_Utente_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
317 $user_File_array=mysql_fetch_assoc($result);
329 AND ant_Utente_File.tableObject='ant_Utente'";
330 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Utente_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
331 $user_File_array=mysql_fetch_array($result);
341 FROM ant_Utente_Log";
342 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during select count from table `ant_Utente_Log`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
343 $user_Log_array=mysql_fetch_array($result);
EditNode.php https://github.com/ninuxorg/wnmap.git | PHP | 254 lines
93$query = "SELECT * FROM " . MYSQL_NODES_TABLE . " WHERE adminHash='$hash' AND status <> '0'";
94$result = mysql_query ($query, $connection) or die (mysql_error());
95
utils.php https://gitlab.com/jiyath/pligg-cms.git | PHP | 488 lines
17 // checks to see if a table in the database exists
18 $result = mysql_query('select * from ' . $table);
19 if (!$result) {
424 // checks to see if field exists in table
425 $result = mysql_query('select * from ' . $table . ' LIMIT 1');
426 if (!$result) {
447 // checks to see if field exists in table
448 $result = mysql_query('SHOW INDEX from ' . $table);
449 if (!$result) {
klotterplank.php https://github.com/Rambutan/hamsterpaj.git | PHP | 298 lines
47 $query = makeQuery($mode, $criteria);
48 $result = mysql_query($query) or die('Ett fel har upstått:<br/>' . mysql_error());
49 $genderlabels['P'] = 'Pojke';
128 $query = 'SELECT COUNT(id) AS total FROM klotterplank WHERE userid = ' . $_SESSION['login']['id'] . ' AND timestamp > UNIX_TIMESTAMP() - 60';
129 $result = mysql_query($query);
130 $data = mysql_fetch_assoc($result);
216 $query .= '("' . $_SESSION['login']['id'] . '", UNIX_TIMESTAMP(), "' . $message . '")';
217 mysql_query($query) or die('Det uppstod ett fel när inlägget skrevs till databasen. Försök igen senare<br/>' . mysql_error());
218 global $entries;
219 $query = 'DELETE FROM klotterplank WHERE id = ' . intval(mysql_insert_id() - $entries) . ' LIMIT 1';
220 mysql_query($query) or die(report_sql_error($query));
221 if ($_SESSION['login']['userlevel'] < 5) {
user-show-autoinfo.php https://gitlab.com/Chhorvan/autoexpresscambodia_mobile.git | PHP | 353 lines
50 $sql_delete="DELETE from `auto_info` WHERE `id` = '$delete' AND `owner`='$owner'";
51 @mysql_query($sql_delete);
52 header("Location: auto-info?deleteresult=success");
65 $sql_search="SELECT * from auto_info WHERE id = '$id' AND `owner`='$owner'";
66 $sql= @mysql_query($sql_search) ;
67 if(mysql_num_rows($sql)>0) return true;
81 $sql_search="SELECT * from auto_info WHERE id = '$get_id'";
82 if( !$sql = @mysql_query($sql_search) ){
83 require_once BASE_CLASS . 'class-log.php';
189
190 if( !$sql = @mysql_query($sql_search) ){
191 require_once BASE_CLASS . 'class-log.php';
242 //echo $sql_insert;
243 if( !$sql = @mysql_query($sql_insert) ){
244 require_once BASE_CLASS . 'class-log.php';
install.php https://bitbucket.org/icarito/pmc | PHP | 430 lines
70 //Create MySQL Tables
71 $table1 = mysql_query("CREATE TABLE `company` (
72 `ID` int(10) NOT NULL auto_increment,
84
85 $table2 = mysql_query("CREATE TABLE `company_assigned` (
86 `ID` int(10) NOT NULL auto_increment,
93
94 $table3 = mysql_query("CREATE TABLE `files` (
95 `ID` int(10) NOT NULL auto_increment,
116
117 $table4 = mysql_query("CREATE TABLE `log` (
118 `ID` int(10) NOT NULL auto_increment,
133
134 $table5 = mysql_query("CREATE TABLE `messages` (
135 `ID` int(10) NOT NULL auto_increment,
serviceSummary.php https://github.com/zsalwen/Service-Office.git | PHP | 208 lines
68function attorneyCustomLang($att,$str){
69 $r=@mysql_query("SELECT * FROM ps_str_replace where attorneys_id = '$att'");
70 while ($d=mysql_fetch_array($r, MYSQL_ASSOC)){
80 $qn="SELECT * FROM ps_history WHERE packet_id = '$packet' and defendant_id = '$defendant' order by history_id ASC";
81 $rn=@mysql_query($qn);
82 $list = "<div>";
96function nameDef($defendant,$packet){
97 $r=@mysql_query("SELECT name".$defendant." from ps_packets WHERE packet_id='$packet'") or die (mysql_error());
98 $d=mysql_fetch_array($r,MYSQL_ASSOC);
102 $qh="SELECT action_str, serverID, address, wizard, resident, residentDesc FROM ps_history WHERE packet_id='$packet' AND defendant_id='$defendant' AND (WIZARD='BORROWER' OR WIZARD='NOT BORROWER')";
103 $rh=@mysql_query($qh) or die (mysql_error());
104 $dh=mysql_fetch_array($rh,MYSQL_ASSOC);
136 $qh="SELECT action_str, serverID FROM ps_history WHERE packet_id='$packet' AND defendant_id='$defendant' AND action_str LIKE '%$address%' AND WIZARD='$type'";
137 $rh=@mysql_query($qh) or die (mysql_error());
138 while ($dh=mysql_fetch_array($rh,MYSQL_ASSOC)){
ebpls_collection_summary.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 249 lines
101$datenext = $dateprev + 1;
102$lgu=mysql_query("select * from ebpls_buss_preference")
103 or die(mysql_error());
106
107 $result=@mysql_query("select * from ebpls_buss_tfo where taxfeetype='$taxtype'")
108 or die(mysql_error());
109// $resulta=mysql_fetch_array($result);
110$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[lguname]'");
111$getlgu = @mysql_fetch_row($getlgu);
111$getlgu = @mysql_fetch_row($getlgu);
112$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[lguprovince]'");
113$getprov = @mysql_fetch_row($getprov);
128$Y_Table_Position = 55;
129$resultpp=@mysql_query("select * from ebpls_buss_taxfeetype where taxfeetype='$taxtype'")
130 or die(mysql_error());
applicationforms.php https://bitbucket.org/mannir/agp.git | PHP | 173 lines
9if(isset($_REQUEST['from']) && isset($_REQUEST['to']) && isset($_REQUEST['sortby'])) { $fr=$_REQUEST['from']; $to=$_REQUEST['to']; $sb=$_REQUEST['sortby'];
10 $query = mysql_query("SELECT *,(select department from _programmes where _programmes.PROGRAMME=_application.programme1 LIMIT 1) AS department FROM `_application`
11WHERE id>='$fr' AND id<='$to' ORDER BY '$sb'"); $ar = array(); while($line = mysql_fetch_array($query, MYSQL_ASSOC)){ $ar[] = $line; }
15 $o = (object) mysqli_fetch_assoc(mysqli_query($con,"SELECT max(id) as mxid FROM _application")); $mxid=$o->mxid;
16$query = mysql_query("SELECT *,(select department from _programmes where _programmes.PROGRAMME=_application.programme1 LIMIT 1) AS department FROM `_application`
17WHERE id>=1 AND id<='$mxid'"); $ar = array(); while($line = mysql_fetch_array($query, MYSQL_ASSOC)){ $ar[] = $line; }
menu_tecnico.php https://bitbucket.org/joseluisroot/general.git | PHP | 210 lines
2include('../conexion/conexion_admin.php');
3$result = mysql_query("SELECT orden_trabajo.Id,
4 cliente.Codigo,
edit.php https://github.com/heidymadia/sfbackup.git | PHP | 54 lines
7$sql = "UPDATE `opportunities` SET `AccountId` = '{$_POST['AccountId']}' , `Amount` = '{$_POST['Amount']}' , `CampaignId` = '{$_POST['CampaignId']}' , `CloseDate` = '{$_POST['CloseDate']}' , `CreatedById` = '{$_POST['CreatedById']}' , `CreatedDate` = '{$_POST['CreatedDate']}' , `CurrentGenerators__c` = '{$_POST['CurrentGenerators__c']}' , `DeliveryInstallationStatus__c` = '{$_POST['DeliveryInstallationStatus__c']}' , `Description` = '{$_POST['Description']}' , `ExpectedRevenue` = '{$_POST['ExpectedRevenue']}' , `Fiscal` = '{$_POST['Fiscal']}' , `FiscalQuarter` = '{$_POST['FiscalQuarter']}' , `FiscalYear` = '{$_POST['FiscalYear']}' , `ForecastCategory` = '{$_POST['ForecastCategory']}' , `ForecastCategoryName` = '{$_POST['ForecastCategoryName']}' , `HasOpportunityLineItem` = '{$_POST['HasOpportunityLineItem']}' , `IsClosed` = '{$_POST['IsClosed']}' , `IsDeleted` = '{$_POST['IsDeleted']}' , `IsPrivate` = '{$_POST['IsPrivate']}' , `IsWon` = '{$_POST['IsWon']}' , `LastActivityDate` = '{$_POST['LastActivityDate']}' , `LastModifiedById` = '{$_POST['LastModifiedById']}' , `LastModifiedDate` = '{$_POST['LastModifiedDate']}' , `LeadSource` = '{$_POST['LeadSource']}' , `MainCompetitors__c` = '{$_POST['MainCompetitors__c']}' , `Name` = '{$_POST['Name']}' , `NextStep` = '{$_POST['NextStep']}' , `OrderNumber__c` = '{$_POST['OrderNumber__c']}' , `OwnerId` = '{$_POST['OwnerId']}' , `Pricebook2Id` = '{$_POST['Pricebook2Id']}' , `Probability` = '{$_POST['Probability']}' , `StageName` = '{$_POST['StageName']}' , `SystemModstamp` = '{$_POST['SystemModstamp']}' , `TotalOpportunityQuantity` = '{$_POST['TotalOpportunityQuantity']}' , `TrackingNumber__c` = '{$_POST['TrackingNumber__c']}' , `Type` = '{$_POST['Type']}' WHERE `id` = '$id' ";
8mysql_query($sql) or die(mysql_error());
9echo (mysql_affected_rows()) ? "Edited row.<br />" : "Nothing changed. <br />";
11}
12$row = mysql_fetch_array ( mysql_query("SELECT * FROM `opportunities` WHERE `id` = '$id' "));
13?>
mysql_backup.class.php https://github.com/holsinger/openfloor.git | PHP | 348 lines
79
80 $res2=mysql_query("select * from $tablename",$con);
81 $nf=mysql_num_fields($res2);
250 $sql = "SHOW TABLES FROM $dbname";
251 $result = mysql_query($sql);
252
262
263 $result2 = mysql_query("SHOW CREATE TABLE `".$row[0]."`");
264 $row2 = mysql_fetch_row($result2);
function.mysql-query.html git://pkgs.fedoraproject.org/kdewebdev | HTML | 496 lines
3><TITLE
4>mysql_query</TITLE
5><META
75></A
76>mysql_query</H1
77><DIV
83> (PHP 3, PHP 4 )</P
84>mysql_query -- Send a MySQL query</DIV
85><DIV
93CLASS="methodname"
94>mysql_query</B
95> ( string query [, resource link_identifier [, int result_mode]])<BR
99CLASS="function"
100>mysql_query()</B
101> sends a query to the currently
takeedit.php https://github.com/delete66/sikevux-s-tracker.git | PHP | 199 lines
67
68$select_torrent = mysql_query('SELECT * FROM torrents WHERE id = ' . sqlesc($id)) or sqlerr(__FILE__, __LINE__);
69$fetch_assoc = mysql_fetch_assoc($select_torrent) or stderr('Error', 'No torrent with this ID!');
192$updateset[] = 'multiplicator = ' . sqlesc($multiplicator);
193mysql_query('UPDATE torrents SET ' . implode(',', $updateset) . ' WHERE id = ' . sqlesc($id)) or sqlerr(__FILE__, __LINE__);
194
search.php http://mightmedia.googlecode.com/svn/trunk/ | PHP | 155 lines
47 if ($_POST['m'] == 'naujienos' || $_POST['m'] == 'vis' && isset($conf['puslapiai']['naujienos.php']['id'])) {
48 $sqlas3 = mysql_query1("SELECT * FROM `" . LENTELES_PRIESAGA . "naujienos` WHERE `pavadinimas` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' OR `naujiena` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' LIMIT 0,100") or die(klaida("Klaida", mysql_error()));
49 if (mysql_num_rows($sqlas3) > 0) {
57 if ($_POST['m'] == 'frmt' || $_POST['m'] == 'vis' && isset($conf['puslapiai']['frm.php']['id'])) {
58 $sqlas4 = mysql_query1("SELECT * FROM `" . LENTELES_PRIESAGA . "d_straipsniai` WHERE `pav` LIKE " . escape("%" . $_POST['s'] . "%") . "LIMIT 0,100") or die(klaida("Klaida", mysql_error()));
59 if (mysql_num_rows($sqlas4) > 0) {
67 if ($_POST['m'] == 'frm' || $_POST['m'] == 'vis' && isset($conf['puslapiai']['frm.php']['id'])) {
68 $sqlas5 = mysql_query1("SELECT * FROM `" . LENTELES_PRIESAGA . "d_zinute` WHERE `zinute` LIKE " . escape("%" . $_POST['s'] . "%") . "LIMIT 0,100") or die(klaida("Klaida", mysql_error()));
69 if (mysql_num_rows($sqlas5) > 0) {
78 if ($_POST['m'] == 'str' || $_POST['m'] == 'vis' && isset($conf['puslapiai']['straipsnis.php']['id'])) {
79 $sqlas6 = mysql_query1("SELECT * FROM `" . LENTELES_PRIESAGA . "straipsniai` WHERE `t_text` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' or `f_text` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' or `pav` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' LIMIT 0,100") or die(klaida("Klaida", mysql_error()));
80 if (mysql_num_rows($sqlas6) > 0) {
89 if ($_POST['m'] == 'siunt' || $_POST['m'] == 'vis' && isset($conf['puslapiai']['siustis.php']['id'])) {
90 $sqlas7 = mysql_query1("SELECT * FROM `" . LENTELES_PRIESAGA . "siuntiniai` WHERE `pavadinimas` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' or `apie` LIKE " . escape("%" . $_POST['s'] . "%") . " AND `rodoma`='TAIP' LIMIT 0,100") or die(klaida("Klaida", mysql_error()));
91 if (mysql_num_rows($sqlas7) > 0) {
update_cpc.php https://github.com/ClickBooth/XTracks.git | PHP | 226 lines
37 $aff_network_sql = "SELECT * FROM 202_aff_networks WHERE aff_network_id='".$mysql['aff_network_id']."' AND user_id='".$mysql['user_id']."'";
38 $aff_network_result = mysql_query($aff_network_sql) or record_mysql_error($aff_network_sql);
39 $aff_network_row = mysql_fetch_assoc($aff_network_result);
52 $aff_campaign_sql = "SELECT * FROM 202_aff_campaigns WHERE aff_campaign_id='".$mysql['aff_campaign_id']."' AND user_id='".$mysql['user_id']."'";
53 $aff_campaign_result = mysql_query($aff_campaign_sql) or record_mysql_error($aff_campaign_sql);
54 $aff_campaign_row = mysql_fetch_assoc($aff_campaign_result);
67 $text_ad_sql = "SELECT * FROM 202_text_ads WHERE text_ad_id='".$mysql['text_ad_id']."' AND user_id='".$mysql['user_id']."'";
68 $text_ad_result = mysql_query($text_ad_sql) or record_mysql_error($text_ad_sql);
69 $text_ad_row = mysql_fetch_assoc($text_ad_result);
96 $landing_page_sql = "SELECT * FROM 202_landing_pages WHERE landing_page_id='".$mysql['landing_page_id']."' AND user_id='".$mysql['user_id']."'";
97 $landing_page_result = mysql_query($landing_page_sql) or record_mysql_error($landing_page_sql);
98 $landing_page_row = mysql_fetch_assoc($landing_page_result);
114 $ppc_network_sql = "SELECT * FROM 202_ppc_networks WHERE ppc_network_id='".$mysql['ppc_network_id']."' AND user_id='".$mysql['user_id']."'";
115 $ppc_network_result = mysql_query($ppc_network_sql) or record_mysql_error($ppc_network_sql);
116 $ppc_network_row = mysql_fetch_assoc($ppc_network_result);
detaillegal.php https://bitbucket.org/Iowane_Tamani/feejeetrav.git | PHP | 400 lines
7}else{
8//$fetch_users_data = mysql_fetch_object(mysql_query("SELECT * FROM `members` WHERE username='".$_SESSION['username']."'"));
9}
useradmin.php https://gitlab.com/jack/senegad.git | PHP | 439 lines
69
70 $result = mysql_query($sql) or die(mysql_error());
71 $row = mysql_fetch_row($result);
210
211 $result = mysql_query($sql) or die(mysql_error());
212 $row = mysql_fetch_row($result);
219 $sql .= "userlevel='$ulevel', email='$email'";
220 mysql_query($sql) or die(mysql_error());
221
239 $sql .= "lname='$lname', userlevel='$ulevel', email='$email' WHERE username='$uname'";
240 mysql_query($sql) or die(mysql_error());
241
256 $sql = "DELETE FROM " . DB_TABLE_PREFIX . "users WHERE uid='$id'";
257 mysql_query($sql) or die(mysql_error());
258 }