Split value from one field to two using Mysql For Example: #Current table Field is like:: Name ———— abcd efgh ijk lmn opq asd j. …
Read MoreSQL
On delete Cascade in php
## ON Delete Cascade: Cascade will work when you delete something on table Courses. Any record on table BookCourses that has reference to table Courses …
Read MoreOn delete Cascade in php
## On Delete one main table data ,delete related others table data. ALTER TABLE Courses ADD FOREIGN KEY (CatCode) REFERENCES Categories(Code) ON DELETE CASCADE;
Read MoreSql-. On delete Cascade in sql
#ON DELETE CASCADE IN SQL Cascade will work when you delete something on table Courses. Any record on table BookCourses that has reference to table …
Read Morehow to fetch field value from table in php
## How to fetch a field value from database in php $r = mysql_query(“select field_name from table_name”); $value =@mysql_result($r,0,”field_name);
Read MoreJoin table using function
// Join variables are assigned here:: $slct = “mg.*”; $from = $prev.”msg as mg JOIN mber as m ON m.ud = mg.fd”; $cond = “mg.td …
Read More