2,403 Solved Topics
Remove Filter  | |
 | I have been butting my head against this problem for the past 4 hours, and I have to tap out. I know I can't be too far from correct I am just not sure what the missing ingredients are. Here is the problem question: Student status: List of all students … |
| | I have the following script which successfully finds the values for $payer_email, reminder_date and sub_expire_date, however where I am having trouble is when I apply a WHERE condition to the SELECT. The condition I am trying to apply is the commented out line at the end of the SELECT. The … Databases sql |
 | Am trying to create edit-form but there are some problem which I cant determine by my self. I cant echo inserted record and updating. <?php include("db_con.php"); $edit_reg_no = filter_input(INPUT_GET, 'edit_customer_detail', FILTER_VALIDATE_INT, ['options' => ['default' => NULL]]); if(isset($_POST['update'])){ $update_reg_no = $edit_reg_no; //getting the text data from the fields $d_fname = $_POST["d_fname"]; … |
 | I am using MS SQL and have logs that are in .mdf and .ldf format. It took us a while but we figured out how to get our new settings correct and coming in w3c format. The olf files are still .mdf and I need to know what I can … Databases mssql |
| | Hi guys, i have a login page where i created a session trainer after login. the session is the mail address of the trainer. now from another apsx page, i would like to retrieve the staffid of the user logged in using the session as criteria. I tried to write …  |
| | Hi not sure if this is possible so wanted some guidance.. I have a database with 3 columns.. id, data,timestamp id is auto increment and data is json array and timestamp is unix timestamp.. the field I wanted to update was data but I wanted to replace just a part …  |
| | **I can't update inserted data via GUI, Its working well on inserting records before I modify it, and when am trying to modify in order to update inserted data its not update as I expect to happen. I can display inserted data well by echo them to GUI Below is … |
| | Good day, I having a problem where creating my setting table as condition below column User_id setting effective_date effective_end_date Row 1: 1 ABC 2017-03-01 2018-02-28 Row 2: 1 DEF 2018-03-01 2019-03-01 I wish to add a constraint to block if same user add in a setting with the effective_date or … Databases mssql |
| | Hello, so, I'm playing a bit with **MariaDB 10.0.29** and I cannot understand why `FOUND_ROWS()` keeps returning the `1` whatever happens to the latest select query. Here's my test: > CREATE TABLE `test` (`id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, `msg` VARCHAR(100) NULL) ENGINE = InnoDB; Query OK, 0 rows affected … |
| | SAMPLE TABLE 1 =================================== product Division sales % =================================== product1 divsion1 99 product2 divsion1 51 product3 divsion1 50 product4 divsion2 98 product5 divsion2 41 product6 divsion2 40 product7 divsion3 97 product8 divsion3 31 product9 divsion3 30 =================================== Expected output 1 =================================== product2 divsion1 51 product3 divsion1 50 product5 divsion2 41 … Databases mysql |
| | The issue I am having has to do with not being able to show different OrderDate for the same Unit Unit OrderDate ShipDate ReceiptDate Robot 20160101 20160102 20160103 Robot 20160102 20160103 20160104 Robot 20160103 20160104 20160105 What is happening instead is that it is showing the same OrderDate for all … |
 | Hi hope someone can help me Read sqlite datatable is verry slow I have a listview in detail mode with 45 columns. and a datatable to add, read, delete and update datarows with 45 colums. Only i have a problem to read the datatable and show it all in the … Databases listview open-source sqlite vb.net  |
 | `Select * from contacts WHERE behavior = 'nice'` [SQL Clause is coming to town.](http://imgur.com/gallery/KvsXO) Not mine, [Little Bobby Tables](https://www.explainxkcd.com/wiki/index.php/Little_Bobby_Tables) almost ruined Christmas. Databases sql |
 | Hello friends. Please help me to solve my problem. I am using sql server 2008. When I try to access it recieve the following error: "Cannot connect to localhost ". So my question is, how to repair sql server? Hopefully someone will be able to help me with this.  |
| | I am working on a report that is requesting to count the total number of errors per element in the total row of the report for a given County. When I use the COUNT function it is taking the max value from the number of reads complete column for that … Databases sql |
 | Hi to all! I am using sql server 2008 enterprise edition. My instance name is "saboor-pc/ SQLSERVERENT". I am using this server for many months and i am satisfied but today an unexpected error occured when i clicked on "connect" button in sql server management studio. The error was: "Cannot … Databases client-server sql  |
 | I am working on a table that will hold batch data. The table will have a BatchDate column as a DateTime type. I'm considering adding a column for BatchYear as an integer and BatchPeriod (which could be a week number, a month number or a quarter number) as an integer, … Databases database-design mssql  |
 | Hi, can some one please help? I want to double-click on a "customer name" in form1 datagridview and then see "customer details" of selected customer on form2.. (in ms access it called "linked forms") I use VS2012 (vb.net) and SQL database.. Thanks, Michelle Databases sql vb.net web-design |
| | Good afternoon, Currently, I’m trying to consolidate all my financial information into one place so that I can see (the solution I’m currently using is Excel – see attached): 1. Valuation at a particular date 2 .Breakdown by investment product 3. Various other analytics (Allocation by class etc.) I’ve tried … Databases microsoft-access sql |
 | File drop database if exists contacts create database contacts; use contacts; create table names ( ID mediumint not null auto_increment primary key, firstName varchar(20), lastName varchar(20) ); create table addresses ( ID mediumint not null auto_increment primary key, nameID mediumint not null, addr1 varchar(30), addr2 varchar(30), city varchar(30), state varchar(10), … Databases file-system mariadb mysql |
| | I am banging my head again, and appologise if such a qestion has been posted and answered - i searched and could not see any results matching my question. I have a datagridview1 full of data, one column has a date and another a qty. datagridview1 Date Qty 2015-11-05 | … |
 | Hi group, I've looked all over the internet to find my solution without luck. Hopefully you can help. I need to add an Oracle server to my data sources in Visual Studio (if it matters, I'm using VB.net). Per the best instructions I've found so far, I've selected "Data Sources" … Databases oracle sql visual-studio |
| | Hi all, Say I have a table called "posts" with thousands of records. For each user, I want to display the top 10 most recent posts. I would normally use: `select * from posts order by created_date desc limit 10` However, doesn't this select ALL records and then removes all … Databases mysql  |
 | Hello, I have to install Oracle Developer 2000 R2.1 on a Windows 8.1 (x64) machine to run an application developed by a third party developer, but my installation keeps on crashing. Tried running in Windows XP SP3 compatibility mode still same result. The error is as follows: "D2KQT10.ins(54): 'Statement' expected … Databases microsoft oracle windows-10 |
| | Hi! I have two tables. Table 1 - fields are: no, referenceno, date, marine Table 2 - fields are: no, referenceno, controlno, date What I would like to do is to retrieve the field **controlno** from table 2 when field **marine** in table 1 = "Y". Coding: SELECT NO, REFERENCENO, … Databases sql |
 | Hi Dw. I'm trying to install MySQL and its my first time to install MySQL. I've downloaded the latest version which is version 5.7.12 and when I try to install its says "Beginning configuration step: Stopping Server [if necessary] Ended configuration step: Stopping Server [if necessary] Beginning configuration step: Writing … Databases client-server mysql |
| | Hi everyone! So we have a web application that some of our clients use to manage their account. Part of that means they can manage activities that their registered employees do. Right now we have a table that logs all of a customer's employees activities, even if they don't use … Databases mssql sql web-design |
| | Using PHP / MySql... I have a transaction table and a record is automatically inserted when someone Initiates a transaction, and then is updated later in the process, based on the recID. I want / need to keep the recIDs filled with completed transactions without any skips in the ID … |
| | getting syntax error into insert i don't know why :( Private Sub Button1_Click(By Val sender As System.Object, By Val e As System.EventArgs) Handles Button1.Click If txtContact.Text.Trim.Length = 0 Then MessageBox.Show("Enter Contact Number.", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If If ComboBox1.Text.Trim.Length = 0 Then MessageBox.Show("Please Select Agent", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) … Databases microsoft-access visual-studio  |
| | Hi all, I would like to export data from an Access DB, can this be achieved through a command? I plan to automate this export. Databases microsoft-access |
| | I am at my wits end. I have written this query which is aimed at importing my csv data uinto mysql table 'refs' load data local infile '/home/amaina/Documents/march2016.csv' into table refs fields terminated by ',' enclosed by '"' escaped by '' lines terminated by '\n' ignore 1 rows; My pain … Databases mysql |
 | Hello Daniweb Community, I've been looking around online for help with this but I can't seem to find a way to get a query to do what I want. The image below should pretty much say what kind of result I'd like to get, it's pretty much merging the tables … |
 | Hi Everyone! I have an application that has thousand of records. the problem that i am having right now is that my website is performing slow.when i am trying to swtich to other link on the site which have a query running on the background it takes ages to load. … |
| | Hi all, I'm running into a problem with PHP and mysql. I run a mySQL query, which returns the following object: `mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => Array ( [0] => 1 [1] => 186 ) [num_rows] => 1 [type] => 0 )` I then …  |
| | Hey ! I'm looking for sql 'like' command help.... I had mysql database and it had settlement table. On that table there is column named 'settlement'. In the settlement column there are so many amounts..... Now I want to find recors '0 values' Can anybody help me ? Databases sql  |
| | Hi all, I am running a mySQL database on a webserver hosting multiple Wordpress installations. It seems that database is getting swamped with memory and going into a continual loop of shutting down and restarting. A reboot fixes the issue temporarily, but I have no idea what I can do … |
| | Hi, I am working in a company that utilises many systems with their own databases. For example, the cafe has its own CAFE system with its own database (it could be postgresql). The Health Care system has its own database system (it could be MS SQL). The Transport booking has … Databases postgresql |
| | I'm having some real trouble running some basic queries that I should be able to run easily. I have a table called settings. When I query `SELECT * FROM settings` I get the output: +----+-----------------+--------------------------------+ | ID | key | value | +----+-----------------+--------------------------------+ | 1 | view | default | … |
| | I need some help in getting the table headers to sort the data populated to a table in MVC. I have implemented search functionality in which the user can filter whatever results by typing a name, but I need to also get the table headers to sort the information as … |
| | I'm making money lending system. On that I use mysql database. I want to find customer's who skipped their daily instalment. I try this code. But It has error. ***Prveious code:*** SELECT l.loan_id, l.custormer_id,custormer_name FROM loan l JOIN income i ON l.loan_id = l.loan_id WHERE l.loan_id NOT IN (SELECT loan_id … |
| | I need help in referencing the name of each individual database attached to a MongoDB instance. I just want to connect to a database with PHP and list the names of all the databases. In the code below I can connect to MongoDB instance and find all the databases. I … Databases mongodb php windows-10 |
| | I am learning mongoDB , version 3 and I wanted to create a collection with two fileds, a date field and a descrition field. When I try to insert a document with the below syntax, from the mongo shell, I get an error and do not know how to correct … Databases mongodb |
| | Hello, currently on one of my development servers I have SQL Server 2014 installed, the problem I HAD was that when I executed any of my PHP sites connected to various databases I was getting `SQLSTATE[HY2000][2002] Connection was activily refused...` I fixed that error by forwarding the port through the … Databases http-protocol mariadb php sql unix web-server |
 | Hi dear everyone, I have a website on WordPress that has been down at least for the past two months: http://terouma.net It is hosted with OVH and for the past weeks, I have been going back and forth with their customer support (which is not the most responsive on earth … Databases microsoft-access wordpress |
| | I used mysql query broweser to create database and tables. but when I run this code it doesn't show results. But there is no error SELECT * FROM expenses WHERE datee BETWEEN 01/01/2016 and 01/09/2016; can anyone help me ? Databases mysql |
 | PHP Warning: mysqli_error() expects exactly 1 parameter, 0 given on line 31 $insert = mysqli_query ($conn," insert into user set user_name = '".$_POST['uname']."' , age = '".$age."' , page = '".$page."' , user_password = '".$password."' , user_birthdate = '".$user_birthdate."' , puser_birthdate = '".$puser_birthdate."' , user_gender = '".$_POST['gender']."' , user_country = … |
| | Hi All, I have a sql query i am trying to get the count of how rows it returned. select a.field1, b.field2, c.field2 from table1 as a, table2 as b, table2 as c where a.field1=b.field1 Considered the above query return 9 rows. I want to get count of '9' in … Databases mysql |
 | Can anyone give a clear,short and simple explanation about database indexes? Databases |
| | my insert statement seems to be ignoring my unique index and adding duplicates what'd i mess up? thanks in advance Table CREATE TABLE `address` ( `address_id` int(11) NOT NULL AUTO_INCREMENT, `address_street1` varchar(100) NOT NULL, `address_street2` varchar(100) DEFAULT NULL, `address_street3` varchar(100) DEFAULT NULL, `address_city` varchar(45) NOT NULL, `address_state` char(2) DEFAULT NULL, … Databases mysql |
| | * <?php mysql_connect("localhost","root","") or die ("could not connect"); mysql_select_db("search_test") or die ("could not find db!"); //collect if(isset($_POST['search'])){ $searchq = $_POST['search']; $searchq = preg_replace("#[^0-9a-z]#i","",$searchq); $query = mysql_query("SELECT * FROM members WHERE firstname LIKE '%$searchq%' OR lastname LIKE '%$searchq%'") or die ("could not search!"); $count = mysql_num_rows($query); if ($count == 0 ) … Databases client-server mysql php |
The End.