ElMaitron
02-01-2009, 04:17 PM
I have a website www.micomunidad.com but when someone registers and chooses 'MARCH' as their month of birth, it appears "APRIL" in their profile! The table is 'birth_month'
I went to MySQLAdmin and I see this:
Rows birth_month
226 NULL
142 0
93 1
110 10
125 11
1 12
82 2
81 3
73 4
92 5
91 6
94 7
85 8
109 9
I see that row 142 is 0 - I supposed that's the month of JANUARY
Now this is the code in my php file
<select name="month">
<?php
$sr_no=1;
while($sr_no!=13)
{
if($now_month==$sr_no)
{
?>
<option value="<?=$sr_no?>" selected><?=$month[$sr_no]?></option>
<?php
}
else
{
?>
<option value="<?=$sr_no?>"><?=$month[$sr_no]?></option>
<?php
}
$sr_no=$sr_no+1;
}
?>
</select>
I don't know what to do if to change the Db and replace the row 142 to 1, 93 to 1, and so on...
If I need to do this what is the command to change this in MYSQLAdmin? and or edit the code in my php code?
Thank you in advance!
:)
I went to MySQLAdmin and I see this:
Rows birth_month
226 NULL
142 0
93 1
110 10
125 11
1 12
82 2
81 3
73 4
92 5
91 6
94 7
85 8
109 9
I see that row 142 is 0 - I supposed that's the month of JANUARY
Now this is the code in my php file
<select name="month">
<?php
$sr_no=1;
while($sr_no!=13)
{
if($now_month==$sr_no)
{
?>
<option value="<?=$sr_no?>" selected><?=$month[$sr_no]?></option>
<?php
}
else
{
?>
<option value="<?=$sr_no?>"><?=$month[$sr_no]?></option>
<?php
}
$sr_no=$sr_no+1;
}
?>
</select>
I don't know what to do if to change the Db and replace the row 142 to 1, 93 to 1, and so on...
If I need to do this what is the command to change this in MYSQLAdmin? and or edit the code in my php code?
Thank you in advance!
:)