MySQL is an open-source, relational database management system.
0
votes
2answers
13 views
using CASE in a MySQL SELECT statement
How can I use CASE in a MySQL query? I'd like to perform something like this, where the value of one column on the table/view is used to create another column in the result set.
I don't know the ...
0
votes
1answer
19 views
MySQL - SUM for one table is joining another table
I have 2 tables:
1.items
+-------+---------+
|itemID | itemName|
+-----------------+
|1 | Item1 |
|2 | Item2 |
+-------+---------+
2.purchases
...
-2
votes
1answer
33 views
AJAX Record Deletion Using jQuery
Hello i just found a code to delete a row from my database using ajax but the thing is that when the delete is made in the html the table that should dissapear does not work.
here is the js code
...
-1
votes
1answer
33 views
MySQL query troubles
I have this query here:
select distinct oawa_id, 'Team Impact' as Club, FirstName, LastName
from team_impacts ti
left join session_participants sp
on (sp.member_id = ti.id)
or (sp.member_id = ...
0
votes
0answers
7 views
Numeric Field in PDF Form changes numeric value in $_POST
I'm using an Adobe Form created in Livecycle ES2 and a PHP script to enter data into a mysql database. For some reason the number I enter into the form and the number being sent via $_POST are ...
0
votes
0answers
18 views
View mysql data using PHP/Jquery with confirmation dialog box
I have a question about jQuery UI Dialog box and showing dynamic content from a database. Here I have a table which is generating blog post using php and mysql and in that table, there is a column to ...
-3
votes
0answers
24 views
Is there ever an acceptable way to store plain text social security numbers in MySql?
I am contracting with a company that stores hundreds of social security numbers (SSN) per day from online visitors (along with other personal data). They're gathered over SSL, but stored as plain text ...
0
votes
0answers
4 views
Mysql windows Error -13 and absolute path
I've problem with Mysql on Windows and
LOAD DATA INFILE "C:/mydir/filetoimport.csv"
(not using LOCAL) specifying an absolute path like "C:/mydir/filetoimport.csv" or "C:\mydir\filetoimport.csv"
The ...
-1
votes
3answers
29 views
storing the value of GET variable
I have a search bar on the first page and the results are shown on the second page with pagination. The problem is the pagination isn't working with $_GET or $_POST variable.
what I meant is like ...
0
votes
0answers
27 views
csv from mysql database
I am new to php and mysql databases. I have been developing a site in which I need the user to be able to download their data from a mysql database in a csv file. I have gone through many answers and ...
0
votes
0answers
7 views
Mysql FPDF data not lining up with table
So I have this pretty problem, ive got my header reading out pretty nicely and the data which is being called by a $_POST is also working fantastic...the only problem is that the data is showing in a ...
-1
votes
5answers
41 views
How To Insert From Data From PHP to MySQL DB
Edit: I can see the form but it does not write to the database. Here's the code:
<html>
<head>Test PAge</head>
<body>
<form action="testform3.php" method="POST">
<h1 ...
0
votes
0answers
9 views
How to insert new node into binary tree without user input gor new node side
I'm working on a project which has hierarchical data
CREATE TABLE `binTree` (
`nodeid` int(10) unsigned NOT NULL auto_increment,
`lnode` int(10) unsigned NOT NULL default '0',
`rnode` int(10) ...
-1
votes
3answers
52 views
SQL: convert all columns to VarChar(255)
After some searching here on stackoverflow and on the web, I couldn't find the answer to my question. I'm not a real SQL talent, but I'm trying to covert all the columns in my table to varchar (255). ...
0
votes
0answers
9 views
Differnece Between MYSQL(Binary) and MySql in LAMP/WAMP/MAMP
What is difference between MySQL(Binary) and MySql in (LAMP,MAMP, WAMP) ?
Which one is better to use?
On What Criteria i should select one of them?
Regardless of Operating System.
Which of ...
