Hello,
We had a script uploaded to MySQL version 4 and the code was written on MySQL 5. However it's to do with the sub-query being called.
Could someone give any tips on how this query c...
[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 wondering why this won't work
PHP Code:
SELECT userid, username, birthday
FROM user
WHERE SUBSTRING(birthday, 5) >= '11-13' AND SUBSTRING(birthday, 5) < '11-20'
...
[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 have a table with around 3 million entries each a city in the world. Other than countrycode, name etc... I have latitude and longitude for each, with an index on each field. There 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
Hi,
in order to make it possible to do a fulltext search on multiple columns I created a temporary table which holds all the fields I want to search in from different tables. I'm creating a 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
The first one is to get the row numbers for my paging.
The second one is what is ran for the actual paging.
I assume you can't join the two because of the LIMIT and offset values.
Am i right...
[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 just migrated from an iBook to a MacBook Pro. All the apps and settings copied across just fine but, as those who've done this before will know, things like Apache settings, MySQL etc are not co...
[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
One column of my table (that i didn't create) contains comma separated category IDs:
parentlist
-1
1,-1
-1
1,-1
3,1,-1
2,-1
For example, the red row is in catego...
[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 isn't a question of "how do I do this" but more of a "what's the best efficient way of doing this"
the current code is: $result=mysql_query("SELECT votes FROM lis...
[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,
If I have a query like:
Quote:
SELECT ided, merch.mid, mer, cost, ran, name, imgurl, brands FROM merch, products WHERE products.mid=merch.mid AND mcat='$cat' 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
Hi, im recently been suspended daily by my hosts, saying that im causing a high load on my server with around 500,000 requests daily!!!
Now they are saying "usual" reasons for this 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
I have two tables: say Yes and No.
Yes(ID, YesEmail, EmailOwner);
No(ID, NoEmail);
Both YesEmail and NoEmail contain email addresses.
What query can retrieve all the email addresses in Yes table 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
Not sure if this issue would fall under PHP or MySQL. So forgive me if I posted this in the wrong section ....
Basically, here is what I have so far....
PHP Code:
$month...
[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 here,
I have a problem with the use of UNION. If I query my database with the following:
Quote:
SELECT column1 FROM mytable WHERE title = "mytitle" UNIO...
[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 query that works on one page but the same query brings up an error on another page.
This is the page that it doesn't work on.
PHP Code:
<?php
if ($_POST...
[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 just set up a test environment on my local machine.
Windows xp pro sp 2
Apache 2
php 5.2.0
MySql 5.0.27
I can connect from the console and run queries just fine but from a php page I try to ...
[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,
We run a php/mysql University Management System that is facing performance problems.
Currently the active components of the system runs on three servers, two dedicated for the 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,
IM a database virgin and am wanting to get in to server side scripting.
Ive been trying to set up mysql on my machine by following this tut:
http://www.sitepoint.com/article/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
Im trying to pull all records from table a and table b for 14 hrs now. It seems so simple?
both tables are indexed with the fields 'classid' and 'states'
actual results should be 36 records 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
Hello,
I am familiar with the VERY basics of MySQL (in other words, I am not an expert...), and I am currently working to create a simple search engine on our website. Users should be able to sea...
[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 i have a table data_9(domain,title,url,text)
basically i want an sql statement to rank in desc order the group of domains. pretty easy but i also want to rank in desc order the group 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
MySQL V 5.0.18 on SUSE 10.1
I'm not a complete *nix noob, but I sure as hell ain't a *nix or MySQL pro.
This is a new installation. Everything screaming fast. Unless it deals w/authenticat...
[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 looking for some advice on suitable ways to construct a table or tables to handle the following situation.
I have a dynamic and structured content requirement, where the user can define 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
Is there a way to query this table:
Code:
+------+-------+
| id_1 | value |
+------+-------+
| 1 | 5 |
+------+-------+
| 1 | 6 |
+------+-------+
| 1 | 7 |
+--...
[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 multiple fields on my form where a user submits a minimum and maximum value. Such as minimum price and maximum price, so I use a Between in my queries like this.
Code:
SELECT COUN...
[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
$search = "SELECT ct_vehicles.id,".
" ct_vehicles.description,".
" ct_vehicles.price,".
" ct_vehicles.manufact...
[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 
