PHP select

thanks!

now i'm getting some errors:

'
and i pasted it just like you had it, '

I dont see anything wrong with the code above. Try putting this above the IF statement...

the response:
Error (1064): You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' Address='12 Main Street, City='Anywhere', StateProv='VA

Check to make sure you dont have any missing quotes.

If not, then replace the first "$result = mysql_query" with "die". That will print out the query that would have run. And maybe we'll see what's causing the syntax error.

'

same as before...i'll pm you

If you're getting that message than you didn't place die() in the right place...

Do you really have to check each field?
Couldn't you also create the MySQL fields as UNIQUE?

That will return "Not inserted:" then say that it is a unique field if it is filled, right?
Otherwise, Kyle, you are missing a quote or something.
I know it's probably wrong or bad style, but try it like this:

Of course, if this is being form submitted, you need to make all the select varialbes $_POST[] or $_GET[] (Depending on your form METHOD)

You could make each field a UNIQUE key, but you'll loose performance.
I don't remember what exactly was said, but somewhere in the MySQL
docs it said that making every field a key can reduce table performace
to the point where it would run faster with no keys.

Ideally, you would make a combination of few fields a single UNIQUE key.

At this point, I just want to see the exact query which is being run.
This can allow us to see what is causing the syntax error. If we can't
spot an error, we can copy & paste the query into phpMyAdmin or a
terminal and run it manually. If running the same query manually
doesn't result in an error, then the mistake is somewhere else in the
PHP code.

ideally you create a primary key. select where primarykey=1 is infinitely faster than select where this=that and that=lat and lat=pat and pat=matt and ...

Kyle's trying to prevent duplicate records. Primary keys won't prevent that.

the info was getting posted, but it would appear to have errors when submitted, and did not redirect to a new page like it should

i replaced the $result=mysql_query with "die", and heres what it gave:SELECT * FROM creationcon WHERE Name='test', Address='test', City='test', StateProv='test', Country='USA', Zip='21431', Email='tetst', Phone='3141241'' what does that do for me/us? all it did was show the inputs i ...inputted.

What that did is show me that you do have all of your quotes, and that the entire query appears to be correct in syntax.

In the php above (your post on May 5), there doesn't appear to be a typo between the mysql_query and the mysql_num_rows. (I'll sometimes mispell $result)

At this point, I'm at a loss. I don't know what's causing the error.

when it says "headers already sent", is that referring to my redirection? if so, how can i redirect without using a header

Header() cannot be called after the script has printed (echoed) anything. This includes white space.

well, i did a search on php.net for url redirection, and all i could come up with was the header() to automatically redirect...is there some way i can get around this?

Eliminate all output prior to the header call.

The header can be a difficult one to work with. Like Mark said, get rid of any output prior to calling it. In a script, I had this meant moving an include file to be included after I called the header.