703 Topics
 | |
 | Hi all, I am trying to insert 1000 above data into a table but after inserting 500 something data its showing an "Internal Server Error". I tried after changing max_execution_time in php.ini and some other methods but no use. But this works fine in localhost. Given below is my code. … |
| | Howdy All, I'm creating a database for UFO sightings and would appreciate some feedback or suggestions. Yes I know, strange topic. Some background info so that the problem is understood: I'm extracting data from several large UFO database catalogs, news articles, and other miscellaneous sources, so that the data can …  |
| | [code=php]// display records page wise code starts: $adjacents = 3; $tbl_name="feedback"; // $display = "SELECT COUNT(*) as num FROM $tbl_name"; $display = "SELECT COUNT(*) as num FROM $tbl_name"; $total_pages = mysql_fetch_array(mysql_query($display)); $total_pages = $total_pages[num]; /* Setup vars for query. */ $targetpage = "dispfeed.php"; //your file name (the name of this … |
| | |
| | Hi! Just want to ask if it's possible that within a select statement, there has a loop. Have this sample query but when I run this it says missing expression after <column2> Select <column1>, <column2>, FOR Lcntr IN 1..12 LOOP CASE WHEN Lcntr THEN .... END END LOOP; FROM <table> … |
| | Hello, Created a query for getting users list excluding the logged in user well I thought about creating a simple one but huh that didn't worked for me. Okay so what logic and for what did I created for. I tried to show the users that are friends with each … |
| | Hi, i bought a framework website which i am altering for a client and i am trying to add a new feature to it. i have added new field to mysql table i have added lines of code to show up on form, the choice in new feature will be … |
 | The program below is just a simple test to see if I can get it to fetch the correct data from MariaDB and then display it on the screen but so far I'm not having any luck. I left the action attribute's value blank because I want the PHP form …  |
| | Hello, I have a table with a filed Customers defined as int(10) I have the following query: SELECT * FROM 'table' where `Customers` = 'a' This query returns all entries which have 0 in this field, BUT a is not equal to 0 as we know? Also I can use … |
| | cmd.CommandText = "UPDATE tbl_System SET S_Name='" & TextBox2.Text & "', S_Function='" & RichTextBox1.Text & "', S_Failure='" & RichTextBox2.Text & "' WHERE EquipTag='" & Tbl_SystemDataGridView.CurrentRow.Cells(0).Value & "' i think this is correct format for update query but i still get error for this |
| | Please guide me. Im begginer in Sql. Im working through task tracking system in php. I need know how to display particular username details using query? Since Im getting all userdetails by single username and password.. |
 | Hi everyone, I have about 20 simple queries running seperately on loading a php page with mysql querying. On my localhost the page takes about 3 seconds to load but on the live server this is over 30 seconds. I'm trying to shave some time off but I'm having trouble …  |
