Foros del Web - Ver Mensaje Individual

JuanCarlos · #1 (**permalink**) 06/08/2008, 06:58

Bueno primero que todo espero que este sea el foro correspondiente para poner esto; mi problema es el siguiente estoy intentando hacer un control de acceso para mi web usando las opciones que me brinda adove dreamwever y cuando quiero probar la pagina el explorador me muestra este error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '±a FROM bienvenida WHERE usuario=NULL AND contraseÃ±a=NULL' at line 1

la pagina y el codigo donde me da el error es la siguiente:

Código:

<?php require_once('../Connections/acceso_control.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
?><?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}

if (isset($_POST['ctext_usuario'])) {
  $loginUsername=$_POST['ctext_usuario'];
  $password=$_POST['ctext_clave'];
  $MM_fldUserAuthorization = "";
  $MM_redirectLoginSuccess = "../bienvenida.php";
  $MM_redirectLoginFailed = "../diseno.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_acceso_control, $acceso_control);
  
  $LoginRS__query=sprintf("SELECT usuario, contraseña FROM bienvenida WHERE usuario=%s AND contraseña=%s",
    GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text")); 
   
  $LoginRS = mysql_query($LoginRS__query, $acceso_control) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
     $loginStrGroup = "";
    
    //declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;	      

    if (isset($_SESSION['PrevUrl']) && false) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Control de Acceso</title>
<style type="text/css">
<!--
body {
	background-color: #E4E8EB;
}
#apDiv1 {
	position:absolute;
	left:300px;
	top:200px;
	width:340px;
	height:12px;
	z-index:1;
}
.Estilo4 {
	font-size: small;
	color: #FFFFFF;
}
.Estilo8 {color: #DA241C; font-size: x-small; }
.Estilo10 {color: #0000FF}
.Estilo12 {
	color: #FFFFFF;
	font-family: Tahoma;
}
-->
</style></head>

<body>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" summary="Tabla de diseño">
  <tr>
    <td rowspan="2">&nbsp;</td>
    <td colspan="4" valign="bottom">&nbsp;</td>
    <td width="30" rowspan="2">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="3" valign="bottom"><img height="9" alt="img_sombra_sup" src="imagenes/marco_01_0000.jpg" width="788" /></td>
    <td valign="bottom">&nbsp;</td>
  </tr>
  <tr>
    <td rowspan="5">&nbsp;</td>
    <td width="32" rowspan="4"><img height="450" alt="img_sombra_der" src="imagenes/marco_02_0000.jpg" width="32" /></td>
    <td height="56" bgcolor="#FFFFFF"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" summary="encabezado">
      <tr>
        <td width="200" bgcolor="#FFFFFF"><img src="../imagenes/barras_banner1.png" alt="img_sup" width="200" height="11" align="top" longdesc="imagen barra superior" /></td>
        <td width="284" rowspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td scope="col"><img src="../imagenes/barras_banner1.png" alt="img_sup" width="300" height="11" align="top" longdesc="imagen barra superior" /></td>
          </tr>
          <tr>
            <td scope="col"><img src="../imagenes/banner_1.png" alt="" width="300" height="56" align="top" /></td>
          </tr>
        </table></td>
        <td width="200"><img src="../imagenes/barras_banner1.png" alt="img_sup" width="221" height="11" align="top" longdesc="imagen barra superior" /></td>
      </tr>
      <tr>
        <td bgcolor="#FFFFFF"><img src="../imagenes/logo_azul_almac_mod1.png" width="200" height="56" /></td>
        <td width="200"><img src="../imagenes/log_der.png" alt="" width="221" height="56" align="top" /></td>
      </tr>
    </table></td>
    <td width="35" height="450" rowspan="4" align="right"><img src="imagenes/marco_04_0000.jpg" alt="img_sombra_izq" width="35" height="450" align="left" /></td>
    <td rowspan="4">&nbsp;</td>
    <td width="30" rowspan="5">&nbsp;</td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF"><img src="../imagenes/barras_banner1.png" alt="" width="721" height="10" /></td>
  </tr>
  <tr>
    <td height="103" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <th bgcolor="#FFFFFF" scope="col">&nbsp;</th>
        <th bgcolor="#FFFFFF" scope="col">&nbsp;</th>
        <td bgcolor="#FFFFFF" scope="col">&nbsp;</td>
      </tr>
      <tr>
        <th bgcolor="#FFFFFF" scope="row">&nbsp;</th>
        <td width="260" bgcolor="#FFFFFF"><table width="100%" border="1" cellpadding="1" cellspacing="1" background="../imagenes/fondo_img.png">
          <tr>
            <th background="../imagenes/fondo_img.png" bgcolor="#FFFFFF" scope="col"><span class="Estilo4">Por favor introduzaca su nombre de usuario y contraseña</span></th>
          </tr>
        </table></td>
        <td bordercolor="#FFFFFF" bgcolor="#FFFFFF">&nbsp;</td>
      </tr>
      <tr>
        <th bgcolor="#FFFFFF" scope="row">&nbsp;</th>
        <td width="260" bgcolor="#FFFFFF"><form id="form_acceso" name="form_acceso" method="POST" action="<?php echo $loginFormAction; ?>">
          <label></label>
          <table width="100%" border="0" cellspacing="1" cellpadding="0">
            <tr>
              <th bordercolor="#FFFFFF" background="../imagenes/fondo_img.png" bgcolor="#DA241C" class="Estilo4" scope="col"><div align="right" class="Estilo12">Usuario:</div></th>
              <th bordercolor="#FFFFFF" scope="col"> <div align="center">
                  <input type="text" name="ctext_usuario" id="ctext_usuario" accesskey="u" tabindex="1" />
              </div></th>
            </tr>
            <tr>
              <th bordercolor="#FFFFFF" background="../imagenes/fondo_img.png" bgcolor="#DA241C" class="Estilo4" scope="row"><div align="right"><span class="Estilo12">Contraseña:</span></div></th>
              <td bordercolor="#FFFFFF"><div align="center">
                  <input type="password" name="ctext_clave" id="ctext_clave" accesskey="c" tabindex="2" />
              </div></td>
            </tr>
            <tr>
              <th colspan="2" scope="row"><input type="submit" name="boton_enviar" id="boton_enviar" value="Enviar" accesskey="b" tabindex="3" /></th>
            </tr>
          </table>
        </form></td>
        <td bgcolor="#FFFFFF">&nbsp;</td>
      </tr>
      <tr>
        <th height="142" bgcolor="#FFFFFF" scope="row">&nbsp;</th>
        <td bgcolor="#FFFFFF">&nbsp;</td>
        <td bgcolor="#FFFFFF">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td width="693" height="16" valign="bottom" bgcolor="#FFFFFF"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
        <tr>
          <th scope="col"><p align="center" class="Estilo8"><strong>*<span class="Estilo10">De</span></strong><br />
                <strong>Ciudad</strong> <strong><span class="Estilo10">Con </span>*Todos</strong> <br />
                <span class="Estilo10"><strong>*Para</strong></span></p></th>
          <th scope="col"><p align="center" class="Estilo8">Terminal  de Pasajeros Puerto Ordaz Sector Alta Vista* <br />
            Estado  Bolívar, Venezuela<br />
          Telf.: 0286-3162717</p></th>
          <th scope="col"><img src="../imagenes/logo_inf.png" width="109" height="59" /></th>
        </tr>
      </table>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <th scope="col"><img src="imagenes/marco_05_0000.jpg" alt="img_sombra_inf" width="721" height="18" align="bottom" /></th>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td colspan="4">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td colspan="4">&nbsp;</td>
    <td width="30">&nbsp;</td>
  </tr>
</table>
</body>
</html>

y la base de datos mysql consta de una tabla llamada bienvenida

con 3 campos
Id ----> int(11)
usuario ----> varchar(40)
contraseña ----> varchar(10)

Dice que tengo un problema en la sintanxis en la primera linea pero no se cual es.

Si alguien me podria ayudar se lo agredeceria mucho...