I am developing a PhoneGap application that gets some information from MySQL Database. I am struggling when I try to open a HTML page that contains two select i
I'm trying to copy a live WordPress site to my local server. I went to import the database from the live site through MAMP, and I received an error message when
I have the table: countries and columns Country and Status I wish to update only the values from the Status column based on a value from the Country column. SMT
<?php mysql_connect("localhost", "root","") or die(mysql_error()); mysql_select_db("tnews2") or die(mysql_error()); $query = "SELECT name,id FROM categories
I've seen many posts about how to build a table in HTML with PHP and Mysql, but my problem is, that I often change the headers of MySQL columns. Is there any wa
I selected a image using: <input type="file" id="pimg" name="pimg" accept='image/*'/> My javascript code: p_img =document.getElementById("pimg").val
I'm building an Node application which will query simple and more complex (multiple joins) queries. I'm looking for suggestions on how I should manage the mySQL
I'm currently developing a site that provides specific news events to users. The purpose of the site is to allow users to select which countri
Am I missing any tricks to speed up this select query? the query is grabbing the location data as the users types it in, its auto filled. $q
Hi i cant use INSERT UPDATE function with this class: MySQLiDB. Im trying write data to mysql and if exists this data then need update. So i use INSERT ... ON D
I have two tables CREATE TABLE person AS ( id INTEGER, sa VARCHAR2 ) CREATE TABLE sampletest AS ( sa VARCHAR2, cell VARCHAR2, pd
Still a mySQL beginner. I have two tables, follows and events, that have these columns: FOLLOWS user | profile EVENTS user | profile | other_stuff I want to
How would one fix this query? IF EXISTS (SELECT * FROM links WHERE age='10') SELECT * FROM links WHERE age = '10' ORDER BY ELSE SELECT * FROM links ORDER BY
id_detail_item id_item id_detail_item_name 1 1 abc 2 1 abcd 3 1 cde 4 3 z
I am trying to load data into a database table (MYSQL 8.0.28) in my Windows 11 pc through load data local infile command. I have gone through the syntax (https:
hello this is my first post on stackoverflow i am at beginner level at php, mysql and work on a php log in page connected to a mysql database which i did try to
I have the following table table x labref name repeat_status 111 L 1 111 L 1 111 K 1 111 K 1 111
How do I delete all rows that have a field called A that are blank. Lets say I have a table that looks like the following. |ID |A |B |C |1 |Data|Data|D
In a MySQL migration script, I'm trying to drop all the foreign keys of a table without knowing the name of the constraints themselves. I need this because I ca
I'm trying to match two choices. "One or the other" SELECT * FROM course WHERE category='blue' || category='red' ORDER BY id DESC LIMIT 5 That is my first thou