PHP mysql select unique records from one table

**Captain Carrot** · 10-05-2010

Hello,
I am looking for a php code to generate a unique record from sql database. I have no idea how to do this. If you know then please post here, it would really help me a lot. Thank you for your help.

**NetworkeR** · 10-05-2010

Hello,
I think this can solve your problem, just give it a try

Code:

$qry = "select DISTINCT name FROM table WHERE name LIKE string"; 
$rsl = my_qry($qry) or die (mysql_error()); 
//$row = mysql_fetch_array($rsl); 
while ($row = mysql_fetch_array($rsl)) { 
echo $row["name"]; 
}

**NetWorkInG** · 10-05-2010

Hello,
You can try the following code , though I am not sure that this is the perfect code that your are looking for

Code:

<?php 
class appmd extends md {

function isunq($field, $value, $id)
    {
        $flds[$this->name.'.'.$field] = $value;
        if (empty($id))
            // add 
            $flds[$this->name.'.id'] = "<> NULL"; 
        else
            // edit
            $flds[$this->name.'.id'] = "<> $id"; 
        
        $this->recursive = -1;
        if ($this->hasAny($flds))
        {
            $this->invalidate('unique_'.$field); 
            return false;
        }
        else 
            return true;
   }

?>

**Linux-Us** · 10-05-2010

Hello,
Alternatively you can use this code

Code:

<?php 
if ($this->User->unq('username', $this->data['User']['username'], $user_id))
    { 
        if ($this->User->save($this->data))
        {
           $this->flash('User has been saved.','/users/index');
        }
     }
?>

**cyber-noob** · 10-05-2010

Hello,
Take a look at the following code

Code:

if (empty($id)){
// add
$cnd = $this->name.".".$flds." = '".$value."'";
}else{
// edit
$flds[$this->name.'.id'] = "<> $id";
$conditions = '('.$this->name.".".$flds." = '".$value."') AND (".$this->name.".id <> $id)";
}

**GlassFish** · 12-05-2010

Hello,
Try the following code

Code:

if (empty($id))
// add
$flds[$this->name.'.id'] = "!= NULL";
else
// edit
$flds[$this->name.'.id'] = "!= $id";

**GlassFish** · 13-05-2010

Hello,
Check the modified code

Code:

$qry = "select DISTINCT name FROM `atable` WHERE name LIKE '%john%'";
$rst = mysqlqry($qry) or die (mysql_error());
$row = mysqlarry($rst);
while ($row = mysqlarry($rst)) {
echo $row["name"];
}