Page 1 of 1

Data Base search

Posted: Wed May 11, 2011 1:41 am
by shinstar
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
}

Re: Data Base search

Posted: Wed May 11, 2011 4:19 am
by eivind
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

Posted: Wed May 11, 2011 5:21 am
by shinstar
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....

Re: Data Base search

Posted: Wed May 11, 2011 12:44 pm
by flying_circus
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....
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.

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.";
?>