i have php code,
<?php
include ("connect.php");
$selecteddate = $_POST['sdate'];
$sql1 = "select date from game1";
$query1 = mysql_query($sql1) or die(mysql_error());
while($row = mysql_fetch_assoc($query1))
{
$rowdate = $row['date'];
// problem here i this while loop only compare my latest last value in
database. i want a code here which search all the data in "date" field.
}
if($selecteddate == $rowdate)
{
echo "Date already Exists";
}
else
{
// form insertion data code here which i have and working fine
}
Data Base search
Moderator: General Moderators
Re: Data Base search
That's because you overwrite $rowdata everytime the loop is runned and the result is that you get out the latest value. Try to put the if statement inside the while loop.
Re: Data Base search
i tryed as u said but in that case else part value is been displayed every time because i have already save some record before....
- flying_circus
- Forum Regular
- Posts: 732
- Joined: Wed Mar 05, 2008 10:23 pm
- Location: Sunriver, OR
Re: Data Base search
I may not completely understand your problem, but if all you are trying to do is check whether $selecteddate exists in the database, it's far more efficient to do it in SQL.shinstar wrote:i tryed as u said but in that case else part value is been displayed every time because i have already save some record before....
Consider the following psuedo-code
Code: Select all
<?php
# Includes
include("connect.php");
# Fetch POST Data
$selecteddate = $_POST['sdate'];
# Execute Query
$sql1 = "SELECT `date` FROM `game1` WHERE `date`='" . mysql_real_escape_string($selecteddate) . "'";
$query1 = mysql_query($sql1) or die(mysql_error());
# Does date already exist in database?
if(mysql_numrows($query1) > 0)
echo "Date already Exists";
else
// form insertion data code here which i have and working fine
echo "Date does not exist.";
?>