MySQL is an open-source, relational database management system.
-1
votes
3answers
21 views
UPDATE mysql record from php
am a complete newbie at this am not a coder by any means, and this is not my own code, just gotten off Google but i believe it serves my purpose. I am trying to update a mysql record via php. It ...
0
votes
1answer
12 views
Difference between mysql_data_seek and mysql_field_seek?
I found that both of them are doing the same job. Is there any difference or not. I think, I had missed something.
mysql_data_seek
<?php
$sql="SELECT * from testing";
...
-1
votes
1answer
16 views
Sql query update and set
I am trying to update some values in a table via MySQL and php, but I cannot it to work: Here is my code:
$update = "UPDATE $table
SET `active`='1' AND `title`='Disabled By Moderator'
...
0
votes
2answers
8 views
Declaring variable in stored procedures and MySQL injections
I have this situation for example:
id value
1 data_1
2 20
3 data_3
4 15
5 data_4
6 data_6
and the following stored procedure:
DELIMITER $$
CREATE ...
0
votes
2answers
39 views
Speed of SELECT Distinct vs array unique
I am using WordPress with some custom post types (just to give a description of my DB structure - its WP's).
Each post has custom meta, which is stored in a separate table (postmeta table). In my ...
-2
votes
0answers
31 views
What could cause a MySQL database to be extremely slow?
I'm trying to figure out why a MySQL database is abnormally slow on a live server. Deleting a row from a table (with only less than 100 rows) can take anywhere between 1 second and 20 seconds. I've ...
0
votes
0answers
19 views
Updating a binary value in a MySQL table from a form
So I have this field in a table that is created from a mysql database.
Each row has a color green, orange or red (more or less like a light sign)
At the beginning of this table I have a buttom that ...
0
votes
1answer
34 views
search process using select query
i am creating a search form that will allow the user to choose between 3 types of search that are :
by name
by specialization
by location
but i get three errors
Notice undefined index : ...
0
votes
1answer
16 views
Combine Two Tables Into A Third Based Upon A Number Match
I'd like to combine two tables into a new table but only on the condition that there is a match on two different columns. I need to generate a CSV file that containing combined rows of data from the ...
0
votes
0answers
10 views
Performance issue on MySQL RDS with Play Framework EBean
I have faced a performance issue on RDS. I'm using Play Framework 2.1.1 with MySQL. The query that I'm testing takes about 2 seconds on my local unmodified MySQL database which I installed from brew ...
0
votes
1answer
11 views
How to convert my MySQL Connection to a Class in VB.NET 2010?
I have multiple forms, each form performs specific task that requires connection to the MySQL Server.
On each form, these are declared:
Imports MySql.Data.SqlClient
Dim myConnObj As New ...
0
votes
0answers
13 views
How can I add a MySql Server link into SQL Server so I can execute MySql queries From SQL Server?
I am trying to add a server link on SQL server so I can allow SQL Server to communicate with MySql Server.
I have found those instructions online
...
0
votes
2answers
40 views
How do I pull data from the my database using a php function
This is what I have in my main page:
$foo = new Foo();
$strQry=$foo->Client();
$user_data=mysql_fetch_object($user_res);
echo $user_data->clientid;
This is what I have in my class file:
...
0
votes
1answer
25 views
PHP / MYSQL Insert on duplicate key update if CURDATE() match otherwise make new entry
I am facing a problem in making a program with mysql and php...
See i want to save my search queries into the database,,
See this example
Stackoverflow searched = > 20 times on date = > 2013-04-26
...
0
votes
1answer
21 views
update query value in foreach statement with looping textbox values PHP
I want to update my database inside the foreach statement but it gives me the same values that I insert on to the last value that I input.
Let's say I have a looping textbox at the previous page.
...
