Hi Folks Iam new to Database,i want to install mysql.How do get the software?
I want to get into web application development using PHP.
Can any one help me out ?
...
[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
Say you add 3 rows to a table, the auto_increment value will be set to 4 (for the next record)... then you delete record number 3, but auto_increment value is still 4. Is there a function in MySQL...
[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, attached are 2 screenshots of my PHPMyAdmin, what I dont understand is why the phone column is blank when I declared it to have a default of ~hidden~?
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
Hi,
I'm working with a legacy database that stores phone numbers in whatever format the customer entered them in an online form. This might be:
(212) 555-1234
212.555.1234
2125551234
...
[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
worked it out
...
[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 new to the forums having purchased "Build Your Own Database Driven Website Using PHP & MySQL". The book has been great up to now. I have just started chapter 4 and I am u...
[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 trying to find out how can you determine the largest value you can enter into a column of type smallint,mediumint,int, etc using a query. I know what the values are by looking at the do...
[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 setting up a mysql database for motorcycles. I was planning on having a bikes table wich would hold all the information about the motorcycles. My question comes in because I want to add ext...
[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 was wondering if anyone could see the best way to lay this functionality out. I have the following tables and fields (comma seperated part).
Assume the vendors userid = 5. I want to grab a li...
[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 never done this before but I'm tasked out to know how to localize data. What I'm working on is a project that needs to be localized into about 17 different languages and what is holding me ...
[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 want to count users by their status, following is the code which I am using currently, instead of using four queries I want to convert this code in one query.
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 have a table with two fields "startDate" and "endDate".
I want to be able to search a date range against these two fields as another date range. Can I do that? How?
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
I'm working on a booking system that allows users to search for properties that are available on a certain date.
For instance, if the user were to search for properties between 2007-02-15 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 there,
I have a simple table. I'm using phpmyadmin. As you can see my default values for NULL are 0 but for some reason wen a null value is posted to the database it appears as "NULL&q...
[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 been racking my brain on this for a couple of hours now, so i'm hoping that maybe someone can give me a hand.
I want to show results by timestamp and give an individual page per date. Al...
[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,
Here I have two queries that both work fine, but actually I want them combined into one, but I 'don't if this is possible.
Qurey 1:
Code:
SELECT
`klasse`.`Klasse`,
`deelnemer...
[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,
What is the difference between these two types of indexes?
Code:
ALTER TABLE mytable ADD INDEX ( myfield1 )
ALTER TABLE mytable ADD INDEX ( myfield2 )
and
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
Hi,
firstly I am using MySQL 4.0.25.
I have a database storing availability of rooms for an accommodation business.
The following tables are relevant to my question:
room:
- r...
[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 anyway to display dates different in MYSQL. I mean dates are presented as y/m/d in mysql and the year is displayed in all four digits (ie 2006/11/05). Is there any way to display dates in...
[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 you please help me do this quickly.
I have a query:
Quote:
mysql_query("INSERT INTO products (id, title, brand) SELECT id, title, brand FROM prods...
[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 quite simple question which I hope can be answered.
Whenever someone downloads a video from my site, a database entry is made with the time and name of the video. I run a php script 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
Well I'm doing a photo site so it starts on the greatest id for the newer pictures then as you click forward it decreases by 1 so the problem I'm having is if I delete it ends up something like th...
[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'm working with Kevin Yank's book, Build Your Own Database Driven Website..." On p. 20, he discusses how to create PHP compatible passwords. He says to put the file in /usr/local/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
can mysql match all words?
the data i am searching through in my table is like this:
Row1 my text/Other text
Row2 my text
Row3 Other text
When i build the sql query i strip everyth...
[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 a newbie to mysql. I need to write a quey of this sort
Select t1.name,t3.* from t1,t2,t3 where t1.name like 'abc%' and t1.id=t2.id and t2.id = t3.id
where t3 is a tempor...
[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 
