Supplied argument is not a valid MySQL...

murosoft

hi, i have this code, i'm trying to display some information of some articles.

first of all, i have no information on the database yet, just the database.

here's the code. the error appears here in line 35, in the where statement.
<?
$mysql_server_address = "cygnus.zac.unac.mx";
$user = DBA;
$pass = SQL;
$db = ("canon");
$link = mysql_connect($mysql_server_address, $user, $pass)//, $mysql_user, $mysql_password)
or die("No se pudo conectar a la base de datos");
mysql_select_db($db,$link)
or die("No existe la base de datos");
$val = $_GET['id'];
$query = mysql_query("SELECT canon.can_idcanon, salon.sal_numero, salon.sal_edificio, canon.can_marca,
canon.can_modelo, canon.can_lumin, canon.can_status
FROM canon, salon
where canon.sal_numero = salon.sal_numero AND id=$val", $link);

echo "<table width=100% border=1>";

echo "<tr>
<td>CAÑON</td>
<td>SALON</td>
<td>EDIFICIO</td>
<td>MARCA</td>
<td>MODELO</td>
<td>HORAS LAMPARA</td>
<td>STATUS</td>
</tr>";
while ($a_row = mysql_fetch_array($query)) {
print $a_row["can_marca"];
}

hand

Add an OR statement to get better informations

<? 
$mysql_server_address = "cygnus.zac.unac.mx"; 
$user = DBA; 
$pass = SQL; 
$db = ("canon"); 

$link = mysql_connect($mysql_server_address, $user, $pass) 
   or die("No se pudo conectar a la base de datos"); 
mysql_select_db($db,$link) 
   or die("No existe la base de datos"); 

$val = $_GET['id']; 

$query = mysql_query("SELECT canon.can_idcanon, salon.sal_numero, salon.sal_edificio, canon.can_marca, 
  canon.can_modelo, canon.can_lumin, canon.can_status 
  FROM canon, salon 
  where canon.sal_numero = salon.sal_numero AND id=$val", $link)
   or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n"; 

echo "<table width=100% border=1>"; 
echo "<tr> 
<td>CAÑON</td> 
<td>SALON</td> 
<td>EDIFICIO</td> 
<td>MARCA</td> 
<td>MODELO</td> 
<td>HORAS LAMPARA</td> 
<td>STATUS</td> 
</tr>"; 

while ($a_row = mysql_fetch_array($query)) { 
   print $a_row["can_marca"]; 
} 
?>

murosoft

now appears this,

MySQL-Error: 1064 -> You have an error in your SQL syntax near '' at line 4

and still appearing the error in line 36, that is the one that has the:
while ($a_row = mysql_fetch_array($query)) {

statement.

<?
/////////////////////////////////////////////////////////////////////////////////////////////////
$mysql_server_address = "cygnus.lag.itesm.mx";
$user = DBA;
$pass = SQL;
$db = ("canon");
$link = mysql_connect($mysql_server_address, $user, $pass)//, $mysql_user, $mysql_password)
or die("No se pudo conectar a la base de datos");
mysql_select_db($db,$link)
or die("No existe la base de datos");
$val = $_GET['id'];
$query = mysql_query("SELECT canon.can_idcanon, salon.sal_numero, salon.sal_edificio, canon.can_marca,
canon.can_modelo, canon.can_lumin, canon.can_status
FROM canon, salon
where canon.sal_numero = salon.sal_numero AND id=$val", $link)
or print ">>> MySQL-Error: ".mysql_errno()." -> ".mysql_error()."<br>\n";

echo "<table width=100% border=1>";

statrat

what table is "id" (in id=$val portion) coming from? you may need to specify a table.

also echo your Select query to see what you've got.

make sure $_GET['id'] is returning a value.

hand

<? 
$mysql_server_address = "cygnus.zac.unac.mx"; 
$user = DBA; 
$pass = SQL; 
$db = ("canon"); 

$link = mysql_connect($mysql_server_address, $user, $pass) 
   or die("No se pudo conectar a la base de datos"); 
mysql_select_db($db,$link) 
   or die("No existe la base de datos"); 

$val = $_GET['id'];

$selectStmt = "SELECT canon.`can_idcanon`, salon.`sal_numero`, salon.`sal_edificio`, canon.`can_marca`, 
  canon.`can_modelo`, canon.`can_lumin`, canon.`can_status` 
  FROM canon, salon 
  where canon.`sal_numero` = salon.`sal_numero` AND id=$val";

print "selectStmt:$selectStmt<br>\n";  // Please post the result of this print

$query = mysql_query($selectStmt, $link)
   or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n"; 

echo "<table width=100% border=1>"; 
echo "<tr> 
<td>CAÑON</td> 
<td>SALON</td> 
<td>EDIFICIO</td> 
<td>MARCA</td> 
<td>MODELO</td> 
<td>HORAS LAMPARA</td> 
<td>STATUS</td> 
</tr>"; 

while ($a_row = mysql_fetch_array($query)) { 
   print $a_row["can_marca"]; 
} 
?>