| | Greeting to daniweb I must partition by Type and rank the following datable ( called dt) by LoanAmt column with ties Type LoanAmt Rnk ==================== A 14 A 15 A 13 A 11 A 11 B 17 B 18 B 17 B 16 As a new learner, I have read … |
| | Not sure if that is the correct title, but I created an additional field in the users profile. I want to add that field with the option to change that field (its a drop down) on the main homepage as well as profile page. It would be the exact same … |
| | I have a oracle query and i would like to run it by powershell using ODP.Net. Below is the query. set pagesize 100 set linesize 200 break on report compute sum of free_mb on report compute sum of act_size on report compute sum of used_mb on report col %used format … |
| | Im having a problem with updating data in SQLite this is the full code who execute after pressing the button try { PrintWriter writer = new PrintWriter("d:\\"+LBL1.getText()+"\\"+TL3.getText()+"_"+TL2.getText()+"_"+TL4.getText()+"_"+TL5.getText()+"_"+TL1.getText()+".txt", "UTF-8"); writer.println("Invoice Number = "+TL1.getText()); writer.println("Seda = " +TL3.getText()); writer.println("Date = " +TL2.getText()); writer.println("Documental Class = " + TL4.getText()); writer.println("Status = " + …  |
 | |
| | Hello, I am loking for a concept to geting started is there a way of creating a notification like on user end any one updates his post update or upload an image then on admin panel it notifies the admin like on menu bar it shows 1 and when the …  |
| | SELECT subject,GROUP_CONTACT(description)FROM assignment WHERE standard_id='1' AND section_id='61' AND assignment_date='2015-06-30' GROUP BY subject; For above query , I am facing this error , what is the mistake, Error:#1305 - FUNCTION ssv.GROUP_CONTACT does not exist.  |
| | Hi Everyone, I am a newbie to PHP programming. I just need to update the status when user click delete button. Here is the piece of code that I tried. When I echo the values of $mode and $id it prints properly. But the update query block doesn't working. <?php … |
| | Hi, Good morning. In a table I show a list of names using while loop from 'name' table and textbox for each student to enter the marks. I showed two students , so two textbox fields will be displayed, and after entering marks in two textboxes, I wrote normal insert … |
| | Moving my [Vivaldi](http://www.vivaldichoir.org/index.php) choir pages to use .php to include for common elements as per [Mayne Island Conservancy](http://www.conservancyonmayne.com) (see open question from 3 days ago) & have noticed some anomolies in IE 11. Any help would be appreciated on this and my open query on "Mobile Display" I intend to … |
| | Hi guys! I'm getting frustrated with my code because my filter in my query is not working. All of the item_model in my receiving_details table were being suggested in auto complete but as you can see in my query that I'm filtering item model with a certain form_no. Please help … |
 | Please help me with how i may receive an sms to my java application using ozeki. I have used sample code that i got from http://www.ozekisms.com/index.php?owpn=584 , I used that sample code and was able to send sms. Using the same code how may i receive an sms so that … |
| | try { frmCombination.Mode = "Add"; this.Clear_All_Controls(); this.Enable_All_Controls(); if (!(this.Form_Name == "Secured Life")) ; this.btnGenerate.Enabled = true; this.btnChange.Enabled = true; this.mskReportDate.Text = Convert.ToString(DateTime.Now); ****** if (this.Form_Name == "Secured Life") this.txtQuotation.Text = Common_Functionality.GenerateId("ProdMix_Quot_No", "Secured_Life_Quotation", "").ToString(); else this.txtQuotation.Text = Common_Functionality.GenerateId("ProdMix_Quot_No", frmCombination.tblAnnorSet, "").ToString(); this.SetupDataGridView(); this.SqlQry = "select Tax_Sec_80CCC_Limit,Tax_Sec_80D_Limit,Tax_rate_Limit from Global_Parameters"; Connection connection = new …  |
 | Dear Folks ! I´m having problems with my navigation at different screensizes. At current level the navigation display is nearly the way i want it for the bigger screensizes. But at media querry @media screen and (max-width: 320px) I want the navigationlinks to stack horizontally which i managed to do … |
| | This is more a general approach question. I have an old ORM like framework for this application. Basically what it does, if it needs to load a bunch of objects/records, is for every child object in my result a new query is triggered to get it's data. Since the nesting … |
| | The 'perf stat' output for a certain executable is shown below. 2,207,929,785,602 cpu-cycles # 1.098 GHz [58.33%] 955,083,725,303 instructions # 0.43 insns per cycle [58.33%] 412,816,464,977 cache-references # 205.308 M/sec [58.33%] 38,645,898,456 cache-misses # 9.362 % of all cache refs [58.33%] 4,692,761,524 branch-misses # 2.334 M/sec [58.33%] 0 ref-cycles # …  |
| | how can I select project from dropdown then execute query catching the value of the project selected I have the follow code using AJAX and JSP pages admin.jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; … |
| | Hi All, I am new in PHP and MySQL. As of now i am building a web application , where i have to get the list of all those clients whose date of joining - current date equals to 30. I have a table in database where there is a … |
The End.