MySQL Error

Makochild2

Edit: got the script working

LordShryku

Is $keyword set?
Try echo $query before you perform mysql_query, just to see what the parsed query looks like...

Weedpacket

And you mean to say you only want to find results where the keyword is the same as the name of the column it appears in? Weird.... what if the keyword isn't the name of any column?

Makochild2

Originally posted by LordShryku
Is $keyword set?
Try echo $query before you perform mysql_query, just to see what the parsed query looks like...

this is what shows up

SELECT name, developer, type, cd, serial FROM programs WHERE `` = ''

and weedpacket, i had presented a sql query to a friend and he said it wouldnt work, so he gave me this. i tried my way and it didnt work either. at least this way, the sql query comes from a trusted source and not from me :p

robinjohn

try referring to the global array that stores POST elements
instead of using $keyword, use $_POST['keyword']

or $REQUEST['keyword'] - $REQUEST stores both POST and GET variables(handy sometimes)

don't forget to use the trim() function to remove any whitespace(unless you want that) check the php manual for dealing with form input - using, trim(), strip_tags() etc.

good habits are best learnt when starting off.

Makochild2

with the help of one of my friends on msn, i got the script working.

thanks for the help everyone,

and robin, ill read up on those functions 🙂