MySQL is an open-source, relational database management system.
0
votes
0answers
23 views
Updating information into a MySQL Database using PHP
Within my code, I'm attempting to update my database with values from modifiable text fields in a form. However, when the query is ran, it wipes all fields (turning them to "") related to the record ...
0
votes
0answers
27 views
Spacing divs from database
Website here.
I am pulling values from the database and displaying them in the right hand box out of the two boxes on the image. There are four values in the middle: price, queue jump, deal 1, and ...
0
votes
1answer
13 views
Hibernate Parent Child Same Table Error
I have a problem with Hibernate using a parent child relationship in the same table. I can do selects and inserts but I can not delete. I wrote a JUnit test to see what was going on and found some ...
1
vote
2answers
14 views
Behavior of InnoDB clustered compound index
We are running MySQL/ISAM database with a following table:
create table measurements (
`tm_stamp` int(11) NOT NULL DEFAULT '0',
`fk_channel` int(11) NOT NULL DEFAULT '0',
`value` int(11) ...
-1
votes
2answers
30 views
mysql_fetch_array() always return null
I am try to fetch data from the database
$check_sql = 'SELECT * FROM table;
$check_result = mysql_query($check_sql);
echo $check_result;
$result = mysql_fetch_array($check_result);
when I echo ...
1
vote
2answers
34 views
Convert different encode charset to UTF-8
I have this words (and more 40 in same case) in customer databases:
Aclimação
Aclimação
I need convert both to UTF-8 and save in MySQL database: Aclimação.
How I do ...
2
votes
1answer
54 views
MySQL query - joining two tables producing duplicate results
I'm running the following MySQL query in PHP.
"SELECT *
FROM `challenges`,`verifications`
WHERE (`challenges`.`user_id`='".$this->record['id']."' OR ...
1
vote
0answers
14 views
Django model: creating small value fixed point
Summary
I'm building a project in Django - and will many small-range positive decimal values (1.25, 0.01, etc). In the database (MySQL), it makes sense to store them as value*10^precision. This means ...
-1
votes
0answers
29 views
Populating Database Causes Freeze
This is the wierdest problem i have experienced on a computer in my life.
the short explanation:
my development environment:
Ubuntu running through virtualbox.
the problem:
infinite-loop like ...
0
votes
0answers
10 views
Having trouble using MySQL in cPanel?
I'm working with HelioHost (a free web host) which has cPanel built in. Inside cPanel there are some DBMS systems to chose from, one of course being MySQL. I've played with MySql outside of cPanel ...
-1
votes
2answers
24 views
How to make jQuery get PHP parameters from mysql_fetch_array?
How can I make jQuery get the PHP parameter from mysql_fetch_array()? Below is part of my code, any suggestion would be welcomed.
PHP
$query=mysql_query($sql) or die(mysql_error());
...
6
votes
7answers
50 views
Selecting the minimum of two distinct values
I'm working on a sql selection where I need to get all the smallest records for an ID. My problem is that, while I thought my code was working, it would often return incorrect values for other ...
0
votes
0answers
30 views
MySQL removes a rows from a table after some period of time
The problem is that i have a database in MySQL (using phpmyadmin), and after some period of time, it drops all rows in some specific table content.
Here is a pic:
== UPDATED ==
Here is my ...
1
vote
2answers
36 views
PHP Insert Numbers not working?
I am inserting tags from a textarea into a database but the issue is that whenever I try to insert the album INT or the track INT it shows up as 0 in the database. If you see the PHP output the values ...
-1
votes
1answer
54 views
AJAX post fails with '?' [closed]
i have a textarea and a button, when i click the button, send the textarea value via ajax and save this data with PHP in a MySQL database. It works fine, the problem is if write any text with '??' ...
