Changeset 285 for trunk/phpbms/checkunique.php
- Timestamp:
- 08/27/07 14:05:27 (5 years ago)
- Files:
-
- 1 modified
-
trunk/phpbms/checkunique.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/phpbms/checkunique.php
r236 r285 39 39 require ("include/session.php"); 40 40 41 function isUnique($tablename,$column,$value,$excludeid,$db link){41 function isUnique($tablename,$column,$value,$excludeid,$db){ 42 42 43 43 $thereturn=false; 44 44 45 45 $querystatement="SELECT count(id) AS thecount FROM ".$tablename." WHERE ".$column."=\"".$value."\" AND id!=".$excludeid; 46 $queryresult= mysql_query($querystatement,$dblink);46 $queryresult=$db->query($querystatement); 47 47 if($queryresult){ 48 $therecord= mysql_fetch_array($queryresult);48 $therecord=$db->fetchArray($queryresult); 49 49 if($therecord["thecount"]==0) 50 50 $thereturn=true; … … 62 62 63 63 $querystatement="SELECT maintable FROM tabledefs WHERE id=".$_GET["tdid"]; 64 $queryresult= mysql_query($querystatement,$dblink);64 $queryresult=$db->query($querystatement); 65 65 if($queryresult) 66 if($therecord= mysql_fetch_array($queryresult))67 $isunique=isUnique($therecord["maintable"],$_GET["c"],$_GET["val"],$_GET["xid"],$db link);66 if($therecord=$db->fetchArray($queryresult)) 67 $isunique=isUnique($therecord["maintable"],$_GET["c"],$_GET["val"],$_GET["xid"],$db); 68 68 } 69 69