hi,
im tryn to run a sql query but im getting this error
Code:
SQL query:
CREATE TABLE `font` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 255 ) NOT NULL ,
`font_url...
[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
Yet again I have a query about joins and even though I keep reading I cannot find a solution for my problem that is relevant or that I understand.
I have 3 tables (I have shortened the number of f...
[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 create a system where a user can enter their registration number (uk cars) and have our site tell them what parts (we sell towbars and such) are compatible with their car.
I have ...
[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
Is there a single query I can run that will set all values of a single column to 0, but set some values to 1 ?
somthing like
Code:
UPDATE `table`
SET `column_name` = 0
WHERE `row_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
Is column = column + 0 allowed as part of a MySQL query?
I am experiencing problems using it, but I can't be sure if it is that or something else in the code..
Cheers
...
[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've got a table named "selector" with the following fields:
model
make
year
timestamp
I'm trying to write a query that returns the number of times that a unique model, mak...
[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
Hiya,
I'm writing a quick script in PHP to update user details that have already been submitted, but for some reason I can't get the following code to update the DB
PHP Code:
...
[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 the following code to import a .sql file.
Code:
mysqlimport --local -u root -pCENSORED teraspot_db /home/default/teraspot_db.sql
and I get this error
Code:
my...
[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
Ok all i'm trying to do it left join a table on another and order by the data in the joined table. Meaning that since it's left joined there is the possability that there will be no data in that t...
[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 there,
I have to make a system for my final year uni project. To put it simply i have 3 tables.
1.) School
2.) Class
3.) Student
Obviously Schools have classes and each class ha...
[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
GROUP_CONCAT is a great function...But have MySQL version < 4.1 and my hosting provider can't upgrade MySQL. Is there a way to get this result with a different SELECT query?
I have a list 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
Hi everyone, the problem is in next:
I have table with following fields:
PointsID int(10)
UserID int(10)
ProductID int(11)
Reason tinyint(4)
Date datetime
Points va...
[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 having problems with my character set - and as a result, certain characters get converted. I changed the column collation to "utf8_general_ci", but it didn't work.
When I use ph...
[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 Everyone.
Everytime I try to read from any MySql database in PHP, I get a blank screen or just a blank response.
I dunno what the problem is. is it the configuration?
When i use ph...
[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 using php4 and mysql and running them in IIS. I installed all in C:\.
Then I put phpmyadmin folder into the wwwroot folder. When I login http://www.mysite/phpmyadmin [http://www....
[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 guys im trying to take off my live database and overwrite it upon my local version of my site on my desktop computer. I have not too much of an idea what im doing - what would be the best way?
...
[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, im following a book to learn sql, its a very good one by larry ullman ( sorry sitepoint!) but its got me a lttle confused. Its told me to create a table that includes a column caled url_id tha...
[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 figure out why I have a hugely slow query (~2 seconds in my testing environment). Details are below:
It involves two tables, products and vendors.
Products is a huge tabl...
[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 these queries:
Code:
SELECT
COUNT(s01_Products.id)
FROM
s01_Products
LEFT JOIN
s01_Attributes
ON
s01_Attributes.product_id = s01_Products.id
LEFT JOIN
...
[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 need to search my whole database and update a word to add ™ to it.
Any ideas on how this is done?
Any help would be great.
Many Thanks
mrmbarnes
...
[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 the following query and it erros out saying the select field name is ambigious. The tables are exactly the same. How would I go about fixing it?
I just want it to return the user_id if ...
[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 writing a script to allow visitors to rate articles on my site. Sometimes a question does not apply to that particular article or a person is just too lazy to fill out the entire form. Eithe...
[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
Right,
Hope fully you can help.
my query at the moment is
PHP Code:
$question = "SELECT *
FROM people
order by
&nb...
[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 could anyone point me in the direction of a good reference list containing lots of sql commands. Im learning and i thought it would be helpful to have a list of possible commands i could use. I...
[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 run phpMyAdmin - 2.8.0.2 both on my local win/apache and on my remote linux/apache with exactly the same config file.
The local server has MySQL - 4.0.16-nt installed.
The remot...
[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 
