Jump to content


This topic is now archived and is closed to further replies.


MySQL Statement Explanation

Recommended Posts



Apparently I am not up on my MySQL because I can\'t figure out how this statement works. After a day of tinkering I have a vague idea of what it does, but when I go to modify it I almost always end up getting an SQL error. I was hoping someone could do a line by line explanation of how this sucker is processed.


	$search_query_count = "select count(*) from $sql_tbl[products], $sql_tbl[pricing], $sql_tbl[categories] where $sql_tbl[pricing].productid=$sql_tbl[products].productid and $sql_tbl[pricing].quantity=1 and $sql_tbl[products].categoryid=$sql_tbl[categories].categoryid $membership_condition and ($sql_tbl[pricing].membership=\'". $user_account[\'membership\']."\' or $sql_tbl[pricing].membership=\'\') and ($sql_tbl[products].product like \'%$substring%\' or $sql_tbl[products].descr like \'%$substring%\') and $sql_tbl[categories].category like \'$search_category%\' and $sql_tbl[products].forsale=\'Y\' and $sql_tbl[categories].avail=\'Y\' $price_condition group by $sql_tbl[products].productid";



Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.