Tagged Questions
MySQL is an open-source, relational database management system. If your issue relates to MySQLi, use the MySQLi tag instead.
0
votes
0answers
3 views
Check if date field in database is expired in php
i've the this token table
-------------------------------------------------
user_id | time | token
-------------------------------------------------
user1 | 2014-10-01 | ...
0
votes
0answers
11 views
mysql group by months and then group results by user id
thanks in advance. Here I need to count employ's salary which depends on the number of rows added per months (with a unique picture_id, so if the same picture ID appears twice it counts only one time) ...
0
votes
0answers
5 views
How to perform exclusive search with mysql fulltext boolean search?
How can I construct boolean fulltext search condition for InnoDB that would return the rows containing only all the listed words (+word1 +word2 +word3) but nothing else?
E. g., if a row contains any ...
0
votes
0answers
3 views
a SQL multi-match join from Stanford open course
You've started a new movie-rating website, and you've been collecting data on reviewers' ratings of various movies. There's not much data yet, but you can still try out some interesting queries. ...
0
votes
1answer
12 views
login page not redirect to reports page in asp.net mysql
i try to login with usertype and redirect to their pages e.g admin redirect to reports page and public user redirect to gallery..
when i try to login from admin username and password then nothing ...
0
votes
2answers
32 views
How to connect php application to database
I have created register form using php and validation done by using jquery.
I have files are index.php, submit.php and functions.php.
So i need to create config.php to connect database.
I have done ...
0
votes
0answers
21 views
Inefficient LIKE query
I have an online search box that needs to look across many MySQL columns for a match. And it needs to handle a multi-keyword search.
Use cases:
I search for DP/101/R/23 (rego no)
I search for ...
0
votes
0answers
21 views
How to retrieve from multiple tables using an array containing keys for different tables
I have a php array where each element contains a list of IDS to fetch info about an item. However, each ID is for a different table.
Each element contains these values and are also a key to some ...
0
votes
1answer
21 views
How To Seperate the record values in sql
I have sql table like below
classids
2,3,4,5,
2,4,5,6,
5,9,6,8,
I want to split the comma separated values in sql
I want to give the condition
select classids from table name where classids = 2 ...
-1
votes
2answers
30 views
Fatal error: Call to a member function mysqli_fetch_array() on a non-object in C:\xampp\htdocs\projectname\searchit.php on line 43
I know this question has been asked several times, however I can still not get this to work!!!
I am trying to make a basic search engine which I manually enter pages etc in a phpMyadmin mysql ...
0
votes
3answers
23 views
To display HTML Table in code behind asp.net C# with MYSQL values
I need a sample coding for displaying an html table in code behind asp.net c# with mysql database values,
Chennai Bangalore Mumbai Hyderabad Delhi
Sridhar ...
-1
votes
0answers
16 views
Mysql #1093 - You can't specify target table 'tbl_client' for update in FROM clause
This is my query.. i dont know what wrong in it
UPDATE tbl_client SET client_totalbalance = (SELECT client_totalbalance FROM tbl_client WHERE client_no = (SELECT COUNT(*) FROM tbl_client) + (SELECT ...
-4
votes
3answers
25 views
Does search engine recognize contents from database?
Typically when we develop the website and later on we want to make it dynamic by integrating with PHP and SQL then does search engine recognize the contents stored in the database? Because it's ...
-3
votes
0answers
15 views
What program should I use for this data base generater? [on hold]
I do not have a lot of experience in data generators but am trying to build a generator similar to this one Can anyone tell me what program to use?
http://fantasy.usatoday.com/football-lineup-generato
...
0
votes
1answer
22 views
Duplicating new row of php table with populated dropdown list
I'm trying to create a new row of php table with two populated dropdown lists. There are three columns in one row, two of them have populated dropdown lists which if I choose one data from one, the ...
0
votes
1answer
8 views
Sage 50 ODBC using PHP-SQL state IM002
I'm trying to set up an ODBC connection to connect to Sage. The DSN is set up and works via Access and Excel. However using the PHP code below,
I get "SQL state IM002" or "[Microsoft][ODBC Driver ...
0
votes
0answers
28 views
How to join tables based on the column value in a table
I have the table news_feed in which all of my different types of activities data will be stored like admin activities, user activities, company activities etc. The table format looks like:
news_id | ...
0
votes
2answers
23 views
SORT BY in SELECT
I am selecting a table that has multiple of the same records (same REQUEST_ID) with different VERSION_NO. So I want to sort it descending so I can take the highest number (latest record).
This is ...
abap
0
votes
0answers
17 views
Query to return tables from mysql database not listed in a column in a table in the database
I have a number of tables in my wordpress database(gooda814_bilby01). I want a function to compare the tables in the database with the values in a column in a table in the database so that the ...
-3
votes
0answers
15 views
my shopify website structure [on hold]
I am total new to shopify and i have worked on wordpress CMS for my projects. I have read documents and have one shopify account. At first i thought shopify to be another CMS like wordpress but later ...
0
votes
0answers
22 views
Delete item from list of angular js and database
hi i am new to angular js. In stage of learning. I had fetched data from database after the json encode. It worked sucessfully. I am using code igniter. Now i want to delete the list fetched from ...
0
votes
0answers
16 views
20 seconds or more MySQL queries when table increased by 300,000 records
My MyISAM database table had around 200,000 records and the below query displayed results within a few seconds. I then increased this database table to 500,000 records and results took 20 or more ...
0
votes
1answer
40 views
2 decimal places missing in price(PHP)
I have a problem with 2 decimal places, I want it to be USD 35.99 instead of USD 3599.
This problem occurred when I kept refreshing my page for testing purposes. Sometimes the price shows no decimal ...
0
votes
0answers
5 views
Full text search with strings containing slashes, dashes and full stops
I have a car search and one of the fields is registration number
Sometimes, they contain special chars like this rego number:
Z-11.269
It would appear that this breaks the fulltext search, i.e. ...
0
votes
1answer
8 views
Are mysql triggers atomic? Does this mysql trigger have concurrency issues?
I have created the following trigger to populate a field with a unique integer value.
I am using this in an InnoDB table and there is a UNIQUE key constraint on the field.
Is it possible that two ...
0
votes
3answers
22 views
Recieving errors when connecting to database
Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\Apache24\htdocs\TheWorld\index.php on line 27
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in ...
-2
votes
1answer
17 views
How to make connection between jaggery and mySQL? [on hold]
I am creating a web application using the JAGGERY a javascript framework and I am facing issues connecting it to mySQL. I am unable to do it please help me.
0
votes
0answers
10 views
Append choices to choice list in Django models dynamically
I want to select the options from a list in my django models. But the options in the list are populated in the post_save() method.The situation is like this:
I enter some attributes in the table1 ...
0
votes
0answers
14 views
mySQL subquery returns NULL
I have a table for blog posts. if a user reblogs a post, then the source_hash field is filled with the original post's hash. I could store the original post's author (username) as well, but if they ...
0
votes
1answer
17 views
query in mysql to perform the not in function
I have written a query in mysql to filter out the vendorids' which are not in vendorids of the userid = 1 but they are present in vendorids of the userid = 5 but I am not getting the correct answer ...
0
votes
0answers
17 views
Sending data to PHP via $.ajax is not working in every browser
I know there were so many related questions like this one. But I didn't find any question that can solve my problem or I didn't find it yet. Umm...I am using three kind of browsers : Maxthon ...
0
votes
2answers
40 views
How to get the right max id and min id from a function?
I had a large table with 3 million rows before, but I split it to 6 tables 500.000 rows each, now I'm trying to connect them, but I want to read 1 table by 1 not all 6 tables at the same time, I'm ...
0
votes
2answers
12 views
mysqli_info() equivalent for PDO?
How to retrieve information like:
Records: 88 Duplicates: 12 Warnings: 2
When performing a batch insert with PDO?
0
votes
1answer
15 views
Getting Error Code: 8155 No column was specified for column 2 of 'pol' in SQL server
Select a.className1
, a.classNumber
, b.firstName + b.lastName
, cl.status AS 'Active'
From a
Left Join cl
on a.id = cl.id
Left Join (Select a.id, count(b.teachCode)
...
0
votes
1answer
38 views
Exact same code working on one server but not other
I have uploaded same files at two different servers. One at hostinger (free web hosting), other at iPage(paid hosting).
The exact script works on hostinger but not on iPage.
Here is the code
<link ...
0
votes
4answers
39 views
get php last message from database
i have a messages page, and i need to only get the last message from each user, my database is the following: msg_id, message, userid, toid, datecreated
im getting the results this way
<?php
...
-1
votes
2answers
11 views
JScrollPane scrollbar doesnt work after GridBagLayout
I am making an auto chat client like Cleverbot for school. I have 2 problems... 1) the scroll bar doesn't seem to work for some reason. Here is a screenshot:
http://imgur.com/AZoP251
import ...
-1
votes
0answers
7 views
sql jsp Dopost() form data getparameters query
I want to retrive the data entered by the user in a form. I use the do post method with the get parameters to retrieve the data, then, I would like to send a query to the database and display the ...
0
votes
3answers
21 views
Error in php mysql connection using xampp
I'm trying to connect a HTML page using PHP form to MySQL database using Xampp. The HTML page is working fine but as soon as I press submit button a page with distinct characters appears, can anybody ...
0
votes
0answers
5 views
cloud9-ide importing database in mysql
please advice how to actually key in the "path" portion of command: source PATH_TO_SQL_FILE.sql?
The Sql (i.e database folder>database.sql) file is inside my cloud 9 ide workspace.
I have tried ...
0
votes
1answer
31 views
auto increment or update age column every year mysql
I want to ask about updating the age column in my table. Is it possible to update the age automatically every year based on date of birth column in my table. the age column and the date of birth ...
0
votes
1answer
21 views
PHPNuke Block - What's wrong with this code?
What is wrong with my code? I want it to display the last sale but it doesn't display anything.
<?php
/****************************************************************************/
/* Generated ...
0
votes
0answers
21 views
PHP/MYSQL hits counter on dynamic page
I need help stackies, I've been trying to code a php/mysql hit counter on a dynamic page but it just doesn't seem to work. Here's the code so far..
while{
$incre=+1;
$update=$db->prepare("UPDATE ...
0
votes
0answers
25 views
error parameter index out of range (2> number of parameters, which is 1)
por favor al ejecutar estas lineas de codigo en un boton modificar usando netbeans 8.0.1 y con base de datos me genera ese famosos error y no hay forma de encontrar el mismo ya que no se en donde ...
0
votes
1answer
16 views
PHP if keep executing, despite the logic
I've been banging my head on this for hours now trying to figure it out. I have a GET variable that basically goes into my database and toggles the ready field from 1 to 0 or 0 to 1, depending on what ...
0
votes
2answers
14 views
Safe PDO mySQL SELECT statement with for loop
I was told to use PDO to safely retrieve data from a database. Now I'm wondering if this would be safe or work at all:
$dbtype = "sqlite";
$dbhost = "localhost";
$dbname = "test";
...
0
votes
1answer
17 views
Insert a certain date format into MySQL
A very simple Insert statement with a topic and a date I would like to insert the date as a certain format "MM/DD/YY" Don't know if it's possible or not?
$sql = "INSERT INTO Topic (Topic,date) VALUES ...
0
votes
1answer
5 views
MySQL full text query across multiple columns
I have an issue that I'm confused about when using a full text search in MySQL. I'm running MySQL 5.1.67. Here is my simplified table:
CREATE TABLE `contact_info` (
`id` int(10) unsigned NOT NULL ...
0
votes
3answers
15 views
Store a unique reference to a Mysql Table
I am creating a site that is sort of ecommerce-ish. I want to give my users a perfect search ability using specific attributes that differ from product to product. I plan to create 1 products table ...
0
votes
0answers
6 views
Dovecot/Postfix/Mysql email server not sending
My postfix/dovecot/mysql virtual mail system is not receiving mail and is not sending it. When sent it goes to the mail queue. I'm stumped and have no idea what to provide you with, so if you ask I ...
