PHP MySQL server-side processing need help.

Jerrys

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.

allan

Sounds like an SQL issue. I'd suggest printing out the built SQL statement and debugging that.

Allan

david63

have you looked in Firebug as it sometimes gives the php/sql error message?