MySQL is an open-source, relational database management system.
-1
votes
0answers
5 views
select 2 previous and 2 next records with one in between
Example:
ID catID
1 3
2 2
3 3
4 1
5 3
6 3
7 3
select * from tbl where ID=5
How would I select records 1,3,6,7 ? Is this something that will take time, I mean a ...
0
votes
2answers
13 views
Group By and Limiting the output in mySql
I am having a difficult time with the syntax. I know where the error is but cant get the line correct.
Lets say in trying to count food groups and I want to see the detailed count of food groups.
...
0
votes
5answers
33 views
Is this a good way to sanatize php $_POST inputs?
I have been using this code on my website for a long time, and just want to make sure I am correctly sanatizing my PHP $_POST inputs...
foreach($_POST as $key=>$val) //this code will sanitize your ...
-1
votes
2answers
26 views
two right joins on same PHP page?
I have two queries on the same PHP page. They are as follows:
$query1 = mysql_query("SELECT * FROM debates RIGHT JOIN users ON debates.UID=users.UID
ORDER BY timestamp DESC LIMIT 0, 10");
...
0
votes
2answers
14 views
How to find similar named databases in Mysql
I need to find out if there any similar named databases in my DB setup - for example 'BusApp', 'BusApp2', 'BusAppTrial', etc.
I know that I can execute "show databases" command and check the output.
...
-4
votes
1answer
43 views
unexpected T_DOUBLE_ARROW [closed]
I've a got a problem with my PHP code. I'm using the str_replace function but I encounterd an error:
$search = array('à', 'ò', 'ù', 'è', 'é','ñ','Ñ' );
$replace = array("a'", "o'", "u'", "e'", ...
0
votes
0answers
12 views
MySQL - form for editing data in multiple tables
I'm writing a MySQL database, hosted on a Linux server (Ubuntu 12.04) and was intending to use OpenOffice Base on a client machine to act as a front end for data entry.
That's fine for editing a ...
0
votes
0answers
6 views
Poor performance on bitnami server AWS EC2 micro
I'm looking for some assistance with performance tools for Linux server running on AWS micro instance.
Apache serves web pages really slow. I have used top command and Idle value is almost 100% and ...
0
votes
0answers
8 views
Spring MVC + Hibernate web application. Web server hangs on load of CRUD operations
I am working on the following project and have came across a runtime issue.
http://github.com/dmcquillan314/YouthMinistryHibernate
The instructions to run this project are located in the README.md ...
0
votes
2answers
19 views
timezone confusion in relational databases
I have downloaded a postgres database in .sql format. The type of temporal column in the database is: timestamp with time zone. And dates are mentioned in the database in the form given below:
...
0
votes
2answers
37 views
If statement error with variable
I have had this problem for a while and finally i narrowed it down to what it is (I think).
I am trying to put a limit on a income and the limit is $storagecap each $warehouse is = to 500 $storagecap. ...
0
votes
3answers
34 views
SQL Query returning too many results
I have an sql query that is almost right but when a user has more than 1 aircraft in the database they end up with multiple row listings in the results returned from:
SELECT a.this_pay,
...
0
votes
1answer
23 views
Joining multiple issue
I am really having trouble joining mulitple tables in a working query.
There are 5 different tables:
Event storing: eventid, staffnumber, date, start and end date..
Event_overview storing: ...
0
votes
0answers
8 views
mysql and VB connecting to a database
can someone explain if i understand these correctly?
• Data Binding/Binding Source
• Data Set
• Table Adapters
this is my understanding:
data binding is linking the program to an outside ...
0
votes
1answer
33 views
How to insert tags into database using jquery html and php
I want to insert these particular tags into the database. This is my HTML:
<div id="tags">
<input type='text' name='tags' placeholder='Type in topic tags here seperated by commas' ...
