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
The topic title is probably pretty confusing... im still confused writing it. It kind of hard to explain what i need to do, and i'm having an ever harder time figuring out a way to do it.
I 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
Sorry for the long post here. I'm trying to give enough info. to explain my situation, and am novice enough to not know how much someone might need to know to help.
I'm very new to SQL, I've...
[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 searched for hours and I thought that REPLACE() might be the solution, but it doesn't seem to work the way I thought it might. In any case, if anyone could tell me if this is possible, and 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
Hi all,
For one of my client,the data from a table is missing time and again. It is reported that client didn't changed anything but despite filling up data,we seeing this situation occuring....
[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
if so, how do I connect to the mysql database with VB?
if not, what SQL databases are?
...
[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
FYI, I'm using INNODB.
Let's say I have a table with a city column containing 30,000 records, and I want to provide a search form 'starts with' and 'ends with fields.
So a user would suppl...
[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 I run a query with limit 3 but a minimum of 1? For instance, I'd like to grab news items from the last 3 days. If, however, there are no items from the last 3 days, it grabs the single newe...
[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 having problems inserting binary data into MySQL using C. Here's a simple example to illustrate what I'm trying to do:
int intArray[4];
intArray[0] = 0;
intArray[1] = 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
This is a fairly common task, but for some reason I'm blanking and haven't had any luck with the manual.
What I want is a query that tries to update a record on a table, or if the record doesn't 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
Hi all,
I am trying to get phpmyadmin working with mysql but I get the below errors...
Why is this??
"phpMyAdmin tried to connect to the MySQL server, and the server rejected the conne...
[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 mysql databae that gets pounded with INSERTs to basically an address book.
Two questions...
1) Is this high:
Server traffic: These tables show the network traffic statistics 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,
Let me apologize for not knowing what to call this, but I am sure it must have come up in the forums before...
I need to build an inventory system with nested levels of categories:
...
[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 have a table called test and it looks like
+---------+---------------------+
| date_id | date |
+---------+---------------------+
| 1 | 2006-...
[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 to all,
I have a simple question/szenario.
Here are my tables:
1. image (id, name)
2. tag (id, name)
3. images_tags (image_id, tag_id)
At the moment I have the following...
[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...
I have this stored procedure
Code:
CREATE PROCEDURE `documents`.`insert_documents_by_id`(in_DocumentId integer, in_DocumentLanguage varchar(255))
BEGIN
IF in_DocumentId= -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
I have a website on a dedicated server that was running really slow, so I got another, much faster server and transferred the MySQL database to this server. However, now when I connect to the fas...
[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 building a db and I want to avoid a mistake that I repeated many times in the past, so this time I am actually planning and will appreciate any advice. Consider this:
3 tablescust...
[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 planning on upgrading to PHP 5.x from 4.x but it says it requires me to also upgrade from MYSQL 4.0 to 4.1.
I thought there was a sticky on this, so point it out if there is:
I rememb...
[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,
my tables structure for this project includes a ForumsMain table, a Forums table storing sub categories forums,a Threads table, and a Posts table. I would like to:
1) get alla 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
First these are the tables I am working on:
Code:
CREATE TABLE testusers (
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
username VARCHAR(30) UNIQUE NOT NULL,
password TINYTEXT,
PRI...
[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 a table called Offer, where the primary key is ID number and there are two foreign keys - Item ID and Member ID (these are the primary keys from the Item table and Member ID).
When ...
[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 
