database php

In order to improve insert performance and load on server, I've decided to divide a large table into 2. A big table which will only be used for…

Im building an application and Im having a bizarre issue where sometimes an sql statement will work and the very next call the exact same sql…

I have millions of songs, each song has its unique Song ID. Corresponding to each Song ID I have some attributes like song name, artist name, album…

i will create schema the database MySQL. There are username, password etc and rating system and available in month. Standard it looks like this: id…

So I have a form that can increase and decrease according to what the user adds to the page. To be able to handle unknown posts, I have set up a…

I've never had to do this before, so really I just want to check and see if I'm approaching this the correct way. I need to switch databases in the…

I have this code: $local_id = $_GET['id']; $sql = dbquery("SELECT * FROM `videos` WHERE `id` = ".$local_id." LIMIT 0, 1"); while($row =…

I need to store postal addresses for my users, but I don't plan on really doing much with these addresses other than displaying it (won't be…

What issues are associated with maintaining multiple tress within a single table? The motivation for having multiple trees is to avoid excessive…

I need to show the updated data as soon as the new entry is added to it and the user doesn't need to refresh the page by himself. People told me to…

After taking some advice from people on here in a previous thread, I'm trying to convert my MySQL to PDO, but am running into some issues. Here is…

I have a table in my MySQL DB with information from each user that they submitted during registration. I would now like to allow users to change one…

I need to create a database to store details about what regions game characters have been in and how they got there. I am planning to store the…

If I open up a cmd shell and run >mysql --host=12.34.56.78 --port=1234 --user=myuser --password=mypasword mydb I can successfully connect to the…

I have a database for my product and in this database i have 2 table 1. product detail and 2. product feathers . There are many feathers for one…

I have a table called phase with following fields. ID,Name. I want to change its comment using query. ALTER TABLE phase CHANGE Name Name…

<?php include 'db.php'; $subassetcategory=$_GET["subassetcategory"]; if ($subassetcategory == "all") { $sql="SELECT * FROM asset_subasset"; }…

i am trying to display a varchar(40) from database to php page field. the value in database is "test address" but when it displays on page it only…

what is the right field type for IP address in mysql? and what is the right way of storing it?

I'm managing a website that is built from the ground-up in PHP and uses AJAX extensively to load pages within the site. Currently, the 'admin'…