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,cryr,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]
