Why don't you let them enter it however they want in the form
mm-dd-yyyy
mm/dd/yy
then in the php script that processes it, convert it with regulat expressions
to a timstamp and enter it in your database as an int. That's how I do it.
I don't understand the point in using the mysql timedate field format.
Then on retrieval form the db, php can easily convert it to a nice format
with the date() function.
> On Tue, 23 Oct 2001 10:52:41 -0600 Jason <[EMAIL PROTECTED]> wrote:
> > I am having a hard time setting up a form for users to enter a date in
> > the format of 00/00/0000 (of course they would use an actual date). My
> > form is as follows...
> > <form name="auth" method="post" action="search.php">
> > <p>*I.E. - Format is 04/01/2001*</p>
> > <p>Search for Ads by date:
> > <input type="text" name="date">
> > </p>
> > <p>
> > <input type="submit" name="login"
> > value="Submit">
> > <input type="reset" name="reset"
> > value="Reset"> </p>
> > </form>
> > ================================================
> > On my search.php page I have the following MySQL connection and search
> > parameters...
> > <?php
> >
> > mysql_connect ("db_hostname", "db_username", "db_password");
> >
> > mysql_select_db ("db_name");
> >
> > if ($date == "")
> > {$date = '%';}
> >
> > $result = mysql_query ("SELECT
> > fname,lname,address,city,state,zip,phonea,phone,email,crty,crnum,crmo,cry
> >r,w eeks,ogden,rock,logan,ipaddress,ad,total,num,date,time
> > FROM ads WHERE date LIKE '%$date%' LIMIT 0, 30 ");
> > $count = -1;
> > if ($row = mysql_fetch_array($result)) {
> > $count ++;
> > do {
> > echo "<B>Name: </B>";
> > printf(mysql_result($result,$count,"fname"));
> > echo " ";
> > printf(mysql_result($result,$count,"lname"));
> > echo "<BR>\n";
> >
> > echo "<B>Address: </B>";
> > printf(mysql_result($result,$count,"address"));
> > echo "<BR>\n";
> >
> > echo "<B>City: </B>";
> > printf(mysql_result($result,$count,"city"));
> > echo "<BR>\n";
> >
> > echo "<B>State: </B>";
> > printf(mysql_result($result,$count,"state"));
> > echo "<BR>\n";
> >
> > echo "<B>Zip: </B>";
> > printf(mysql_result($result,$count,"zip"));
> > echo "<BR>\n";
> >
> > echo "<B>Phone: </B>(";
> > printf(mysql_result($result,$count,"phonea"));
> > echo ") ";
> > printf(mysql_result($result,$count,"phone"));
> > echo "<BR>\n";
> >
> > echo "<B>Email: </B>";
> > printf(mysql_result($result,$count,"email"));
> > echo "<BR>\n";
> >
> > echo "<B>Credit Type: </B>";
> > printf(mysql_result($result,$count,"crty"));
> > echo "<BR>\n";
> >
> > echo "<B>Credit Number: </B>";
> > printf(mysql_result($result,$count,"crnum"));
> > echo "<BR>\n";
> >
> > echo "<B>Credit Card Date: </B>";
> > printf(mysql_result($result,$count,"crmo"));
> > echo " ";
> > printf(mysql_result($result,$count,"cryr"));
> > echo "<BR>\n";
> >
> > echo "<B>Weeks: </B>";
> > printf(mysql_result($result,$count,"weeks"));
> > echo "<BR>\n";
> >
> > echo "<B>town1: </B>";
> > printf(mysql_result($result,$count,"town1"));
> > echo "<BR>\n";
> >
> > echo "<B>town2: </B>";
> > printf(mysql_result($result,$count,"town2"));
> > echo "<BR>\n";
> >
> > echo "<B>town3: </B>";
> > printf(mysql_result($result,$count,"town3"));
> > echo "<BR>\n";
> >
> > echo "<B>IP Address: </B>";
> > printf(mysql_result($result,$count,"ipaddress"));
> > echo "<BR>\n";
> >
> > echo "<B>Ad: </B>";
> >
> > $ad[$count] = (mysql_result($result,$count,"ad"));
> >
> > $ad[$count] = ereg_replace ("&a&", "'", $ad[$count]);
> > $ad[$count] = ereg_replace ("&q&", "\"", $ad[$count]);
> > $ad[$count] = ereg_replace ("&p&", "%", $ad[$count]);
> > $ad[$count] = ereg_replace ("&bs&", "\\", $ad[$count]);
> >
> >
> > echo $ad[$count];
> > echo "<BR>\n";
> >
> > echo "<B>Total: </B>";
> > printf(mysql_result($result,$count,"total"));
> > echo "<BR>\n";
> >
> > echo "<B>Ad Number: </B>";
> > printf(mysql_result($result,$count,"num"));
> > echo "<BR>\n";
> >
> > echo "<B>Date: </B>";
> > printf(mysql_result($result,$count,"date"));
> > echo "<BR>\n";
> >
> > echo "<B>Time: </B>";
> > printf(mysql_result($result,$count,"time"));
> > echo "<BR>\n";
> >
> > } while($row = mysql_fetch_array($result));
> >
> > } else {print "Sorry, no records were found!";}
> >
> > ?>
> > So far I have come to the conclusion that the input from the user is
> > probably where my problem is because I am assuming it is taking the "/"
> > in the date they enter and doing something I don't want it to. In any
> > event if someone could give me a clue as to how to resolve this issue it
> > would be greatly appreciated.
> >
> >
> >
> > --
> > PHP Database 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]
>
> #-------------------------------------------------------#
>
> "Believe nothing - consider everything"
>
> Russ Michell
> Anglia Polytechnic University Webteam
> Room 1C 'The Eastings' East Road, Cambridge
>
> e: [EMAIL PROTECTED]
> w: www.apu.ac.uk/webteam
>
> www.theruss.com
>
> #-------------------------------------------------------#
--
PHP Database 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]
