Month: November 2020

php – mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource

The Question : 968 people think this question is useful I am trying to select data from a MySQL table, but I get one of the following error messages: mysql_fetch_array() expects parameter 1 to be resource, boolean given This is my code: The Question Comments : you can get more useful eroor msg using:: QUERY

sql – Join vs. sub-query

The Question : 889 people think this question is useful I am an old-school MySQL user and have always preferred JOIN over sub-query. But nowadays everyone uses sub-query, and I hate it; I don’t know why. I lack the theoretical knowledge to judge for myself if there is any difference. Is a sub-query as good

mysql – MyISAM versus InnoDB

The Question : 865 people think this question is useful Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 2 years ago. Improve this question I’m working on a projects which