Couldn't execute query

Photon

Posted on 11 Dec 2006, 11:28:55

Access: Member
Total Posts: 4
Joined: 2006-12-11

It says on my index.php after I installed this script. The admin panel works perfectly. Do you have any idea how I can fix this problem?

Code:


<?php 
if($_GET['cat'] == "all"){
$sql =  "SELECT * FROM $newstable ORDER BY timestamp $newsorder LIMIT $from ,$nppage";
}else{
$sql =  "SELECT * FROM $newstable WHERE catid = '$catid' ORDER BY timestamp $newsorder LIMIT $from ,$nppage";
}
$result = mysql_query($sql)
        or die ("Couldn't execute query.");
?>

#65

Last edited by Photon at 2006-12-11 11:54:31 Reason:

Photon

Posted on 11 Dec 2006, 17:31:23

Access: Member
Total Posts: 4
Joined: 2006-12-11

I have check the sql and I think that there's an error in the installation file...

#67

Photon

Posted on 11 Dec 2006, 17:34:36

Access: Member
Total Posts: 4
Joined: 2006-12-11

Quote:

I have check the sql and I think that there's an error in the installation file...

here ya go.. the installation file doesn't call all the sql code..

#68