10,945 Topics
 | |
 | 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 am getting this error when i process this form Notice: Undefined index: image in C:\xampp2\htdocs\trail\auction_upload.php on line 10 Notice: Undefined index: image in C:\xampp2\htdocs\trail\auction_upload.php on line 13 <?php session_start(); $_SESSION['message']=""; $mysqli = new mysqli('localhost', 'root', '','auction'); if ($_SERVER['REQUEST_METHOD'] == 'POST') { $item_name = $mysqli->real_escape_string($_POST['item_name']); $item_description = $mysqli->real_escape_string($_POST['item_description']); $item_image = … |
 | |
| | I currently have some code that gets the overall top 25 frame sales, which is as follows: `Dim FrameCountSelectStr As String = "SELECT TOP 25 Count(Glasses.OrderID) AS GlassesCount, Glasses.Manufacturer, Glasses.FrameName FROM(Glasses) WHERE FrameName <> '' AND OrderDate >= #" & SearchDateStart & "# AND OrderDate < #" & SearchDateEnd & …  |
| | Recently I tried many ways to retrive two columns from database. First I'll explain my database structure: Module Table mod_id,name,year,semester Lesson Table less_id,name,location,mod_id,year,semester,faculty I want to retrive mod_id,name from module table. I used this select query to do that : select md.mod_id as 'mdid',md.name as 'nme' from module md,lesson ls … |
| | hey guys I'm doing lms project. I created login page and php file. I can't find where I stucked. Here explanation of login form : * Check whether given username and password correct or not.. * If correct then check user type... * redirect to different pages according to user's … |
 | Hello to all, I am trying to display the images on my page through php from mysql database Problem is - Images are repeating , It always display only first image. <?php include("header.php"); include("connection.php"); $sql = "select Image from flood_light"; $result = $conn -> query($sql); if ($result->num_rows > 0) { … |
 | Guys, ... and let's not forget the "Girls"! I am really starting to get pissed off at the searchengines. For 2 days now been googling (tried ask.com now too) searching for web proxy hosts as I want to run a free service like: http://anonymouse.org/anonwww.html But hardly any relevant results. You … |
| | Hi I have a mysql tables shown below:  I need to build a query to select all groupnames a user belongs to in a single field seperated by ',' e.g. I wanted to following results id fname lname groups 1 connor Faulkner group_one,group_two 2 Maisie Yates group_four,group_three Just … |
 | hi everyone.. please my code is having an issue... i made a select query and its displaying the error in the IMAGE attached... the code is also attached... pls what could be the error.... the image ain 't uploading....so below is the error... ( ! ) Warning: mysql_fetch_array() expects parameter … |
 | 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 don't have such problems as mentioned. Yesterday MySQL 5.5 couldn't open database. I repeated an effort, but with no result. I have to open database in 3 days up to Monday.  |
 | I am querying a MYSQL database and would like to return the results so that all of the job numbers that are the same are grouped together and expandable when clicking on the common name. so when the bag loads all you see is a list of job numbers. I … |
 | 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 … |
 | Hello, I am thinking about working with large picture galleries databases. Can you change excel sheet and make it importable into mysql tables? I have to take 5000 photographies data and import them into the databases. I am thinking just to take the excel spreadsheet and convert it into mysql …  |
 | Hello Am looking for an out-of-the-box Wordpress theme which can help me create a website similar to either FileHorse or FileHippo in a very short time. Any one has an idea? |
| | using (MySqlCommand cmd = new MySqlCommand("SELECT EmpId, Emp_Name, Salary , Start_date , End_date , CASE WHEN (Employees.End_Date is null) THEN DATEDIFF(DATE_ADD(Start_Date, INTERVAL 30 DAY), Start_Date) * Salary/30 ELSE DATEDIFF(End_Date, Start_Date) * Salary/30 END AS Total_Salary From Employees;")) { using (MySqlDataAdapter sda = new MySqlDataAdapter()) { cmd.Connection = con; sda.SelectCommand = … |
| | 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 …  |
 | As I am doing a application on attendance management where I need to store the details by using check boxes I am unable to store the details of check boxes where it will be generated as present or absent in database Can anyone help me to find out this |
 | Hi Everyone, Can anybody suggest me. I have mysql with two database operations and production. My operations db have master master syncing on live server . I want to make production's master slave syncing onsame live server . Is it possible. How can do it?. Please help me. Thanks in … |
 | Inline Code Example HereI m working on a MLM project in which i have to store member automatically in binary tree form like 1 is root 2 is child of 1 3 is child of 1 Then 4 is child of 2 5 is child of 2 6 is child … |
 | 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 + …  |
 | hello everyone [{ "uid": "BR-M12068", "registeredDate": "Thursday May 11th 2017 03:56:37 PM", "file_path": "BR-M12068.pdf", "file_thumbnail_path": "BR-M12068thumb.png", "test_type": "Free", "title": "Medical Bills", "createdAt": "Thursday June 29th 2017 05:02:19", "chkTime": "Thursday June 29th 2017 05:01:53 PM", "chkoutTime": "Thursday June 29th 2017 05:02:29 PM" }, { "uid": "BR-M12068", /// first data "registeredDate": "Thursday … |
| | I am using the following mysql query: CREATE TEMPORARY TABLE temp_table ENGINE=MyISAM AS (SELECT age, performance, wind,name,surname,dob,prov,pos,place,date, @curRank := IF(@prevRank = performance, @curRank, @incRank) AS rank, @incRank := @incRank + 1, @prevRank := performance, CONCAT(name,' ',surname) AS 'athlete' FROM results p, ( SELECT @curRank :=0, @prevRank := NULL, @incRank := … |
 | **Am was already created form like this and working perfect but on last two forms not working, it displays warning-Undefined variable: reg_no and cost. Am trying to follow algorithm as previous forms but nothing happen. My goal is to update inserted data and here is my form** <?php @session_start(); if(!isset($_SESSION['b_lname'])){ … |
 | i want a private messaging system using php and mysql...someone plz help |
| | Hello Everyone. Please how can i make a Like button in PHP.. i want the button to be clicked. the button see the far i 've gone with the attachements... like feature starts from... line 84 - 107  |
 | |
| | 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 all, I am stuck at some logic and can't able to find stuffs for my research.I have a web based data Entry app in php.Now there will be atleast 2 operators for data entry.now when they login they will redirected to same page.I fetch one file at a time.Here … |
The End.