Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Returnign NULL values from a form based query to a MySQL db
you're a star and a half! Many thanks again. -
Returnign NULL values from a form based query to a MySQL db
but I do have to name each case meaning that if the end user adds a new instrument to the form it will mean altering the PHP script? -
Returnign NULL values from a form based query to a MySQL db
I figured there may be a way of getting the query to recognise that if there were a NULL value or even a value = All then it would treat it the same as SELECT * and ignore the preceding criteria. -
Returnign NULL values from a form based query to a MySQL db
Hi folks, Sorry to be such a pest only days after my last glitch (hard to believe I’ve been writing code for 10 years, must be old age catching up on me at last) was resolved so masterfully on thus forum. I have a simple form that queries a MySQL db… <form name="form1" method="POST"... -
Using form to query MySQL database via PHP is producing errors
Many thanks to everyone on this. I'm finally seeing a result on screen. I really appreciate your help. Take the rest of the day off everyone :-) -
Using form to query MySQL database via PHP is producing errors
Hi Justin, apologies about not using the code tags. I think you've got something with the 2nd option above. I'm no longer getting the error, no results are displaying but I'll look into that before panicking again. Assuming this resolves everything then my thanks to you and Ken and anyone else... -
Using form to query MySQL database via PHP is producing errors
Many thanks Ken for looking at this for me. Alas it does not do the trick. I still receive the 'Couldn't execute query' message. -
Using form to query MySQL database via PHP is producing errors
Hi folks, This is a pathetic one that in all honesty I should be able to figure out (having done so in the past) but my brain is refusing to give up the answers today….. I have a form into which the user can enter the name of a musical instrument and then submit to query a MySQL database...
