I have tried this a few different ways, but I keep getting the same error message:
MySQL Error Number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MyS...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have a column in a table that contains domain names. I want to use the $_SERVER['HTTP_HOST'] value to see if the domain name exists in my table. If one of the rows has 'abcdomain.com' in the dom...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all.
I am currently trying to achieve the following
I have the following two tables
TABLE 1 - USERS
Ident | Name
--------------------
34 | Dave
35 | Adam
36 | L...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hello.My problem is,I want to insert the value in my array into the database. Here is my coding.(Im using PHP).
------------------------------------------------------------
for($i=5;$i<=1...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
Can anyone tell me if and how, a MERGE STORAGE ENGINE results in a better performance or a faster query than using a UNION ALL?
Let me explain my requirement in detail. I have the foll...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Can any one help me out with creating a rearrangeable mysql database? The database will have the information already loaded for the time being. Eventually I need to create a form to add and delete...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have a question about creating a MYSQL Database structure. I want to create a table full of information that would look similar to that of an excel spread sheet. How would I create such a databa...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
First of all iam so sorry because my english is very bad...I hope you can understand what i want to ask...
first that I wanted to ask what was that had heard or knew about the control of data ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am new to working with databases. What I need to do is to transfer information from an old system that has been ran through access on a local server inside an office to a new system that is buil...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
How do you get the machine name of the current computer in MySQL?
e.g. KevinPC.
In MSSQL, I could use:
Code:
CONVERT(varchar(200), SERVERPROPERTY('MachineName'))
to get a strin...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
sorry my english bad, i have trouble from my query, before migrate to mysql i use MS access, now i have problem query here
select `qrstock`.`ID_BARANG` AS `ID_BARANG`,`qrstock`.`BARANG` AS `BA...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I just started to switch to mysqli.
PHP version is 5.1.4 and MySQL 4.1.2
It is working fine until I would like to use a 16th parameter.
The error message is that the amount of...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I'm using:
mysql Ver 14.12 Distrib 5.0.26, for pc-linux-gnu (i686) using readline 5.1
within a PHP Version 5.2.2-pl1-gentoo script.
I have 3 tables:
members: usernames with unique id...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hey all, my last msg didn't post. I thought it might be because of the link so here it is without....
If anyone has a second to look at a query I would be incredibly grateful. My SQL skills a...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Purpose of Post: To create a SELECT statement that returns results from multiple tables, choosing which tables to retrieve values from based on NULL fields within the main (comics) or intermediate...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi ,
i m new here, and doing some project in mysql , can any one help me out, its about the normalizing the tables, in what kind of circumstances we do not need to normalize the tables pls guy...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am trying to store incoming MySQL connections to a table. I currently run mysql 4.1.22 and can’t seem to set it up in a way. I have been looking around but unable to find data that will assist m...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hello, that server supplier was down our website, they said our database is overload, detail info:
" Here is a copy of the queries that have caused the overload:
1.Time: 36% (3252 sec...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I am trying to set up a WAMP - Windows, Apache, MySQL, PHP combination environment on a Windows XP machine.
Apache and PHP together seem to be configured and working fine. MySQL works...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have set-up a MySQL database called test_db with table authorised_users.
user_name varchar(35)
user_id varchar(16)
user_password varchar(16)
account varc...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi every body, let just say that I'm kind of new at everything having to do with server-side web anything.
I'm currently taking a class, to learn a little about SQL, however I'm trying to appl...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi List,
The world of the enterprise DBA is changing, be part of it. Like it or not, open source technology is making serious inroads into the enterprise environment. Justifying the purchase o...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello guys,
I would like to ask something about searching Japanese characters from the database. Because every time I searched, it won't display data. But if searched without a condition it dis...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello:
I am new to MySQL. I am getting this error because of this query written for me. Can you pls advice me how I can better write this query.
Problem in Product Selection: The SELECT wou...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
SQL Edge not only allows users to execute SQL scripts, but also provides a powerful way to visualize data relationships. With SQL Edge, users can use only one query to retrieve data in a master ta...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
