10,940 Topics
 | |
 | 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 … |
| | Hi All, I am having a system which receive data from around 30K gps . Each unit will be inserting concurrently around 1 minute. 1.What tweak should I add to cater for this? I target my ram to be 48Gb with 24 cpus. 2. Once the data grow should I … |
| | 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 … |
 | Hey, I have two columns. Ride and booking. In table booking there is the foreign key of ride. The intention is that 30-day and later bookings will be removed. If I run this query, I get the error message: mysql 1451 can not delete or update a parent row The … |
 | I am rather new to Normalization. I understand the concept of how it organizes the tables but I fail to see how I can use the data to show up correctly in my query using pdo. I have 3 tables: employees: id | name 1 user1 2 user2 2 user3 …  |
| | Hi, I'm back ^_^ Ok, I almost have this cute thing working. I know I am close but I have no idea how to get this working the right way. I am Left Joining a few tables and I want to filter the results after multiple values. ...... Ex: Options … |
The End.