PageRenderTime 35ms queryTime 44ms sortTime 10ms getByIdsTime 16ms findMatchingLines 10ms

100+ results results for 'mysql_query repo:krishna2793/aces' (35 ms)

Not the results you expected?
show.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 161 lines
                    
19}
                    
20$req = mysql_query("SELECT * FROM `cms_album_cat` where `website` = '$website' AND  `id` = '$al'");
                    
21if (!mysql_num_rows($req)) {
                    
81    $kmess = 1;
                    
82    $start = isset($_REQUEST['page']) ? $page - 1 : (mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` where `website` = '$website' AND  `album_id` = '$al' AND `id` > '$img'"), 0));
                    
83    // Обрабатываем ссылку для возврата
                    
88}
                    
89$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` where `website` = '$website' AND  `album_id` = '$al'"), 0);
                    
90if ($total > $kmess)
                    
92if ($total) {
                    
93    $req = mysql_query("SELECT * FROM `cms_album_files` where `website` = '$website' AND  `user_id` = '" . $user['id'] . "' AND `album_id` = '$al' ORDER BY `id` DESC LIMIT $start, $kmess");
                    
94    $i = 0;
                    
115            // Счетчик просмотров
                    
116            if (!mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_views` where `website` = '$website' AND  `user_id` = '$user_id' AND `file_id` = '" . $res['id'] . "'"), 0)) {
                    
117                mysql_query("INSERT INTO `cms_album_views` SET `user_id` = '$user_id', `file_id` = '" . $res['id'] . "', `time` = '" . time() . "', `website` = '$website'");
                    
                
index.php https://github.com/michaelmwu/saratogahigh.com.git | PHP | 219 lines
                    
15	if(is_numeric($_GET['delete']))
                    
16		mysql_query('DELETE FROM NOTEPAGE_LIST WHERE NOTEPAGE_OWNER=' . $userid . ' AND NOTEPAGE_ID=' . $_GET['delete']) or die("Delete failed.");
                    
17	if($_POST['go'] == 'Save')
                    
23		else
                    
24			mysql_query('INSERT INTO NOTEPAGE_LIST (NOTEPAGE_OWNER, NOTEPAGE_CREATED, NOTEPAGE_MODIFIED, NOTEPAGE_VALUE, NOTEPAGE_DIGEST) VALUES (' . $userid . ', "' . date(TIME_FORMAT_SQL, CURRENT_TIME) . '", NOTEPAGE_CREATED, \'' . $_POST['entrytext'] . '\', \'' . makedigest($_POST['entrytext']) . '\')') or die("Insert failed.");
                    
25	}
                    
27	{
                    
28		mysql_query('UPDATE NOTEPAGE_LIST SET NOTEPAGE_MODIFIED="' . date(TIME_FORMAT_SQL, CURRENT_TIME) . '", NOTEPAGE_VALUE=\'' . $_POST['entrytext'] . '\', NOTEPAGE_DIGEST=\'' . makedigest($_POST['entrytext']) . '\' WHERE NOTEPAGE_OWNER=' . $userid . ' AND NOTEPAGE_ID=' . $_GET['id']) or die("Insert failed.");
                    
29	}
                    
64        
                    
65        $entries = mysql_query('SELECT NOTEPAGE_ID, NOTEPAGE_DIGEST, UNIX_TIMESTAMP(NOTEPAGE_CREATED) as TS FROM NOTEPAGE_LIST WHERE NOTEPAGE_OWNER=' . $userid . ' AND MATCH(NOTEPAGE_VALUE) AGAINST (\'' . $_GET['query'] . '\')') or die('Query failed.');
                    
66
                    
180
                    
181	$entries = mysql_query('SELECT NOTEPAGE_LIST.*, NOTEPAGE_CREATED as CR, NOTEPAGE_MODIFIED as MO FROM NOTEPAGE_LIST WHERE NOTEPAGE_OWNER=' . $userid . ' AND NOTEPAGE_ID=' . $id) or die('Query failed.');
                    
182			
                    
                
core.php https://github.com/rezamoussavi/MouRe.git | PHP | 351 lines
                    
25		if(!$osdbcon){ $_result=null; return;}
                    
26		$_result= mysql_query(parseQuery($caller,$s),$osdbcon);
                    
27	}
                    
29		global $osdbcon,$_result;
                    
30		if(!($_result= $osdbcon? mysql_query($s,$osdbcon):false)){
                    
31			osLog("os","query()","calling mysql_query() <b><font color=red>ERROR</font><br />Query:</b><br />".$s);
                    
                
delivery_list.php https://gitlab.com/Henaway/CLFC | PHP | 253 lines
                    
25    route_name ASC';
                    
26$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 769302 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
27while ( $row = mysql_fetch_array($result) )
                    
73    last_name ASC';
                    
74$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 769302 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
75$num_orders = mysql_numrows($result);
                    
188    sum_p DESC';
                    
189$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 860342 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
190while ($row = mysql_fetch_array($result))
                    
                
watch_brek_vid.php https://gitlab.com/msdusad/all_ones | PHP | 237 lines
                    
49		$sd="select bann_news from banner";
                    
50		$ab=mysql_query($sd);
                    
51		$df=mysql_fetch_array($ab);
                    
69			
                    
70			$rf=mysql_query($df);
                    
71			$row=mysql_fetch_array($rf);
                    
111			
                    
112			$rf=mysql_query($df);
                    
113			$row=mysql_fetch_array($rf);
                    
                
functions_db.php https://github.com/justinmc/turkiball.com.git | PHP | 389 lines
                    
34   
                    
35   $QUERY = mysql_query("SELECT * FROM $table WHERE Index = '$index'");
                    
36   $DATA = mysql_fetch_array($QUERY);
                    
54   
                    
55   $QUERY = mysql_query("SELECT * FROM $table WHERE `Index` = $index");
                    
56   $DATA = mysql_fetch_array($QUERY);
                    
74   
                    
75   $QUERY = mysql_query("SELECT * FROM smf_messages WHERE ID_MSG = $id");
                    
76   $DATA = mysql_fetch_array($QUERY);
                    
94   
                    
95   $QUERY = mysql_query("SELECT * FROM smf_members WHERE ID_MEMBER = $id");
                    
96   $DATA = mysql_fetch_array($QUERY);
                    
123   {
                    
124      $QUERY = mysql_query("SELECT * FROM smf_members WHERE ID_MEMBER = $count");
                    
125      $DATA = mysql_fetch_array($QUERY);
                    
                
submit_track.php http://airscore.googlecode.com/svn/trunk/ | PHP | 332 lines
                    
19$query = "select *, unix_timestamp(comDateTo) as comUnixTo  from tblCompetition where comPk=$comPk";
                    
20$result = mysql_query($query) or die('Query failed: ' . mysql_error());
                    
21$title = 'highcloud.net';
                    
123    $query = "select pilPk, pilHGFA from tblPilot where pilLastName='$name'";
                    
124    $result = mysql_query($query) or die('Query failed: ' . mysql_error());
                    
125
                    
171        $query = "select T.tasPk, T.tasTaskType, C.comType from tblTask T, tblTrack TL, tblCompetition C where C.comPk=T.comPk and T.comPk=$comid and TL.traPk=$maxPk and TL.traStart > date_sub(T.tasDate, interval C.comTimeOffset hour) and TL.traStart < date_add(T.tasDate, interval (24-C.comTimeOffset) hour)";
                    
172        $result = mysql_query($query) or die('Query failed: ' . mysql_error());
                    
173        if (mysql_num_rows($result) > 0)
                    
181    $query = "insert into tblComTaskTrack (comPk,tasPk,traPk) values ($comid,$tasPk,$maxPk)";
                    
182    $result = mysql_query($query) or die('ComTaskTrack failed: ' . mysql_error());
                    
183
                    
225    $query = "update tblTrack set traGlider='$glider', traDHV='$dhv' where traPk=$maxPk";
                    
226    $result = mysql_query($query) or die('Update tblTrack failed: ' . mysql_error());
                    
227
                    
                
events.php https://github.com/cybernet/CyBerFuN-CoDeX.git | PHP | 272 lines
                    
114$sql = "DELETE FROM `events` WHERE `id` = $id LIMIT 1;";
                    
115$res = mysql_query($sql);
                    
116if(mysql_error()!=0)
                    
150//echo "<p>$sql</p>";
                    
151$res = mysql_query($sql);
                    
152if(mysql_error()!=0)
                    
                
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 ") ;
                    
                
edit.php https://github.com/heidymadia/sfbackup.git | PHP | 54 lines
                    
7$sql = "UPDATE `opportunities` SET  `AccountId` =  '{$_POST['AccountId']}' ,  `Amount` =  '{$_POST['Amount']}' ,  `CampaignId` =  '{$_POST['CampaignId']}' ,  `CloseDate` =  '{$_POST['CloseDate']}' ,  `CreatedById` =  '{$_POST['CreatedById']}' ,  `CreatedDate` =  '{$_POST['CreatedDate']}' ,  `CurrentGenerators__c` =  '{$_POST['CurrentGenerators__c']}' ,  `DeliveryInstallationStatus__c` =  '{$_POST['DeliveryInstallationStatus__c']}' ,  `Description` =  '{$_POST['Description']}' ,  `ExpectedRevenue` =  '{$_POST['ExpectedRevenue']}' ,  `Fiscal` =  '{$_POST['Fiscal']}' ,  `FiscalQuarter` =  '{$_POST['FiscalQuarter']}' ,  `FiscalYear` =  '{$_POST['FiscalYear']}' ,  `ForecastCategory` =  '{$_POST['ForecastCategory']}' ,  `ForecastCategoryName` =  '{$_POST['ForecastCategoryName']}' ,  `HasOpportunityLineItem` =  '{$_POST['HasOpportunityLineItem']}' ,  `IsClosed` =  '{$_POST['IsClosed']}' ,  `IsDeleted` =  '{$_POST['IsDeleted']}' ,  `IsPrivate` =  '{$_POST['IsPrivate']}' ,  `IsWon` =  '{$_POST['IsWon']}' ,  `LastActivityDate` =  '{$_POST['LastActivityDate']}' ,  `LastModifiedById` =  '{$_POST['LastModifiedById']}' ,  `LastModifiedDate` =  '{$_POST['LastModifiedDate']}' ,  `LeadSource` =  '{$_POST['LeadSource']}' ,  `MainCompetitors__c` =  '{$_POST['MainCompetitors__c']}' ,  `Name` =  '{$_POST['Name']}' ,  `NextStep` =  '{$_POST['NextStep']}' ,  `OrderNumber__c` =  '{$_POST['OrderNumber__c']}' ,  `OwnerId` =  '{$_POST['OwnerId']}' ,  `Pricebook2Id` =  '{$_POST['Pricebook2Id']}' ,  `Probability` =  '{$_POST['Probability']}' ,  `StageName` =  '{$_POST['StageName']}' ,  `SystemModstamp` =  '{$_POST['SystemModstamp']}' ,  `TotalOpportunityQuantity` =  '{$_POST['TotalOpportunityQuantity']}' ,  `TrackingNumber__c` =  '{$_POST['TrackingNumber__c']}' ,  `Type` =  '{$_POST['Type']}'   WHERE `id` = '$id' "; 
                    
8mysql_query($sql) or die(mysql_error()); 
                    
9echo (mysql_affected_rows()) ? "Edited row.<br />" : "Nothing changed. <br />"; 
                    
11} 
                    
12$row = mysql_fetch_array ( mysql_query("SELECT * FROM `opportunities` WHERE `id` = '$id' ")); 
                    
13?>
                    
                
log-2016-01-20.php https://gitlab.com/fcupen/PHP | PHP | 44 lines
                    
20ERROR - 2016-01-20 12:20:54 --> Severity: error --> Exception: Configured database connection is persistent. Aborting. /usr/home/astfou/domains/astral-foundations.com/public_html/system/libraries/Session/drivers/Session_database_driver.php 94
                    
21ERROR - 2016-01-20 12:37:40 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
22ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
22ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
23ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_query(): A link to the server could not be established /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
24ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40
                    
24ERROR - 2016-01-20 12:37:40 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40
                    
25ERROR - 2016-01-20 12:40:19 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
26ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
26ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
27ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_query(): A link to the server could not be established /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
28ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40
                    
28ERROR - 2016-01-20 12:40:19 --> Severity: Warning --> mysql_fetch_array() expects parameter 1 to be resource, boolean given /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 40
                    
29ERROR - 2016-01-20 12:40:55 --> Severity: 8192 --> mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
30ERROR - 2016-01-20 12:40:55 --> Severity: Warning --> mysql_query(): Access denied for user ''@'localhost' (using password: NO) /usr/home/astfou/domains/astral-foundations.com/public_html/application/controllers/my_account/Main.php 39
                    
                
edit.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 122 lines
                    
18    }
                    
19    $req = mysql_query("SELECT * FROM `lib` where `website` = '$website' AND  `id` = '" . $id . "'");
                    
20    $ms = mysql_fetch_array($req);
                    
44                }
                    
45                mysql_query("UPDATE `lib` SET
                    
46                    `name` = '" . mysql_real_escape_string(mb_substr(trim($_POST['name']), 0, 100)) . "',
                    
66                $mod = intval($_POST['mod']);
                    
67                mysql_query("UPDATE `lib` SET
                    
68                `text` = '" . $text . "',
                    
78            $text = functions::check($_POST['text']);
                    
79                mysql_query("update `lib` set text='" . $text . "' where `website` = '$website' AND  id='" . $id . "';");
                    
80                header("location: index.php?id=$ms[refid]");
                    
                
phorum.rb https://gitlab.com/Ruwan-Ranganath/discourse | Ruby | 218 lines
                    
30
                    
31    total_count = mysql_query("SELECT count(*) count FROM #{TABLE_PREFIX}users;").first['count']
                    
32
                    
33    batches(BATCH_SIZE) do |offset|
                    
34      results = mysql_query(
                    
35        "SELECT user_id id, username, email, real_name name, date_added created_at,
                    
59
                    
60    categories = mysql_query("
                    
61                              SELECT forum_id id, name, description, active
                    
83
                    
84    total_count = mysql_query("SELECT count(*) count from #{TABLE_PREFIX}messages").first["count"]
                    
85
                    
86    batches(BATCH_SIZE) do |offset|
                    
87      results = mysql_query("
                    
88        SELECT m.message_id id,
                    
                
moreinfo.php https://github.com/damanlovett/SEAHO.git | PHP | 145 lines
                    
38$query_rsConference = sprintf("SELECT * FROM conference WHERE conference.deleted = 0 AND conference.conference_id = %s", GetSQLValueString($colname_rsConference, "text"));
                    
39$rsConference = mysql_query($query_rsConference, $CMS) or die(mysql_error());
                    
40$row_rsConference = mysql_fetch_assoc($rsConference);
                    
48$query_rsItems = sprintf("SELECT * FROM delegate_invoice WHERE delegate_invoice.conference_id=%s AND delegate_invoice.deleted = 0 AND delegate_invoice.type != 'registration' ORDER BY delegate_invoice.label", GetSQLValueString($colname_rsItems, "text"));
                    
49$rsItems = mysql_query($query_rsItems, $CMS) or die(mysql_error());
                    
50$row_rsItems = mysql_fetch_assoc($rsItems);
                    
58$query_rsFees = sprintf("SELECT * FROM delegate_invoice WHERE delegate_invoice.conference_id=%s AND delegate_invoice.deleted = 0 AND delegate_invoice.type = 'registration' ORDER BY delegate_invoice.amount", GetSQLValueString($colname_rsFees, "text"));
                    
59$rsFees = mysql_query($query_rsFees, $CMS) or die(mysql_error());
                    
60$row_rsFees = mysql_fetch_assoc($rsFees);
                    
                
counters.php https://gitlab.com/phamngsinh/baitaplon_sinhvien | PHP | 203 lines
                    
23
                    
24        $albumcount = mysql_result(mysql_query("SELECT COUNT(DISTINCT `user_id`) FROM `cms_album_files` WHERE `website` = '$website'"), 0);
                    
25        $photocount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `website` = '$website'"), 0);
                    
25        $photocount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `website` = '$website'"), 0);
                    
26        $newcount = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` where `website` = '$website' AND  `time` > '" . (time() - 259200) . "' AND `access` > '1'"), 0);
                    
27        return $albumcount . '&#160;/&#160;' . $photocount . ($newcount ? '&#160;/&#160;<span class="red"><a href="' . core::$system_set['homeurl'] . '/users/album.php?act=top">+' . $newcount . '</a></span>' : '');
                    
38
                    
39        $total = mysql_result(mysql_query("SELECT COUNT(*) FROM `download` where `website` = '$website' AND  `type` = 'file'"), 0);
                    
40        $new = mysql_result(mysql_query("SELECT COUNT(*) FROM `download` where `website` = '$website' AND  `time` > '" . (time() - 259200) . "' AND `type` = 'file'"), 0);
                    
54
                    
55        $total_thm = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` where `website` = '$website' AND  `type` = 't'" . (core::$user_rights >= 7 ? "" : " AND `close` != '1'")), 0);
                    
56        $total_msg = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` where `website` = '$website' AND  `type` = 'm'" . (core::$user_rights >= 7 ? "" : " AND `close` != '1'")), 0);
                    
78        if (core::$user_id) {
                    
79            $req = mysql_query("SELECT COUNT(*) FROM `forum`
                    
80                LEFT JOIN `cms_forum_rdm` ON `forum`.`id` = `cms_forum_rdm`.`topic_id` AND `cms_forum_rdm`.`user_id` = '" . core::$user_id . "'
                    
                
tracker_stats.inc.php https://github.com/harriswong/ATutor.git | PHP | 487 lines
                    
26$sql5 = "select * from ".TABLE_PREFIX."g_refs";
                    
27	$result = mysql_query($sql5, $db);
                    
28	$refs = array();
                    
46
                    
47	if(!$result8 = mysql_query($sql8, $db)){
                    
48		require(AT_INCLUDE_PATH.'footer.inc.php');
                    
67			course_id='$_SESSION[course_id]'";
                    
68	if(!$result7 = mysql_query($sql7, $db)){
                    
69		require(AT_INCLUDE_PATH.'footer.inc.php');
                    
93	$title_tools = array();
                    
94	$result9 = mysql_query($sql9, $db);
                    
95	while ($row= mysql_fetch_array($result9)) {
                    
102$sql10 = "select count(g) from ".TABLE_PREFIX."g_click_data where course_id='$_SESSION[course_id]' GROUP BY g";
                    
103$result10 = mysql_query($sql10, $db);
                    
104while($row=mysql_fetch_array($result10)){
                    
                
edit_event.php https://bitbucket.org/anneivycat/california-tour.git | PHP | 326 lines
                    
29
                    
30		$mysql_result_update = mysql_query($query_update, $mysql_link);
                    
31	}
                    
41			$query_check_cat = "SELECT category_id from CATEGORIES where category_name = '$NewCategoryName'";
                    
42			$mysql_result_cat_check = mysql_query($query_check_cat,$mysql_link);
                    
43
                    
49
                    
50				$mysql_result_cat_insert = mysql_query($query_cat_insert, $mysql_link);
                    
51				$CategoryId = $NewCategoryId;
                    
65//	print($query_get_info);
                    
66	$mysql_result_get_info = mysql_query($query_get_info, $mysql_link);
                    
67
                    
80	$query_user = "SELECT user_name from USER where user_id = '$EventUserId'";
                    
81	$mysql_result_user = mysql_query($query_user, $mysql_link);
                    
82	$row_user = mysql_fetch_array($mysql_result_user);
                    
                
listCMS_ONLINE_RESOURCES.php https://github.com/juddy/GIP.git | PHP | 211 lines
                    
39$sql = "SELECT   * FROM CMS_ONLINE_RESOURCES".$orderByQuery.$limitQuery;
                    
40$result = MYSQL_QUERY($sql);
                    
41$numberOfRows = MYSQL_NUM_ROWS($result);
                    
                
listCMS_OFFLINE_RESOURCES.php https://github.com/juddy/GIP.git | PHP | 211 lines
                    
39$sql = "SELECT   * FROM CMS_OFFLINE_RESOURCES".$orderByQuery.$limitQuery;
                    
40$result = MYSQL_QUERY($sql);
                    
41$numberOfRows = MYSQL_NUM_ROWS($result);
                    
                
listGridCMS_GROUPUSERS.php https://github.com/juddy/GIP.git | PHP | 225 lines
                    
15	$sqlUpdate = "UPDATE CMS_GROUPUSERS SET GROUP_ID = '$thisGROUP_ID' , USER_ID = '$thisUSER_ID' , GROUPUSER_FLAGS = '$thisGROUPUSER_FLAGS'  WHERE GROUP_ID = '$thisGROUP_ID'";
                    
16	$resultUpdate = MYSQL_QUERY($sqlUpdate);
                    
17	echo "<b>Record with Id ".$thisGROUP_IDFromForm." has been Updated<br></b>";
                    
28	$sqlInsert = "INSERT INTO CMS_GROUPUSERS (GROUP_ID , USER_ID , GROUPUSER_FLAGS ) VALUES ('$thisGROUP_ID' , '$thisUSER_ID' , '$thisGROUPUSER_FLAGS' )";
                    
29	$resultInsert = MYSQL_QUERY($sqlInsert);
                    
30	echo "<b>Record has been inserted in Database<br></b>";
                    
41	$sqlDelete = "DELETE FROM CMS_GROUPUSERS WHERE GROUP_ID = '$thisGROUP_ID'";
                    
42	$resultDelete = MYSQL_QUERY($sqlDelete);
                    
43
                    
81$sql = "SELECT   * FROM CMS_GROUPUSERS".$orderByQuery.$limitQuery;
                    
82$result = MYSQL_QUERY($sql);
                    
83$numberOfRows = MYSQL_NUM_ROWS($result);
                    
                
DBIMysql.class.php https://gitlab.com/qbarbosa/klindev | PHP | 468 lines
                    
188        if ($options == ($options | PMA_DatabaseInterface::QUERY_STORE)) {
                    
189            return mysql_query($query, $link);
                    
190        } elseif ($options == ($options | PMA_DatabaseInterface::QUERY_UNBUFFERED)) {
                    
192        } else {
                    
193            return mysql_query($query, $link);
                    
194        }
                    
                
customer_list.php https://gitlab.com/Henaway/CLFC | PHP | 280 lines
                    
56    AND '.NEW_TABLE_PRODUCTS.'.product_version = "'.mysql_real_escape_string ($product_version).'"';
                    
57$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 738102 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
58if ( $row = mysql_fetch_object($result) )
                    
189        AND product_version = "'.mysql_real_escape_string ($product_version).'"';
                    
190    $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 155816 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
191    $bpid= mysql_insert_id();
                    
204        AND product_version = "'.mysql_real_escape_string ($product_version).'"';
                    
205    $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 731034 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
206  }
                    
223        inventory_id = '.mysql_real_escape_string ($inventory_id);
                    
224    $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 066934 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
225  }
                    
235        AND product_version = "'.mysql_real_escape_string ($product_version).'"';
                    
236    $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 267490 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
237  }
                    
                
mysqldataprovider.cpp https://gitlab.com/ablu/invertika-backup-invertika | C++ | 454 lines
                    
156        // actually execute the query.
                    
157        if (mysql_query(mDb, sql.c_str()) != 0) {
                    
158            throw DbSqlQueryExecFailure(mysql_error(mDb));
                    
                
ref.mysql.html https://bitbucket.org/stillzhl/manuals.git | HTML | 425 lines
                    
417
                    
418 <h2>Table of Contents</h2><ul class="chunklist chunklist_reference"><li><a href="function.mysql-affected-rows.html">mysql_affected_rows</a> — 取得前一次 MySQL 操作所影响的记录行数</li><li><a href="function.mysql-client-encoding.html">mysql_client_encoding</a> — 返回字符集的名称</li><li><a href="function.mysql-close.html">mysql_close</a> — 关闭 MySQL 连接</li><li><a href="function.mysql-connect.html">mysql_connect</a> — 打开一个到 MySQL 服务器的连接</li><li><a href="function.mysql-create-db.html">mysql_create_db</a> — 新建一个 MySQL 数据库</li><li><a href="function.mysql-data-seek.html">mysql_data_seek</a> — 移动内部结果的指针</li><li><a href="function.mysql-db-name.html">mysql_db_name</a> — 取得结果数据</li><li><a href="function.mysql-db-query.html">mysql_db_query</a> — 发送一条 MySQL 查询</li><li><a href="function.mysql-drop-db.html">mysql_drop_db</a> — 丢弃(删除)一个 MySQL 数据库</li><li><a href="function.mysql-errno.html">mysql_errno</a> — 返回上一个 MySQL 操作中的错误信息的数字编码</li><li><a href="function.mysql-error.html">mysql_error</a> — 返回上一个 MySQL 操作产生的文本错误信息</li><li><a href="function.mysql-escape-string.html">mysql_escape_string</a> — 转义一个字符串用于 mysql_query</li><li><a href="function.mysql-fetch-array.html">mysql_fetch_array</a> — 从结果集中取得一行作为关联数组,或数字数组,或二者兼有</li><li><a href="function.mysql-fetch-assoc.html">mysql_fetch_assoc</a> — 从结果集中取得一行作为关联数组</li><li><a href="function.mysql-fetch-field.html">mysql_fetch_field</a> — 从结果集中取得列信息并作为对象返回</li><li><a href="function.mysql-fetch-lengths.html">mysql_fetch_lengths</a> — 取得结果集中每个输出的长度</li><li><a href="function.mysql-fetch-object.html">mysql_fetch_object</a> — 从结果集中取得一行作为对象</li><li><a href="function.mysql-fetch-row.html">mysql_fetch_row</a> — 从结果集中取得一行作为枚举数组</li><li><a href="function.mysql-field-flags.html">mysql_field_flags</a> — 从结果中取得和指定字段关联的标志</li><li><a href="function.mysql-field-len.html">mysql_field_len</a> — 返回指定字段的长度</li><li><a href="function.mysql-field-name.html">mysql_field_name</a> — 取得结果中指定字段的字段名</li><li><a href="function.mysql-field-seek.html">mysql_field_seek</a> — 将结果集中的指针设定为制定的字段偏移量</li><li><a href="function.mysql-field-table.html">mysql_field_table</a> — 取得指定字段所在的表名</li><li><a href="function.mysql-field-type.html">mysql_field_type</a> — 取得结果集中指定字段的类型</li><li><a href="function.mysql-free-result.html">mysql_free_result</a> — 释放结果内存</li><li><a href="function.mysql-get-client-info.html">mysql_get_client_info</a> — 取得 MySQL 客户端信息</li><li><a href="function.mysql-get-host-info.html">mysql_get_host_info</a> — 取得 MySQL 主机信息</li><li><a href="function.mysql-get-proto-info.html">mysql_get_proto_info</a> — 取得 MySQL 协议信息</li><li><a href="function.mysql-get-server-info.html">mysql_get_server_info</a> — 取得 MySQL 服务器信息</li><li><a href="function.mysql-info.html">mysql_info</a> — 取得最近一条查询的信息</li><li><a href="function.mysql-insert-id.html">mysql_insert_id</a> — 取得上一步 INSERT 操作产生的 ID</li><li><a href="function.mysql-list-dbs.html">mysql_list_dbs</a> — 列出 MySQL 服务器中所有的数据库</li><li><a href="function.mysql-list-fields.html">mysql_list_fields</a> — 列出 MySQL 结果中的字段</li><li><a href="function.mysql-list-processes.html">mysql_list_processes</a> — 列出 MySQL 进程</li><li><a href="function.mysql-list-tables.html">mysql_list_tables</a> — 列出 MySQL 数据库中的表</li><li><a href="function.mysql-num-fields.html">mysql_num_fields</a> — 取得结果集中字段的数目</li><li><a href="function.mysql-num-rows.html">mysql_num_rows</a> — 取得结果集中行的数目</li><li><a href="function.mysql-pconnect.html">mysql_pconnect</a> — 打开一个到 MySQL 服务器的持久连接</li><li><a href="function.mysql-ping.html">mysql_ping</a> — Ping 一个服务器连接,如果没有连接则重新连接</li><li><a href="function.mysql-query.html">mysql_query</a> — 发送一条 MySQL 查询</li><li><a href="function.mysql-real-escape-string.html">mysql_real_escape_string</a> — 转义 SQL 语句中使用的字符串中的特殊字符,并考虑到连接的当前字符集</li><li><a href="function.mysql-result.html">mysql_result</a> — 取得结果数据</li><li><a href="function.mysql-select-db.html">mysql_select_db</a> — 选择 MySQL 数据库</li><li><a href="function.mysql-set-charset.html">mysql_set_charset</a> — 设置客户端的字符集</li><li><a href="function.mysql-stat.html">mysql_stat</a> — 取得当前系统状态</li><li><a href="function.mysql-tablename.html">mysql_tablename</a> — 取得表名</li><li><a href="function.mysql-thread-id.html">mysql_thread_id</a> — 返回当前线程的 ID</li><li><a href="function.mysql-unbuffered-query.html">mysql_unbuffered_query</a> — 向 MySQL 发送一条 SQL 查询,并不获取和缓存结果的行</li></ul>
                    
419</div>
                    
                
interface.php https://github.com/Lithixium/HawkEye.git | PHP | 244 lines
                    
35	$players = array();
                    
36	$res = mysql_query("SELECT * FROM `" . $config["dbPlayerTable"] . "`");
                    
37	if (!$res)
                    
45	$worlds = array();
                    
46	$res = mysql_query("SELECT * FROM `" . $config["dbWorldTable"] . "`");
                    
47	if (!$res)
                    
133	//Run query
                    
134	$res = mysql_query($sql);
                    
135	if (!$res)
                    
                
camaras_productor.model.php https://gitlab.com/talueses/SIPVE | PHP | 197 lines
                    
53		$link = DbLink::getLink();
                    
54		$result = mysql_query($sql, $link);
                    
55		if (!$result) {
                    
108		$str .= "\t\t\$link = DbLink::getLink();\n";
                    
109		$str .= "\t\t\$result = mysql_query(\$sql, \$link);\n";
                    
110		$str .= "\t\tif (!\$result) {\n";
                    
143		$str .= "\t\t\$link = DbLink::getLink();\n";
                    
144		$str .= "\t\t\$result = mysql_query(\$sql, \$link);\n";
                    
145		$str .= "\t\tif (!\$result) {\n";
                    
160                $str .= "\t\t\$link = DbLink::getLink();\n";
                    
161		$str .= "\t\t\$result = mysql_query(\$sql, \$link);\n";
                    
162		$str .= "\t\tif (!\$result) {\n";
                    
                
_stats_load.php https://gitlab.com/Etern4l/BitcoinDice | PHP | 238 lines
                    
17
                    
18$settings=mysql_fetch_array(mysql_query("SELECT * FROM `system` LIMIT 1"));
                    
19
                    
23  case 'my_bets':
                    
24    if (empty($_GET['_unique']) || mysql_num_rows(mysql_query("SELECT `id` FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1"))==0) exit();
                    
25    $player=mysql_fetch_array(mysql_query("SELECT * FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1"));
                    
26    
                    
27    $my_bets=mysql_query("SELECT * FROM `bets` WHERE `player`=$player[id] ORDER BY `time` DESC LIMIT 30");
                    
28    if (mysql_num_rows($my_bets)==0) $content.='<br><br><br><i>You haven\'t bet yet.</i>';
                    
44        
                    
45        $username=mysql_fetch_array(mysql_query("SELECT `alias` FROM `players` WHERE `id`=$my_bet[player] LIMIT 1"));
                    
46        
                    
74  case 'all_bets':
                    
75    $all_bets=mysql_query("SELECT * FROM `bets` WHERE `bet_amount`!=0 ORDER BY `time` DESC LIMIT 30");
                    
76    if (mysql_num_rows($all_bets)==0) $content.='<br><br><br><i>No one has bet yet.</i>';
                    
                
index.php https://github.com/jomartigcal/cvsea.git | PHP | 239 lines
                    
52			$query = "SELECT * FROM admins";
                    
53			$result = @mysql_query($query);
                    
54			$test = FALSE;
                    
                
mysql.dbi.lib.php https://gitlab.com/albert925/lading-ach | PHP | 450 lines
                    
171    if ($options == ($options | PMA_DBI_QUERY_STORE)) {
                    
172        $r = mysql_query($query, $link);
                    
173    } elseif ($options == ($options | PMA_DBI_QUERY_UNBUFFERED)) {
                    
175    } else {
                    
176        $r = mysql_query($query, $link);
                    
177    }
                    
                
heidelpay_response.php https://bitbucket.org/isaacoheneayisi/ecommerce.git | PHP | 190 lines
                    
48		mysql_select_db($connect->db);	
                    
49		$result = mysql_query("SELECT virtuemart_order_id FROM ".$connect->dbprefix."virtuemart_orders"." WHERE  order_number = '".mysql_real_escape_string($orderID)."';");
                    
50		$row = mysql_fetch_object($result);
                    
169					"response_ip					= \"".mysql_real_escape_string($_SERVER['REMOTE_ADDR']). "\";" ;
                    
170			$dbEerror = mysql_query($sql);
                    
171		}
                    
                
printprod_new.php https://gitlab.com/Henaway/CLFC | PHP | 201 lines
                    
34    subcategory_name ASC';
                    
35$rs = @mysql_query($sql, $connection) or die("Couldn't execute category query: ".mysql_error());
                    
36while ( $row = mysql_fetch_array($rs) )
                    
98        '.TABLE_MEMBER.'.business_name';
                    
99    $resultp = @mysql_query($sqlp, $connection) or die("Couldn't execute query 2.");
                    
100    while ( $row = mysql_fetch_array($resultp) )
                    
128            unit_price ASC';
                    
129        $result = @mysql_query($sql, $connection) or die("Couldn't execute search query: " . mysql_error());
                    
130        while ( $row = mysql_fetch_array($result) )
                    
                
ebpls_bus_indtaxdelinquent.html http://ebpls.googlecode.com/svn/trunk/ | HTML | 199 lines
                    
28
                    
29					$result=mysql_query("select lgumunicipality, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error());
                    
30          $resulta=mysql_fetch_row($result);
                    
126	         // unang gawang tama
                    
127	        $result=mysql_query("select ' ', ' ', ' ' , ' ', ' '
                    
128	        from ebpls_business_enterprise") or die(mysql_error());
                    
131          /* sample/test ko lng
                    
132	        $result=mysql_query("select a.owner_id, a.business_name, a.business_city_code, a.business_type_code, 
                    
133          a.business_street, a.business_capital_investment, a.business_last_yrs_dec_gross_sales, b.fee_amount,
                    
160
                    
161	$result=mysql_query("select gs_name, gs_pos, gs_office from global_sign where sign_id =1") or die(mysql_error());
                    
162    $resulta=mysql_fetch_row($result);
                    
                
ebpls_ctc_issued.php http://ebpls.googlecode.com/svn/trunk/ | PHP | 214 lines
                    
82
                    
83        $result=@mysql_query("select lguname, lguprovince from ebpls_buss_preference")
                    
84        or die(mysql_error());
                    
85    $resulta=mysql_fetch_row($result);
                    
86$getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'");
                    
87$getlgu = @mysql_fetch_row($getlgu);
                    
87$getlgu = @mysql_fetch_row($getlgu);
                    
88$getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'");
                    
89$getprov = @mysql_fetch_row($getprov);
                    
115$date_to = date('Y-m-d', $xdate);
                    
116	$result1=mysql_query("select concat(ctc_first_name, ' ', ctc_middle_name, ' ', ctc_last_name) as name, ctc_code, 
                    
117    ctc_address, ctc_date_issued, ctc_tax_due, ctc_tax_interest, ctc_additional_tax1, ctc_additional_tax2, ctc_additional_tax3 from ebpls_ctc_individual where ctc_date_issued between '$date_from' and '$date_to' order by name asc") 
                    
119	$x1 = @mysql_num_rows($result1);
                    
120	$result2=mysql_query("select ctc_company, ctc_code, ctc_company_address, ctc_date_issued, ctc_tax_due, ctc_tax_interest, ctc_additional_tax1, ctc_additional_tax2 from ebpls_ctc_business where ctc_date_issued between '$date_from' and '$date_to' order by ctc_company asc") 
                    
121    or die(mysql_error());
                    
                
Abstract.php https://github.com/hettema/Stages.git | PHP | 325 lines
                    
34    /**
                    
35     * @var Mysql_Query
                    
36     */
                    
314     *
                    
315     * @return Main_Mysql_Query object 
                    
316     */
                    
319        if(!$this->_query) {
                    
320            $this->_query = new Main_Mysql_Query();
                    
321        }
                    
                
entry.php https://github.com/kenichiromiya/webwritecms.git | PHP | 253 lines
                    
13/*
                    
14		$result = mysql_query($sql,$this->db);
                    
15		$archives = array();
                    
28
                    
29//		mysql_query($query,$this->db);
                    
30	}
                    
35                $sth->execute(array($param['title'],$param['category_id'],$param['body'],$param['id']));
                    
36		//mysql_query($query,$this->db);
                    
37	}
                    
43
                    
44	//	mysql_query($query,$this->db);
                    
45	}
                    
52
                    
53		//$result = mysql_query($query,$this->db);
                    
54		//$entry=mysql_fetch_assoc($result);
                    
                
index.php https://github.com/d3c0n808/MiningFarm.git | PHP | 276 lines
                    
49								$fifteenMinutesAgo -= 60*15;
                    
50								$userHashHistoryQ = mysql_query("SELECT DISTINCT `timestamp` FROM `stats_userMHashHistory` WHERE `username` LIKE '".$getCredientials->username.".%' AND `timestamp` >= '$fifteenMinutesAgo' AND `mhashes` > 0 ORDER BY `timestamp` ASC");
                    
51								$numRows = mysql_num_rows($userHashHistoryQ);
                    
66										//Get all mhash results with this timestamp and average them up
                    
67											$getAllWorkerHash = mysql_query("SELECT `mhashes` FROM `stats_userMHashHistory` WHERE `username` LIKE '".$getCredientials->username.".%' AND `timestamp` = '".$time["timestamp"]."' AND `mhashes` > 0");
                    
68											$numWorkersThisTime = mysql_num_rows($getAllWorkerHash);
                    
74										//Get pool average results
                    
75											$getPoolAverageResult = mysql_query("SELECT `averageMhash`, `totalMhash` FROM `stats_poolMHashHistory` WHERE `timestamp` = '".$time["timestamp"]."' LIMIT 0,1");
                    
76									
                    
102									//Go through the pool history and display that
                    
103									$poolHistory = mysql_query("SELECT `averageMhash`, `totalMhash`, `timestamp` FROM `stats_poolMHashHistory` WHERE `timestamp` >= '".$fifteenMinutesAgo."' ORDER BY `timestamp` ASC");
                    
104										while($poolHash = mysql_fetch_array($poolHistory)){
                    
191										//retireve blogs
                    
192										$blogs = mysql_query("SELECT `title`, `timestamp`, `message` FROM `blogPosts` ORDER BY `timestamp` DESC");
                    
193										while($blog = mysql_fetch_array($blogs)){
                    
                
data_access.php https://github.com/jroglesby/Test-Reservation-System.git | PHP | 322 lines
                    
26		
                    
27		mysql_query("UPDATE user set password='$newpassword' where fsuid='$fsuid'");
                    
28	}
                    
39		
                    
40		$result = mysql_query("SELECT * from user WHERE fsuid='$username' AND password='$password'");
                    
41		$arr=array();
                    
104			
                    
105		$result = mysql_query($query);
                    
106		$arr=array();
                    
127		
                    
128		$result = mysql_query($query);
                    
129		$arr=array();
                    
148		
                    
149		$result = mysql_query("SELECT t2.coursenum,  t2.testname, DATE_FORMAT(t1.day, '%a, %c/%e'), l1.name, TIME_FORMAT(t1.session_time,'%h:%i%p'),  t1.seshid, r1.isMakeup 
                    
150					FROM reservation r1, test_session t1, test t2, location l1 
                    
                
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
                    
                
qmigo_sendsms.php https://github.com/deviltry/qmigo.git | PHP | 266 lines
                    
35# Get the LATEST OFFER INFO query on the database through the connection
                    
36$result = mysql_query($SqlStatement,$connection);
                    
37if (!$result)
                    
67# Get the LATEST OFFER INFO query on the database through the connection
                    
68$result1 = mysql_query($SqlStatement1,$connection);
                    
69if (!$result1)
                    
86
                    
87	$result2 = mysql_query($SqlStatement2,$connection);
                    
88	if ($row2 = mysql_fetch_array($result2, MYSQL_ASSOC)) 
                    
95	
                    
96	$result3 = mysql_query($SqlStatement3,$connection);
                    
97	
                    
114		$SqlStatement4 = "INSERT into qmigo_status (member_id, offer_id, QR_status) VALUES ($member_id, $offer_id, 0);";
                    
115		mysql_query($SqlStatement4,$connection) or die(mysql_error());
                    
116		//set QR status to 0.
                    
                
tests.inc.php https://github.com/harriswong/ATutor.git | PHP | 214 lines
                    
21$sql = 'SELECT * FROM '.TABLE_PREFIX."content_tests_assoc WHERE content_id=$_REQUEST[cid]";
                    
22$result = mysql_query($sql, $db);
                    
23while ($row = mysql_fetch_assoc($result)) {
                    
31            ORDER BY start_date DESC";
                    
32$result	= mysql_query($sql, $db);
                    
33$num_tests = mysql_num_rows($result);
                    
70	$sql_sub = "SELECT COUNT(*) AS sub_cnt FROM ".TABLE_PREFIX."tests_results WHERE status=1 AND test_id=".$row['test_id'];
                    
71	$result_sub	= mysql_query($sql_sub, $db);
                    
72	$row_sub = mysql_fetch_assoc($result_sub);
                    
76	$sql_sub = "SELECT COUNT(*) AS marked_cnt FROM ".TABLE_PREFIX."tests_results WHERE status=1 AND test_id=".$row['test_id']." AND final_score=''";
                    
77	$result_sub	= mysql_query($sql_sub, $db);
                    
78	$row_sub = mysql_fetch_assoc($result_sub);
                    
82	$sql_sub = "SELECT G.title FROM ".TABLE_PREFIX."groups G INNER JOIN ".TABLE_PREFIX."tests_groups T USING (group_id) WHERE T.test_id=".$row['test_id'];
                    
83	$result_sub	= mysql_query($sql_sub, $db);
                    
84	if (mysql_num_rows($result_sub) == 0) {
                    
                
listarUsuarios.php https://github.com/antonioformatic/curso2011.git | PHP | 218 lines
                    
90$query_limit_usuarios = sprintf("%s LIMIT %d, %d", $query_usuarios, $startRow_usuarios, $maxRows_usuarios);
                    
91$usuarios = mysql_query($query_limit_usuarios, $conexionEmpresa) or die(mysql_error());
                    
92$row_usuarios = mysql_fetch_assoc($usuarios);
                    
96} else {
                    
97  $all_usuarios = mysql_query($query_usuarios);
                    
98  $totalRows_usuarios = mysql_num_rows($all_usuarios);
                    
                
companyclass.php https://github.com/samsonnguyen/CPSC471carinsurance.git | PHP | 280 lines
                    
23		}
                    
24		mysql_query($sql) or die(mysql_error());
                    
25		return true;
                    
29		$sql="DELETE FROM `Company` WHERE Commercial_License_No='$companyno'";
                    
30		mysql_query($sql) or die(mysql_error());
                    
31		return true;
                    
34	static function getAllCompanies($selection){
                    
35		$companies = mysql_query("SELECT * FROM `Company`");// or die(mysql_error());
                    
36		if($companies != null){
                    
89		}
                    
90		return mysql_query($sql);
                    
91	}
                    
140		$sql = "SELECT * FROM `Company` ORDER BY Commercial_License_No ASC LIMIT $offset, $limit";
                    
141		$result = mysql_query($sql);
                    
142		print "<table class=\"company\"><tr>";
                    
                
homepage.php https://github.com/GE3/GE3.git | PHP | 258 lines
                    
19                  //název
                    
20                  $radek = mysql_fetch_assoc( Mysql_query("SELECT * FROM $CONF[sqlPrefix]gal_kat WHERE id=$idGalerie AND skryta='ne'") );
                    
21                  $tmplGalerie->prirad("id", $radek["id"]);
                    
24                  //fotky
                    
25                  $dotaz = Mysql_query("SELECT x.id as idKategorie, x.slozka, x.nazev, y.* FROM 
                    
26                                          $CONF[sqlPrefix]gal_kat x JOIN $CONF[sqlPrefix]galerie y ON x.id=y.kategorie
                    
54    
                    
55    $dotaz2 = Mysql_query("SELECT * FROM $CONF[sqlPrefix]clanky WHERE typ='novinka' ORDER BY id DESC LIMIT 2");
                    
56    $i = 0;
                    
77    $dotaz2 = "SELECT *, MIN(cenaSDph), MIN(cenaBezDph) FROM $CONF[sqlPrefix]zbozi WHERE akce=1 GROUP BY produkt ORDER BY id DESC LIMIT 0,".$radek["pocet_zbozi"]."";
                    
78    $dotaz2 = Mysql_query($dotaz2);
                    
79
                    
148    $tmplClanek = new GlassTemplate("templates/$CONF[vzhled]/clanek.html");    
                    
149    $dotaz2=Mysql_query("SELECT *
                    
150                         FROM $CONF[sqlPrefix]clanky
                    
                
AddressImportGeocom.php https://github.com/ParveenArora/AddressHunter.git | PHP | 204 lines
                    
92}
                    
93mysql_query("SET NAMES UTF8", $dbh);
                    
94
                    
176			);
                    
177			$dbresult = mysql_query($insert, $dbh);
                    
178			if (!$dbresult) {
                    
                
database.php https://gitlab.com/billyprice1/b374k | PHP | 343 lines
                    
80			if(class_exists('mysqli')) return $con->query($query);
                    
81			elseif(function_exists('mysql_query')) return mysql_query($query);
                    
82		}
                    
                
mysql_query.c https://github.com/energy6/xbmc.git | C | 370 lines
                    
48{
                    
49    cmyth_mysql_query_t * query = (cmyth_mysql_query_t *)p;
                    
50    if(query->buf != NULL)
                    
206int
                    
207cmyth_mysql_query_param_long(cmyth_mysql_query_t * query,long param)
                    
208{
                    
221int
                    
222cmyth_mysql_query_param_ulong(cmyth_mysql_query_t * query,unsigned long param)
                    
223{
                    
280int
                    
281cmyth_mysql_query_param_str(cmyth_mysql_query_t * query, const char *param)
                    
282{
                    
350int
                    
351cmyth_mysql_query(cmyth_mysql_query_t * query)
                    
352{
                    
                
MySql.php https://github.com/joshbhamilton/todophp.git | PHP | 438 lines
                    
319	 *          sends the SQL query query to MySQL without automatically fetching and buffering the
                    
320	 *          result rows as `mysql_query()` does (for less memory usage).
                    
321	 * @return resource Returns the result resource handle if the query is successful.
                    
332
                    
333			$func = ($options['buffered']) ? 'mysql_query' : 'mysql_unbuffered_query';
                    
334			$resource = $func($sql, $self->connection);
                    
                
weather_xml.php https://github.com/michaelmwu/saratogahigh.com.git | PHP | 334 lines
                    
94	$query = "DELETE FROM weather_xml WHERE last_updated < '$expiredatetime'";
                    
95	$result = mysql_query($query) or die('Invalid query: ' . mysql_error());
                    
96
                    
97	$query = "SELECT * FROM weather_xml WHERE xml_url = '$xml_url'"; 
                    
98	$result = mysql_query($query) or die('Invalid query: ' . mysql_error());
                    
99	$row = mysql_fetch_array($result);
                    
124			$query = "INSERT INTO weather_xml VALUES ('$xml_url', '$xml', '$datetime')";
                    
125			$result = mysql_query($query) or die('Invalid query: ' . mysql_error());
                    
126		}
                    
                
db_base.cpp https://github.com/matszpk/native-boinc-for-android.git | C++ | 500 lines
                    
122    }
                    
123    retval = mysql_query(mysql, p);
                    
124    if (retval) {
                    
                
spo.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 218 lines
                    
14        <?php $selPle="select localitati.nume, localitati.id_localitate from spo inner join localitati on spo.id_oras = localitati.id_localitate inner join tari on localitati.id_tara = tari.id_tara where tari.nume = 'Romania' Group by localitati.id_localitate Order by localitati.nume ";
                    
15		$quePle=mysql_query($selPle, $conn_tz) or die(mysql_error()); ?>
                    
16		Localitate Plecare:
                    
24       <?php $selPle="select tari.nume, tari.id_tara from spo inner join tari on spo.id_tara = tari.id_tara inner join localitati on spo.id_oras = localitati.id_localitate inner join tari as tari_plec on localitati.id_tara = tari_plec.id_tara where tari_plec.nume = 'Romania' Group by tari.id_tara Order by tari.nume ";
                    
25		$quePle=mysql_query($selPle, $conn_tz) or die(mysql_error()); ?>
                    
26		Tari sosire:
                    
46	$insEx="INSERT INTO exceptii_lista_spo (spo) VALUES ('".$_GET['scoate']."') ";
                    
47	$queEx=mysql_query($insEx, $connect->link) or die(mysql_error());
                    
48	@mysql_free_result($queEx);
                    
52$selEX="SELECT spo FROM exceptii_lista_spo GROUP BY spo ";
                    
53$queEX=mysql_query($selEX, $connect->link) or die(mysql_error());
                    
54while($rowEX=mysql_fetch_array($queEX)) {
                    
89
                    
90$rez=mysql_query($query);
                    
91$numar_total=mysql_num_rows($rez);
                    
                
postdata.php https://github.com/camlegleiter/Project-CyCal.git | PHP | 304 lines
                    
151		$value = mysql_real_escape_string($errorvalue);
                    
152		mysql_query("INSERT INTO panel(userid,rss,posx,posy,sizex,sizey,themeid,minimized) VALUES ('$userid','$value','$posx','$posy','$sizex','$sizey','$themeid','$minimized')");
                    
153		$rows = mysql_affected_rows();
                    
171		$feed = mysql_real_escape_string(urlencode($feed));
                    
172		$rssCheck = mysql_query("DELETE FROM panel WHERE userid='$userid' AND rss='$feed'");
                    
173		$rssCheckTheme = mysql_query("DELETE FROM theme WHERE userid='$userid' AND rss='$feed'");
                    
193	$feed = mysql_real_escape_string(urlencode($rss[0]));
                    
194	if(mysql_query("UPDATE panel SET posx='$posx',posy='$posy', sizex='$sizex' , sizey='$sizey' WHERE userid='$userid' AND rss='$feed'")){
                    
195		successMessage('');
                    
209	}
                    
210	$getRSS = mysql_query("SELECT * FROM panel WHERE userid='$userid' $panelTheme");
                    
211	$rssarr = array();
                    
227			$rss['themeid']['type'] = "User";
                    
228			$getTheme = mysql_query("SELECT * FROM theme WHERE userid='$userid' AND rss='".$row['rss']."'");
                    
229			$themeRow = mysql_fetch_assoc($getTheme);
                    
                
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
                    
                
todolist.php https://gitlab.com/jonz94/2016NCU_FreshWeb_HW | PHP | 187 lines
                    
11    $query_RecUser = "SELECT `nickname`,`permission` FROM `user` WHERE `username`='".$username."'";
                    
12    $RecUser = mysql_query($query_RecUser);
                    
13    $row_RecUser = mysql_fetch_assoc($RecUser);
                    
30    $query_RecLogin = "SELECT * FROM `user` WHERE `username`='".$_POST["username"]."'";
                    
31    $RecLogin = mysql_query($query_RecLogin);   
                    
32    //取出帳號密碼的值
                    
                
op-name.php https://github.com/micheleberg/Calontir-OP.git | PHP | 283 lines
                    
51

                    
52$awardRS = mysql_query("SELECT AwardDate FROM Awards ORDER BY AwardDate DESC");

                    
53$numAward = mysql_num_rows($awardRS);

                    
138

                    
139  $kListRS = mysql_query("SELECT * FROM Kingdoms ORDER BY KingdomInd");

                    
140  $numKList = mysql_num_rows($kListRS);

                    
164

                    
165  $countRS = mysql_query("SELECT count(PopInd) as recCount FROM Populace WHERE $whereClause ORDER BY Name");

                    
166  $numPop = mysql_num_rows($countRS);

                    
174  {

                    
175    $popRS = mysql_query("SELECT * FROM Populace WHERE $whereClause ORDER BY Name");

                    
176    $numPop = mysql_num_rows($popRS);

                    
204        {

                    
205          $awardRS = mysql_query("SELECT Awards.PopInd, Awards.AwardCode, Awards.AwardDate, Awards.KingdomCode, AwardList.Precedence FROM Awards, AwardList WHERE Awards.PopInd =' $popInd ' and AwardList.AwardInd = Awards.AwardCode ORDER BY Awards.AwardDate, AwardList.Precedence");          

                    
206        }

                    
                
install.php https://github.com/benbruscella/Grammafone.git | PHP | 424 lines
                    
5  $query = "SELECT user_id FROM mp3act_users";
                    
6  $result = @mysql_query($query);
                    
7	if(@mysql_num_rows($result) > 0){
                    
351foreach($querys as $key=>$query){
                    
352	if(mysql_query($query)){
                    
353		
                    
396			  $query = "UPDATE mp3act_settings SET invite_mode=$_POST[invite],sample_mode=$_POST[sample_mode],downloads=$_POST[downloads],amazonid=\"$_POST[amazonid]\",mp3bin=\"$_POST[mp3bin]\",lamebin=\"$_POST[lamebin]\",phpbin=\"$_POST[phpbin]\",jukemode=\"$_POST[jukemode]\",mpdserver=\"$_POST[mpdserver]\",mpdport=\"$_POST[mpdport]\" WHERE id=1";
                    
397  			mysql_query($query);
                    
398  			echo "<strong>Settings Saved....</strong><br/><br/>";
                    
409  			$query = "INSERT INTO `mp3act_users` VALUES (NULL, 'admin', 'Admin', 'User', PASSWORD(\"$random_password\"), 10, NOW(), 1, '', 'streaming', 0, 's', '21232f297a57a5a743894a0e4a801fc3', '', '0000-00-00 00:00:00', 1,'','','',0)";
                    
410  			mysql_query($query);
                    
411  			echo "<br/><strong>Username:</strong> Admin<br/><strong>Password:</strong> $random_password (Please change this password as soon as you login.)<br/><br/>";
                    
                
classes.php https://github.com/camlegleiter/Project-Pencl.git | PHP | 378 lines
                    
26	$classid = mysql_real_escape_string($classid);
                    
27	$padRow = mysql_query("SELECT name,description,password,owner FROM classes WHERE id='$classid'");
                    
28	$row = mysql_fetch_assoc($padRow);
                    
54	$classid = mysql_real_escape_string($classid);
                    
55	$padRow = mysql_query("SELECT notebookid FROM classbooks WHERE classid='$classid'");
                    
56	$notepadHTML = "";
                    
69	$classid = mysql_real_escape_string($classid);
                    
70	$padRow = mysql_query("SELECT userid FROM classmates WHERE classid='$classid'");
                    
71	$notepadHTML = "";
                    
87	$id = mysql_real_escape_string($id);
                    
88	$padRow = mysql_query("SELECT name,description,created,modified,userid FROM notebooks WHERE id='$id'");
                    
89	$row = mysql_fetch_assoc($padRow);
                    
122	$id = mysql_real_escape_string($id);
                    
123	$padRow = mysql_query("SELECT username FROM users WHERE userid='$id'");
                    
124	$row = mysql_fetch_assoc($padRow);
                    
                
mutate_htmlsnippet.dynamic.php https://github.com/garryn/evolution.git | PHP | 225 lines
                    
35$sql = 'SELECT internalKey, username FROM '.$tbl_active_users.' WHERE action=78 AND id=\''.$id.'\'';
                    
36$rs = mysql_query($sql);
                    
37$limit = mysql_num_rows($rs);
                    
51	$sql = 'SELECT * FROM '.$tbl_site_htmlsnippets.' WHERE id=\''.$id.'\'';
                    
52	$rs = mysql_query($sql);
                    
53	$limit = mysql_num_rows($rs);
                    
                
simulador-comparador-pruebas.php https://gitlab.com/fredyteheranto/gestionet | PHP | 332 lines
                    
70					  $hoy = date("Y-m-d");
                    
71				      $result = mysql_query("SELECT * FROM extranet_cash_productos WHERE id_tipo_producto = $tipoConsulta AND fecha_hasta >= '$hoy' ORDER BY cuantia_max ASC, anyos ASC;");
                    
72					  while ($row=mysql_fetch_array($result)) {
                    
73					  	$idBanco = $row['id_entidad'];
                    
74					  	$resultBanco = mysql_query("SELECT * FROM extranet_cash_entidades WHERE id = $idBanco;");
                    
75					  	$rowBanco=mysql_fetch_array($resultBanco);
                    
113					<?php
                    
114						$resultFecha = mysql_query("SELECT MAX(f_user) AS fecha FROM extranet_cash_productos");
                    
115						$rowFecha=mysql_fetch_array($resultFecha);
                    
152						<?php
                    
153					      $result = mysql_query("SELECT * FROM extranet_cash_productos WHERE id IN ($seleccion) ORDER BY cuantia_max ASC, anyos ASC;");
                    
154						  while ($row=mysql_fetch_array($result)) {
                    
155						  	$idBanco = $row['id_entidad'];
                    
156						  	$resultBanco = mysql_query("SELECT * FROM extranet_cash_entidades WHERE id = $idBanco;");
                    
157						  	$rowBanco=mysql_fetch_array($resultBanco);
                    
                
class.eyemysqladap.inc.php https://github.com/kevinroberts/snippetz.git | PHP | 438 lines
                    
116	{
                    
117		$result = mysql_query($query, $this->link);
                    
118
                    
                
mysqlquery.php https://bitbucket.org/deditec/finoplaner.git | PHP | 562 lines
                    
179		#echo '<!--'.$this->_query.'-->';
                    
180		$this->_result = mysql_query($this->_query, $this->_dbHandle);
                    
181		$result = array();
                    
211						#echo '<!--'.$queryChild.'-->';
                    
212						$resultChild = mysql_query($queryChild, $this->_dbHandle);
                    
213				
                    
263						#echo '<!--'.$queryChild.'-->';
                    
264						$resultChild = mysql_query($queryChild, $this->_dbHandle);
                    
265				
                    
316
                    
317		$this->_result = mysql_query($query, $this->_dbHandle);
                    
318
                    
374			$query = 'DESCRIBE '.$this->_table;
                    
375			$this->_result = mysql_query($query, $this->_dbHandle);
                    
376			while ($row = mysql_fetch_row($this->_result)) {
                    
                
mysql.php http://seo-phpbb.googlecode.com/svn/trunk/ | PHP | 479 lines
                    
58				{
                    
59					@mysql_query("SET NAMES 'utf8'", $this->db_connect_id);
                    
60					// enforce strict mode on databases that support it
                    
62					{
                    
63						$result = @mysql_query('SELECT @@session.sql_mode AS sql_mode', $this->db_connect_id);
                    
64						$row = @mysql_fetch_assoc($result);
                    
82						$mode = implode(',', $modes);
                    
83						@mysql_query("SET SESSION sql_mode='{$mode}'", $this->db_connect_id);
                    
84					}
                    
114			case 'begin':
                    
115				return @mysql_query('BEGIN', $this->db_connect_id);
                    
116			break;
                    
118			case 'commit':
                    
119				return @mysql_query('COMMIT', $this->db_connect_id);
                    
120			break;
                    
                
parsetodb.php https://gitlab.com/bjwebb-codedump/plingconica.git | PHP | 219 lines
                    
33    
                    
34    if ($result = mysql_query("SELECT * FROM `".$tablename."` WHERE id='".$array["id"]."'", $con));
                    
35    else die(mysql_error());
                    
66    if ($query) {
                    
67        if (mysql_query($query));
                    
68        else {
                    
215
                    
216if (mysql_query("UPDATE `custom` SET `uptodate`=0 WHERE `uptodate`=1"));
                    
217else die(mysql_error());
                    
                
xpdomanager.class.php https://github.com/Kleist/xPDO.git | PHP | 296 lines
                    
81                if (!$rt= @ mysql_select_db($dsnArray['dbname'], $conn)) {
                    
82                    @ mysql_query($sql, $conn);
                    
83                $errorNo= @ mysql_errno($conn);
                    
105                if (@ mysql_select_db($dsnArray['dbname'], $conn)) {
                    
106                    if (@ mysql_query($sql, $conn)) {
                    
107                        $removed= 1;
                    
                
sqlite.php https://github.com/yourhty/hypervm.git | PHP | 635 lines
                    
131		//print($string . "\n");
                    
132		$res = mysql_query($string, $res);
                    
133		if (!$res) {
                    
136			$this->reconnect();
                    
137			$res = mysql_query($string, $res);
                    
138		}
                    
333		if ($sgbl->__var_database_type === 'mysql') {
                    
334			$result = mysql_query("SHOW COLUMNS FROM $this->__sqtable", $gbl->$fdbvar);
                    
335			if (!$result) {
                    
337				$this->reconnect();
                    
338				$result = mysql_query("SHOW COLUMNS FROM $this->__sqtable", $gbl->$fdbvar);
                    
339			}
                    
                
index.php https://github.com/adanganan/chits.git | PHP | 317 lines
                    
72
                    
73/*mysql_query("ALTER TABLE `m_patient` DROP PRIMARY KEY , ADD PRIMARY KEY (`patient_id`)");
                    
74mysql_query("ALTER TABLE `m_consult` DROP PRIMARY KEY , ADD PRIMARY KEY (`consult_id`)");
                    
74mysql_query("ALTER TABLE `m_consult` DROP PRIMARY KEY , ADD PRIMARY KEY (`consult_id`)");
                    
75mysql_query("ALTER TABLE `m_family` DROP PRIMARY KEY , ADD PRIMARY KEY (`family_id`)");
                    
76mysql_query("ALTER TABLE `m_consult_notes` DROP PRIMARY KEY , ADD PRIMARY KEY (`notes_id`)");
                    
76mysql_query("ALTER TABLE `m_consult_notes` DROP PRIMARY KEY , ADD PRIMARY KEY (`notes_id`)");
                    
77mysql_query("ALTER TABLE `content` DROP PRIMARY KEY , ADD PRIMARY KEY (`content_id`)");
                    
78mysql_query("ALTER TABLE `m_patient_mc` DROP PRIMARY KEY, ADD PRIMARY KEY(`mc_id`)");
                    
78mysql_query("ALTER TABLE `m_patient_mc` DROP PRIMARY KEY, ADD PRIMARY KEY(`mc_id`)");
                    
79mysql_query("ALTER TABLE `m_patient_fp` DROP PRIMARY KEY, ADD PRIMARY KEY(`fp_id`)");
                    
80mysql_query("ALTER TABLE `m_patient_ccdev` DROP PRIMARY KEY, ADD PRIMARY KEY(`ccdev_id`)");
                    
80mysql_query("ALTER TABLE `m_patient_ccdev` DROP PRIMARY KEY, ADD PRIMARY KEY(`ccdev_id`)");
                    
81mysql_query("ALTER TABLE `m_patient_ntp` DROP PRIMARY KEY, ADD PRIMARY KEY(`ntp_id`)"); 
                    
82mysql_query("ALTER TABLE `m_consult_appointments` DROP PRIMARY KEY, ADD PRIMARY KEY(`schedule_id`)");
                    
                
home.php https://github.com/budigutama/tes-repo.git | PHP | 304 lines
                    
107	if($_SESSION['string'] == $_POST['code']){
                    
108		$ncari = mysql_num_rows(mysql_query("SELECT *
                    
109								 				 FROM member
                    
112				$verifikasi = md5(uniqid());
                    
113				mysql_query("INSERT INTO member VALUES(null, $_POST[kota], '$_POST[nama]', '$_POST[alamat]',
                    
114							'$_POST[telp]', '$_POST[kodepos]', '$_POST[email]', '".md5($_POST['password'])."',
                    
129if(isset($_GET['code'])){
                    
130	if(mysql_num_rows(mysql_query("SELECT * FROM member WHERE verificationcode_member = '$_GET[code]' AND status_member = '0'")) == 1){
                    
131		mysql_query("UPDATE member
                    
140	
                    
141	$tampil2 = mysql_query($sqlproduk) or die(mysql_error());
                    
142	$jmldata = mysql_num_rows($tampil2);
                    
226					  
                    
227	$qproduk = mysql_query($sqlproduk) or die(mysql_error());
                    
228	$no = 0;
                    
                
create_question_likert.php https://github.com/harriswong/ATutor.git | PHP | 203 lines
                    
86		$sql = vsprintf(AT_SQL_QUESTION_LIKERT, $sql_params);
                    
87				$result	= mysql_query($sql, $db);
                    
88		
                    
100		$sql	= "SELECT * FROM ".TABLE_PREFIX."tests_questions WHERE question_id=$_POST[preset_num] AND course_id=$_SESSION[course_id]";
                    
101		$result	= mysql_query($sql, $db);
                    
102		if ($row = mysql_fetch_assoc($result)){
                    
133			$sql = "SELECT * FROM ".TABLE_PREFIX."tests_questions WHERE course_id=$_SESSION[course_id] AND type=4";
                    
134			$result = mysql_query($sql, $db);
                    
135			if ($row = mysql_fetch_assoc($result)) {
                    
                
load_MySQL.c https://bitbucket.org/vrrm/brl-cad-copy-for-fast-history-browsing-in-git.git | C | 221 lines
                    
69    sprintf (query, "select gid from project where pid = '%d'", pid);
                    
70    mysql_query (&slave_load_mysql_db, query);
                    
71    res = mysql_use_result (&slave_load_mysql_db);
                    
84    snprintf (query, 256, "select trinum,meshnum,gsize,gdata from geometry where gid = '%d'", gid);
                    
85    mysql_query (&slave_load_mysql_db, query);
                    
86    res = mysql_use_result (&slave_load_mysql_db);
                    
173	snprintf (query, 256, "select attr from meshattrmap where mesh='%s' and gid=%d", slave_load_mesh_list[i].name, gid);
                    
174	if (!mysql_query (&slave_load_mysql_db, query)) {
                    
175	    char attr[48];
                    
186/* printf("query[%d]: %s\n", i, query); */
                    
187	    if (!mysql_query (&slave_load_mysql_db, query)) {
                    
188		res = mysql_use_result (&slave_load_mysql_db);
                    
198    snprintf (query, 256, "select asize,adata from geometry where gid='%d'", gid);
                    
199    mysql_query (&slave_load_mysql_db, query);
                    
200    res = mysql_use_result (&slave_load_mysql_db);
                    
                
SocialGroup.class.php https://github.com/harriswong/ATutor.git | PHP | 486 lines
                    
42			$sql = 'SELECT * FROM '.TABLE_PREFIX.'social_groups WHERE id='.$this->group_id;
                    
43			$result = mysql_query($sql, $db);
                    
44			if (mysql_num_rows($result) > 0){
                    
76		$sql = 'SELECT * FROM '.TABLE_PREFIX.'social_groups_members WHERE group_id='.$this->group_id;
                    
77		$result = mysql_query($sql, $db);
                    
78		if ($result){
                    
100		 $sql = 'SELECT a,id AS id, a.title AS title FROM '.TABLE_PREFIX.'social_groups_activities g LEFT JOIN '.TABLE_PREFIX.'social_activities a ON g.activity_id=a.id WHERE g.group_id='.$this->group_id;
                    
101		 $result = mysql_query($sql, $db);
                    
102		 if ($result){
                    
127
                    
128		$rs = mysql_query($sql, $db);
                    
129		if($rs){
                    
143		 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_groups_board WHERE group_id='.$this->getID().' ORDER BY created_date DESC';
                    
144		 $rs = mysql_query($sql, $db);
                    
145
                    
                
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            
                    
                
feedback.php https://bitbucket.org/maxpanzer/cred_katherine.git | PHP | 175 lines
                    
28		echo $sql;
                    
29		mysql_query($sql) or die(mysql_error());
                    
30?>
                    
                
mysql.php https://gitlab.com/ken3/bluSky | PHP | 443 lines
                    
92
                    
93			mysql_query('SET '.implode(', ', $variables), $this->_connection);
                    
94		}
                    
151			// PHP is compiled against MySQL 4.x
                    
152			$status = (bool) mysql_query('SET NAMES '.$this->quote($charset), $this->_connection);
                    
153		}
                    
185		// Execute the query
                    
186		if (($result = mysql_query($sql, $this->_connection)) === FALSE)
                    
187		{
                    
286
                    
287		if ($mode AND ! mysql_query("SET TRANSACTION ISOLATION LEVEL $mode", $this->_connection))
                    
288		{
                    
293
                    
294		return (bool) mysql_query('START TRANSACTION', $this->_connection);
                    
295	}
                    
                
page_class.php https://github.com/dariostric/CMS.git | PHP | 238 lines
                    
11        if ($language==0) {
                    
12        $response1=mysql_query("SELECT * FROM languages");
                    
13        $row1=mysql_fetch_array($response1, MYSQL_ASSOC);
                    
13        $row1=mysql_fetch_array($response1, MYSQL_ASSOC);
                    
14            $response=mysql_query("SELECT * FROM pages where underpage='0' ORDER BY id");
                    
15            while ($row=mysql_fetch_array($response, MYSQL_ASSOC)) {
                    
18        } else {
                    
19            $response1=mysql_query("SELECT * FROM languages where id='".$language."'");
                    
20            while ($row1=mysql_fetch_array($response1, MYSQL_ASSOC)) {
                    
20            while ($row1=mysql_fetch_array($response1, MYSQL_ASSOC)) {
                    
21            $response=mysql_query("SELECT * FROM pages where underpage='0' ORDER BY id");
                    
22            while ($row=mysql_fetch_array($response, MYSQL_ASSOC)) {
                    
39        if($id==0) {
                    
40            $response=mysql_query("SELECT * FROM pages");
                    
41            $row=mysql_fetch_array($response, MYSQL_ASSOC);
                    
                
panel_producer_admin.php https://gitlab.com/Henaway/CLFC | PHP | 308 lines
                    
33        producer_id = "'.mysql_real_escape_string ($_SESSION['producer_id_you']).'"';
                    
34    $resultr = @mysql_query($sqlr,$connection) or die(debug_print ("ERROR: 904933", array ($sqlr,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
35    $message = 'Producer # '.$producer_id.' has been updated.<br>';
                    
48        producer_id = "'.mysql_real_escape_string ($_GET['producer_id_you']).'"';
                    
49    $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 860943 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
50    while ($row = mysql_fetch_object($result))
                    
73//       LIMIT 0,1';
                    
74//     $result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 537557 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
75//     while ($row = mysql_fetch_object($result))
                    
99    business_name';
                    
100$result = @mysql_query($query, $connection) or die(debug_print ("ERROR: 759326 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__));
                    
101while ( $row = mysql_fetch_object($result) )
                    
                
Database.php https://github.com/durand54/caresite.git | PHP | 395 lines
                    
95		//$this->queries[] = $query;
                    
96		return mysql_query($query);
                    
97	}
                    
                
adhesion.php https://gitlab.com/radicalcinema/AnarchistNewsroom | PHP | 369 lines
                    
19$del=$_GET['del'];
                    
20$sql = mysql_query("SELECT * FROM ".$prefix."cotisations WHERE id = '$del'");
                    
21	$nb_rep_request = mysql_num_rows($sql);
                    
23	{
                    
24		mysql_query("DELETE FROM ".$prefix."cotisations WHERE id = '$del'");
                    
25	}
                    
262
                    
263$sql_cotisations = mysql_query("SELECT * FROM ".$prefix."cotisations WHERE id_user = '$id_user_online' ORDER BY date_debut DESC");
                    
264while($cotis = mysql_fetch_array($sql_cotisations)) { 
                    
                
class.Ticker.inc.php http://flaimo-php.googlecode.com/svn/trunk/ | PHP | 266 lines
                    
211		$sql .= ' VALUES (' . $tm->getTimestamp() . ',"' . addslashes($tm->getText()) . '");';
                    
212		$result =  mysql_query($sql, $this->conn) or die ('Request not possible! SQL Statement: ' . $sql . ' / ' . mysql_error());
                    
213	} // end function
                    
                
searchresult2.php https://bitbucket.org/ayudh_das/khaugali.com.git | PHP | 412 lines
                    
19			$query = "select * from restaurant";
                    
20			$resultset = mysql_query($query,$connection);
                    
21			confirmQuery($resultset);
                    
38						on cuisines.cuisine_id=cid.cuisine_id";
                    
39				$res = mysql_query($q2, $connection);
                    
40				confirmQuery($res);
                    
46						on city.city_id=cityid.city_id";
                    
47				$res = mysql_query($q2, $connection);
                    
48				confirmQuery($res);
                    
80						where restaurant.res_id=r2.rest_id";
                    
81				$resultset = mysql_query($query,$connection);
                    
82				confirmQuery($resultset);
                    
99							on cuisines.cuisine_id=cid.cuisine_id";
                    
100					$res = mysql_query($q2, $connection);
                    
101					confirmQuery($res);
                    
                
form.php https://github.com/damanlovett/ucc.git | PHP | 263 lines
                    
59  mysql_select_db($database_connCareer, $connCareer);
                    
60  $Result1 = mysql_query($insertSQL, $connCareer) or die(mysql_error());
                    
61
                    
                
slip.php https://gitlab.com/msdusad/all_ones | PHP | 324 lines
                    
11{ 
                    
12     $inslipnos=mysql_query("SELECT * FROM slip;");
                    
13    while($sl=mysql_fetch_array($inslipnos)){
                    
18$_SESSION['number'] = $_SESSION['number'] + 1; 
                    
19  $inslipno=mysql_query("UPDATE slip SET slipno='{$_SESSION['number']}';");
                    
20} 
                    
121     $ms=$_GET['sl'];
                    
122     $result=mysql_query("SELECT * FROM trregistration where id='$ms';");
                    
123if($result){
                    
                
import.php https://github.com/atutor/scorm_packages.git | PHP | 490 lines
                    
183
                    
184	$result = mysql_query($sql, $db);
                    
185	$q_row	= mysql_fetch_assoc($result);
                    
333
                    
334	$result = mysql_query($sql, $db);
                    
335	if (!$result) {
                    
357
                    
358			$result = mysql_query($sql, $db);
                    
359			if (!$result) {
                    
376				)";
                    
377			$result = mysql_query($sql, $db);
                    
378			break;
                    
402				)";
                    
403			$result = mysql_query($sql, $db);
                    
404			if (!$result) {
                    
                
edit_post.php https://github.com/harriswong/ATutor.git | PHP | 104 lines
                    
41		$sql = "UPDATE ".TABLE_PREFIX."blog_posts SET private=$_POST[private], title='$_POST[title]', body='$_POST[body]', date=date WHERE owner_type=".BLOGS_GROUP." AND owner_id=$_REQUEST[oid] AND post_id=$id";
                    
42		mysql_query($sql, $db);
                    
43
                    
52$sql = "SELECT private, title, body FROM ".TABLE_PREFIX."blog_posts WHERE owner_type=".BLOGS_GROUP." AND owner_id=$_REQUEST[oid] AND post_id=$id";
                    
53$result = mysql_query($sql, $db);
                    
54$post_row = mysql_fetch_assoc($result);
                    
                
confirm.php https://github.com/harriswong/ATutor.git | PHP | 170 lines
                    
30	$sql    = "SELECT creation_date FROM ".TABLE_PREFIX."members WHERE member_id=$id";
                    
31	$result = mysql_query($sql, $db);
                    
32	if ($row = mysql_fetch_assoc($result)) {
                    
36			$sql = "UPDATE ".TABLE_PREFIX."members SET email='$e', last_login=NOW(), creation_date=creation_date WHERE member_id=$id";
                    
37			$result = mysql_query($sql, $db);
                    
38
                    
54	$sql    = "SELECT email, creation_date FROM ".TABLE_PREFIX."members WHERE member_id=$id AND status=".AT_STATUS_UNCONFIRMED;
                    
55	$result = mysql_query($sql, $db);
                    
56	if ($row = mysql_fetch_assoc($result)) {
                    
64			}
                    
65			$result = mysql_query($sql, $db);
                    
66
                    
106	$sql    = "SELECT member_id, email, creation_date, status FROM ".TABLE_PREFIX."members WHERE email='$_POST[email]'";
                    
107	$result = mysql_query($sql, $db);
                    
108
                    
                
FrontlineSMSParser.php https://github.com/rkabir/Swiftriver.git | PHP | 306 lines
                    
287
                    
288        $myResult = mysql_query($sqlQuery, $myConnection);
                    
289        $myArray = array();
                    
                
Index.php https://gitlab.com/ElvisAns/tiki | PHP | 260 lines
                    
21        $this->table = new Search_MySql_Table($db, $index);
                    
22        $this->builder = new Search_MySql_QueryBuilder($db);
                    
23        $this->tfTranslator = new Search_MySql_TrackerFieldTranslator();
                    
162            return $resultSet;
                    
163        } catch (Search_MySql_QueryException $e) {
                    
164            if (empty($e->suppress_feedback)) {
                    
254                $this->table->ensureHasIndex($indexToRestore['Column_name'], $indexType);
                    
255            } catch (Search_MySql_QueryException $exception) {
                    
256                // Left blank on purpose
                    
                
mysql.php https://bitbucket.org/pastor399/newcastleunifc.git | PHP | 413 lines
                    
90		// Set sql_mode to non_strict mode
                    
91		mysql_query("SET @@SESSION.sql_mode = '';", $this->connection);
                    
92
                    
270		// Execute the query. Error suppression is used here to prevent warnings/notices that the connection has been lost.
                    
271		$this->cursor = @mysql_query($query, $this->connection);
                    
272
                    
                
student_2.php https://bitbucket.org/deba666/accitsoftware.git | PHP | 93 lines
                    
55                                                                        <?php $std_row="select * from student ORDER BY STUD_NO DESC";
                    
56                                                                            $q=mysql_query($std_row);
                    
57                                                                            while($row=mysql_fetch_array($q))
                    
                
assetfunctions.php https://github.com/iitgrad/cellarworxiPhoneApp.git | PHP | 751 lines
                    
164
                    
165     mysql_query($query);
                    
166
                    
176
                    
177       $result=mysql_query($query);
                    
178
                    
204
                    
205//       $result=mysql_query($query);
                    
206
                    
232
                    
233       $result=mysql_query($query);
                    
234
                    
258
                    
259       $result=mysql_query($query);
                    
260
                    
                
form3New.php https://gitlab.com/cesardemora/neaticketwebapphomeEs | PHP | 296 lines
                    
54                    $valor = $_GET['fecha_alta'];
                    
55                    $result = mysql_query("SELECT * FROM CLIENTES WHERE fecha_alta LIKE '$valor%' LIMIT $init, $limit_end");
                    
56                    $count = "SELECT COUNT(*) FROM CLIENTES WHERE fecha_alta LIKE '$valor%'";
                    
62                    $valor = $_GET['email'];
                    
63                    $result = mysql_query("SELECT * FROM CLIENTES WHERE mail LIKE '%$valor%' LIMIT $init, $limit_end");
                    
64                    $count = "SELECT COUNT(*) FROM CLIENTES WHERE mail LIKE '%$valor%'";
                    
                
lib.inc.php https://github.com/harriswong/ATutor.git | PHP | 143 lines
                    
126	$sql = 'SELECT p.* FROM '.TABLE_PREFIX.'pa_photos p LEFT JOIN '.TABLE_PREFIX."pa_course_album ca ON p.album_id=ca.album_id WHERE member_id=$member_id AND ca.course_id IS NULL";
                    
127	$result = mysql_query($sql, $db);
                    
128	if ($result){
                    
                
DBMysql.php https://github.com/sergiygladkyy/OEF.git | PHP | 495 lines
                    
115       
                    
116      if (!mysql_query("SET CHARACTER SET ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
                    
117      if (!mysql_query("SET character_set_client = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
                    
117      if (!mysql_query("SET character_set_client = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
                    
118      if (!mysql_query("SET character_set_results = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
                    
119      if (!mysql_query("SET character_set_connection = ".$this->charset)) throw new Exception(__METHOD__.": Can't set encoding");
                    
257   {
                    
258      return mysql_query($query, $this->conn);
                    
259   }
                    
                
new_account.php https://github.com/atutor/mahara.git | PHP | 244 lines
                    
22$sql = 'SELECT * FROM '.TABLE_PREFIX.'members WHERE member_id="'.$_SESSION['member_id'].'"';
                    
23$result = mysql_query($sql, $db);
                    
24$row = mysql_fetch_assoc($result);
                    
182$sql = "INSERT INTO ".TABLE_PREFIX."mahara SET at_login='".$_SESSION['login']."', username='".$registration->username."', password='".$random_password."'";
                    
183if (!mysql_query($sql, $db_atutor))
                    
184    exit;              // in case there's some external error; prevent being caught in an infinite loop
                    
                
plugin.h.pp https://gitlab.com/envieidoc/tomato | Puppet | 142 lines
                    
136void thd_get_xid(const void* thd, MYSQL_XID *xid);
                    
137void mysql_query_cache_invalidate4(void* thd,
                    
138                                   const char *key, unsigned int key_length,
                    
                
prueba.php https://gitlab.com/gustCL/syscar | PHP | 268 lines
                    
80        {
                    
81            mysql_query('SET NAMES'.$this->charset);
                    
82        }
                    
95                $tables = array();
                    
96                $result = mysql_query('SHOW TABLES');
                    
97                while($row = mysql_fetch_row($result))
                    
116
                    
117                $result = mysql_query('SELECT * FROM '.$table);
                    
118                $numFields = mysql_num_fields($result);
                    
120                $sql .= 'DROP TABLE IF EXISTS '.$table.';';
                    
121                $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
                    
122                $sql.= "\n\n".$row2[1].";\n\n";
                    
220      $tables = array();
                    
221      $result = mysql_query('SHOW TABLES');
                    
222      while($row = mysql_fetch_row($result))
                    
                
connection.php https://github.com/abdelm/stationwagon.git | PHP | 447 lines
                    
168			// PHP is compiled against MySQL 4.x
                    
169			$status = (bool) mysql_query('SET NAMES '.$this->quote($charset), $this->_connection);
                    
170		}
                    
211		// Execute the query
                    
212		if (($result = mysql_query($sql, $this->_connection)) === false)
                    
213		{
                    
                
sqlquery.lib.php https://github.com/akash6190/pragyan.git | PHP | 256 lines
                    
36		$sqlQueryQuery = 'SELECT `sqlquery_title`, `sqlquery_query` FROM `sqlquery_desc` WHERE `page_modulecomponentid` = \'' . $this->moduleComponentId."'";
                    
37		$sqlQueryResult = mysql_query($sqlQueryQuery);
                    
38		if(!$sqlQueryResult) {
                    
88			$query="SHOW TABLES";
                    
89			$res=mysql_query($query);
                    
90			while($row=mysql_fetch_row($res))
                    
102			$query="SELECT * FROM '$tablename'";
                    
103			$res=mysql_query($query);
                    
104			$numfields=mysql_num_fields($res);
                    
137			$query="SELECT * FROM '$tablename' LIMIT 1";
                    
138			$res=mysql_query($query);
                    
139			for($i=0;$i<mysql_num_fields($res);$i++)
                    
161			$defaultValueQuery = 'SELECT `sqlquery_title`, `sqlquery_query` FROM `sqlquery_desc` WHERE `page_modulecomponentid` = \'' . $this->moduleComponentId."'";
                    
162			$defaultValueResult = mysql_query($defaultValueQuery);
                    
163			if(!$defaultValueResult) {
                    
                
Installer.class.php https://github.com/prabhupathak/openemr.git | PHP | 372 lines
                    
123        $sql_results .= "Creating $title tables...\n";
                    
124	// mysql_query("USE $dbname",$dbh);
                    
125	$fd = fopen($filename, 'r');
                    
308    }
                    
309    $results = mysql_query($sql, $this->dbh);
                    
310    if ( $results ) {
                    
                
mysqlnduhconnection.query.html https://bitbucket.org/stillzhl/manuals.git | HTML | 130 lines
                    
117    <li class="member">
                    
118      <span class="function"><a href="function.mysql-query.html" class="function" rel="rdfs-seeAlso">mysql_query()</a> - 发送一条 MySQL 查询</span>
                    
119    </li>
                    
                
CMySQL.php https://github.com/stargazers/CMySQL.git | PHP | 401 lines
                    
97        // Execute query
                    
98        $ret = @mysql_query( $query, $this->_connection );
                    
99
                    
                
contactus.php https://github.com/AvinashMudunuri/Modernize.git | PHP | 92 lines
                    
20  mysql_select_db($database_powermigrate, $powermigrate);
                    
21  $Result1 = mysql_query($insertSQL, $powermigrate) or die(mysql_error());
                    
22  SendContactUsMail($_POST['company_name'], $_POST['contact_name'], $_POST['job_title'], $_POST['telephone'], $_POST['email'], $_POST['comments']);	
                    
                
index.php https://github.com/damanlovett/SEAHO.git | PHP | 202 lines
                    
36$query_rsEditorsOne = "SELECT * FROM state_editors WHERE `column` = 1 ORDER BY `order` ASC";
                    
37$rsEditorsOne = mysql_query($query_rsEditorsOne, $Directory) or die(mysql_error());
                    
38$row_rsEditorsOne = mysql_fetch_assoc($rsEditorsOne);
                    
42$query_rsEditorsTwo = "SELECT * FROM state_editors WHERE `column` = 2 ORDER BY `order` ASC";
                    
43$rsEditorsTwo = mysql_query($query_rsEditorsTwo, $Directory) or die(mysql_error());
                    
44$row_rsEditorsTwo = mysql_fetch_assoc($rsEditorsTwo);
                    
59  mysql_select_db($database_Directory, $Directory);
                    
60  $Result1 = mysql_query($updateSQL, $Directory) or die(mysql_error());
                    
61}
                    
                
all_hotels.php https://bitbucket.org/ocaziituristice/ocaziituristice.ro.git | PHP | 143 lines
                    
2$sel_hoteluri = "SELECT Accommodation_UnitID, Accommodation_Name, Accommodation_Stars, Accommodation_City_Name, Accommodation_City_ID FROM preturi_transilvania GROUP BY Accommodation_UnitID ";
                    
3$que_hoteluri = mysql_query($sel_hoteluri);
                    
4while($row_hoteluri = mysql_fetch_array($que_hoteluri)) {
                    
15	$sel_loc = "SELECT * FROM localitati_corespondent WHERE nume_furnizor = '".$hotels['localitate'][$key]."' AND code_furnizor = '".$hotels['localitate_id'][$key]."' AND id_furnizor = '".$id_furnizor."' ";
                    
16	$que_loc = mysql_query($sel_loc);
                    
17	$row_loc = mysql_fetch_array($que_loc);
                    
19		$ins_city = "INSERT INTO localitati_corespondent (nume_furnizor, code_furnizor, id_furnizor) VALUES ('".$hotels['localitate'][$key]."', '".$hotels['localitate_id'][$key]."', '".$id_furnizor."') ";
                    
20		$que_city = mysql_query($ins_city) or die(mysql_error());
                    
21		@mysql_free_result($que_city);
                    
23		$sel_oras = "SELECT id FROM localitati_corespondent WHERE nume_furnizor = '".$hotels['localitate'][$key]."' AND code_furnizor = '".$hotels['localitate_id'][$key]."' AND id_furnizor = '".$id_furnizor."' ";
                    
24		$que_oras = mysql_query($sel_oras);
                    
25		$row_oras = mysql_fetch_array($que_oras);
                    
34	$sel_hotels = "SELECT * FROM import_hoteluri WHERE nume_hotel = '".$value."' AND stele_hotel = '".$hotels['stele'][$key]."' AND city = '".$hotel_city."' ";
                    
35	$que_hotels = mysql_query($sel_hotels);
                    
36	$row_hotels = mysql_fetch_array($que_hotels);
                    
                
agent_calendar_2007.php https://bitbucket.org/anneivycat/california-tour.git | PHP | 313 lines
                    
17ORDER BY tt;';
                    
18$r = mysql_query($sql);
                    
19$nr = mysql_num_rows($r);
                    
265//  echo "<span style='font-size: 70%;'>$query</span><br />\n";
                    
266  $mysql_result = mysql_query($query);
                    
267  $totalnumrows = mysql_num_rows($mysql_result);
                    
272    $querytour = "SELECT * FROM TOUR WHERE TOUR_ID = '$TourId'";
                    
273    $mysql_result_tour = mysql_query($querytour);
                    
274    $rowtour = mysql_fetch_array($mysql_result_tour);
                    
                
mysql_db.cpp https://github.com/o1iver/Code-Backup.git | C++ | 426 lines
                    
48
                    
49as_value mysql_query(const fn_call& fn);
                    
50as_value mysql_row(const fn_call& fn);
                    
65    obj.init_member("disconnect", gl.createFunction(mysql_disconnect));
                    
66    obj.init_member("query", gl.createFunction(mysql_query));
                    
67    obj.init_member("fetch_row", gl.createFunction(mysql_fetch));
                    
387as_value
                    
388mysql_query(const fn_call& fn)
                    
389{
                    
                
MySQLTableInfo.php https://bitbucket.org/ferOnti/processmaker.git | PHP | 252 lines
                    
48
                    
49        $res = mysql_query("SHOW COLUMNS FROM `" . $this->name . "`", $this->conn->getResource());
                    
50
                    
110        // Primary Keys
                    
111        $res = mysql_query("SHOW KEYS FROM `" . $this->name . "`", $this->conn->getResource());
                    
112
                    
143        // Indexes
                    
144        $res = mysql_query("SHOW INDEX FROM `" . $this->name . "`", $this->conn->getResource());
                    
145
                    
173    // First make sure we have supported version of MySQL:
                    
174    $res = mysql_query("SELECT VERSION()");
                    
175    $row = mysql_fetch_row($res);
                    
191       // Get the CREATE TABLE syntax
                    
192    $res = mysql_query("SHOW CREATE TABLE `" . $this->name . "`", $this->conn->getResource());
                    
193    $row = mysql_fetch_row($res);
                    
                
 

Source

Language