7,368 Topics
| |
How can I do a bulk insert of rows but only if specific combinations of columns don't already exist? Those columns are not unique to the table. (Otherwise I could easily use INSERT IGNORE). Rather, I just need this to happen for one particular SQL query. | |
I'm trying to retrieve the values of checkboxes in a custom post type. My complete function: function getTeam() { global $post; $team = new WP_Query(); $team->query('post_type=coaches'); $workshops = get_field('workshops'); if ($team->found_posts > 0) { echo '<ul>'; while ($team->have_posts()) { $team->the_post(); $listTeam = '<li>'; $listTeam .= '<a href="#" class="js-modal">'; $listTeam .= … | |
Hello Sir, I am developing social networking website using jsp and servlet . I have created login page using mysql but now i am not able to make posting status and commenting system on that post.Please provide me solution. thankyou aayush | |
Hi, Not done any programming for a few years so am somewhat rusty again. I have two tables **users** table and **users_profiles** table. I want to update **users_profiles** table on the condition that **user_uid** matches on both tables (**users.user_uid** and **users_profiles.user_uid**) and where **users.user_login ** = 'johndoe' and **users.user_uid** = … | |
Can Somebody help me? i have an error whenever i want to save the data i have retrieved from different table in mysql. my system is doorlock system. im going to choose an item in the combobox and when i click the button, the data i'd chose from the combo … | |
Ok... back to my PHP/Wordpress adventure. In my testimonials post type I have added 5 custom fields and 2 fields are not mandatory which means they can be empty. One of them is the url field which I want to output within my while loop with a different HTML when … | |
Hi to all the old familiar faces, have not been here for a while... I have read up on tons of samples and answers (and even more on how cryptography works) but none answers my scenario. I am creating a new user from desktop app in VB.Net. User need to … | |
I have affiliate api of amazon,ebay,flipkart and snapdeal. I want to combine all api results to my web page with pagination. Like this website https://www.compareraja.in/mobiles.html If possible please suggest any ideas. I am using opencart for development. | |
I have scenario where one user can refer two codes to other one will become right and other left.Now this right can have two child left and right and so on same for left child user.... So this is binary tree like strucutre so i am selecting a user from … | |
Why was `INSERT DELAYED` deprecated? https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html I used to use it and it was incredibly useful. | |
I have an InnoDB table called `articles_read` with fewer than 20,000 rows in it. It consists of 3 columns: member_id article_id timestamp There are two indexes: A unique index on (member_id, article_id) and a regular index on (timestamp). It is read from fairly more than it is written to, and … | |
I have a database with only one table which has around 2 Million rows and 60 columns. I created a php application with multiple search filters like name, country, state, surname, domain etc which will filter and display the result in HTML table. But the problem is, every text field … | |
Hello every one i am having one doubt i have a set of links[url].Now there is pave ackages like 6 links,25 links package. if two user select 6 link each day and both will have same links[url] .now i when user log in then on adversitment page he visit each … | |
i need help in the following code i am trying to create dynamic radio buttons from mysql db and want to insert into another table its not echoing data and not even inserting i am just beginner please help me out thanks in advance <?php $dbhost = 'localhost'; $dbuser = … | |
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 … | |
HI, I have recently upgraded my mysql database to version 5.1.72 community log. I am having an issue that all my select queries are showing the columns as NULL if there is no entry added for a specific column. For exmaple I have a table table_employee and the employee name … | |
Hi I'm new to php,i need a code for issue and edit in library management system can someone please help | |
hello, i have one table in sql server and i made a form to editing this table from. so when i click edit in the table .. it takes me to the editing form with the chosen id .. what i need is to show all other feildes in the … | |
I'm excited I just discovered a way to remove unused MySQL indexes and I wanted to share it with you guys. I'm following the tutorial here: https://www.percona.com/blog/2012/06/30/find-unused-indexes/ We happened to have already been using a Percona-fork of MySQL. It just so happens that Percona has been our database consultants for … | |
Hi I have a master table Company info where information like revenue, profit, expenses etc are captured. Now i want to retrieve companies who has made profit every year since last 5 years. Issue is some company have latest data of 2017 and some have latest dat until 2016. How … | |
if a group of students pass out from their college or university etc. now how to create a database that a teacher can see his how much his student got success in life | |
I'm trying to generate barcode tickets after successful booking and it's working fine. But yesterday (08-Jan-2017) night at 11.59 pm, one customer booked 2 tickets but the ticket sl.no was duplicate. Tthat is both tickets sl.no was 1. Actually it should be 2. But the next customer's tickets sl.no was … | |
there are five tables (personTb, addressTb,churchTb) each holds data pertinent to an individual; (personAddress,personChurch) each hold the primary key for the person table and corresponding table IE personAddress holds primary key for addressTb. both snippets work, my question is;** Is my join correctly formatted? ** select concat(personTb.p_fName,' ',personTb.p_mName,'. ',personTb.p_lName) … | |
Im creating a social network site and i was able to create a user folder each time a new user signs up but my problem is copying a default image from a folder to that user folder how can i do that? I've searched the web on solutions like using … | |
Hello i want to make a statement that increases a row on a table on MySql every time one visits the page. The $_GET['ID'] its ok dont waste your time with that. This is the statement require 'config.php'; $db = getDB(); $ID=$_GET['ID'] ; mysqli_query($db, "UPDATE table SET count = count … | |
hello fellow web developers, i am trying to develop a schools web portal, i need to design it such that students details can be submitted, retrieved for deleting or editing or printing, i already have material guides on how go above adding editing or printing, how do i display and … | |
| Hello, I built a website on my personal server and everything work fine. But when I uploaded it on the production server there is a problem with the database - the character encoding is wrong so the text is unreadable (users submit greek words). The collation of the tables is … |
The other day I tweeted that MySQL unions are my new best friend. I just want to take that back. I just spent the past six hours (it's now 5 am) overhauling a MySQL query and removing one of the unions actually sped up performance. Dazah is really my first … | |
What is FIND_IN_SET() performance like? It it something that should be avoided at all costs? I want to search a column that consists of comma-delimited numbers for rows that contain a specific number. | |
I'm beginner to **php/mysql** (quite familiar with PHP, mysql), **novice** to **XMPP**. I have created my site in simple **php/mysql/javascript/jquery**. I'm trying to add simple Private Chat to my web site. Trying to integrate **[JSXC Chat](https://www.jsxc.org/examples.html)** into my website. Please Guide me how to create **chat database**, install **XMPP server**, … |
The End.