Thanks for all the help. I finally got it to work. I ended up using a bunch
of if ($lname=="") { statements instead of if (($lname=="") ||
($fname=="")) { and that seems to be working. I still can't get the
header() statement to work. So I just cheated and put in some text telling
the user to hit the back button and fill out the rest of the information on
the form.
Louis
At 02:29 PM 3/27/01 -0500, you wrote:
>H-
>
>Another solution might be to use javascript to check the fields before
>the page is even submitted to make sure they put "something" in the
>first and last name fields.
>
>Unfortunately I'm not a javascript person but I've seen it done so much
>I'm sure you could find examples on the web or via a web search engine.
>
>As far as your code; I concure with the other posters replies: "" is
>empty, " " is a space. I've made the same mistake. Also did the if
>($name = "") { } Screwed me up for a bit until I remembered == is
>comparison. 8^) Oh well if you don't use it you lose it.
>
>Take it easy.
>-Sterling
>
>
>Louis Brooks wrote:
> >
> > Hi:
> >
> > I am trying to set up a simple script that will verify that all the blanks
> > in a form have been filled out and then submit that to mySQL. If the form
> > has not been completely filled out I want it to redirect them back to the
> > original form. I know that the mySQL part of the script works, but I am
> > unable to get the part of the script that checks the form input to see if
> > everything was filled out to work. It seems to bypass this part of the
> > script and enter the info into mySQL . Here is what I have so far:
> >
> > If (($fname == " ") || ($lname == " "))
> > {
> > header("Location:
> http://callook.org/member_joinform.html");
> > }else{
> > $db = mysql_connect("localhost", "name", "password");
> > mysql_select_db("dBase",$db);
> > $sql = "INSERT INTO
> > members
> > (fname,lname,address,city,state,zip,country,email,username,password)
> > VALUES
> >
> ('$fname','$lname','$address','$city','$state','$zip','$country','$email','$user
> > name','$password')";
> > $result = mysql_query($sql);
> > }
> >
> > I hope the formatting comes out right. I am sure it is something simple I
> > have missed but I have tried the script several different ways and nothing
> > seems to work. Thank you for any help.
> >
> > Sincerely,
> >
> > Louis Brooks
> >
> > BTW: Is there a faq for this list before I go asking anymore questions?
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
