2,570 Topics
 | |
| | as seen in the pic a table. I have the following im trying to fill the boxes based on rows. So line one will fill by the correct ordergoing left to right then down. here is my code. $results = mysqli_query($con, " SELECT * FROM PMAsset Order by Linenum, LineOrder") …  |
 | Hi, i have installed prestashop 1.4.8.2 & i need a report of last order date for each customers, please help me to create mysql query. i need below columns information from database. id_customer, firstname, lastname, email, last order date. or is there any way i can export in active customers … |
 | I want to start a website like hippofile, cnet download, filehorse or freewarefiles in Wordpress Anyone who knows a Wordpress theme with which that I can build a website like hippofile, cnet download, filehorse or freewarefiles in Wordpress Many thanks  |
 | I have a table with nutrient data(in Dutch) it looks like this  My DB design skills are very low, I only know Mr. Codd is lurking 'round the corner somwhere. Could anyone give me some hints on how to set up my tables or should I just usr … |
 | 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 haver an IIS server with an mvc 5 app im developing and i have had no luck so far getting the windows authentication working with my app, i have it set to windows authenication but the app will only auto login users when accessed from the server. Then once …  |
 | If a table contains field's like name,age tuition fee,bus fee,year, 1,2 When I tried to update 1 year details it is updating but when I try to update the entire fields it's not updating in form of jsp page |
