Re: Ayudaaaa!!!
| From: | Diana Montes | Date: | Mon, 10 May 2004 01:33:53 +0000 |
| Subject: | Re: Ayudaaaa!!! | ||
| References: | 1 | Groups: | php.general.es |
| Request: | Send a blank email to general-es+get-48386@lists.php.net to get a copy of this message | ||
lo que pasa es que le pasa el sql mas no la conexion, intenta algo asi,
espero te sirva
mira:
function getDatabaseConnection() {
$config['dbConn'] =
mysql_pconnect($config['database']['host'],
$config['database']['user'],
$config['database']['password']);
if (!$config['dbConn']) {
return PEAR::raiseError('error connecting to the
database');
}
// select database name
if(!mysql_select_db($config['database']['name'],
$config['dbConn'])){
return PEAR::raiseError('database name not
found');
}
return $config['dbConn'];
}
//
function existConvenio($codFacultad,$codInstitucion)
{
$this->connection = Application::getDatabaseConnection();
$sql = "SELECT * FROM convenio WHERE codFacultad='$codFacultad' AND
codInstitucion='$codInstitucion'";
$this->consult = mysql_query($sql, $this->connection); <-- debes pasarle
la conexion
$numrows=mysql_num_rows($this->consult);
return $numrows;
}