Posted by Sean on 10/02/75 11:35

There is something wrong with this query.

$response = mysql_query("SELECT nombre
FROM `acciones`
WHERE oficial_id =$suc and accion=$campania", $dbase);

Change to this:

$response = mysql_query("SELECT nombre
FROM `acciones`
WHERE oficial_id =$suc and accion=$campania", $dbase);
if (!$response ) {
die('Invalid query: ' . mysql_error());
}

So you can see what the error is. If accion is a varchar or some sort
of string you might need to change it to:

$response = mysql_query("SELECT nombre
FROM `acciones`
WHERE oficial_id =$suc and accion='$campania'",
$dbase);

Buts that's a complete guess, I am not sure what is wrong with the
query.

[Back to original message]