Data Base search

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
shinstar
Forum Newbie
Posts: 18
Joined: Fri May 21, 2010 2:33 pm

Data Base search

Post 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
}
eivind
Forum Commoner
Posts: 28
Joined: Tue Apr 19, 2011 7:57 am

Re: Data Base search

Post 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.
shinstar
Forum Newbie
Posts: 18
Joined: Fri May 21, 2010 2:33 pm

Re: Data Base search

Post 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....
User avatar
flying_circus
Forum Regular
Posts: 732
Joined: Wed Mar 05, 2008 10:23 pm
Location: Sunriver, OR

Re: Data Base search

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