Ho to check record existence and write if not exist?

[coder9]

ok

 

i have this table name: jtable

with two columns: id and box_no

 

now what i want is to check first if $link has the same value already in box_no column.

 

I want the search to search all the records in the table if $link has duplicate already under box_no column

 

if duplicate found, then don't write $link value  into box_no column.

 

if it doesn't have duplicate, then write the value of $link into box_no column.

 

now my humble request is this could you show me how is this done using PHP & MySQL?

 

Thank you very much in advance.

 

 

 

[samshel]

sudo code...

$strQuery1 = "select count(*) as cnt from jtable where box_no='".$link."'";
$res = mysql_query($strQuery1);
$row = mysql_fetch_array($res);
$intCount = $row['cnt'];

if($intCount == 0) {
  $strQuery2 = "insert into jtable (box_no) values ('".$link."')";//assumption id is auto-incremented.
  $res2 = mysql_query($strQuery2);
}

[waynew]

Or

 

$amount = mysql_num_rows($result);

[samshel]

i prefer count() as it does not actually fetch all rows but just returns count() of rows..in case the table has a lot of records...it will fetch all rows when we just need a count of rows and not the actual data.

 

[waynew]

Lesson learned.

[coder9]

@samshel

 

 

Thank you very much man!

 

You really helped me.

 

I'll pray for you.

[ignace]

why not just use:

 

REPLACE INTO?