100+ results results for 'mysql_query' (150 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 ") ;
ebpls_ctc_issued.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 214 lines
82
83 $result=@mysql_query("select lguname, lguprovince from ebpls_buss_preference")
84 or die(mysql_error());
85 $resulta=mysql_fetch_row($result);
86$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'");
87$getlgu = @mysql_fetch_row($getlgu);
87$getlgu = @mysql_fetch_row($getlgu);
88$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'");
89$getprov = @mysql_fetch_row($getprov);
115$date_to = date('Y-m-d', $xdate);
116 $result1=mysql_query("select concat(ctc_first_name, ' ', ctc_middle_name, ' ', ctc_last_name) as name, ctc_code,
117 ctc_address, ctc_date_issued, ctc_tax_due, ctc_tax_interest, ctc_additional_tax1, ctc_additional_tax2, ctc_additional_tax3 from ebpls_ctc_individual where ctc_date_issued between '$date_from' and '$date_to' order by name asc")
119 $x1 = @mysql_num_rows($result1);
120 $result2=mysql_query("select ctc_company, ctc_code, ctc_company_address, ctc_date_issued, ctc_tax_due, ctc_tax_interest, ctc_additional_tax1, ctc_additional_tax2 from ebpls_ctc_business where ctc_date_issued between '$date_from' and '$date_to' order by ctc_company asc")
121 or die(mysql_error());
Database.singleton.php https://code.google.com/p/gctour/ | PHP | 311 lines
132 // do query
133 $this->query_id = @mysql_query($sql, $this->link_id);
134
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
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;
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
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;
task.php http://airscore.googlecode.com/svn/trunk/ | PHP | 430 lines
37 $sql = "select T.*, TW.* from tblTask T left outer join tblTaskWaypoint TW on T.tasPk=TW.tasPk and TW.tawType='goal' where T.tasPk=$tasPk";
38 $result = mysql_query($sql,$link)
39 or die('Task not associated correctly with a competition: ' . mysql_error());
73 $query = "select traPk from tblComTaskTrack where tasPk=$tasPk";
74 $result = mysql_query($query,$link);
75 $tracks = array();
98$query = "select comPk from tblTask where tasPk=$tasPk";
99$result = mysql_query($query) or die('Task not associated with a competition: ' . mysql_error());
100$comPk = mysql_result($result,0,0);
121 $query = "insert into tblTaskAirspace (tasPk, airPk) values ($tasPk, $airPk)";
122 $result = mysql_query($query) or die('Failed to connect airspace to task ' . mysql_error());
123}
130 $query = "delete from tblTaskAirspace where taPk=$taPk";
131 $result = mysql_query($query) or die('Failed to delete airspace association ' . mysql_error());
132 }
index.php http://clients-oriented-ftp.googlecode.com/svn/trunk/ | PHP | 308 lines
20 foreach ($query as $i => $value) {
21 $result = mysql_query($query[$i]);
22 if (mysql_error()) {
themes.php http://novaboard.googlecode.com/svn/trunk/ | PHP | 487 lines
103
104mysql_query("UPDATE {$db_prefix}settings SET theme_order='$order', theme_limit='$limit', theme_method='$method'");
105
217
218mysql_query("DELETE FROM {$db_prefix}themes WHERE theme_name ='$theme_name'");
219
219
220mysql_query("INSERT INTO {$db_prefix}themes (theme_name, installed) VALUES ('$theme_name', '1')");
221
273
274mysql_query("DELETE FROM {$db_prefix}themes WHERE theme_name ='$theme_name'");
275
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);
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;
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);
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))
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);
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' " .
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))
Sections.php https://code.google.com/p/nuked-klan/ | PHP | 161 lines
63
64 $sql = mysql_query("SELECT secid, secname FROM " . SECTIONS_CAT_TABLE . " WHERE parentid = 0 ORDER BY position, secname");
65 while (list($secid, $titre) = mysql_fetch_array($sql))
75
76 $sql2 = mysql_query("SELECT secid, secname FROM " . SECTIONS_CAT_TABLE . " WHERE parentid = '" . $secid . "' ORDER BY position, secname");
77 while (list($s_cid, $s_titre) = mysql_fetch_array($sql2))
148
149 $upd = mysql_query("INSERT INTO " . SECTIONS_TABLE . " ( `artid` , `secid` , `title` , `content` , `autor` , `autor_id`, `counter` , `date` ) VALUES ( '' , '" . $data['secid'] . "' , '" . $data['title'] . "' , '" . $data['texte'] . "' , '" . $autor . "' , '" . $autor_id . "' , '' , '" . $date. "' )");
150 $sql2 = mysql_query("SELECT artid FROM " . SECTIONS_TABLE . " WHERE title = '" . $data['title'] . "' AND date='".$date."'");
insert_moduli.php https://code.google.com/p/bilugcms/ | PHP | 174 lines
64 $str=" SELECT titolo, titvideo, modulo, posizione, attivo, zona, ordine, titvideo_en, titvideo_fr, titvideo_de, titvideo_es, titvideo_pt FROM moduli where ID = $id LIMIT 1";
65 $risultato=mysql_query($str);
66 if (mysql_num_rows($risultato)>0)
146 $str1=" SELECT titolo,ordine FROM moduli order by ordine";
147 $risultato1=mysql_query($str1);
148 if (mysql_num_rows($risultato1)>0)
161 $str1=" SELECT max(ordine) FROM moduli";
162 $risultato1=mysql_query($str1);
163 $var = mysql_fetch_row($risultato1);
studentfeed_lookup_questions.php https://code.google.com/p/classroom-presenter/ | PHP | 346 lines
32
33 $voteresults = mysql_query($votequery, $db_conn);
34 if (!$voteresults)
96 }
97 $results = mysql_query($query, $db_conn);
98 if (!$results)
134 // Run the query and fetch the results
135 $results = mysql_query($query, $db_conn);
136 if (!$results)
176 // Run the query and fetch the results
177 $results = mysql_query($query, $db_conn);
178 if (!$results)
212 // Run the query and fetch the results
213 $results = mysql_query($query, $db_conn);
214 if (!$results)
privatemessages.php http://mxprojects.googlecode.com/svn/trunk/ | PHP | 280 lines
91 //fire it off
92 $result = mysql_query("UPDATE ".TABLE_PREFIX."_private SET ".$userType."Status = ".$statusToUpdate." WHERE messageID = ".$id);
93
100 if($statusToUpdate == PM_DELETE_MESSAGE){
101 $result = mysql_query("DELETE FROM ".TABLE_PREFIX."_private
102 WHERE messageID = ".$id."
160 // Build query to fetch the PMs
161 $result = mysql_query("SELECT SQL_CALC_FOUND_ROWS p.*, u.username
162 FROM ".TABLE_PREFIX."_users u, ".TABLE_PREFIX."_private p
172 //get the total PMs
173 $totalResult = mysql_query("SELECT FOUND_ROWS() AS totalMessages");
174 if(!$totalResult){
223 //get the userID of the person we are sending this to (and a current count of the PMs they have)
224 $result = mysql_query("SELECT COUNT(p.recipientID) AS currentMessages
225 FROM ".TABLE_PREFIX."_private 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);
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);
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
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)){
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);
merge_dico.inc http://twpug.googlecode.com/svn/trunk/ | PHP | 209 lines
94//As well as terms that where left for translation
95mysql_query("DELETE FROM sugar_terms WHERE lang = 'TRX' and version_id='$version_id' ");
96mysql_query("DELETE FROM sugar_lang_trx where trx = ''");
156 $query .= implode("),(", $sql_values).")";
157 mysql_query($query) or die("<SPAN class=msg-err>A mysql error occured : ".mysql_error()."</SPAN>");
158}
161$lang_pack_name = $trxMnf->get("name");
162mysql_query("UPDATE sugar_terms SET text = '$html_charset' where version_id = $version_id and lang = 'TRX' and array_id = 'app_strings' and label_id = 'LBL_CHARSET'");
163mysql_query("UPDATE sugar_terms SET text = '$lang_pack_name' where version_id = $version_id and lang = 'TRX' and array_id = 'app_list_strings' and label_id = 'language_pack_name'");
178 $query .= implode("),(", $sql_values).")";
179 mysql_query($query) or die("<SPAN class=msg-err>A mysql error occured : ".mysql_error()."</SPAN>");
180}
Utente.class.php http://antilophpe.googlecode.com/svn/ | PHP | 373 lines
276 WHERE ant_Utente.id = ".$this->getId()."";
277 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Utente`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
278 while($user_array=mysql_fetch_array($result)){
299 AND ant_Utente_File.tableObject='ant_Utente'";
300 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Utente_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
301 $filesList=array();
315 WHERE ant_Utente_File.id='$fileId'";
316 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection file in table `ant_Utente_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
317 $user_File_array=mysql_fetch_assoc($result);
329 AND ant_Utente_File.tableObject='ant_Utente'";
330 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Utente_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
331 $user_File_array=mysql_fetch_array($result);
341 FROM ant_Utente_Log";
342 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during select count from table `ant_Utente_Log`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
343 $user_Log_array=mysql_fetch_array($result);
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());
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) {
ebpls_motor_permit.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 346 lines
12
13 $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error());
14 $resultsa=mysql_fetch_row($result);
14 $resultsa=mysql_fetch_row($result);
15$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resultsa[0]'");
16$getlgu = @mysql_fetch_row($getlgu);
16$getlgu = @mysql_fetch_row($getlgu);
17$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resultsa[1]'");
18$getprov = @mysql_fetch_row($getprov);
49
50 $result = mysql_query("select concat(a.owner_first_name, ' ', a.owner_middle_name, ' ', a.owner_last_name),
51 b.motorized_motor_model, b.motorized_motor_no, b.motorized_chassis_no, b.motorized_plate_no, b.motorized_body_no,
61
62 $result = mysql_query("select concat(a.owner_first_name, ' ', a.owner_middle_name, ' ', a.owner_last_name),
63 b.motorized_motor_model, b.motorized_motor_no, b.motorized_chassis_no, b.motorized_plate_no, b.motorized_body_no,
ebpls_fish_permit.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 298 lines
9
10 $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error());
11 $resulta=mysql_fetch_row($result);
11 $resulta=mysql_fetch_row($result);
12$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'");
13$getlgu = @mysql_fetch_row($getlgu);
13$getlgu = @mysql_fetch_row($getlgu);
14$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'");
15$getprov = @mysql_fetch_row($getprov);
30if ($reportpermit == '1') {
31$result = mysql_query("select concat(a.owner_first_name, ' ', a.owner_middle_name, ' ', a.owner_last_name),
32 concat(a.owner_street, ', ', d.zone_desc, ', ', e.barangay_desc, ', ', f.district_desc, ', ', g.city_municipality_desc, ', ',
37} else {
38 $result = mysql_query("select concat(a.owner_first_name, ' ', a.owner_middle_name, ' ', a.owner_last_name),
39 concat(a.owner_street, ', ', d.zone_desc, ', ', e.barangay_desc, ', ', f.district_desc, ', ', g.city_municipality_desc, ', ',
lstof_duedates-inc.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 303 lines
9 //exit;
10 $xRecord = mysql_query("UPDATE ebpls_buss_penalty1 SET revdate=Now(), mdue='$iMonthlyDueDates' ",$dbLink);
11
32
33 $xRecord = mysql_query("UPDATE ebpls_buss_penalty1 SET revdate=Now(), qtrdue1='$qtr1iMonthlyDueDates', qtrdue2='$qtr2iMonthlyDueDates', qtrdue3='$qtr3iMonthlyDueDates', qtrdue4='$qtr4iMonthlyDueDates' ",$dbLink);
34
52 } else {
53 $xRecord = mysql_query("UPDATE ebpls_buss_penalty1 SET revdate=Now(), semdue1='$sem1iMonthlyDueDates', semdue2='$sem2iMonthlyDueDates'",$dbLink);
54
62
63$seleRecord = mysql_query("SELECT * FROM ebpls_buss_penalty1 ",$dbLink);
64//$SeleRecord=th_query($seleRecord);
ebpls_professional_tax.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 345 lines
8
9 $result=mysql_query("select lgumunicipality, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error());
10 $resulta=mysql_fetch_row($result);
24
25 $result=mysql_query("select a.business_permit_code, concat(c.owner_first_name, ' ', c.owner_middle_name, ' ',
26 c.owner_last_name), b.business_name, e.bus_nature, b.business_street, e.cap_inv, e.last_yr, d.total_amount_paid,
151
152// $result=mysql_query("select gs_name, gs_pos, gs_office from global_sign where sign_id =1") or die(mysql_error());
153// $resulta=mysql_fetch_row($result);
212
213 $result=mysql_query("select lgumunicipality, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error());
214 $resulta=mysql_fetch_row($result);
228 /*
229 $result=mysql_query("select '0000', '0.00', '0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00' from ebpls_business_enterprise")
230 or die(mysql_error());
deleteorganization2.php http://ndepics-redcross.googlecode.com/svn/trunk/ | PHP | 72 lines
30 LIMIT 1";
31$result = mysql_query($query) or die ("Deletion Query failed (organization)");
32
36 WHERE organization_id = ".$organization_id;
37$result = mysql_query($query) or die ("Deletion Query 2 failed (works_for)");
38
42 WHERE organization_id = ".$organization_id;
43$result = mysql_query($query) or die ("Deletion Query 3 failed (resrouce_listing)");
44
48 WHERE organization_id = ".$organization_id;
49$result = mysql_query($query) or die ("Deletion Query 4 failed (SoU)");
50
54 WHERE organization_id = ".$organization_id;
55$result = mysql_query($query) or die ("Deletion Query 5 failed (facility_survey) IGNORE THIS");
56
fonctionsClients.php http://auberge-de-jeunesse-de-rimouski.googlecode.com/svn/trunk/ | PHP | 251 lines
19 connectDb();
20 $requete = mysql_query("SELECT id_client from Client WHERE id_client='".mysql_real_escape_string($_SESSION['idClient'])."'");
21 $ligne = mysql_fetch_row($requete);
37 connectDb();
38 $requete = mysql_query("SELECT nom_cl FROM Client WHERE id_client='".mysql_real_escape_string($ipNoClient)."'");
39 $ligne = mysql_fetch_row($requete);
53 connectDb();
54 $requete = mysql_query("SELECT prenom_cl FROM Client WHERE id_client='".mysql_real_escape_string($ipNoClient)."'");
55 $ligne = mysql_fetch_row($requete);
69 connectDb();
70 $requete = mysql_query("SELECT tarif FROM Tarif_lit t, Facture f WHERE t.id_tarif = f.id_tarif AND f.id_facture='".mysql_real_escape_string($ipNoFacture)."'");
71 $ligne = mysql_fetch_row($requete);
85 connectDb();
86 $reqNoFacture = mysql_query("SELECT id_facture FROM facture WHERE id_reservation='".mysql_real_escape_string($ipNoReservation)."'");
87 $ligneNoFacture = mysql_fetch_row($reqNoFacture);
process_registration.php git://github.com/aichallenge/aichallenge.git | PHP | 312 lines
15 $query = "SELECT * FROM user_status_code WHERE status_id = ".(int)$code;
16 $result = mysql_query($query);
17 return (boolean)mysql_num_rows($result);
24 $query = "SELECT * FROM organization WHERE org_id=".(int)$code;
25 $result = mysql_query($query);
26 return (boolean)mysql_num_rows($result);
33 $query = "SELECT count(*) from country where country_id=". $id;
34 $result = mysql_query($query);
35 $row = mysql_fetch_assoc($result);
53 $query = "SELECT org_id FROM organization WHERE name='".$org_name."'";
54 $result = mysql_query($query);
55 if ( mysql_num_rows($result) > 0 ) {
58 $query = "INSERT INTO organization (`name`) VALUES('".$org_name."')";
59 $result = mysql_query($query);
60 return mysql_insert_id();
Db_Mysql.php http://slightphp.googlecode.com/svn/trunk/ | PHP | 471 lines
389 if(!empty($this->charset)){
390 mysql_query("SET NAMES ".$this->charset);
391 }
400 }
401 $result = mysql_query($sql,Db_Mysql::$globals[$this->key]);
402 if(!$result){
main.php https://code.google.com/p/bilugcms/ | PHP | 121 lines
23 $stringa="SELECT ID,sez,voce FROM menu order by sez";
24 $risulta=mysql_query($stringa);
25 if (mysql_num_rows($risulta)>0)
31 $str1="SELECT voce,link,stat FROM menuvoci where IDmenu='$control[0]' order by ordine";
32 $risultato1=mysql_query($str1);
33 if (mysql_num_rows($risultato1)>0)
insert_datirss.php https://code.google.com/p/bilugcms/ | PHP | 83 lines
34$str=" SELECT ID,titolo,descrizione,copyright,image,vimage FROM datirss ";
35$risultato=mysql_query($str);
36if (mysql_num_rows($risultato)>0)
cadastroProtocolo.php http://controlprot.googlecode.com/svn/trunk/ | PHP | 285 lines
57 where A.codProtocolo ='".$_SESSION['codProtocolo']."'";
58 $resultado = mysql_query($sql) or die ("erro sql".mysql_error());
59 $total = mysql_num_rows($resultado);
101 $sql2 = "select * from protocolo order by codProtocolo desc limit 1 ";//busca o ultimo cod que est? no banco
102 $resultado2 = mysql_query($sql2) or die ("erro sqlGravarCabecalho".mysql_error());
103 $dado2 = mysql_fetch_assoc($resultado2);
107$sql = "INSERT INTO protocolo (codProtocolo,dataCriacao,status,codUsuario,codEmpresa,quantidadeContratos) VALUES ('$codProtocolo',now(),'A','".$_SESSION['codUsuarioIndex']."','".$_SESSION['codEmpresaIndex']."','0')";
108 $resultadosql = mysql_query($sql) or die ("erro sql GravarCabecalho 2".mysql_error());
109}
142
143 $resultado_ver = mysql_query($sql_ver);
144 $linha_ver = mysql_num_rows($resultado_ver);
169 VALUES ('".$_SESSION['cpfCnpjCliente']."','".$_SESSION['nome']."','N','".$_SESSION['codProtocolo']."','".$_SESSION['obs']."')";
170 $resultadosql = mysql_query($sql) or die ("erro sql gravarItemProtocolo".mysql_error());
171 }
manage_apps.php http://decs.googlecode.com/svn/trunk/ | PHP | 251 lines
22
23$result = mysql_query("SELECT * FROM platform");
24$Nplatform = mysql_num_rows($result);
41
42 $result = mysql_query("SELECT * FROM app");
43 $Nrow=mysql_num_rows($result);
53 $commands .= "<P><pre>$cmd</pre>\n";
54 mysql_query($cmd);
55 continue; // next row, this one is gone
64 $commands .= "<P><pre>$cmd</pre>\n";
65 mysql_query($cmd);
66 }
74 $commands .= "<P><pre>$cmd</pre>\n";
75 mysql_query($cmd);
76 }
GetArt.php http://thegamesdb.googlecode.com/svn/trunk/ | PHP | 224 lines
53 ## Select all fanart rows for the requested game id
54 $ssResult = mysql_query(" SELECT filename FROM banners WHERE keyvalue = $gameID AND keytype = 'screenshot' ORDER BY filename ASC ");
55
94 ## Select all fanart rows for the requested game id
95 $faResult = mysql_query(" SELECT filename FROM banners WHERE keyvalue = $gameID AND keytype = 'fanart' ORDER BY filename ASC ");
96
130 ## Select all boxart rows for the requested game id
131 $baResult = mysql_query(" SELECT filename FROM banners WHERE keyvalue = $gameID AND keytype = 'boxart' ORDER BY filename ASC ");
132
157 ## Select all boxart rows for the requested game id
158 $banResult = mysql_query(" SELECT filename FROM banners WHERE keyvalue = $gameID AND keytype = 'series' ORDER BY filename ASC ");
159
177 ## Select all boxart rows for the requested game id
178 $clResult = mysql_query(" SELECT filename, resolution FROM banners WHERE keyvalue = $gameID AND keytype = 'clearlogo' LIMIT 1 ");
179
mysql.php git://github.com/jakubkulhan/shopaholic.git | PHP | 518 lines
122 if (!$ok) {
123 $ok = @mysql_query("SET NAMES '$config[charset]'", $this->connection); // intentionally @
124 if (!$ok) {
136 if (isset($config['sqlmode'])) {
137 if (!@mysql_query("SET sql_mode='$config[sqlmode]'", $this->connection)) { // intentionally @
138 throw new DibiDriverException(mysql_error($this->connection), mysql_errno($this->connection));
166 if ($this->buffered) {
167 $this->resultSet = @mysql_query($sql, $this->connection); // intentionally @
168 } else {
index.php http://ourproject.googlecode.com/svn/trunk/ | PHP | 363 lines
135 if(mysql_get_server_info() > '4.1') {
136 mysql_query("CREATE DATABASE `$dbname` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci", $conn);
137 $dbsql=@mysql_select_db($dbname);
143
144 mysql_query("set names 'GBK'");
145
153 $sql=str_replace("\r\n","",$v);
154 mysql_query($sql)or die(mysql_error());
155 }
161 $sql=str_replace("\r\n","",$v);
162 mysql_query($sql) or die(mysql_error());
163 }
166 $table_config=$tablepre."admin_config";
167 mysql_query("insert into $table_user values (null,'1','$username','$password','$name')");
168 mysql_query("update $table_config set `config`='$weburl' where `name`='sy_weburl'");
files.public.list.tmpl.php http://phpwcms.googlecode.com/svn/trunk/ | PHP | 181 lines
43
44 mysql_query("UPDATE ".DB_PREPEND."phpwcms_user SET usr_var_publicfile="._dbEscape(serialize($_SESSION["pklapp"]))." WHERE usr_id=".$_SESSION["wcs_user_id"], $db);
45
51$sql = "SELECT COUNT(f_id) FROM ".DB_PREPEND."phpwcms_file WHERE f_public=1 AND f_aktiv=1 AND f_trash=0 LIMIT 1;";
52if($result = mysql_query($sql, $db) or die ("error while counting user files")) {
53 if($row = mysql_fetch_row($result)) {
69
70 if($result = mysql_query($sql, $db) or die ("error while browsing user's public files")) {
71 $user_counter=0;
105 " AND f_public=1 AND f_aktiv=1 AND f_kid=1 AND f_trash=0 ORDER BY f_name;";
106 if($file_result = mysql_query($file_sql, $db) or die ("error while listing files")) {
107 $file_durchlauf = 0;
main.php https://code.google.com/p/nuked-klan/ | PHP | 226 lines
32{
33 $sql_cat = mysql_query("SELECT nom FROM " . FORUM_CAT_TABLE . " WHERE id = '" . $_REQUEST['cat'] . "'");
34 list($cat_name) = mysql_fetch_row($sql_cat);
66{
67 $main = mysql_query("SELECT nom, id FROM " . FORUM_CAT_TABLE . " WHERE '" . $visiteur . "' >= niveau AND id = '" . $_REQUEST['cat'] . "'");
68}
70{
71 $main = mysql_query("SELECT nom, id FROM " . FORUM_CAT_TABLE . " WHERE " . $visiteur . " >= niveau ORDER BY ordre, nom");
72}
79
80 $sql = mysql_query("SELECT nom, comment, id from " . FORUM_TABLE . " WHERE cat = '" . $cid . "' AND '" . $visiteur . "' >= niveau ORDER BY ordre, nom");
81 while (list($nom, $comment, $forum_id) = mysql_fetch_row($sql))
85
86 $req2 = mysql_query("SELECT forum_id from " . FORUM_THREADS_TABLE . " WHERE forum_id = '" . $forum_id . "'");
87 $num_post = mysql_num_rows($req2);
soap_sis_laporan_keuangan.php http://sistem-informasi-sekolah-online.googlecode.com/svn/trunk/ | PHP | 267 lines
28
29 $result = mysql_query($sql);
30
59
60 $result = mysql_query($sql);
61
90
91 $result = mysql_query($sql);
92
122
123 $result = mysql_query($sql);
124
154
155 $result = mysql_query($sql);
156
ecommerce.php https://code.google.com/p/bilugcms/ | PHP | 414 lines
131 $homepage = "SELECT id FROM parametri WHERE valore = './html/ecommerce.php' AND nomecampo = '_CORPO' LIMIT 1";
132 $rshomepage = mysql_query( $homepage );
133 $home = mysql_num_rows( $rshomepage );
174 $sql = "SELECT categoria FROM ecommercecategoria WHERE id = $cat AND id_lingua = $id_lingua LIMIT 1";
175 $rssql = mysql_query( $sql );
176 $h_cat = mysql_result( $rssql, 0, 0 );
191 $sql = "SELECT articoli FROM ecommerceris WHERE ID = '$idut' LIMIT 1";
192 $rssql = mysql_query($sql);
193 $articoli_ris = mysql_result($rssql, 0, 0);
213 ";
214 $ris = mysql_query( $query );
215 $max = mysql_num_rows( $ris );
234 ";
235 $ris = mysql_query( $query );
236 $max = mysql_num_rows( $ris );
libdb.php http://jqian.googlecode.com/svn/trunk/ | PHP | 138 lines
69 // do query
70 $this->query_id = @mysql_query($sql, $this->link_id);
71 if (!$this->query_id) {
menu.php https://gestion001.svn.codeplex.com/svn | PHP | 117 lines
28 // echo $query_RsMenu;
29 $RsMenu = mysql_query($query_RsMenu, CONEXION) or trigger_error(mysql_error(''), E_USER_ERROR);
30 $row_RsMenu = mysql_fetch_assoc($RsMenu);
40 // echo $query_RsSubMenu;
41 $RsSubMenu = mysql_query($query_RsSubMenu, CONEXION) or trigger_error(mysql_error(), E_USER_ERROR);
42 $row_RsSubMenu = mysql_fetch_assoc($RsSubMenu);
54 // echo $query_RsItem;
55 $RsItem = mysql_query($query_RsItem, CONEXION) or trigger_error(mysql_error(), E_USER_ERROR);
56 $row_RsItem = mysql_fetch_assoc($RsItem);
boleto.php http://ymscorp.googlecode.com/svn/trunk/ | PHP | 130 lines
6
7$gwresult = mysql_query("SELECT * FROM tblpaymentgateways WHERE gateway='boleto'");
8while($data = mysql_fetch_array($gwresult)) {
14$query = "SELECT * FROM tblinvoices WHERE id='$invoiceid'";
15$result=mysql_query($query);
16$data = mysql_fetch_array($result);
db.class.php http://timoseven.googlecode.com/svn/trunk/ | PHP | 417 lines
41 mysql_errno () != 0 && $this->halt ( "Connect($pconnect) to MySQL failed" );
42 mysql_query ( "SET character_set_connection=" . $this->charset . ", character_set_results=" . $this->charset . ", character_set_client=binary" );
43 mysql_query ( "SET NAMES " . $this->charset );
78 } else {
79 $query = mysql_query ( $sql );
80 }
114 } else {
115 $query = mysql_query ( $sql );
116 }
MySQLDump.class.php http://openbiz-cubi.googlecode.com/svn/trunk/ | PHP | 103 lines
17 if($charset) {
18 @mysql_query("SET NAMES '$charset';");
19 $this->mysql_error = mysql_error();
32 $this->tables = array();
33 $sql = mysql_query("SHOW FULL TABLES");
34 while ($row = mysql_fetch_array($sql)) {
57 function list_values($tablename) {
58 $sql = mysql_query("SELECT * FROM `$tablename`");
59 $this->output .= "\n\n-- Dumping data for table: `$tablename`\n\n";
86 }
87 $sql = mysql_query("SHOW CREATE VIEW `$tablename`");
88 $this->output .= mysql_result($sql, 0, 'Create View').';'; //" PRIMARY KEY (`$primary`)\n);\n";
96
97 $sql = mysql_query("SHOW CREATE TABLE `$tablename`");
98 $this->output .= mysql_result($sql, 0, 'Create Table').';'; //" PRIMARY KEY (`$primary`)\n);\n";
index.php http://showslow.googlecode.com/svn/trunk/ | PHP | 228 lines
12 );
13 $result = mysql_query($query);
14
27
28 if (!mysql_query($query))
29 {
125
126 if (!mysql_query($query))
127 {
191
192 if (!mysql_query($query))
193 {
paginar.php http://cachoncr.googlecode.com/svn/trunk/ | PHP | 253 lines
147
148$rs = mysql_query($ssql,$conn);
149
158
159 $resultado=mysql_query($strselect,$conn);
160
163
164 $consulta = mysql_query($strselect);
165 $totalfilas= mysql_num_rows($consulta);
insert_sotmenu_link.php https://code.google.com/p/bilugcms/ | PHP | 216 lines
37$str = "SELECT titolo, tipo FROM menutipo WHERE id = '$id' LIMIT 1";
38$risultato = mysql_query($str);
39if ( mysql_num_rows($risultato) > 0 )
66 $strs=" SELECT titolo, argomento, ID FROM notizie WHERE autorizza='si' ORDER BY argomento";
67 $risultatos=mysql_query($strs);
68 $argomento=0;
77 $str1s=" SELECT argomenti FROM argomenti WHERE ID = '$controls[1]' LIMIT 1";
78 $risultato2s=mysql_query($str1s);
79 $control1s=mysql_fetch_row($risultato2s);
102 $stat=" SELECT id, titolo FROM statiche ORDER BY ordine";
103 $ristat=mysql_query($stat);
104 while($statiche=mysql_fetch_row($ristat)) {
120 $sql = "SELECT id, cartella FROM galleria WHERE id_padre = 0 ORDER BY cartella DESC";
121 $rssql = mysql_query( $sql );
122 if ( mysql_num_rows( $rssql ) > 0 ) {
ebpls_bus_masterlist.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 288 lines
10
11$bgy = mysql_query("select * from ebpls_barangay where barangay_code='$brgy_name'");
12$bgy = mysql_fetch_assoc($bgy);
94
95 $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference")
96 or die(mysql_error());
97 $resulta=mysql_fetch_row($result);
98$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'");
99$getlgu = @mysql_fetch_row($getlgu);
99$getlgu = @mysql_fetch_row($getlgu);
100$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'");
101$getprov = @mysql_fetch_row($getprov);
154 if ($trans == 'Retire') {
155 $result = mysql_query ("select distinct (c.business_permit_code) as pid, a.business_name,
156 concat(a.business_lot_no, ' ', a.business_street, ' ', f.barangay_desc, ' ',
uotd.inc http://decs.googlecode.com/svn/trunk/ | PHP | 182 lines
62 }
63 $result = mysql_query($query);
64
84 //
85 $result = mysql_query("SELECT * FROM profile,user WHERE profile.userid=user.id AND verification=1 ORDER BY uotd_time ASC LIMIT 1");
86 }
96 $sql = "UPDATE profile SET uotd_time = ".time()." WHERE userid=$user->id";
97 mysql_query($sql);
98
140
141 $result = mysql_query($query);
142 if($result) {
ebpls_activity_log1.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 182 lines
74
75 $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error());
76 $resulta=mysql_fetch_row($result);
76 $resulta=mysql_fetch_row($result);
77 $getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'");
78$getlgu = @mysql_fetch_row($getlgu);
78$getlgu = @mysql_fetch_row($getlgu);
79$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'");
80$getprov = @mysql_fetch_row($getprov);
135$date_to = date('Y-m-d', $xdate);
136/* $result=mysql_query("select userid, userlevel, username, action, remoteip, lastupdated
137 from ebpls_activity_log where lastupdated between '$date1' and '$date2' ") or die(mysql_error());
138*/
139 $result=mysql_query("select userid, userlevel, username, action, remoteip, lastupdated,querystring from ebpls_activity_log where
140 username like '$owner_last%' and lastupdated between '$date_from' and '$date_to'") or die(mysql_error());
competition.php http://airscore.googlecode.com/svn/trunk/ | PHP | 327 lines
16$query = "select comName from tblCompetition where comPk=$comPk";
17$result = mysql_query($query) or die('Task add failed: ' . mysql_error());
18$comName = mysql_result($result,0);
39 $query = "insert into tblTask (comPk, tasName, tasDate, tasTaskStart, tasFinishTime, tasStartTime, tasStartCloseTime, tasSSInterval, tasTaskType, regPk, tasDeparture, tasArrival) values ($comPk, '$Name', '$Date', '$Date $TaskStart', '$Date $TaskFinish', '$Date $StartOpen', '$Date $StartClose', $Interval, '$TaskType', $regPk, '$depart', '$arrival')";
40 $result = mysql_query($query) or die('Task add failed: ' . mysql_error());
41
48 $query = "select CTT.traPk from tblComTaskTrack CTT, tblTask T, tblTrack TR, tblCompetition C where CTT.comPk=$comPk and C.comPk=CTT.comPk and T.tasPk=$tasPk and CTT.traPk=TR.traPk and CTT.tasPk is null and TR.traStart > date_sub(T.tasDate, interval C.comTimeOffset hour) and TR.traStart < date_add(T.tasDate, interval (24-C.comTimeOffset) hour)";
49 $result = mysql_query($query,$link);
50 $tracks = array();
59 $sql = "update tblComTaskTrack set tasPk=$tasPk where comPk=$comPk and traPk in (" . implode(",",$tracks) . ")";
60 $result = mysql_query($sql,$link);
61
81 $query = "delete from tblTask where tasPk=$id";
82 $result = mysql_query($query) or die('Task delete failed: ' . mysql_error());
83
lib_db.php http://pixie-cms.googlecode.com/svn/trunk/ | PHP | 432 lines
56 global $DB, $pixieconfig, $message, $dst, $tzHM, $timezone;
57 $method = (!$unbuf) ? 'mysql_query' : 'mysql_unbuffered_query';
58 if (!$q)
92 // if ( (first_word($q) == 'SELECT' or 'SHOW' or 'EXPLAIN' or 'DESCRIBE') ) {
93 // mysql_free_result( mysql_query($q) );
94 // }
95 // }
96 // } /* Don't need to do this for php 4 */ /* While this works, something else is causing an Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query() in Unknown on line 0 error */
97 return $result;
364 $query_names = "SET NAMES '{$charset}'";
365 $set_db_names_charset = mysql_query($query_names);
366 /* Set the name character set for database connection */
367 $query_char = "SET CHARACTER SET '{$charset}'";
368 $set_db_charset = mysql_query($query_char);
369 /* Set the character set for database connection */
ebpls_buslist_suspended.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 471 lines
70
71 $result=mysql_query("select lgumunicipality, lguprovince, lguoffice from ebpls_buss_preference")
72 or die(mysql_error());
102
103// $result=mysql_query("select ' ', business_name, ' ' , business_street, ' ' from ebpls_business_enterprise") or die(mysql_error());
104
104
105 $result = mysql_query("select a.business_name, concat(a.business_lot_no, ' ', a.business_street, ' ',
106 a.business_city_code, ' ', a.business_province_code, ' ', a.business_zip_code), a.employee_male, a.employee_female,
115
116 $result2 = mysql_query("select last_yr
117 from ebpls_business_enterprise a, ebpls_owner b, ebpls_business_enterprise_permit c, tempbusnature d
161//new signatories table
162// $result=mysql_query("select gs_name, gs_pos, gs_office from global_sign where sign_id =1") or die(mysql_error());
163// $resulta=mysql_fetch_row($result);
ta_logindatabase.inc http://collman.googlecode.com/svn/trunk/ | PHP | 294 lines
58 $q = "SELECT password FROM ".TBL_USERS." WHERE username = '$username'";
59 $result = mysql_query($q, $this->connection);
60 if(!$result || (mysql_numrows($result) < 1)){
93 $q = "SELECT userid FROM ".TBL_USERS." WHERE username = '$username'";
94 $result = mysql_query($q, $this->connection);
95 if(!$result || (mysql_numrows($result) < 1)){
121 $q = "SELECT username FROM ".TBL_USERS." WHERE username = '$username'";
122 $result = mysql_query($q, $this->connection);
123 return (mysql_numrows($result) > 0);
134 $q = "SELECT username FROM ".TBL_BANNED_USERS." WHERE username = '$username'";
135 $result = mysql_query($q, $this->connection);
136 return (mysql_numrows($result) > 0);
152 $q = "INSERT INTO ".TBL_USERS." VALUES ('$username', '$password', '0', $ulevel, '$email', '$userlanguage', $time)";
153 return mysql_query($q, $this->connection);
154 }
ARC2_StoreDeleteQueryHandler.php https://code.google.com/p/goodrelations-for-joomla/ | PHP | 197 lines
68 if ($g_id = $this->getTermID($g, 'g')) {
69 $rs = mysql_query('DELETE FROM ' . $tbl_prefix . 'g2t WHERE g = ' .$g_id, $con);
70 $r += mysql_affected_rows($con);
122 }
123 $rs = mysql_query($sql, $con);
124 if ($er = mysql_error($con)) {
156 ';
157 if (($rs = mysql_query($sql, $con)) && mysql_num_rows($rs)) {
158 /* delete unconnected triples */
164 ';
165 mysql_query($sql, $con);
166 }
172 ';
173 if (($rs = mysql_query($sql, $con)) && mysql_num_rows($rs)) {
174 /* delete unconnected graph refs */
mysql.dbconnection.php git://github.com/jelix/jelix.git | PHP | 189 lines
91 && isset($this->_charsets[jApp::config()->charset])){
92 mysql_query("SET NAMES '".$this->_charsets[jApp::config()->charset]."'", $cnx);
93 }
113
114 if ($qI = mysql_query ($query, $this->_connection)){
115 return new mysqlDbResultSet ($qI);
124
125 if ($qI = mysql_query ($query, $this->_connection)){
126 return mysql_affected_rows($this->_connection);
mass_email.php http://decs.googlecode.com/svn/trunk/ | PHP | 113 lines
65
66 $result = mysql_query($query);
67 while ($user = mysql_fetch_object($result)) {
invoice_list.php git://git.savannah.nongnu.org/gcourrier.git | PHP | 261 lines
27$requeteInit = "Select id from facture Limit 1;";
28$result = mysql_query($requeteInit) or die(mysql_error());
29if(mysql_num_rows($result) == 0){
AloneDB.php http://phpfor.googlecode.com/svn/trunk/ | PHP | 269 lines
53
54 if($rs = mysql_query($sql,$db_lnk)){
55 $db_result = array('rs'=>&$rs,'sql'=>$sql);
146 if(constant('DB_CHARSET')){
147 mysql_query('SET NAMES \''.DB_CHARSET.'\'',$lnk);
148 }
class.mysql.php http://seekstudio.googlecode.com/svn/trunk/ | PHP | 257 lines
41 $get_charset = str_replace('-', '', $this->character);
42 mysql_query("SET NAMES '".$get_charset."'");
43 mysql_query("SET CHARACTER_SET_CLIENT = '$get_charset';");
43 mysql_query("SET CHARACTER_SET_CLIENT = '$get_charset';");
44 mysql_query("SET CHARACTER_SET_RESULTS = '$get_charset';");
45 }
46 if(mysql_get_server_info() > '5.0'){
47 mysql_query("SET sql_mode=''");
48 }
65 }
66 if(!($query = mysql_query($sql)) && $query_type != 'SILENT') {
67 $this->halt('MySQL Query Error', $sql);
87 }
88 if(!($query = mysql_query($sql)) && $query_type != 'SILENT') {
89 $this->halt('MySQL Query Error', $sql);
block_login.php https://code.google.com/p/nuked-klan/ | PHP | 213 lines
35 if ($avatar != 'off'){
36 $sql_avatar=mysql_query('SELECT avatar FROM ' . USER_TABLE . ' WHERE id = \'' . $user[0] . '\' ');
37 list($avatar_url) = mysql_fetch_array($sql_avatar);
47
48 $sql2 = mysql_query('SELECT mid FROM ' . USERBOX_TABLE . ' WHERE user_for = \'' . $user[0] . '\' AND status = 1');
49 $nb_mess_lu = mysql_num_rows($sql2);
74
75 $sql_users = mysql_query('SELECT id FROM ' . USER_TABLE . ' WHERE niveau < 3');
76 $nb_users = mysql_num_rows($sql_users);
77
78 $sql_admin = mysql_query('SELECT id FROM ' . USER_TABLE . ' WHERE niveau > 2');
79 $nb_admin = mysql_num_rows($sql_admin);
80
81 $sql_lastmember = mysql_query('SELECT pseudo FROM ' . USER_TABLE . ' ORDER BY date DESC LIMIT 0, 1');
82 list($lastmember) = mysql_fetch_array($sql_lastmember);
Query.php https://bitbucket.org/mstetson/obiblio/ | PHP | 373 lines
88 }
89 $r = mysql_query($sql, $this->_link);
90 if ($r === false) {
pet.php http://ccmtc-chen.googlecode.com/svn/trunk/ | PHP | 282 lines
25$sql="select * from pet where user_id='".$userid."'";
26$result=mysql_query($sql,$DB->my_connect);
27$pet_num=@mysql_num_rows($result);
index.php http://sairuk-misc.googlecode.com/svn/trunk/ | PHP | 448 lines
65//Main Table Query
66$result = mysql_query("SELECT * FROM ". $tblnm ." ORDER BY Title");
67$types = mysql_query("SELECT * FROM Types ORDER BY types");
76 $delete_ids = implode(",",$dtitle);
77 mysql_query("DELETE FROM ". $tblnm ." WHERE Title IN ($delete_ids)");
78 $dtitle = '';
87 $delDate = date(c, strtotime("+$deldays day", time()));
88 mysql_query("UPDATE ". $tblnm ." SET Actioned='Y',Compdate='$delDate' WHERE Title='$key' ");
89 wrtRSSItem($uri,$key,'','COMPLETED','COMPLETED');
102 //Add to DB
103 mysql_query("INSERT INTO ". $tblnm ." (Title,Comment,Type,Date,Actioned) VALUES ('" . $atitle ."','" . $acomm ."','" . $atype ."','" . $adate ."','N')");
104
286 {
287 mysql_query("DELETE FROM ". $tblnm ." WHERE Title='".$row['Title']."' ");
288 }
QueryBuilder.class.php http://antilophpe.googlecode.com/svn/ | PHP | 308 lines
210 $query = "show columns from $table";
211 $result = mysql_query($query, $db);
212 while ($row = mysql_fetch_array($result)){
274 $query = "SELECT DISTINCT $field FROM $table";
275 $result = mysql_query($query, $db);
276 while ($row = mysql_fetch_array($result)){
300 $query = "SELECT DISTINCT $labelField FROM $table WHERE id ='$foreignKey'";
301 $result = mysql_query($query, $db);
302 $row = mysql_fetch_array($result);
Authorization.class.php http://antilophpe.googlecode.com/svn/ | PHP | 329 lines
234 WHERE ant_Authorization.id = ".$this->getId()."";
235 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Authorization`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
236 while($authorization_array=mysql_fetch_array($result)){
255 AND ant_Authorization_File.tableObject='ant_Authorization'";
256 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Authorization_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
257 $filesList=array();
271 WHERE ant_Authorization_File.id='$fileId'";
272 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection file in table `ant_Authorization_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
273 $authorization_File_array=mysql_fetch_assoc($result);
285 AND ant_Authorization_File.tableObject='ant_Authorization'";
286 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during selection in table `ant_Authorization_File`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
287 $authorization_File_array=mysql_fetch_array($result);
297 FROM ant_Authorization_Log";
298 $result = mysql_query($query, $this->getResourceLinkId()) or die('Query: '.$query.' Error during select count from table `ant_Authorization_Log`: '.mysql_errno($this->getResourceLinkId()).' - '.mysql_error($this->getResourceLinkId()));
299 $authorization_Log_array=mysql_fetch_array($result);
connection.php git://github.com/UCF/fuelphp-crash-course.git | PHP | 438 lines
168 // PHP is compiled against MySQL 4.x
169 $status = (bool) mysql_query('SET NAMES '.$this->quote($charset), $this->_connection);
170 }
201 // Execute the query
202 if (($result = mysql_query($sql, $this->_connection)) === false)
203 {
lgsl_add.php http://lansuite.googlecode.com/svn/trunk/ | PHP | 265 lines
132 $ip_check = gethostbyname($ip);
133 $mysql_result = mysql_query("SELECT `ip`,`disabled` FROM `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` WHERE `type`='{$type}' AND `q_port`='{$q_port}'");
134
193 $mysql_query = "INSERT INTO `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` (`type`,`ip`,`c_port`,`q_port`,`s_port`,`disabled`,`cache`,`cache_time`) VALUES ('{$type}','{$ip}','{$c_port}','{$q_port}','{$s_port}','{$disabled}','','')";
194 $mysql_result = mysql_query($mysql_query) or die(mysql_error());
195
nextpage.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 226 lines
24// Perform MySQL query on only the current page number's result
25//$result = mysql_query($searchsql)or die (mysql_error());
26$result = Query1($dbtype,$dbLink,$searchsql);
smDatabase.class.php git://github.com/madeinnordeste/PHP-Server-Monitor-Plus.git | PHP | 365 lines
41 // Setting the utf collection
42 mysql_query("SET NAMES utf8;", $this->getLink());
43 mysql_query("SET CHARACTER SET 'utf8';", $this->getLink());
54
55 $result = mysql_query($sql, $this->getLink());
56
66 // Rows found
67 $result_num_rows_found = $this->fetchResults(mysql_query('SELECT FOUND_ROWS();'));
68 $this->num_rows_found = $result_num_rows_found[0]['FOUND_ROWS()'];
insert_utenti.php https://code.google.com/p/bilugcms/ | PHP | 151 lines
53 $str=" SELECT * FROM anagrafica where ID='$id'";
54 $risultato=mysql_query($str);
55 if (mysql_num_rows($risultato)>0)
keywords.php https://code.google.com/p/bilugcms/ | PHP | 210 lines
19 $sql = "SELECT argomenti FROM argomenti WHERE id = " . ((int)$_GET['argo']) . " LIMIT 1";
20 $rssql = mysql_query( $sql );
21 if ( mysql_num_rows( $rssql ) > 0 ) {
29 $sql = "SELECT titolo, keywords FROM notizie WHERE id = " . ((int)$_GET['news']) . " LIMIT 1";
30 $rssql = mysql_query( $sql );
31
53 $sql = "SELECT titolo, keywords FROM statiche WHERE id = " . ((int)$_GET['stat']) . " LIMIT 1";
54 $rssql = mysql_query( $sql );
55 if ( mysql_num_rows( $rssql ) > 0 ) {
98 ";
99 $rssql = mysql_query( $sql );
100 if ( mysql_num_rows( $rssql ) > 0 ) {
124 $sql = "SELECT YEAR(dataora), MONTH(dataora), descrizione, titolo, tipo FROM eventi WHERE YEAR(dataora) = " . ((int)$_POST['anno']) . " AND MONTH(dataora) = " . ((int)$_POST['mese']);
125 $rssql = mysql_query( $sql );
126 if ( mysql_num_rows( $rssql ) > 0 ) {
rechercherFacture.php git://git.savannah.nongnu.org/gcourrier.git | PHP | 324 lines
75 $requete = "SELECT * FROM destinataire ORDER BY nom";
76 $result = mysql_query($requete) or die( mysql_error() );
77 while( $ligne = mysql_fetch_array( $result ) ){
88 $requete = "SELECT * FROM service WHERE libelle <> 'admin' ORDER BY libelle";
89 $result = mysql_query($requete) or die ( mysql_error() );
90 while( $ligne = mysql_fetch_array( $result ) ){
233
234$result = mysql_query( $requete ) or die ( mysql_error() ) ;
235echo "<table align=center font-color ='white' class='resultats'>";
pm.php http://mightmedia.googlecode.com/svn/trunk/ | PHP | 270 lines
74$limit = 30;
75$uzeris = mysql_fetch_assoc(mysql_query1("SELECT `pm_viso`,`nick` FROM " . LENTELES_PRIESAGA . "users WHERE nick='" . $_SESSION['username'] . "'"));
76$pm_sk = kiek("private_msg", "WHERE `to`=" . escape($uzeris['nick']));
81 if ($url['d'] == 0) {
82 mysql_query1("DELETE FROM `" . LENTELES_PRIESAGA . "private_msg` WHERE `to`=" . escape($_SESSION['username']));
83 header("Location: ?id," . $url['id'] . ";p," . $url['p'] . "");
84 } elseif ((int)$url['d'] > 0) {
85 mysql_query1("DELETE FROM `" . LENTELES_PRIESAGA . "private_msg` WHERE `to`=" . escape($_SESSION['username']) . " AND `id`=" . escape((int)$url['d']));
86 header("Location: ?id," . $url['id'] . ";p," . $url['p'] . "");
102 $date = time();
103 $sql = mysql_query1("SELECT nick,email FROM " . LENTELES_PRIESAGA . "users WHERE nick=" . escape($to) . " LIMIT 1");
104 if (mysql_num_rows($sql) == 0) {
108 if (kiek("private_msg", "WHERE `to`=" . escape($to) . "") < 51) {
109 $result = mysql_query1("INSERT INTO `" . LENTELES_PRIESAGA . "private_msg` (`from`, `to`, `title`, `msg`, `read`, `date`) VALUES (" . escape($from) . ", " . escape($to) . ", " . escape($title) . ", " . escape($msg) . ", 'NO', '" . $date . "')");
110 if (!$result) {
save_QueryBuilder.class.php http://antilophpe.googlecode.com/svn/ | PHP | 317 lines
283 $query = "SELECT DISTINCT $field FROM $table";
284 $result = mysql_query($query, $db);
285 while ($row = oci_fetch_array($result)){
309 $query = "SELECT DISTINCT $labelField FROM $table WHERE id ='$foreignKey'";
310 $result = mysql_query($query, $db);
311 $row = oci_fetch_array($result);
bizlevel.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 120 lines
4//get sub levels
5$getsl = mysql_query("SELECT b.* FROM ebpls_user_sublevel_listings a,
6 ebpls_user_sublevel b WHERE a.user_id = $user_id
newpost.php http://clover-mana.googlecode.com/svn/trunk/ | PHP | 337 lines
22 $sql_manga = "select MID,MangaName from manga where Passed = 2 order by MangaName";
23 $result_manga = mysql_query($sql_manga,$connection);
24 $num_manga = mysql_num_rows($result_manga);
93 $sql = "select Image from manga where MID = $mid";
94 $result = mysql_query($sql,$connection);
95 $num = mysql_num_rows($result);
188 $sql_checkno =sprintf("select PID from posting where MID = '%s' and ChapNo='%d' and Status ='%d'",$mangaid,$no,$sttok);
189 $result_checkno = mysql_query ($sql_checkno, $connection);
190 $num_checkno = mysql_num_rows($result_checkno);
218 ", $uid,$post_date,$post_date,$stt, $mangaid,$name,$no);
219 mysql_query ($strSQL, $connection);
220 $postid = mysql_insert_id();
230
231 mysql_query ($sql, $connection);
232 // echo $sql;
cache.php http://novaboard.googlecode.com/svn/trunk/ | PHP | 260 lines
148 {
149 $query = mysql_query('SELECT * FROM ' . $this->db_prefix . 'settings');
150 $row = mysql_fetch_assoc($query);
163 $censor = array();
164 $query = mysql_query('SELECT * FROM ' . $this->db_prefix . 'censor');
165
181 $groups = array();
182 $query = mysql_query('SELECT * FROM ' . $this->db_prefix . 'groups');
183
199 $moderators = array();
200 $query = mysql_query('SELECT * FROM ' . $this->db_prefix . 'moderators');
201
217 $hooks = array();
218 $query = mysql_query('
219 SELECT h.file, h.location, m.module_name
lop.php http://cn08b.googlecode.com/svn/trunk/ | PHP | 270 lines
25 {
26 $khoa=mysql_query("select * from khoa",$quanlyktx);
27?> <span>Danh Sách C?a Khoa:
52 {
53 $khoa=mysql_query("select * from khoa",$quanlyktx);
54?> <span>Danh Sách C?a Khoa:
65 $lop="select * from lop where MA_KHOA= '".$_POST["khoa"]."'";
66 $query_lop=mysql_query($lop,$quanlyktx);
67 $stt=0;
116 $query_update= "update lop set MA_LOP='".$_POST['malop']."',TEN_LOP='".$_POST['tenlop']."',SOLUONG_SV=".$_POST['soluong'].",GIAOVIEN_CN='".$_POST['giaovien']."',MA_KHOA='".$_POST['khoa']."' where MA_LOP='".$_GET["ma_lop"]."'";
117 $bol=mysql_query($query_update,$quanlyktx);
118 if($bol)
128 {
129 $lop=mysql_query("select * from lop where MA_LOP='".$_GET["ma_lop"]."'",$quanlyktx);
130 if($row_lop=mysql_fetch_array($lop))
realizar_venta.php https://code.google.com/p/zapatillas-4-dsw1/ | PHP | 167 lines
16
17 $qi = mysql_query($item, $db_zapatos)or die(mysql_error());
18 $lista = mysql_fetch_assoc($qi);
37
38 $qc = mysql_query($cant, $db_zapatos)or die(mysql_error());
39
mysql.php https://code.google.com/p/celebrio/ | PHP | 455 lines
158 if ($this->buffered) {
159 $this->resultSet = @mysql_query($sql, $this->connection); // intentionally @
160 } else {
edit.php http://creative-portal.googlecode.com/svn/trunk/ | PHP | 108 lines
18 {
19 $query = mysql_query("UPDATE `" . NV_PREFIXLANG . "_" . $module_data . "` SET `title` = " . $db->dbescape( $title ) . " WHERE `id` =" . $id . "");
20 $query = mysql_query("UPDATE `" . NV_PREFIXLANG . "_" . $module_data . "` SET `thumb` = " . $db->dbescape( $thumb ) . " WHERE `id` =" . $id . "");
20 $query = mysql_query("UPDATE `" . NV_PREFIXLANG . "_" . $module_data . "` SET `thumb` = " . $db->dbescape( $thumb ) . " WHERE `id` =" . $id . "");
21 $query = mysql_query("UPDATE `" . NV_PREFIXLANG . "_" . $module_data . "` SET `duongdan` = " . $db->dbescape( $duongdan ) . " WHERE `id` =" . $id . "");
22 $query = mysql_query("UPDATE `" . NV_PREFIXLANG . "_" . $module_data . "` SET `theloai` = " . $db->dbescape( $theloai ) . " WHERE `id` =" . $id . "");
22 $query = mysql_query("UPDATE `" . NV_PREFIXLANG . "_" . $module_data . "` SET `theloai` = " . $db->dbescape( $theloai ) . " WHERE `id` =" . $id . "");
23 $query = mysql_query("UPDATE `" . NV_PREFIXLANG . "_" . $module_data . "` SET `who_post` = " . $db->dbescape( $who_post ) . " WHERE `id` =" . $id . "");
24 if ($query)
soap_sis_entry_siswa_spp.php http://sistem-informasi-sekolah-online.googlecode.com/svn/trunk/ | PHP | 159 lines
51 ";
52 $result = mysql_query($sql);
53
89
90 $result = mysql_query($query);
91
110
111 $result = mysql_query($query);
112
admin.php https://code.google.com/p/nuked-klan/ | PHP | 301 lines
35
36 $sql = mysql_query("SELECT auteur, texte, ip FROM " . TEXTBOX_TABLE . " WHERE id = '" . $mid . "'");
37 list($pseudo, $texte, $ip) = mysql_fetch_array($sql);
60
61 $sql = mysql_query("UPDATE " . TEXTBOX_TABLE . " SET texte = '" . $texte . "' WHERE id = '" . $mid . "'");
62 // Action
64 $acdate = time();
65 $sqlaction = mysql_query("INSERT INTO ". $nuked['prefix'] ."_action (`date`, `pseudo`, `action`) VALUES ('".$acdate."', '".$user[0]."', '".$texteaction."')");
66 //Fin action
78
79 $sql = mysql_query("DELETE FROM " . TEXTBOX_TABLE . " WHERE id = '" . $mid . "'");
80 // Action
82 $acdate = time();
83 $sqlaction = mysql_query("INSERT INTO ". $nuked['prefix'] ."_action (`date`, `pseudo`, `action`) VALUES ('".$acdate."', '".$user[0]."', '".$texteaction."')");
84 //Fin action
netflow2_debug.php http://timoseven.googlecode.com/svn/trunk/ | PHP | 126 lines
34 echo $query."\n";
35 $result = mysql_query($query,$dbh);
36 while($row = mysql_fetch_array($result))
ebpls010.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 164 lines
46if (!empty($frmBtnDelete)) {
47 $checkif = @mysql_query("select username,login,logout from ebpls_user where id = '$frmId'");
48 $checkiff = @mysql_fetch_assoc($checkif);
149 $sql = "DELETE FROM ebpls_user_sublevel_listings WHERE user_id=$uid";
150 @mysql_query($sql, $dbLink);
151}
show.php git://git.savannah.nongnu.org/qsos.git | PHP | 318 lines
113$query = "SELECT id FROM evaluations WHERE appname <> '' AND language = '$lang'";
114$IdReq = mysql_query($query, $IdDB);
115$allIds = array();
123 $query = "SELECT file FROM evaluations WHERE id = \"$id\"";
124 $IdReq = mysql_query($query, $IdDB);
125 $result = mysql_fetch_row($IdReq);
messages.static.php http://modx-ja.googlecode.com/svn/trunk/ | PHP | 350 lines
13$sql = "SELECT * FROM $dbase.`".$table_prefix."user_messages` WHERE $dbase.`".$table_prefix."user_messages`.id=".$_REQUEST['id'];
14$rs = mysql_query($sql);
15$limit = mysql_num_rows($rs);
29 $sql = "SELECT username FROM $dbase.`".$table_prefix."manager_users` WHERE id=$sender";
30 $rs2 = mysql_query($sql);
31 $row2 = mysql_fetch_assoc($rs2);
85 $sql = "UPDATE $dbase.`".$table_prefix."user_messages` SET $dbase.`".$table_prefix."user_messages`.messageread=1 WHERE $dbase.`".$table_prefix."user_messages`.id=".$_REQUEST['id'];
86 $rs = mysql_query($sql);
87 }
97$sql = "SELECT count(id) FROM $dbase.`".$table_prefix."user_messages` WHERE recipient=".$modx->getLoginUserID()."";
98$rs=mysql_query($sql);
99$countrows = mysql_fetch_assoc($rs);
144$sql = "SELECT * FROM $dbase.`".$table_prefix."user_messages` WHERE $dbase.`".$table_prefix."user_messages`.recipient=".$modx->getLoginUserID()." ORDER BY postdate DESC LIMIT ".$int_cur_position.", ".$int_num_result;
145$rs = mysql_query($sql);
146$limit = mysql_num_rows($rs);
ImpExtratoConta.php http://conexao.googlecode.com/svn/trunk/ | PHP | 134 lines
57
58 $sql=mysql_query("SELECT * FROM CONTA") or die ("Houve erro na selecao da tabela");
59
90
91 $sql=mysql_query("SELECT distinct nome FROM conta ") or die ("Houve erro na selecao da tabela");
92
admin_homePage.php http://jcuecafe.googlecode.com/svn/ | PHP | 183 lines
77 $query = "SELECT Bill_ID,Time_Of_Delivery,Bill_Status FROM Bill WHERE Bill_Status ='Pending' ";
78 $result1= mysql_query($query);
79
securefunctions.php http://railoapacheportable.googlecode.com/svn/trunk/ | PHP | 221 lines
12
13 mysql_query("SET PASSWORD = PASSWORD('".mysql_real_escape_string($newpass)."')"); //Fix by Wiedmann
14 mysql_query("FLUSH PRIVILEGES");
48
49 mysql_query("SET PASSWORD for 'pma'@'localhost' = PASSWORD('".mysql_real_escape_string($pmanewpass)."')"); //Fix by Wiedmann
50 mysql_query("FLUSH PRIVILEGES");
db_info.php https://gestion001.svn.codeplex.com/svn | PHP | 164 lines
47
48 $stati=mysql_query("show table status");
49 while($status=mysql_fetch_array($stati)) {
58 foreach($table_names as $table) {
59 mysql_query("show columns from `".$table."`");
60 $table_fields[]=mysql_affected_rows();
124 // get number of rows and size of tables
125 $stati=mysql_query("show table status",$con);
126 while ($status=@mysql_fetch_array($stati)) {
totrx.php http://twpug.googlecode.com/svn/trunk/ | PHP | 144 lines
120 foreach ($updated as $id => $value) {
121 mysql_query("update sugar_lang_trx set trx = '". mysql_real_escape_string($value) ."' WHERE id = ".$id);
122 }
129 $count = $counts[0]->cnt;
130 mysql_query("INSERT INTO sugar_lang_dico (ref,trx) SELECT ref,trx FROM sugar_lang_trx where trx != ''");
131 mysql_query("DELETE FROM sugar_lang_trx where trx != ''");
Database.php https://code.google.com/p/php-blackops-rcon/ | PHP | 261 lines
249 // Send query
250 $statement = @mysql_query($statement, $this->link);
251
ebpls4221.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 181 lines
11
12$searchtemp = mysql_query("select count(tempid) as total
13 from permit_templates where
23
24$searchexist = mysql_query("select * from permit_templates
25 where permit_type='$tag'")
36if ($act1==1) {
37 $gets = mysql_query ("select * from global_sign where sign_id=$sign1");
38 $gs=mysql_fetch_row($gets);
46if ($act2==1) {
47 $gets = mysql_query ("select * from global_sign where sign_id=$sign2");
48 $gs=mysql_fetch_row($gets);
58if ($act3==1) {
59 $gets = mysql_query ("select * from global_sign where sign_id=$sign3");
60 $gs=mysql_fetch_row($gets);
PDOStatement_mysql.class.php http://xvweb.googlecode.com/svn/trunk/ | PHP | 352 lines
343 function __uquery(&$query) {
344 if(!@$query = mysql_query($query, $this->__connection)) {
345 $this->__setErrors('SQLER');
newmanga.php http://clover-mana.googlecode.com/svn/trunk/ | PHP | 236 lines
21 $sql_type ="select * from category";
22 $result_type = mysql_query($sql_type,$connection);
23 echo "<form action=\"\" method=\"post\" enctype=\"multipart/form-data\" name=\"frmNewmanga\">";
139 $sql_check ="select * from manga where MangaName = '$name'";
140 $result_check = mysql_query($sql_check,$connection);
141 $num_rs_check = mysql_num_rows($result_check);
169 ", $name,$date, $stt, $uid, $summary,$passed,$author);
170 mysql_query ($strSQL, $connection);
171 if(mysql_errno() != 0)
204 $strSQL = sprintf("Update manga set Image = '%s',Icon = '%s' where MID = '%d'", $path_img,$path_ico,$mangaid1);
205 mysql_query ($strSQL, $connection);
206// echo $path_img.$path_ico;
215 $sql2 = sprintf("select MID from manga where MangaName = '%s'",$name);
216 $result2 = mysql_query ($sql2, $connection);
217 $num2 = mysql_num_rows($result2);
setup.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 315 lines
123
124 $cdb = mysql_query("create database $dbname") or die(mysql_error());
125 }
145 while ($x<300) {
146 $ins = mysql_query("insert into ebpls_buss_taxfeeother
147 (taxfeeid) values ('')");
149 }
150 $delins = mysql_query("delete from ebpls_buss_taxfeeother");
151
152
153 $ty = mysql_query("truncate ebpls_user");
154
157
158 $ty = mysql_query("INSERT INTO ebpls_user (id, level, csgroup, username, password, lastname, firstname, designation, email, gsmnum, login, logout, lockout, currthreads, roundrobinflag, dateadded, lastupdated) VALUES (1, '?', NULL, 'ebpls', '°e?w', 'EBPLS', 'EBPLS', '', '', '', '2007-03-07 16:35:31', '2007-03-07 16:35:31', NULL, NULL, NULL, '2006-07-06 09:56:38', '2007-03-07 16:35:31')");
159 $ty = mysql_query("INSERT INTO ebpls_user (id, level, csgroup, username, password, lastname, firstname, designation, email, gsmnum, login, logout, lockout, currthreads, roundrobinflag, dateadded, lastupdated) VALUES (2, '?', NULL, 'nccfoo', '?]v?kL', 'FOO', 'NCC', '', '', '', '2007-02-01 13:49:49', '2007-01-23 14:01:26', NULL, NULL, NULL, '2006-07-06 09:57:11', '2007-02-01 13:49:49')") or die (mysql_error());
usuarios_insertar.php https://gestion001.svn.codeplex.com/svn | PHP | 189 lines
21 $query_ValidarUsuario = sprintf("SELECT Usuario FROM `Usuario` WHERE Usuario = '%s'", $colname_ValidarUsuario);
22 $ValidarUsuario = mysql_query($query_ValidarUsuario, CONEXION) or trigger_error(mysql_error(),E_USER_ERROR);
23 $row_ValidarUsuario = mysql_fetch_assoc($ValidarUsuario);
45 mysql_select_db(DB_NAME, CONEXION);
46 $Result1 = mysql_query($insertSQL, CONEXION) or trigger_error(mysql_error(),E_USER_ERROR);
47
58$query_Rsdepartamento = "SELECT * FROM Nivel";
59$Rsdepartamento = mysql_query($query_Rsdepartamento, CONEXION) or trigger_error(mysql_error(),E_USER_ERROR);
60$row_Rsdepartamento = mysql_fetch_assoc($Rsdepartamento);
64$query_RsSexo = "SELECT * FROM Sexo";
65$RsSexo = mysql_query($query_RsSexo, CONEXION) or trigger_error(mysql_error(),E_USER_ERROR);
66$row_RsSexo = mysql_fetch_assoc($RsSexo);
functions.php http://viewpanelblogger.googlecode.com/svn/trunk/ | PHP | 413 lines
14 $sql = "SELECT rank FROM users WHERE username = '".$_COOKIE['View_Panel_ID']."'";
15 $query = mysql_query($sql);
16 while($row = mysql_fetch_array($query)){
92function View_Panel_Page_Lister() {
93 $result = mysql_query("SELECT * FROM blog_lister");
94 while($row = mysql_fetch_array($result)) {
100function View_Panel_Blog_Lister($output_get = 'blog', $secondget = '') {
101 $result = mysql_query("SELECT * FROM blog_lister");
102 echo "<option></option>";
116 $blog = addslashes($blog);
117 $result = mysql_query("SELECT themeid FROM blog_lister WHERE pageName = '".$blog."'");
118 while($row = mysql_fetch_array($result)) {
124function View_Panel_Theme_Lister() {
125 $result = mysql_query("SELECT * FROM viewpanel_themes");
126 while($row = mysql_fetch_array($result)) {
browser_kernel.php https://gestion001.svn.codeplex.com/svn | PHP | 297 lines
112 if ($flag == 0) {
113 $Rsfora1 = mysql_query($query_Rsfora1, CONEXION) or trigger_error(mysql_error(),E_USER_ERROR);
114 $row_Rsfora1 = mysql_fetch_assoc($Rsfora1);
224
225 $this->rs= mysql_query($query_limit_rs, CONEXION) or trigger_error(mysql_error(),E_USER_ERROR);
226 $this->numfields = mysql_num_fields($this->rs);
230 else {
231 $all_rs = mysql_query($query_rs) or trigger_error(mysql_error(),E_USER_ERROR);
232 $this->totalRows_rs = mysql_num_rows($all_rs);
vente.php http://immopaca.googlecode.com/svn/trunk/ | PHP | 186 lines
39
40$res_r = mysql_query(sprintf(MODELE_REQUETE, $debut, NB_PAR_PAGE)) or die(mysql_error());
41
41
42$res_n = mysql_query('SELECT FOUND_ROWS()') or die(mysql_error());
43$NumRows = mysql_result($res_n, 0, 0);
submit_sample_gel_free.inc.php http://prohits.googlecode.com/svn/trunk/ | PHP | 386 lines
87 $SQL = "SELECT ID FROM Hits WHERE BandID = '$Band_ID'";
88 if(mysql_num_rows(mysql_query($SQL))){
89 return "Error: You can't delete the Band since it has hits.";
explore.php http://building-browsergames-tutorial.googlecode.com/svn/trunk/ | PHP | 150 lines
20 mysql_real_escape_string($_SESSION['username']));
21 $result = mysql_query($query);
22 list($userID) = mysql_fetch_row($result);
41 mysql_real_escape_string($_POST['monster']));
42 $result = mysql_query($query);
43 list($monsterID) = mysql_fetch_row($result);
81 mysql_real_escape_string($rand));
82 $result = mysql_query($query);
83 list($itemID) = mysql_fetch_row($result);
85 mysql_real_escape_string($userID),mysql_real_escape_string($itemID));
86 $result = mysql_query($query);
87 list($count) = mysql_fetch_row($result);
98 }
99 mysql_query($query);
100 # retrieve the item name, so that we can display it
post_add_action.php http://ouyo.googlecode.com/svn/trunk/ | PHP | 50 lines
41//echo "insert into info (title,created,pubid,content,type,audit,allowComment,comment_audit) values('$post_title','$post_created','$post_pubid','$post_content','$post_type','$post_audit','$post_allowComment','$post_commentAudit')";
42$result_post=mysql_query("insert into info (title,created,pubid,content,type,audit,allowComment,comment_audit) values('$post_title','$post_created','$post_pubid','$post_content','$post_type','$post_audit','$post_allowComment','$post_commentAudit')");
43if(mysql_affected_rows()>0){
index.php http://clover-mana.googlecode.com/svn/trunk/ | PHP | 421 lines
77 //echo "$mgname";
78 $result = mysql_query ($strSQL,$connection);
79 echo"<div id='mangalist'>";
ez_sql_mysql.php http://jvstutoriales.googlecode.com/svn/trunk/ | PHP | 266 lines
195
196 // Perform the query via std mysql_query function..
197 $this->result = @mysql_query($query,$this->dbh);
666remove.php http://cartonbank.googlecode.com/svn/trunk/ | PHP | 165 lines
25
26 $result = mysql_query($sql);
27
37 //pokazh ($sql);
38 mysql_query($sql1);
39
47 //pokazh ($sql);
48 $result = mysql_query($sql);
49 if (!$result) {die('Invalid query: ' . mysql_error());}
51 //pokazh ($sql);
52 $result = mysql_query($sql);
53 if (!$result) {die('Invalid query: ' . mysql_error());}
55 //pokazh ($sql);
56 $result = mysql_query($sql);
57 if (!$result) {die('Invalid query: ' . mysql_error());}
index.php http://xepec.googlecode.com/svn/trunk/ | PHP | 258 lines
7
8 $re = mysql_query( "SELECT COUNT(*) FROM bugzilla", $dbcnx);
9 if (!$re) exit("db error");
22
23 $re = mysql_query( "INSERT INTO bugzilla VALUES (0,'$place', '$autor', '$email', '$comment','$date',0,0)", $dbcnx);
24 if (!$re) {echo("?????? ? ???????? xepec.ru");mysql_close($dbcnx); return FALSE;}
33
34 $re = mysql_query( "SELECT * FROM bugzilla WHERE id = '$id'", $dbcnx);
35 $arr = mysql_fetch_array($re);
danhsachdia.php http://quan-li-cua-hang-bang-dia.googlecode.com/svn/trunk/ | PHP | 176 lines
18$truyvan="select * from nhac";
19$thtv=mysql_query($truyvan,$link);
20$tongtrang=ceil(mysql_num_rows($thtv)/$dong);
35$s="select * from nhac limit ".$x.",".$dong;
36$lienket=mysql_query($s,$link);
37while($rows=mysql_fetch_object($lienket))
39$macasi=$rows->macasi;
40$s1=mysql_query("select * from casi where macasi='$macasi'",$link);
41$row2=mysql_fetch_object($s1);
50 $macasi=$rows->macasi;
51$s2=mysql_query("select * from casi where macasi='$macasi'",$link);
52$row3=mysql_fetch_object($s2);
103$truyvan="select * from phim";
104$thtv=mysql_query($truyvan,$link);
105$tongtrang=ceil(mysql_num_rows($thtv)/$dong);
generate.php git://github.com/benkeen/generatedata.git | PHP | 189 lines
159
160 $query = mysql_query("
161 SELECT *
170 $country_slug = $row["country_slug"];
171 $query2 = mysql_query("SELECT * FROM {$g_table_prefix}regions WHERE country_id = $country_id");
172
install_function.php http://ourproject.googlecode.com/svn/trunk/ | PHP | 453 lines
91 } else {
92 if($query = @mysql_query("SHOW TABLES FROM $dbname")) {
93 while($row = mysql_fetch_row($query)) {
post.php http://0byte.googlecode.com/svn/trunk/ | PHP | 190 lines
118// $sql_get="SELECT * FROM `blogs` WHERE id = '".intval($_GET['blog'])."' ";
119// $resul=mysql_query($sql_get,$sql);
120// $rowa = mysql_fetch_assoc($resul);
125// '".$usr->login."'";
126// $res=mysql_query($sql_get,$sql);
127// $ro = mysql_fetch_assoc($res);
setup.check.inc.php http://phpwcms.googlecode.com/svn/trunk/ | PHP | 304 lines
104
105 if($result = mysql_query("SELECT VERSION()", $db)) {
106
118
119 if($result = @mysql_query('SELECT * FROM '. ($phpwcms["db_prepend"] ? $phpwcms["db_prepend"].'_' : '').'phpwcms_user', $db)) {
120
179
180 @mysql_query('SET storage_engine=MYISAM', $db);
181
183 $value = "SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO'";
184 @mysql_query($value, $db);
185 $value = "SET NAMES '".$phpwcms['db_charset']."'".(empty($phpwcms['db_collation']) ? '' : " COLLATE '".$phpwcms['db_collation']."'");
185 $value = "SET NAMES '".$phpwcms['db_charset']."'".(empty($phpwcms['db_collation']) ? '' : " COLLATE '".$phpwcms['db_collation']."'");
186 @mysql_query($value, $db);
187 }
how_to.php http://braddoro.googlecode.com/svn/trunk/ | PHP | 117 lines
15$s_sql = "select chapterID, displayOrder, chapterName from cms.cfg_howto_chapters order by displayOrder, chapterName";
16$q_data = mysql_query($s_sql);
17if (!$q_data) {die_well(mysql_error());}
32 displayOrder, headingName";
33$q_data = mysql_query($s_sql);
34if (!$q_data) {die_well(mysql_error());}
area.php https://code.google.com/p/bilugcms/ | PHP | 226 lines
58 $stringamenu="SELECT menu,link,extra,descr FROM menuadmin where colonna=1 $visibile order by ordine";
59 $menu =mysql_query($stringamenu);
60 if (mysql_num_rows($menu)>0)
84 $stringamenu="SELECT menu,link,extra,descr FROM menuadmin where colonna=2 $visibile order by ordine";
85 $menu =mysql_query($stringamenu);
86 if (mysql_num_rows($menu)>0)
109 $stringamenu="SELECT menu,link,extra,descr FROM menuadmin where colonna=3 $visibile order by ordine";
110 $menu =mysql_query($stringamenu);
111 if (mysql_num_rows($menu)>0)
134 $stringamenu="SELECT menu,link,extra,descr FROM menuadmin where colonna=4 $visibile order by ordine";
135 $menu =mysql_query($stringamenu);
136 if (mysql_num_rows($menu)>0)
160 $stringamenu="SELECT menu,link,extra,descr FROM menuadmin where colonna=5 $visibile order by ordine";
161 $menu =mysql_query($stringamenu);
162 if (mysql_num_rows($menu)>0)
remind.php http://decs.googlecode.com/svn/trunk/ | PHP | 311 lines
101 $x = 0;
102 $result = mysql_query("select rpc_time from host where userid=$user->id");
103 while ($host = mysql_fetch_object($result)) {
203 $query = "insert into sent_email values($user->id, $now, $ntype)";
204 mysql_query($query);
205 }
209 $query = "select * from sent_email where userid=$user->id";
210 $result = mysql_query($query);
211 $t = 0;
252 $max_create_time = time() - $globals->start_interval;
253 $result = mysql_query(
254 "select * from user where send_email<>0 and create_time<$max_create_time and total_credit = 0;"
268 //
269 $result = mysql_query(
270 "select userid from host group by userid having max(rpc_time)<$max_last_rpc_time;"
AddQuality.php http://gestion-calls.googlecode.com/svn/trunk/ | PHP | 296 lines
71<?php
72@mysql_query("SET NAMES 'utf8'");
73if($action == "update" || $_GET[action] == "update")// esta editando.
blogsubmitinsert.php http://ownerpress.googlecode.com/svn/trunk/ | PHP | 300 lines
19 $sql = "begin transaction";
20 mysql_query($sql);
21 $sql = $wpdb->query("
59 $sql = "commit";
60 mysql_query($sql);
61 $result = TRUE;
69 $sql ="rollback";
70 mysql_query($sql);
71
phpip2country.class.php http://php-ip-2-country.googlecode.com/svn/trunk/ | PHP | 295 lines
284 private function dbGetRow($sql){
285 $result = mysql_query($sql);
286 if($result){
block_html.php https://code.google.com/p/nuked-klan/ | PHP | 78 lines
24
25 $sql = mysql_query('SELECT active, position, titre, module, content, type, nivo, page FROM ' . BLOCK_TABLE . ' WHERE bid = \'' . $bid . '\' ');
26 list($active, $position, $titre, $modul, $content, $type, $nivo, $pages) = mysql_fetch_array($sql);
pass.php http://mycaptain.googlecode.com/svn/ | PHP | 86 lines
19 }
20mysql_query($sql);
21mysql_close($conn);
27$sql="select * from gly where id=1";
28$result=mysql_query($sql);
29while($rs =mysql_fetch_array($result))
duplicate_business.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 117 lines
41// execute query
42$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
43
elenco_ecommerce.php https://code.google.com/p/bilugcms/ | PHP | 152 lines
39$sql = "SELECT categoria FROM ecommercecategoria WHERE id = $id_categoria LIMIT 1";
40$rssql = mysql_query($sql);
41$categoria = mysql_result($rssql, 0, 0);
65
66$ecommerce = mysql_query($query);
67
admin_hanghoa.php http://webdienmay.googlecode.com/svn/trunk/ | PHP | 164 lines
38 {
39 $kq=mysql_query("select * from hanghoa order by Mahang ASC ",$link);
40 $tongsotrang=ceil((mysql_num_rows($kq)-1)/$sodong);
62 $s="select * from hanghoa order by Mahang ASC limit ".$x.",".$sodong;
63 $kq=mysql_query($s,$link);
64 while($dong=mysql_fetch_array($kq) )
70
71 $kq2=mysql_query($sql2,$link);
72 $dong2=mysql_fetch_array($kq2);
75
76 $kq3=mysql_query($sql3,$link);
77 $dong3=mysql_fetch_array($kq3);
jobstatus.php git://github.com/jquery/testswarm.git | PHP | 140 lines
28
29 $result = mysql_queryf("SELECT jobs.name, jobs.status, users.name FROM jobs, users WHERE jobs.id=%u AND users.id=jobs.user_id;", $job_id);
30
52
53 $result = mysql_queryf("SELECT runs.id as run_id, runs.url as run_url, runs.name as run_name, useragents.engine as browser, useragents.name as browsername, useragents.id as useragent_id, run_useragent.status as status FROM run_useragent, runs, useragents WHERE runs.job_id=%u AND run_useragent.run_id=runs.id AND run_useragent.useragent_id=useragents.id ORDER BY run_id, browsername;", $job_id);
54
66
67 $runResult = mysql_queryf("SELECT run_client.client_id as client_id, run_client.status as status, run_client.fail as fail, run_client.error as error, run_client.total as total, clients.useragent_id as useragent_id FROM run_client, clients WHERE run_client.run_id=%u AND run_client.client_id=clients.id ORDER BY useragent_id;", $row["run_id"]);
68
ARC2_StoreLoadQueryHandler.php https://code.google.com/p/s3db/ | PHP | 387 lines
167 $r = 0;
168 if (($rs = mysql_query($sql)) && mysql_num_rows($rs)) {
169 while ($row = mysql_fetch_array($rs)) {
178 $sql = "SELECT MAX(t) AS `id` FROM " . $this->store->getTablePrefix() . "triple";
179 if (($rs = mysql_query($sql)) && mysql_num_rows($rs) && ($row = mysql_fetch_array($rs))) {
180 return $row['id'] + 1;
204 $sql = "SELECT id AS `id`" . $cid_suffix . ", '" . $sub_tbl . "' AS `tbl` FROM " . $this->store->getTablePrefix() . $sub_tbl . " WHERE val = BINARY '" . mysql_real_escape_string($val) . "'";
205 if (($rs = mysql_query($sql . ' LIMIT 1')) && mysql_num_rows($rs) && ($row = mysql_fetch_array($rs))) {
206 $this->term_ids[$val] = array($tbl => isset($row['cid']) ? $row['cid'] : $row['id']);
233 ";
234 if (($rs = mysql_query($sql)) && mysql_num_rows($rs) && ($row = mysql_fetch_array($rs))) {
235 $this->triple_ids[$val] = $row['t'];/* hack for "don't insert this triple" */
326 $t1 = ARC2::mtime();
327 mysql_query($this->sql_buffers[$tbl]);
328 /* table error */
block_survey.php https://code.google.com/p/nuked-klan/ | PHP | 107 lines
21
22 $sql = mysql_query('SELECT sid, titre FROM ' . SURVEY_TABLE . ' ' . $where);
23 list($poll_id, $titre) = mysql_fetch_array($sql);
29
30 $sql2 = mysql_query('SELECT voteID, optionText FROM ' . SURVEY_DATA_TABLE . ' WHERE sid = \'' . $poll_id . '\' ORDER BY voteID ASC');
31 while (list($voteid, $optiontext) = mysql_fetch_array($sql2)){
47
48 $sql = mysql_query('SELECT active, position, titre, module, content, type, nivo, page FROM ' . BLOCK_TABLE . ' WHERE bid = \'' . $bid . '\' ');
49 list($active, $position, $titre, $modul, $content, $type, $nivo, $pages) = mysql_fetch_array($sql);
82
83 $sql2 = mysql_query('SELECT sid, titre FROM ' . SURVEY_TABLE . ' ORDER BY sid DESC');
84 while (list($survey_id, $survey_title) = mysql_fetch_array($sql2)){
PieDataFrench.php http://cfstox.googlecode.com/svn/trunk/ | PHP | 59 lines
24 $useUTFQuery = "SET NAMES 'utf8'";
25 $utfQueryResult = mysql_query($useUTFQuery);
26
32 $strQuery = "select * from French_Factory_Master";
33 $result = mysql_query($strQuery) or die(mysql_error());
34
39 $strQuery = "select sum(Quantity) as TotOutput from Factory_Output where FactoryId=" . $ors['FactoryId'];
40 $result2 = mysql_query($strQuery) or die(mysql_error());
41 $ors2 = mysql_fetch_array($result2);
inforstudent.php https://bitbucket.org/dangph_54/se-project/ | PHP | 92 lines
6 $connect = mysql_connect("localhost","root","") or die ("cannot connect this database");
7 mysql_query("set names 'utf8' ");
8 mysql_select_db("site",$connect);
9 $sql = "select * from student where id_student= '".$_SESSION['id_student']."'";
10 $query = mysql_query($sql);
11 $row = mysql_fetch_array($query);
database.php git://git.savannah.nongnu.org/lamantengo.git | PHP | 240 lines
119 $this->mLastquery = $query;
120 $result = mysql_query($query, $this->_mConnection);
121 $this->confirmQuery($result);
eBPLS.industry.class.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 340 lines
289
290 $rx=mysql_query("select * from $tble where $prim_key = '$new_code' and $prim_key <> '$origid' ");
291 $this->outnumrow = mysql_num_rows($rx);
forgot.php git://git.savannah.nongnu.org/lamantengo.git | PHP | 147 lines
54 $query = "SELECT uid,username,email,realname,active FROM users WHERE LOWER(username) ='" . strtolower($username) . "' AND email='" . strtolower($email) . "'";
55 $rs = mysql_query($query);
56 if ($fila = mysql_fetch_object($rs)) { // matches users and mail ... new genus pass, and sent him
72 $password = "";
73 $rs = mysql_query($query);
74 if ($errors)
extension.cache.mysql.php https://bitbucket.org/chamilo/chamilo/ | PHP | 171 lines
102 // Check version number and clear cache if changed
103 $this->cursor = mysql_query("SELECT `value` FROM `getid3_cache` WHERE (`filename` = '".GETID3_VERSION."') AND (`filesize` = '-1') AND (`filetime` = '-1') AND (`analyzetime` = '-1')", $this->connection);
104 list($version) = @mysql_fetch_array($this->cursor);
116
117 $this->cursor = mysql_query("DELETE FROM `getid3_cache`", $this->connection);
118 $this->cursor = mysql_query("INSERT INTO `getid3_cache` VALUES ('".GETID3_VERSION."', -1, -1, -1, '".GETID3_VERSION."')", $this->connection);
133 // Loopup file
134 $this->cursor = mysql_query("SELECT `value` FROM `getid3_cache` WHERE (`filename`='".$filenam2."') AND (`filesize`='".$filesize."') AND (`filetime`='".$filetime."')", $this->connection);
135 list($result) = @mysql_fetch_array($this->cursor);
148 $res2 = mysql_escape_string(serialize($result));
149 $this->cursor = mysql_query("INSERT INTO `getid3_cache` (`filename`, `filesize`, `filetime`, `analyzetime`, `value`) VALUES ('".$filenam2."', '".$filesize."', '".$filetime."', '".time()."', '".$res2."')", $this->connection);
150 }
158
159 $this->cursor = mysql_query("CREATE TABLE IF NOT EXISTS `getid3_cache` (
160 `filename` VARCHAR(255) NOT NULL DEFAULT '',
tab_advancedsearch.php http://thegamesdb.googlecode.com/svn/trunk/ | PHP | 145 lines
42 <?$query = "SELECT * FROM languages";
43 $result = mysql_query($query) or die('Query failed: List ' . mysql_error());
44 while ($languagelist = mysql_fetch_object($result)) {
56 <?$query = "SELECT * FROM genres";
57 $result = mysql_query($query) or die('Query failed: List ' . mysql_error());
58 while ($languagelist = mysql_fetch_object($result)) {
134 $query = "SELECT *, games.id as showid, (SELECT round(avg(rating)) FROM ratings WHERE itemid = games.id and itemtype='series') AS srating FROM (translation_seriesname INNER JOIN games ON translation_seriesname.seriesid = games.id) INNER JOIN languages ON translation_seriesname.languageid = languages.id ".$where.$orderby." LIMIT 50";
135 $result = mysql_query($query) or die('Query failed: List ' . mysql_error());
136 while ($serieslist = mysql_fetch_object($result)) {
index.php http://showslow.googlecode.com/svn/trunk/ | PHP | 164 lines
10 );
11 $result = mysql_query($query);
12
130
131 if (!mysql_query($query))
132 {
formtimkiem.php http://clover-mana.googlecode.com/svn/trunk/ | PHP | 178 lines
22 $strSQL2 = "select * from category";
23 $result2 = mysql_query ($strSQL2,$connection);
24 $i = 0;
117 }
118 $result = mysql_query ($strSQL,$connection);
119 $Count = mysql_num_rows($result);
157 $sql_1 = "select count(*) from chapter where MID = $mid";
158 $result_1 = mysql_query($sql_1);
159 $row_1 = mysql_fetch_array($result_1);
addfav.php http://jcuecafe.googlecode.com/svn/ | PHP | 121 lines
22 $query="SELECT Favourite_1,Favourite_2,Favourite_3 from favourite where Favourite_ID='$u'";
23 $results= mysql_query($query) or die(mysql_error());
24 $num_results = mysql_num_rows($results);
28 $query="Insert into favourite values ($u,$i,0,0)";
29 $results= mysql_query($query) or die(mysql_error());
30 ?>
40 $query="SELECT Favourite_1,Favourite_2,Favourite_3 from favourite where Favourite_ID='$u'";
41 $results= mysql_query($query) or die(mysql_error());
42 $msg="none";
92 {
93 $results= mysql_query($query) or die(mysql_error());
94 ?>
eBPLS.Announcement.class.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 255 lines
239
240 $ifexist = @mysql_query("select * from ebpls_announcement where announcements = '$announcement' and eaid <> '$bbo'");
241 //echo "select * from ebpls_announcement where announcements = '$announcement' and eaid <> '$bbo'";
MySQLConnection.class.php git://github.com/xp-framework/xp-framework.git | PHP | 259 lines
108
109 mysql_query('set names LATIN1', $this->handle);
110
114 // "modes is a list of different modes separated by comma (,) characters."
115 $modes= array_flip(explode(',', current(mysql_fetch_row(mysql_query(
116 "show variables like 'sql_mode'",
201 } else {
202 $result= @mysql_query($sql, $this->handle);
203 }
index.php git://github.com/MrMEEE/ironhide.git | PHP | 137 lines
23 mysql_real_escape_string($start), mysql_real_escape_string($shutdown));
24 $query = mysql_query($sql);
25 $row = mysql_fetch_assoc($query);
30 // acceptable since $confirmed and $id are both numbers
31 mysql_query("UPDATE `confirmed` SET `Users Confirming`=$confirmed WHERE id=$id");
32 echo "System Added to already existing profile";
42 );
43 mysql_query($sql);
44 echo "System Added";
52 if($searchitem=="showall")
53 $query = mysql_query("SELECT * FROM `confirmed` ORDER by Manufacturer");
54 else
54 else
55 $query = mysql_query(sprintf("SELECT * FROM confirmed WHERE Model = '%s'",
56 mysql_real_escape_string($searchitem)));
index.php https://code.google.com/p/nuked-klan/ | PHP | 202 lines
43
44 $sql = mysql_query('SELECT
45 (SELECT COUNT(id) FROM ' . USER_TABLE . ') AS nb_us,
71 $nb = 0;
72 $sql2 = mysql_query('SELECT nom, count FROM ' . STATS_TABLE . ' ORDER BY count DESC');
73 while (list($page, $count) = mysql_fetch_array($sql2)) {
ebpls_buslist_mainbusact.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 127 lines
28
29 $result=mysql_query("select lgumunicipality, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error());
30 $resulta=mysql_fetch_row($result);
64 // unang gawang tama
65 $result=mysql_query("select ' ', ' ', business_name, ' ', business_street, '0.00', '0.00', '0.00', ' ', ' ', ' '
66 from ebpls_business_enterprise") or die(mysql_error());
69 /* sample/test ko lng
70 $result=mysql_query("select a.owner_id, a.business_name, a.business_city_code, a.business_type_code,
71 a.business_street, a.business_capital_investment, a.business_last_yrs_dec_gross_sales, b.fee_amount,
93
94 $result=mysql_query("select gs_name, gs_pos, gs_office from global_sign where sign_id =1") or die(mysql_error());
95 $resulta=mysql_fetch_row($result);
action.summary.php http://modx-ja.googlecode.com/svn/trunk/ | PHP | 311 lines
144// make sure we can use the database
145if ($installMode > 0 && !@ mysql_query("USE {$dbase}")) {
146 $errors += 1;
151if (!isset ($database_connection_charset) || empty ($database_connection_charset)) {
152 if (!$rs = @ mysql_query("show session variables like 'collation_database'")) {
153 $rs = @ mysql_query("show session variables like 'collation_server'");
172 echo "<p>" . $_lang['checking_table_prefix'] . $table_prefix . "`: ";
173 if ($rs= @ mysql_query("SELECT COUNT(*) FROM $dbase.`" . $table_prefix . "site_content`")) {
174 echo "<span class=\"notok\">" . $_lang['failed'] . "</span></b>" . $_lang['table_prefix_already_inuse'] . "</p>";
181 echo "<p>" . $_lang['checking_table_prefix'] . $table_prefix . "`: ";
182 if (!$rs = @ mysql_query("SELECT COUNT(*) FROM $dbase.`" . $table_prefix . "site_content`")) {
183 echo "<span class=\"notok\">" . $_lang['failed'] . "</span></b>" . $_lang['table_prefix_not_exist'] . "</p>";
204 echo "<p>". $_lang['checking_mysql_strict_mode'];
205 $mysqlmode = @ mysql_query("SELECT @@global.sql_mode");
206 if (@mysql_num_rows($mysqlmode) > 0){
ms_csv.php git://pkgs.fedoraproject.org/ocsinventory | PHP | 166 lines
84 while($_SESSION['OCS']['SQL_DATA_FIXE'][$protectedGet['tablename']][$i]){
85 $result=mysql_query($_SESSION['OCS']['SQL_DATA_FIXE'][$protectedGet['tablename']][$i], $link) or die(mysql_error($link));
86 while( $cont = mysql_fetch_array($result,MYSQL_ASSOC) ) {
admin_pref.php https://openticket.svn.sourceforge.net/svnroot/openticket | PHP | 197 lines
25 //keys for config table
26 $query=mysql_query("SHOW COLUMNS FROM ".$db_table['config']);
27 $keys=array();
36 foreach ($sqls as $sql) {
37 if (!mysql_query($sql)) { $err[] = LANG_FAILED.': '.mysql_error()." :<br>\n $sql"; }
38 }
44 //normal keys for settings
45 $query=@mysql_query("SELECT `key` FROM `".$db_table['settings']."` WHERE `group`='' OR `group` IS NULL");
46 if ($query) {
54 foreach ($sqls as $sql) {
55 if (!mysql_query($sql)) { $err[] = LANG_FAILED.': '.mysql_error()." :<br>\n $sql"; }
56 }
61 $sql="UPDATE ".$db_table['config']." SET filetypes = REPLACE(filetypes, ".escape_string($_POST['filetypes'].';').", '')";
62 if (!mysql_query($sql)) { $err[] = LANG_FAILED.': '.mysql_error()." :<br>\n $sql"; }
63 if (empty($err)) { header('Location: '.$_SERVER['REQUEST_URI']); die(); }
apphis.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 196 lines
11
12 $get = mysql_query("select * from ebpls_business_enterprise a, ebpls_owner c
13 where a.owner_id='$owner_id' and
78
79 $get = mysql_query("select distinct(for_year), business_permit_code, application_date,
80 transaction, steps, released, released_date from ebpls_business_enterprise_permit
114 <?php
115 $getphis = mysql_query("select * from ebpls_transaction_payment_or_details a,
116 ebpls_transaction_payment_or b where
136 if ($p["or_entry_type"]=='CHECK') {
137 $gs = mysql_query("select * from ebpls_transaction_payment_check where
138 or_no='$p[or_no]'");
index.php http://showslow.googlecode.com/svn/trunk/ | PHP | 435 lines
40
41$result = mysql_query($query);
42
133
134$result = mysql_query($query);
135
149
150$result = mysql_query($query);
151
exiberelatorioacesso.php http://conexao.googlecode.com/svn/trunk/ | PHP | 207 lines
50 $sql= "SELECT * FROM acesso ORDER BY datacesso";
51 $resultado=mysql_query($sql) or die ("Nao foi possivel realizar a consulta ao banco de dados".mysql_error());
52
96 $sql= "SELECT * FROM acesso ORDER BY usuario";
97 $resultado=mysql_query($sql) or die ("Nao foi possivel realizar a consulta ao banco de dados".mysql_error());
98
143 $sql= "SELECT * FROM acesso";
144 $resultado=mysql_query($sql) or die ("Nao foi possivel realizar a consulta ao banco de dados".mysql_error());
145
class.database.php https://code.google.com/p/bf2stats/ | PHP | 194 lines
62 {
63 $sql = mysql_query($query,$this->mysql) or die("Couldnt Run Query: ".$query."<br />Error: ".mysql_error($this->mysql)."");
64 $this->_statistics['count']++;
72 {
73 $sql = mysql_query($query,$this->mysql) or die("Couldnt Run Query: ".$query."<br />Error: ".mysql_error($this->mysql)."");
74 $this->_statistics['count']++;
99 {
100 $sql = mysql_query($query,$this->mysql) or die("Couldnt Run Query: ".$query."<br />Error: ".mysql_error($this->mysql)."");
101 $this->_statistics['count']++;
117 {
118 $sql = mysql_query($query,$this->mysql) or die("Couldnt Run Query: ".$query."<br />Error: ".mysql_error($this->mysql)."");
119 $this->_statistics['count']++;
136 {
137 $sql = mysql_query($query, $this->mysql) or die("Couldnt Run Query: ".$query."<br />Error: ".mysql_error($this->mysql)."");
138 $this->_statistics['count']++;
outcomment_pt.php http://clover-mana.googlecode.com/svn/trunk/ | PHP | 164 lines
27
28$rs = mysql_query($string,$connection);
29$kq = mysql_fetch_array($rs);
31
32$rs1 = mysql_query($string1,$connection);
33$kq1 = mysql_fetch_array($rs1);
52}
53$cout = mysql_query($coutrow,$connection);
54$result = mysql_query($strSQL,$connection);
128 $str = "SELECT account.Username,Power FROM account WHERE account.UID = '$row[1]' ";
129 $result_user = mysql_query($str,$connection);
130 if(mysql_errno() != 0)
ez_sql_mysql.php http://thinksns-2.googlecode.com/svn/trunk/ | PHP | 271 lines
63
64 mysql_query('SET NAMES UTF8',$this->dbh);
65
96
97 mysql_query('SET NAMES UTF8',$this->dbh);
98
200
201 // Perform the query via std mysql_query function..
202 $this->result = @mysql_query($query,$this->dbh);
transmettreFacture.php git://git.savannah.nongnu.org/gcourrier.git | PHP | 94 lines
45 $requete = "SELECT * FROM service ORDER BY libelle; ";
46 $result = mysql_query($requete) or die( mysql_error() );
47 while( $ligne = mysql_fetch_array( $result ) ){
79 VALUES ($idCourrier,$service,'$date')";
80 $result = mysql_query($requete) or die(mysql_error());
81
85
86 $result = mysql_query($requete) or die(mysql_error());
87 while ($ligne = mysql_fetch_array($result))
89 $requete = "UPDATE facture SET histo='$libService' WHERE id='$idCourrier'";
90 $result = mysql_query($requete) or die(mysql_error());
91