Posted by Peter van Schie on 01/11/07 10:48

Dave Nash wrote:
> I have a site working locally fine with PHP
>
> Local php version = PHP Version 4.4.3
> Live version = Version 4.3.2
>
>
> Ive then moved the site live to test and I keep getting the following
> error
>
> Couldn't execute query
>
> code is as follows.
>
> $query = "select * from categories where parentid = $catid";
> $result = mysql_query($query) or die ("Couldn't execute query");

Hi Dave,

Try to get some more information about the error by using mysql_error():

$result = mysql_query($query) or die ("Couldn't execute query: " .
mysql_error());

Ruben.

[Back to original message]