fenway

These are server hints.

You can do no such thing... why would you care, anyway? If there's no error, there's no error -- doesn't mean it failed.

You have to make sure the column was defined properly.

Not really... but regardless, you should still limit permissions.

Have you read the sticky yet?

Say what?

According to the HTML spec: And since the default value for a button is nothing, IE is following the spec.

Biological sciences? Which one? I have an MSc in biochemistry...

[ code ] and [ / code ] -- without the spaces Very good -- now, what's the mysql statement? And please don't post the php line... I want to see an SQL statement. WAIT -- you're missing a space after LIKE. BUT STILL -- don't post about mysql errors without posting a mysql statment! This is very clearly stated in the forum guidline.

I don't need to search by anything -- YOU need to post the error. And you can't bold inside a code block (which I changed to make it more readable). Besides, you put mysql functions in bold -- it's because whatever you're doing isn't a valid query.

What error? What query?

The only "easy hack" is to add expressions to your column list to would evaluate to true/false: SELECT *, IF( col1 = 'sometext', 1, 0 ) AS clause1, IF( col2 = 2', 1, 0 ) AS clause2, IF( col3 = 'some' OR col3 = 'number' OR col3 = 'here' ) etc.

I would have preferred if you had continued your original thread so that newcomers won't have to guess where you started....

SQL injection has nothing to do with the type of statment...

Not exactly... you can use INSERT IGNORE.

This is now the THIRD identical topic you've posted -- that's quite enough. Both Barand and I have helped you with this... I suggest you continue the initial thread, mark it "unsolved", and take it from there....

I still have never written a single line of php code.

Easier to push() onto an array and join with AND at the end.

FYI, if you add a LIMIT 0, nothing will happen, but mysql will still parse your statement... an easy way to check for errors.

First, there's a CSV table table! Second, look at the LOAD DATA INFILE syntax -- you can load any delimited file.

That's the best way... you can always "copy" existing habitat relationship records with an insert into.. select where ... and just replace the h_id.

And what's that regex ... and what's the string?

You don't enter that in the species table -- you make a new table that ties species to habitats. Check out the sticky on db normalization.

Concatenating uids like that is HORRIBLE -- don't even think about doing it. You have a few choices: you can use a IN () clause and then make sure that you find both filter ids "after"... or you could self-join again. OR you could use an EXISTS subquery.

I have a hard time believeing that.