Jennifer: Did you ever get your If else Question answered?
On Mon, 25 Mar 2002, Jennifer Downey wrote:
> Hi all,
>
> I have a table called pets, here is a partial dump:
> At this time this is all I am working with.
>
>
> uid int(10) NOT NULL default '0',
> num_pet tinyint(1) NOT NULL default '1',
>
> There are three steps to adding the pet into the db
>
> Step 1 create the record, this is in create.php. And yes believe it or not
> this does work.
>
> $query_update = "INSERT INTO pets (uid) SELECT uid FROM users WHERE
> uid={$session["uid"]}";
> $result = mysql_query($query_update)
> or die("Unable to insert into the database");
>
> Step 2 Check to see if there is already a pet record this is in process.php.
>
> $query="SELECT num_pet FROM pets WHERE uid={$session["uid"]}";
> $ret = mysql_query($query);
> while(list($num_pet)=
> mysql_fetch_row($ret))
>
> // echo the number in the db, it should = 1 until submit button clicked
> echo $num_pet
>
> $number_pet = $num_pet;
>
> if($number_pet == 0 ) {
> print ("Sorry you can't add another pet");
> }else{ this does all the updating of the record
>
> ?>
> <form action="petdata.php" method="post">
> Click to continue<BR>
> <INPUT TYPE="submit" VALUE="Submit" NAME="submit">
> </form>
> <?
> }
>
> Step three update num_pet after submit is clicked, this is in petdata.php
>
> $db = "update pets set num_pet = 0 where uid={$session["uid"]}";
> $ret = mysql_query($db) or die(db_error());
>
> Now here is my question, If the submit button is clicked and num_pets is
> updated to 0 and you try to add another record shouldn't this print- Sorry
> you can't add another pet?
>
> I am at a loss as to why it will keep adding records. Anyone want to take a
> stab at it?
>
> TIA
> Jen
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
