I am doing a search engine for a library and I would like to offer the users the possibility of choosing a kind of document (video, audio, music sheet...) thanks to a check box . But the problem is that the kind of document in the database MySQL is named by an abbreviation (like "AV" for a a Video), which should not be seen on the result page. I would like that the full name "Video" is seen on the result page instead.
But I canīt find out how I can write that code.
I wrote that but it doesnīt work
Expand|Select|Wrap|Line Numbers
- if($_POST[`docī]=="Video") {$sql="SELECT Tipo_de_documento FROM tablabu LIKE "AV") }
Thanks for your help