| | SELECT CASE WHEN (Employees.End_Date is null) THEN select EmpId, Emp_Name, Salary , Start_date , End_date ,DATEDIFF(DATE_ADD(Start_Date, INTERVAL 30 DAY), Start_Date) * Salary/30 as 'Total_Salary' from Employees ELSE Select EmpId, Emp_Name, Salary , Start_date , End_date ,DATEDIFF(End_Date, Start_Date) * Salary/30 as 'Total_Salary' from Employees END From Employees; Please help me to …  |
 | I am a beginner practicing how to create tables on SQL Here is what I've done: Create Table PO (Order_id int primary key, order_date date, customer varchar(1000)); Create table PO_Line_Item (Order_id int not null, Line_number int not null, Product varchar (30), Unit_Price decimal (10,2), Qty decimal (10,2), Tax decimal(10,2)); When …  |
 | Hello Dear Friends, I need some help to check avilidity of the username on Leave event of a textbox in Database SQL Server, but i cann't get. it code is bellow private void textBox6_Leave(object sender, EventArgs e) { cmd = new SqlCommand("SELECT * FROM usertab WHERE username='"+textBox6.text+"'",con); SqlDataAdapter da = …  |
 | I am trying to create a mysql query that groups people and the ranks them. I use the following to rank them without the grouping and get that result: SELECT rank, performance, wind,athlete,dob,prov,pos,place,date FROM (SELECT performance, wind,name,surname,dob,prov,pos,place,date, @curRank := IF(@prevRank = performance, @curRank, @incRank) AS rank, @incRank := @incRank + … |
 | **problem** How to get cost per hotel and flight then add it in duration cost table based on flight date automatically . **Details** suppose i write flight date 26/07/2017 alexia 8days 04/08/2017 it must automatically get cost from hotel price table and price from flight then add it in duration …  |
 | Hello pls i am making a comment feature for my log. I want the comments to be submited from a form in the "READ_MORE.PHP" , and i want the form to be processed in a "COMMENT.PHP" page were the form values are insertrd in the Comment table... (which has 5 …  |
 | Hello, I am trying to rename database MySQL: RENAME DATABASE old_db_name TO new_db_name; 1 kesalahan ditemukan dalam analisis. A rename operation was expected. (near "" at position 0) Query SQL: RENAME DATABASE wwwsoulf_revsoul TO wwwsoulf_revsoul2 MySQL menyatakan: Dokumentasi #1064 - You have an error in your SQL syntax; check the … |
 | Hi I have the following form at [http://test.genealogyresearchassistance.co.uk/newLinks.php](http://test.genealogyresearchassistance.co.uk/newLinks.php) The code is <form id="add" action="add.php" method="get"> <label for="name" id="name">Name of site</label> <input type="text" name="name" required="yes"><br/> <label for="link" id="link">Link of site</label> <input type="url" name="link" required="yes"><br/> <label for="desc" id="desc">A bit about the site</label> <textarea name="desc" required="yes"></textarea><br/> <label for="location"> Location:</label> <?php include 'database_conn.php'; $sql … |
| | I want to get sum of estimate quantity from estimates table gropBy material_id. Also want get sum of mprs quantity related to previous query table. My estimates table is as below | id | project_id | material_id | estimatequantity | | 1 | 1 | 1 | 500 | | … |
| | i want to combine multiple rows into a single row using **DB2**. I have found this code, but I do not know how can i edit it>? CREATE FUNCTION MySchema/MyUDF ( PARCol2 CHAR(5) ) RETURNS VARCHAR(1024) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA CALLED ON NULL INPUT DISALLOW PARALLEL BEGIN …  |
| | 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 … |
| | Hello SQL Gurus, This Query below is doing the job but it is horrible slow. Is there any way to make the query faster ? Perhaps a join .. inner outer, left ? I am looooost. Thanks for any help. SQLQuery1.SQL.Clear; SQLQuery1.SQL.Text:= 'SELECT * FROM orders_batch WHERE invoice_no=:elorder_no'; SQLQuery1.params.parambyname('elorder_no').Asstring := … |
| | Hello experts, I have to write a sql joining 6 tables. to retrieve classid, planname, workoutname,date,timeslot,status,staffemail and display them to a gridview. the tables are as below **tblclass** having columns *classid(PK)*, planallocationid*(FK to tblallocation)*, date, timeslotid*(FK to tbltimeslot),*status, staffid*(FK to tblstaff)* **tblallocation** having columns *planallocation(PK)*, planid*(FK to tblplan)*, workoutid*(FK to …  |
| | 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 … |
 | |
 | I am using OS Ticket and I have another site for Members Area,I am trying to join the 3 tables that have the information that corresponds to the customer by EMAIL. the first table is:qbcd_ticket: ticket_id | number | user_id | user_email_id | status_id | dept_id | and more... 5 …  |
 | I want to make a member login system which every member has its own database, when a user is registered successfully i want to create his special database. please help me the database creation code if you can Thank you Ali-Yare Mohamed  |
 | To all database genius out there, I hope you can help me with this error I encountered when importing excel file to SQL Server 2005. This is the error: [CODE]Executing (Error) Messages Error 0xc020901c: Data Flow Task 1: There was an error with output column "Description" (21) on output "Excel … |
| | I am trying to cast/ convert varchar to a numeric value. I have done this succesfuly when I eval the lower range, however I get an error when I do the upper range. this is my evaluation section that works. isnull(cast(measurmentdata.measvalue as numeric),0) < productinfo.lowerrange however when I try to … |
| | I work in MVC 5 c# in visual studio 2015 web applications I have table pictures in SQL server 2012 have two fields ID Image ID have number of image inserted like 1,2,3,4,5 Image field store picture added what i need actually browsing images found in table pictures in database … |
| | Hello, I am trying to upload mysql file into my xampp. (Max: 2,048KiB) I wonder why it cannot exceed that limit? I have tried to update my php.ini file : upload_max_filesize=10M and save it but it does not change the fact. I have to upload like 2.6 M file but … |
| | Hello Everyone, I am working in MySQL Workbench 6.3 CE and trying to use a trigger inside of a stored procedure to see if it will detect if my email format is not in the right format I specified in the message text error, but I am having trouble because … |
 | Actually the form below is a registration form, and i only have ' username, email, password and confirm password field' so i want to add another field name job, but keeps getting error. see the code below; if (!preg_match("/^[a-zA-Z ]+$/",$name)) { $error = true; $name_error = "Name must contain only … |
The End.