please give me a query for already existing name in the data base

[sudheerk]

please give me a query for already existing name in the data base using mysql

[pbmods]

Heya, sudheerk.

[code=mysql]
SELECT
*
FROM
`Table`
WHERE
`Name` = 'someName'
LIMIT 1;
[/code]

[sudheerk]

hi thank u,

but table name means

Is it existing table name ?

Heya, sudheerk.

[code=mysql]
SELECT
*
FROM
`Table`
WHERE
`Name` = 'someName'
LIMIT 1;
[/code]

[mwasif]

Replace Table with your database table name in question and Name with database table column.

[sudheerk]

the same thing i was done its not working

plz plz give me a example progrm

Replace Table with your database table name in question and Name with database table column.

[mwasif]

Please tell us your table structure (table name and the columns you have in the table).

[sudheerk]

i have 4 fields like below

id name email phone

submit(button)

now i want already exist name should not store in the data base once again.

my table name is sudha

my data base name is sudheer


thank u for u r response
sudheer

Please tell us your table structure (table name and the columns you have in the table).

[r035198x]

i have 4 fields like below

id name email phone

submit(button)

now i want already exist name should not store in the data base once again.

my table name is sudha

my data base name is sudheer


thank u for u r response
sudheer

Sounds like a good candidate for a trigger. Are you using MySQL 5.0 or higher?

[sudheerk]

exactly iam not getting u r point.

but my sql version is 2.6.1

Sounds like a good candidate for a trigger. Are you using MySQL 5.0 or higher?

[r035198x]

exactly iam not getting u r point.

but my sql version is 2.6.1

That's old. Are you sure it's 2.6.1?
Anyway if you don't have trigger support for your MySQL version then you may have to do a select from the table where name = newName. If it returns any data then don't add the new name (It's already there).

[mwasif]

Do you know how to save data in database using PHP?

[sudheerk]

no sir,

and also trigger concept

so plz give me exact query to do that thing ie already existing name in the data base

Do you know how to save data in database using PHP?

[sudheerk]

MYSQL 4.1.10a LICENSE

now i got my musql vrsion sir ie 4.1.10

now tell me sir

give me a small example program

no sir,

and also trigger concept

so plz give me exact query to do that thing ie already existing name in the data base

[kovik]

Stop being such a beggar and try. There's a million resources in Google about basic MySQL queries, and theres an entire manual at http://dev.mysql.com/doc and most installations of MySQL come with the manual. You've already been given the syntax, now get to work.

[mwasif]

no sir,

and also trigger concept

so plz give me exact query to do that thing ie already existing name in the data base

This is the query
[CODE=mysql]SELECT * FROM sudha WHERE name = 'username';[/CODE]
Replace username with the user name you want to know about.
To accomplish your task you need the following

1. Post data using HTML form
2. Connect to database using PHP
3. Retrieve data from database using PHP