choose 1

i have 3 rows called "xyz", i wanna pick one of these rows, how do i do that?

also, when im inserting, hwo would i check if that row already exists?

i ahve 2 tables, one holds names ands ids, the other one holds the id and extra info., so i wanna make sure i dont get dupes in the names.

thanks :)

I do not understand what you are attempting to do. Explain it in more detail, examples would be good.

i have a table, with 3 columns

id | name | counter (Table called hc)

and another table:

hcid | tipname | tip (Table called hctext)

hcid contains the id from the table hc

when a user submits the info, it adds it into hc, then adds the rest of the info with the correct ID into hctext. sometimes the info (such as the name) is the same, so i want to just add the info into hctext with the same id, instead of having 3 or 4 duplicates all pointing to a different id, but are basically the same. i dunno how to describe it better...do you get it now?