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=”
