> OK getting somewhere now...I have modified the code to the
> more advanced option that you suggested...I am now getting a
> return when I search by the ID but still not when I search by
> the FName or LName:
>
> Here is the html:
<snip>
> * No, no error reported
>
> * What command do I type to find out the version of PHP and
> MYSQL? I had my network guy install that stuff and he is not
> around anymore :)
>
> * Tried the length thing and each field returns the proper length
>
> * Am looking at the myisamchk and optimize commands now...
>
OK, this is a PHP problem not a MySQL problem
If you type 'smith' in your form and press enter then you'll not get any
results where as if you type 'smith' in your form and ***CLICK*** the Submit
button you'll get the results!
It may be a good idea to turn on all PHP error reporting
error_reporting( E_ALL ) ;
And to check for a value that has been POSTed, do something similar to
if( $_SERVER['REQUEST_METHOD'] == POST AND isset( $POST['searchit'] ) ) }
$HITBUTTON = 'YES' ;
}
There are plenty of tutorials out there for handling forms and the logic
required for form processing in PHP, Google is your friend but you can also
try www.zend.com and www.phpbuilder.com
As a general rule of thumb, if you're not getting the expected results
then...
1. echo out the completed SQL statement and paste it in to the command line
mysql utility (or use MySQLcc http://dev.mysql.com/downloads/mysqlcc.html).
If you get the expected results then the problem is in your script logic.
2. Sprinkle your PHP scripts with DEBUG/echo statements
<?php
define( '_DEBUG_', TRUE ) ;
.
.
.
Code
.
.
if( _DEBUG ) {
echo "Value of the variable MY_SQL_QUERY is ".$MY_SQL_QUERY ;
}
3. Get something like the ZEND Studio IDE so you can watch variable values
and step through a script a line at a time.
Hope this helps
Dean
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
