mairving — Sun, 11 May 2003 11:27:06 +0000

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.

Mark Hensler — Sun, 11 May 2003 05:52:11 +0000

Eliminate all output prior to the header call.

brady.k — Sat, 10 May 2003 19:02:59 +0000

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?

Mark Hensler — Sat, 10 May 2003 08:34:41 +0000

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

brady.k — Sat, 10 May 2003 01:51:43 +0000

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

Mark Hensler — Fri, 09 May 2003 06:16:44 +0000

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.

brady.k — Fri, 09 May 2003 01:22:54 +0000

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.

Mark Hensler — Thu, 08 May 2003 17:07:34 +0000

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

ROB — Thu, 08 May 2003 08:25:50 +0000

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 ...

Mark Hensler — Thu, 08 May 2003 07:52:23 +0000

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.