$strSQL = "SELECT TRANSCRIPTS.*,SUBJECTS.* FROM TRANSCRIPTS,SUBJECTS WHERE TRANSCRIPTS.ID = '$tempid' AND TRANSCRIPTS.xYearth='1' AND TRANSCRIPTS.xTerm ='1' AND TRANSCRIPTS.Code = SUBJECTS.Code ";
$objExec1 = odbc_exec($objConnect, $strSQL) or die ("Error Execute [".$strSQL."]");
while($objResult1 = odbc_fetch_array($objExec1)){........
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too many fields defined., SQL state S1001 in SQLExecDirect in C:\AppServ\www\srv\student.php on line 123
Error Execute [SELECT TRANSCRIPTS.*,SUBJECTS.* FROM TRANSCRIPTS,SUBJECTS WHERE TRANSCRIPTS.ID = '26465' AND TRANSCRIPTS.xYearth='1' AND TRANSCRIPTS.xTerm ='1' AND TRANSCRIPTS.Code = SUBJECTS.Code ]
SELECT
TRANSCRIPTS.*,SUBJECTS.*
FROM
TRANSCRIPTS,SUBJECTS
WHERE
TRANSCRIPTS.Sj_id=SUBJECTS.Sj_id
AND TRANSCRIPTS.ID = '$tempid'
AND TRANSCRIPTS.xYearth='1'
AND TRANSCRIPTS.xTerm ='1'
AND TRANSCRIPTS.Code = SUBJECTS.Code "
Load balance : Server 00
