MySQL is an open-source, relational database management system.
0
votes
0answers
10 views
What's the scope of MYSQL VIEW?
I have a question concerning the scope of VIEWs. I am new to mysql and I am creating a website with automotive information.
The setup for this specific php page is that I create a VIEW from several ...
2
votes
2answers
24 views
MySQL query to get count of only new users each day
I have a table of call records,
I need to know for each day how many people are first time calling every day,
Note: they called the selected day, but never before that day.
I managed to have this ...
0
votes
0answers
8 views
Is it possible to write Java SE socketserver using Apache, XAMPP, MySQL?
I have a prototype of client - server desktop system. Let's say that there are 2 clients - doctor and patient. Doctor has his own desktop Java app and patient has his own Java app - both are ...
0
votes
1answer
15 views
More value in one field MySQL
Who know how I can put in MYSQL more than one value in one field or who have any idea:
thanks
0
votes
1answer
9 views
Grab Posts Content from Database with hyperlink - PHP
hello guys,
i want to know how to get content from database with Anchor tag.. as a example i have posted the post on the site.
Hello I am the PHP.go from here http://php.net
now when i get data ...
-1
votes
1answer
22 views
How to extract the country code and area code from telephone number using algorithm
we are working on a project where we need to derive the solution for Extracting the Country code and Area code from Telephone number.
we are saving the Telephone number in the Mysql database and ...
0
votes
0answers
10 views
Using left most on unique key across two columns or separate index?
If I understand it correctly, if I have a regular index across two columns and wish to use only the left most column, it works just as well as having an index only on that column. However, if instead ...
0
votes
1answer
31 views
How to display normalized MySQL data in a flat HTML table with PHP?
I want to display this data in table format, like
<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
...
0
votes
2answers
26 views
Give value to radio button php and save to sql
I have a little problem that i have been struggling for the last 16hrs I can find a solution for this... I really really need some help please...
I have the form which is generated by a query based ...
-1
votes
0answers
35 views
how to run more than one php page in the same time?
hello every body i wanna ask question that how can i run more than php page in the same time : my project is to display expectation time bus to arrive station i used a desktop computer as screen to ...
0
votes
1answer
9 views
Can't create/write to a file in MySQL
I've created a stored procedure which create an CSV file from a table.
this is the stored procedure :
CREATE DEFINER = `root`@`localhost` PROCEDURE `DO_BACKUP` ( IN `table_name` TEXT )
NOT ...
0
votes
0answers
9 views
PHPMyAdmin/setup show blank screen, while PMA itself works
I'm setting up PHPMyAdmin on an NginX server. The system itself works, however, the /setup page where I should be able to change settings (i.e. build a new config.inc.php) is blank. It doesn't show an ...
-2
votes
0answers
25 views
How to preserve existing database connection?
I'm the developer of a PHP comments script which is designed to be included into the body of the users' websites. The script has its own database connection and currently uses the 'MySQL' extension. ...
-2
votes
5answers
23 views
How can i frame a query for this
I have a table like this:
staffname | periods
___________________
david | yes
seema | no
raj | yes
seema | no
david | yes
Now i want the result like this:
...
-3
votes
1answer
19 views
distributed storing data like facebook
We are planning to create one web application like Facebook. We have problem of storing data in multiple zones.
We think that, we will create user wise database and we will store every comment in ...
facebook
