J
|
Jane 1/22/2007 |
Hi, function ViewOnLoad() { $myun = @$_SESSION["UserID"]; $dldate = date("Y:m:d:H:i:s"); global $where,$strTableName,$conn; $str = "select from ".$strTableName." where ".$where; $rs = db_query($str,$conn); $data = db_fetch_array($rs); if($data["cl_status"]=="active") { // if record exists do something $result = mysql_query("SELECT FROM _cdws WHERE uname like '$myun' ") or die(mysql_error()); while($row = mysql_fetch_array( $result )) { $strSQLInsert = "insert into _dlp (dws_cname,abin,lead_id,dlp_date) values ('".$myun."', '".$row["abin"]."','".$data["ds_Lead_ID"]."','".$dldate."')"; db_exec($strSQLInsert,$conn); echo "Got It"; } } else { // if dont exist do something else echo "This is not an ACTIVE LEAD"; die(); } } |
D
|
datapimp author 1/23/2007 |
an error comes up when i use your code: |
D
|
datapimp author 1/24/2007 |
I'm thinking that no-one has any idea with this one ????? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=14858&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' /> |
J
|
Jane 1/24/2007 |
Try to use _clead table instead of _dvl: function ViewOnLoad() { $myun = @$_SESSION["UserID"]; $dldate = date("Y:m:d:H:i:s"); global $where,$strTableName,$conn; $str = "select * from _clead where ".$where; $rs = db_query($str,$conn); $data = db_fetch_array($rs); ... |