querying mssql database
Posted: Wed Jun 21, 2006 4:18 pm
The following piece of code does not work, can someone tell me why? I see an error in the log saying exit bus signal error(10) and in IE I get page cannot be displayed error.
$SQL = "BEGIN SELECT tblfirsttable.varCharData , tblSecondtable.floatData from tblfirsttable, tblSecondtable";
$query_rslt = mssql_query($SQLl);
$numrows = mssql_num_rows($query_rslt);
echo $numrows;
The strangest thing is that when I swap the selec return types(first select tblSecondtable.floatData, tblfirsttable.varCharData) it works fine, as shown below.
$SQL = "BEGIN SELECT tblSecondtable.floatData, tblfirsttable.varCharData from tblfirsttable, tblSecondtable";
$query_rslt = mssql_query($SQLl);
$numrows = mssql_num_rows($query_rslt);
echo $numrows;
Can someone please explain this behavior.
Thanks.
- Meena.
[/b]
$SQL = "BEGIN SELECT tblfirsttable.varCharData , tblSecondtable.floatData from tblfirsttable, tblSecondtable";
$query_rslt = mssql_query($SQLl);
$numrows = mssql_num_rows($query_rslt);
echo $numrows;
The strangest thing is that when I swap the selec return types(first select tblSecondtable.floatData, tblfirsttable.varCharData) it works fine, as shown below.
$SQL = "BEGIN SELECT tblSecondtable.floatData, tblfirsttable.varCharData from tblfirsttable, tblSecondtable";
$query_rslt = mssql_query($SQLl);
$numrows = mssql_num_rows($query_rslt);
echo $numrows;
Can someone please explain this behavior.
Thanks.
- Meena.
[/b]