I need someone to help me fix this sql statement.
$query=mysqli_query($conn,"select * from tbl_songs where song_originalname LIKE '%track%' AND where song_originalname LIKE 'unknow%'");
Hi,
I'm interested to work on your project, I will start project immediately
Please let me know if you require any detailed information.
Waiting for your reply
Thanks
Dev
Hello Sir, we have rich experience in sql query development. I am really interested in your application so i have placed a fair price.
i don't want any upfront payment. 100% once job done.
I am 100% sure i can do this. Also dont worry about time frame i will try to complete within 30 mins max. Please consider my bid .Please let me know what do you think.
Also you can see my profile about my work and communication.
Thank you
Hi
You have a repeated where clause in the SQL, which is the problem.
Please rewrite the SQL as below, and you will be all set.
"select * from tbl_songs where song_originalname LIKE '%track%' AND song_originalname LIKE 'unknow%'"
Please accept the award the project and pay me $10 if this works for you.
Thanks
Roni
Hello,
I don't want make you to pay for that, just delete the second where:
select * from tbl_songs where song_originalname LIKE '%track%' AND song_originalname LIKE 'unknow%'
That's it.
Hi there, My name is Manish. I would like to fix your sql query.
please get in touch to discuss more.
I have good proficiency in sql.
Please go through my profile.
I can help you fix it right away, just let me know what the problem is with it or what it's doing wrong. I'll be available anytime tonight. I'm in the US as well by the way, in Florida
Hi
I will do the changes. I hope you need to if the current displayed query issue.
OR, do you want to change the query.
I will give you the long time best support.
Please check my profile for more details.
Thank you.
I am Krunal, having 12+ years of exp. having completed majority of projects with MS technologies. I have a team of exp. developers expertise in .NET & MS-SQL for developing a web portal / solutions.
We can provide you the Query you are looking for.
We believe in establishing the long-term relationship with our clients, giving them best services at a reasonable rate. Looking forward to an opportunity to discuss this project with you and work on it.
use this
$query=mysqli_query($conn,"select * from tbl_songs where song_originalname LIKE '%track%' AND song_originalname LIKE 'unknow%'");
no need add where 2 times in query
Hello,
I would like to thank you for posting the project. Please find my proposed solution below:
$query=mysqli_query($conn,"select * from tbl_songs where song_originalname LIKE '%track%' AND song_originalname LIKE 'unknow%'");
Thanks.
Simple remove one extra "where"...
$query=mysqli_query($conn,"select * from tbl_songs where song_originalname LIKE '%track%' AND song_originalname LIKE 'unknow%'");
Hello,Hope you doing well.I read your project description,Lets have a technical
discussion,negotiate costing, timeline and then we proceed further.
I Will show my past work also.
Thanks!