Posted by myed 3 years ago In:

php, mysql

myed Asked:

Can WHERE equal anything in a MySQL query?

I'm trying to create one function to do a lot of different sorting. Can I make the default value of a WHERE argument equal to anything? So that the default value for that argument will find everything?

function get_inventory ($order = 'id', $location = 'WA', $recalls = 'anything', $sold = '0') {
$query = "SELECT * FROM v_inventory ";
$query .= "WHERE location = '{$location}' and ";
$query .= "recalls = '{$recalls}' and ";
$query .= "sold = '{$sold}' ";
$query .= "ORDER BY {$order} ASC";
$result = mysql_query($query, $connection);
}

Answer this question

Liked this question? Tell your friends about it

Facebook Windows Live Yahoo Twitter Digg Google del.icio.us Reddit

Link

Embed

Copy and paste the text above to share this Q&A

Answers

Ace Portman Answered:

No, because WHERE arguments gives a specific field to search the record from the table. In front end you can assign a variable for WHERE that you can search in everything record from table.

Posted 2 years ago

TeamCreatives proudly delivers professional and <a href="http://www.teamcreatives.com/" rel="nofollow">affordable web design services</a> and <a href="http://www.teamcreatives.com/services/seo.html" rel="nofollow">search engine optimization services</a> for your website needs.