I need help with simple php but I'm new in this and I'm not sure how to do it.
So, story goes like this:
I need to make a web application in PHP which will depending on variable in URL, show users from MySQL database with first letter of surname matching letter in variable.
Shows users with first surname letter A (Armstrong, Anderson...).
If variable letter is not defined:
Shows all users from database
Table Users (name, surname, OIB, avatar_id)
Table Avatars (id, url)
Connect with relation users.avatar.id with avatars.id
Thank you and kind regards,