Well I have lets say 2 options in enum, 'apple',bubble', can i do something in the query to tell mysql to insert the first or second one into the field by just saying something like this?


$query = 'INSERT INTO table VALUES (1)' // <- Would "bubble" be in that field?


Thanks =)

Yep.

ENUM elements have integer keys, if you like.

Example


NULL = NULL
'' = 0
'apple' = 1
'bubble' = 2



Hope that helps

Moving to database...

Moving to database...

Sorry, thought it would be under PHP since i was trying to figure out what string in php what do that in the database, thanks for the move though.

Sorry, thought it would be under PHP since i was trying to figure out what string in php what do that in the database, thanks for the move though.
It's no biggie, don't even worry about it. :)