|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
September 17th, 2003, 06:29 AM
|
|||
|
|||
|
Predefined?
Hi everyone,
I have just got into PHP and MySQL. I have managed to do alot of things but I am stuck. I am using the WHERE command. I have three columns in my table 'name','adress' and 'phone'. Is there a <i>predefined</i> 'column' if you like that I can use to call up an entry. E.G SELECT * FROM $table WHERE <i>rownumber</i>="1" ORDER BY name Where rownumber is I would put the predefined value. Thanks,
|
|
#2
September 17th, 2003, 06:53 AM
|
|||
|
|||
|
RE: Predefined?
Not sure what you are talking about.. can you make the question more clear.
"SELECT * FROM TABLE WHERE id='$myId'"
|
|
#3
September 17th, 2003, 09:50 AM
|
|||
|
|||
|
RE: Predefined?
I think you want an autoincrement field that acts as a unique ID number for each row.
Add the following field to your table: (For MySQL only) Code:
id bigint primary key auto_increment;
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Predefined? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
