I have a great problem: On my Workstation at home, all my SQL-Querry doing right, but when i do it on my web, they dont work ther is a error: 0 is not a MySQL result index in...
here is an example:
$sql="SELECT tblfonds.*, tblfondsperformance.* FROM tblfonds INNER JOIN tblfondsperformance ON tblfonds.WPK=tblfondsperformance.WPK WHERE tblfonds.Art LIKE 'Aktien%' AND (tblfonds.Schwerpunkt Like 'Deutschland%') AND (tblfondsperformance.Kv1JaProz IS NOT NULL) ORDER BY tblfondsperformance.Kv1JaProz DESC LIMIT 0,10";
Why dosent work this querry on my webspace? It works on my workstation at home. My config at home: W2k, Apache 1.3.12, MySQL for Win, PHP3. Webspace: Sun Solaris, Apache 1.3.9 MySQL and PHP3. Pleas help me. Iam sorry for my bad english.
here is an example:
$sql="SELECT tblfonds.*, tblfondsperformance.* FROM tblfonds INNER JOIN tblfondsperformance ON tblfonds.WPK=tblfondsperformance.WPK WHERE tblfonds.Art LIKE 'Aktien%' AND (tblfonds.Schwerpunkt Like 'Deutschland%') AND (tblfondsperformance.Kv1JaProz IS NOT NULL) ORDER BY tblfondsperformance.Kv1JaProz DESC LIMIT 0,10";
Why dosent work this querry on my webspace? It works on my workstation at home. My config at home: W2k, Apache 1.3.12, MySQL for Win, PHP3. Webspace: Sun Solaris, Apache 1.3.9 MySQL and PHP3. Pleas help me. Iam sorry for my bad english.