I have a query to search the lowest price of each hotel
PHP Code:
SELECT a.hID,
SUBSTRING( MIN( CONCAT( LPAD( dbl, 8, '0' ) , mID, rmID ) ) , 9, 1 ) AS mID, SUBSTRING( MI...
[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 add 4 columns together and have the answer put into a 5th column
Something like
Name--1st--2nd---3rd---4th---5th answer
griffin--1----2-----3-----4-----10
This is...
[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 installed Mysql from the Windows Essentials download. I go through the configuration process and set it up as per K. Yanks book 'Database Driven Website using PHP and Mysql' but at the fina...
[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've always managed dependencies accross tables with a 'link' table:
Eg:
Users belong to Groups so I'd have a User2Groups linking table to manage the connection.
This 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 want to create a temporary table/view which will contain the times between two given times (incremented, say every 15 or 30 mins).
For example, I have the main table like this:
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
Need someone to optimize my database.
I have dedicated server for mysql, which is always overloaded. I run there DB for site with 120k-150k uniques/day.
Something is wrong there. Please PM...
[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 joining the same table in two different ways to another table.
Code:
SELECT *
FROM table1
LEFT JOIN table2
ON table2.id = table1.field1
LEFT JOIN table2
ON table2.id = table1.fi...
[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,
if I have a table with 200 rows in it. I want to select 1 random row. Does anyone know how to do that in a select statement?
thanks.
...
[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,
How is possible to replace in INSERT_NOW - CURRENT with words from STORAGE - OK_WORDS when BAD_WORDS is like NOT_OK_WORDS only from mysql console?
Short if i have storage of words nam...
[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 folks,
Ubuntu-6.06-LAMP-server-amd64
I followed section "10 MySQL" on;
http://www.howtoforge.com/perfect_setup_ubuntu_6.06_p4
and found "libmysqlclient12-dev" ...
[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 my jsp form named frmAdminSelectid.jsp.
In this,i am coding to get data from database from one table called artist.
i have three different conditions where i need to display artistid's ...
[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 people
I am trying to lock a table which was created in the MyISAM engine.
I use the following query:
Code:
LOCK TABLES A WRITE;
That works fine
At the end of my executing 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
I have an art website. I have the pieces of art grouped under each artist. I need to be able to change the ordering of the art from time to time. Currently, they are ordered by most recently ad...
[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
This is search by zipcode query. It used to work on MySQL 4 and now gets the error " Unknown column 'location_zip' in 'on clause' ". We have a huge list of zipcodes with their latitude/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
Hi there
I was hoping for some urgent help. One of my websites is having big problems with MySQL. Its a popular website and MySQL hasn't been able to cope. The site recently froze, here is...
[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
On my community website i'm doing "friends" in a similar way to myspace.
What's the best way to do it ?
Have a two rows in the friends table. One with the the user reqesting the friendsh...
[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
Currently I have an algorithm to do this, but I'm interested to know whether it could be done using a SQL query, here's my table:
Value1 Value2 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
Well, I own a website for rating pictures of girls.
The thing is, I need to implement a anti-cheat voting script so that people can't vote more than once on the pictures.
I am thinking 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'd like to be able to move up/down output data (rows).
So i need some help how i could swap two rows in a table.
This is what i tried:
Code:
$q_pos = mysql_query("SELECT * FRO...
[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,
I have inherited a query that works perfectly on MySQL 3/4 but not 5. I didn't write it and very little experience with joins.
So my first question is... what's it trying to do and...
[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 friends,
i have 3 tables namely--- artist, journalist and songs.
i try to update the flags in artist and journalist and try to update few fields from songs by firing foloowing qurries.
...
[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
Anyone know what the select speed difference is between MySQL 4 and 5, if any? I'm not looking for a specific number since of course it will depend on a whole host of factors, but I'm just wonder...
[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 all.
So I'm looking for a way to pull the results from the database showing all the records EXCEPT for the latest one i.e. if there are 30 recordsets I only want to show numbers 1-29.
...
[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 with several tables on a shared server. I have raw data (sql) I want to populate the tables with and am using the command line in telnet. Can someone give me an exam...
[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
Arrrghh,
Just learning from a php/mysql book, really getting through it ( the larry ullman visual quickstart one) and i left it on the train on the way back from london! IM gutted
Could an...
[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 
