Giving pets a Gender

[SieghartZeke]

i run this in the sql,but dont work!
what i need to do?
change the code?
INSERT INTO adopts_owned_adoptables
VALUES gender
and sorry when you dont understand what im saying,but im italian and for me is so hard make english word......

[Arianna]

Don't worry - is there any way that you can manually insert it, via phpmyadmin or the like? 'Cause if you just insert "gender" there's no way of having an int variable and stuff like that.

[SieghartZeke]

Uhm...i try......

[torakitty]

SieghartZeke, I don't know if your problem has been solved yet or not, but if not you can try running the following code in sql:

ALTER TABLE `adopts_owned_adoptables` ADD `gender` varchar(40) NULL;

That should add the gender field to the owned adoptables table.

I also had a question about the gender script. I'm using it on my test site and it works great. I have it so it randomly generates a pet's gender, but I'm wondering if there is a way to have some pets only be one gender, such as female, and not be male at all while still having other adoptables get random genders?

[Arianna]

It's nice that you asked. I was having a problem, as some pets had 'gender' alts. Basically, it meant that it was the alt image, it was female, if not, it was male. Just add a field called 'malefemale', and then it checks. If it's value is 'onlyfemale', automatically set 'gender' to 'Female'. If it is 'onlymale', set 'gender' to 'Male'. If it is blank, set 'gender' using the random code. Do you get it?

[torakitty]

I got it. Thanks for the help, Arianna. :D

[Arianna]

Yay! ;)

[SieghartZeke]

No...i have added in the table,but i don't show the pet when i go to adop(after i give a name) And i dont view his Id!

[Arianna]

I... really don't get what you're saying. :( Could you give me a screenshot of the database in phpmyadmin and a screenshot of adopting, please?

[SieghartZeke]

Originally Posted by tommyk1210

instead of your random number to select gender code, try this:

PHP Code:

<form id="form1" name="form1" method="post" action="">
  <p>
    <label>
    Male:</label>
    <label>
      <input type="radio" name="Genderselect" value="male" id="Genderselect_0" />
    </label>
    <br />
    <label>
    Female:</label>
    <label>
      <input type="radio" name="Genderselect" value="female" id="Genderselect_1" />
    </label>
    <br />
  </p>
</form>

$gender = $_GET[genderselect]; 


When i have puted this code in my page,i have get a error!
Why?