sorry, M. Sokolewicz, everyone, reposting in english :)
(previous post had some japanese text.)
>Arigato thank you.
It was my pleasure.
This is your problem:
> Bad query: You have an error in your SQL syntax near 'and Tit like and Aut
> like and Auty like ' at line 4
The SQL query you formed may have an invalid syntax. Because of this,
$result does not contain a valid resource. Of course, subsequent
operations using $result will produce errors:
> Warning: mysql_num_rows(): supplied argument is not a valid MySQL result...
> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result....
What you can do is to debug first your SQL statement:
$sql = "select * from gen_table where GO like ". $_GET["go"].
" and ym like ". $_GET["dt"] .
" and Tit like ".$_GET["ti"]." .
" and Aut like ".$_GET["au"].
" and Auty like ".$_GET["ay"];
//print_r() and var_dump() functions are very helpful in debugging in PHP!
print_r($sql); //show the SQL statement, (remove this when everything
is working)
$result = mysql_query($sql);
//add this code to check for $result's validity
if($result) {
// do some error handling here
}
As the manual says, mysql_query returns a false when the statement is
invalid. Take a loot at http://www.php.net/mysql_query ,
http://www.php.net/mysql_error , and http://www.php.net/mysql_errno
for more details on error handling.
---
ramil
http://ramil.sagum.net/blog
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
