Often we want to search, find or remove duplicate and similar content from our data base containing articles, text, messages etc. It is easy to do so manually if you have only 100 or so records in your database. But to handle large number of records it is bit time consuming and for even more … Read more
After a lot of searching on web (spending many hours) on many sites and then trying again and again, I am now able to do automatic posting on Facebook Pages (I am admin of) in offline mode. I would like to share the steps which I followed, please go through following: Step 1: Create a … Read more
How to get a value from a table using functions and return count: Write a simple query and pass the parameters: function somename($tablename, $colnam, $colvalue, $mode, $returncolnam) { Select $returncolnam from $tablenam where $colnam=$colval } Note: For $returncolnam you can also use array number starting from 0.
When we search a column in MySQL we use where condition. When we have many records separated by a ‘,’ in a column then searching it becomes bit complex. We can search using like function. It will be clear by taking an example: Let say we have a record with value – 1,2,3,4,5,6,7,8,9,10,11,12 We want … Read more
A tree structure means nodes within nodes. By using MySQL and PHP you can read a database then fetch records recursively. By taking an example we can understand it better. There is a table Category with records for categories and sub-categories. There are 3 columns: Id, Name, Parent Id and records are: [php] 1, A, … Read more
mysql_insert_id — Get the ID generated in the last query Use mysql_insert_id(); More information can be found at: http://php.net/mysql_insert_id Get the ID generated in the last query
Basically FOUR SQL commands used very often. These four commands are SELECT, INSERT, UPDATE, DELETE By using these four basic commands you can do a lot of queries. SELECT select * from tablename INSERT insert into tablename SET col1=”, col2=” UPDATE update tablename SET col1=”, col2=” WHERE col3=” DELETE delete from tablename WHERE col1=”
