| |
thread by: kaf3773 |
last post Feb 27 '16 by: hsriat
Hello,
I am trying to query the data set below for the data_value for the data_id of the recent data_date.
So for data_id 18554 the recent data_date will be 2/8/2016 18:40 and its data_value will be 29504.76
And for data_id 18555 the recent data_date will be 2/8/2016 18:40 and its data_value will be -90909090909
...
|
thread by: sman |
last post Jan 14 '16 by: Rabbit
i wish to now know how to normalize a table which have duplicate names and number repeated severally and i tried normalizing but could not
|
thread by: SOMUKARTHIK |
last post Dec 23 '15 by: Rabbit
Hi, I have used inner join but need to remove leading zero's in one of the field because my query is
"select * from table1 inner join table2 where table1.start = table2.start" here table1.start field consistleading zero's. how can i apply query in where condition to remove leading zero's.
|
thread by: ahmad641 |
last post Dec 23 '15 by: adriancs
***> here is the code***.
> when i search single word like GOOGLE then the result is appear
> if i search two or more word search then the result is not appear.
<?php
include("connection.php");
@ob_start();
session_start();
$GLOBALS=isset($_GET) ? htmlspecialchars(urldecode(urlencode($_GET))):"";
|
thread by: t2tt |
last post Dec 21 '15 by: t2tt
I need help designing a separate lookup database that allows me to find information about members quickly. On our main system each account can have 3 sub-members linked to it including the main which makes 4. They can only purchase an event once per member + sub member. Each member has its own 15 Digit ID.
I need help figuring out how to join...
|
thread by: Toxicous8 |
last post Dec 12 '15 by: Luuk
Hey everybody,
Problems everywhere ain't they?
Well this one is about mysql and when I open phpmyadmin, I get
"Access Denied.
Error!
Cannot connect: invalid settings.
Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check...
|
thread by: FluffyPancakes |
last post Dec 7 '15 by: FluffyPancakes
I am working on a project similar to Cleverbot (a chatbot). It will store user input and quickly match it with a response that another user already gave for that input.
What would be the proper way to store the conversation in a database? Just as a table with a bunch of individual records of sentences? (with key>value type pairs?)... or is that...
|
| |
thread by: samvb |
last post Nov 28 '15 by: zmbd
Alo all,
We are targeting specific kind of customers who use different kind of services such as fashion shops, cosmetics etc. This service providers just buy a package (domain, web site, db etc) and they are good to go. Now they customers are repeated time and again and so a single customer is registered 5-6 times in a single computer running...
|
thread by: rich300 |
last post Nov 12 '15 by: rich300
I have a long, complicated set of conditions that I would like to use in a MySQL stored procedure to either (a) update a table with the complicated set of conditions in the WHERE clause, or (b) return a single value based on the same set of complicated conditions. I know how to write a stored procedure to do one or the other, but cannot see a way...
|
thread by: game2d |
last post Nov 9 '15 by: game2d
I need some help writing a sql query. I have below 2 queries and I want to combine them together.
Now I already tried 'union' but it doesn't work.
I first want to print all results of query1 than at bottom of that I want to print all results for query2.
--Query#1
SELECT DISTINCT a., b.Description
FROM CONTAINSTABLE(myTable, *,...
|
thread by: dashpilot79 |
last post Oct 13 '15 by: dashpilot79
I wanted to use MySQL for storage of login information. Then I will have multiple services (RADIUS, Proxy, etc) checking against the information.
Is there a way to make a master table that will have all the information that is needed, then have a bunch of child tables that have the redundant information from the master table, however, only...
|
thread by: sarah997 |
last post Oct 6 '15 by: sarah997
I am building a query that gives the following information
Total Claims, Total Charges, Total Payment, Denial Count, % of Billed Charges and % of Claims Denied
This is all grouped by provider id, provider name and denied count then ordered by Total Claims.
I have been successful with my query until it comes to getting the % of Billed...
|
thread by: viana2020 |
last post Sep 22 '15 by: viana2020
how do i change this to mysqli?
<?php
require 'connect.php';
session_start();
$username = "";
$password = "";
|
thread by: harman30 |
last post Sep 16 '15 by: RonB
I am using the code below for search function but it is not protected from injections and I am not programming expert so can anyone help me on this my code is
<?php include ( "./inc/header.inc.php" ); ?>
<?php
if(!isset($_POST)) {
header("Location: main.php");
}
$search_sql="SELECT * FROM blogs WHERE title LIKE '%".$_POST."%' OR body...
|
thread by: harman30 |
last post Sep 16 '15 by: harman30
I have created a search box now want to add search function to it that searches for text entered only in my site. I want to know how things are put together for search to work. I know we need to call data from tables we want to search, but do i need to create a table for this search function just read it somewhere, if it is so what is the purpose...
|
| |
thread by: lgoddgreat |
last post Sep 15 '15 by: lgoddgreat
I was trying to create a website that enables the users to Input something in it, like user info. but it always gives an error whenever I try to test submit the inputted data's into the database.
'Could not Connect: Access denied for user 'smdg'@'localhost' (using password: YES)'
connection:
define('DB_NAME', 'testdb');
define('DB_USER',...
|
thread by: daisyy |
last post Sep 12 '15 by: Luuk
I tried editing .ini file, it prompts access in denied. And if i try to chnage using command prompt that also it does no allow me to do so.I cannot even use "Show Max_allowed_packets". It says show is not recognized as internal and external command.
# For advice on how to change settings please see
#...
|
thread by: yelly |
last post Sep 12 '15 by: Luuk
My goal is to connect my SSIS package to a MySQL server running on a different machine (windows).
I am new to MySQL and my client's system admin doesn't know much about MySQL either. I've been trying to connect to using ODBC MySQL driver 5.3 but i keep getting this error: ERROR: Can't connect to MySQL server on '' (10061)
Do i need to have a...
|
thread by: abreal |
last post Sep 12 '15 by: Luuk
Is it possible to install MySQL standard edition to a remote server using filezilla to upload files and putty to run and execute the setup MySQL?
if yes, how to run the installation
|
thread by: viana2020 |
last post Aug 31 '15 by: RonB
i am trying to feed a number to database in this case my reference number which is of a (AAA/BBB/28AUG2015 - 4082) format,
which should be selected by user,and the date should be the system date while the last number should be auto-generated in that sequence.
the 1st and 2nd values are fixed.kindly i am unable to do that on phpmyadmin DB...
|
thread by: babs115 |
last post Aug 21 '15 by: RonB
HELP PLEASE!!!!!!!!!!!!!
Error
MySQL said: Documentation
#2003 - Can't connect to MySQL server on '127.0.0.1' (10061)
Connection for controluser as defined in your configuration failed.
|
thread by: Exequiel |
last post Aug 14 '15 by: Rabbit
I have bunch of data in the table in my database, the field is in a varchar type, the field has deimal numbers, has integers, has letters etc. i only want to check if the data in that field is a decimal, how can i check that using only mysql syntax? no php.
Any comment are so apprecitaed, thank you. :)
|
thread by: babs115 |
last post Aug 9 '15 by: Siam9
My colleagues say it is wrong but not one of them can tell why and I don't know myself.
I attached the design and ERD for your correction ,please.
|
| |
thread by: xcoop38 |
last post Aug 1 '15 by: Luuk
Trying to write a sql statement to return a result set comparing two dates where the 1st date is 31 days or greater than the 2nd date
|
thread by: sabarisan |
last post Jul 26 '15 by: Luuk
what is the procedure to connecting a database and application using byethost server
|