PHP/SQL Question

Anon

I created an interface with the ability to edit the contents of an sql database. My problem is that if a number is entered in the "equipment #" like 1234....then sql reads is no problem and the interface works the way it is suppose to, but if I use letters and numbers like 'nlt1234' it gives me a "0 is not a MySQL result index"....anyone have any clues?

Anon

the field data type you defined in your db is integer, and you are trying to enter varchar (alphabets) in your form too.

thats why i think its giving you errors.

you can check in PHP, so that it returns error before saving it to db, and user has to re-enter the data.

or else you can define the data type to be varchar in db too, and it will not give you any errors.

Anon

The field data type is set for varchar

Anon

The error message you're getting indicates that your search query is failing to return a result; the user's entered data isn't in the DB, or the SQL is badly formed.

Check what the error is using mysql_error (or whatever's appropriate for your D😎, e.g.

$result = mysql_query($sql, $db) or error_page(mysql_error($db));

HTH,

Anon

Try enclosing it with "xxx2134" before using it.