Can you elaborate on exactly what information you are trying to retrieve? If you do not include the id in your query, you will get a distinct list of titles. However, you want to know the ID of each distinct title. So, if you add in the ID column in your query, you will get that information.
I am not clear on what you are trying to get in your results.
I'm trying to get the id of the distinct elements. if i say
SELECT id, DISTINCT title FROM songs WHERE lang = 'Telugu'
Its showing all the records from the table. I want only id's of the perticular distinct titles. Please help me
Hi, I am a newbie in developing a website. i have tried to connect using mysqli conncetion
Here is my simple code.
// db.php code
//$con = mysqli_connect("localhost","root","","bakery"); ...
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...