Display only the values that are equal to a certain value when pulling MySQL columns.

[DandeNada]

$result = mysql_query("select * from finances "); while($show = mysql_fetch_array($result)){ echo " {$show["id"]} With the above code, I am displaying relevant columns from the database. However, I want to list only those values that are equal to a specific value in that column. How can I do that? Share 06.01.2017 17:17 #2 ntka https://ntka.org User Membership 22.01.2012 Age/Gender 41 / M Profession Agent Location Istanbul Anatolia Name Surname N** T** Messages 2762 Likes 811 / 810 Trade 262, (%100) I think you can achieve this with the like command. Share dijitalsite.com.tr Either buy or sell / get a $20 balance gift for new members 06.01.2017 17:20 #3 KartMarket Membership Suspended Banned User Membership 03.05.2013 Age/Gender 33 / M Profession Prepaid Card Sales Location North Cyprus Name Surname B** U** Messages 1135 Likes 160 / 373 Trade 16, (%100) http://www.***.net/database/1678684-mysql-pulling-columns-equal-to-a-value.html#post1072170598 They answered on ***select * from finances where desired_column="equal to this" or desired_column="can also be equal to this" or desired_column="might be equal to this" Share 06.01.2017 18:14 #4 werfection WM Tool User Membership 01.12.2014 Age/Gender 27 / M Profession Web Master Location Bursa Name Surname A** A** Messages 374 Likes 69 / 83 Trade 18, (%100) Hello, you can impose conditions like this; - Select * from people where age > 18 -- We asked to bring data larger than 18 in the "age" column of the People table. - select * from people where name like '%a%' -- We asked to bring all records in the "name" column of the People table that contain the letter "a". The % sign means any character can come before it. By adding it at the end, we mean it can also come at the end. - select * from people where name="ali" and surname="akkaya" -- We asked to bring the value in the "name" column as "ali" and in the "surname" column as "akkaya" from the People table. We can extend it with more conditions using 'and'. - select * from people where age between 18 and 30 --- We asked to bring all values between "18" and "30" in the "age" column of the People table. If you get stuck somewhere, you can search like this (on Google). "MySQL queries", "MySQL where conditions", "MySQL tutorials" to find the desired results. Share To switch from the free version of Chevereto to the paid one when fetching data from the database, without distinguishing between uppercase and lowercase letters. The topic is being read by a total of 1 person. (0 users and 1 guest) Copyright © 2010 - 2024 WM Tool, a place provider approved by BTK, has no obligation to control or investigate the contents. Please inform us if you believe there is content that you think is illegal. Report Inappropriate Content Tools Whois Query SEO Analysis Site Analysis Rank Tracker Code/Design Tools Site Tools WM Tool Forum Classifieds Threads Advanced Search I Have a Complaint Polls Other Pages About Us Premium Memberships Privacy Policy Distance Sales Agreement Delivery and Returns Policy Notification of Illegal Activities Contact Us WM Tool is housed securely in Cesur.NET Internet Technologies. HOME FORUM LOGIN REGISTER Login Site Settings Ads by Google; The topic is being read by a total of 1 person. (0 users and 1 guest) Whois Query Quickly and easily perform a whois query. IP Class Query Split sites according to ip class a, b, and c. Raffle Tool Raffle tool with advanced features. Forum Career Blog Directory What is it? Site Settings Theme Options Site Sounds Notifications Get Private Messages Sign In Log in with your user information. Your phone number Your password Remember me on my next logins. Log In Forgot My Password! $('input:not(.activate-autocomplete), form:not(.activate-autocomplete)').attr('autocomplete','new-password'); $("#footerMenu button").on("click",function(e){ if($("body").hasClass("openFooterMenu")){ wma.setCookie('mobileFoterMenu', 'off'); }else{ wma.setCookie('mobileFoterMenu', 'on'); } }); $("#switchThema").on("change",function(){ var darkMode; if($("#switchThema").prop("checked")){ $("body").addClass("dark"); wma.setCookie('darkMode