I'm trying to convert an old db scripted by someone else to my new code
In my new database, I store dates using a datetime field, while the old script used a number like this "1128615400&qu...
[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 have an artist table which has artistid has primary key.
i need those artist whose statusverify is 'pending' and those artist whose statusverify is 'notpending'.The field statusv...
[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 have altered my tables to include foreign keys, but I would like to know if they should appear in those tables?
When I altered the tables to have these foreign keys, I also inserted 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 all,
I had to move from my hosting and I needed to export my MySQL databases.
I did it via the phpmyadmin panel, imported via shell to the new host and everything ran smooth.
However,...
[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 select rows from one table that don't exist in another table.
For example, I have 2 tables. Each table refers to a file's id. If a file is downloaded, a row is added to the ...
[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.
So, on this site I am building, there is a section with band 'profiles'. I have 3 tables (releases, bands and shows) in my db from which I get the data to insert into the page. I've got e...
[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 big table (15 million records). Each row has a parsed address (number, prefix, street, type, suffix) and I need to take these separate pieces and concatenate them. However, often times ...
[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
So I'm working on a new table for a game database which keeps track of the player's inventory. As you can imagine there are a lot of items in the game, and thus a lot of primary keys are needed. 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
I have a table of job postings and they can have up to three certifications associated with them. In the job table they are stored as certification_1, certification_2, certification_3 and feed off...
[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,
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
Browse sub-categories 
