PHP MySQL server-side processing need help.
PHP MySQL server-side processing need help.
Jerrys
Posts: 13Questions: 2Answers: 0
Hello,
i'll trying to run server-side script on PHP with MySQL data base.
And when I try to make a INNER JOIN in server side script, the search option stoped worked, only showing message "Processing... " and don't get any answers.
My code is:
[code]
$aColumns = array(
'id',
'inventorinis',
'atsakingas',
'dislokacija'
);
/* Indexed column (used for fast and accurate table cardinality) */
$sIndexColumn = "id";
/* DB table to use */
$sTable = "iranga";
/* Join condition */
$sJoin = "INNER JOIN auditas ON iranga.inventorinis = auditas.inventorinis";
/* Select condition */
$sSelect = "auditas.id AS id, auditas.inventorinis AS inventorinis, iranga.atsakingas AS atsakingas, iranga.dislokacija AS dislokacija";
[/code]
[code]
/*
* SQL queries
* Get data to display
*/
$sQuery = "
SELECT SQL_CALC_FOUND_ROWS $sSelect
FROM $sTable
$sJoin
$sWhere
$sOrder
$sLimit
";
[/code]
Please help me found error, why stoped working a search option in datatables, when I try use releationships between two data base tables.
i'll trying to run server-side script on PHP with MySQL data base.
And when I try to make a INNER JOIN in server side script, the search option stoped worked, only showing message "Processing... " and don't get any answers.
My code is:
[code]
$aColumns = array(
'id',
'inventorinis',
'atsakingas',
'dislokacija'
);
/* Indexed column (used for fast and accurate table cardinality) */
$sIndexColumn = "id";
/* DB table to use */
$sTable = "iranga";
/* Join condition */
$sJoin = "INNER JOIN auditas ON iranga.inventorinis = auditas.inventorinis";
/* Select condition */
$sSelect = "auditas.id AS id, auditas.inventorinis AS inventorinis, iranga.atsakingas AS atsakingas, iranga.dislokacija AS dislokacija";
[/code]
[code]
/*
* SQL queries
* Get data to display
*/
$sQuery = "
SELECT SQL_CALC_FOUND_ROWS $sSelect
FROM $sTable
$sJoin
$sWhere
$sOrder
$sLimit
";
[/code]
Please help me found error, why stoped working a search option in datatables, when I try use releationships between two data base tables.
This discussion has been closed.
Replies
Allan