2. PHPRunner General questions
  3. [SOLVED]  SELECT QUERY NOT RETURN RESULTS
This topic is locked
[SOLVED]

 SELECT QUERY NOT RETURN RESULTS

 		1/31/2011 9:53:55 AM
PHPRunner General questions
C
 ckapote author

HI EVERYONE ,
I HAVE A PHPRUNNER PROJECT CONNECTED WITH AN ACCESS MDB TABLE .
ONE TABLE NAMED tblmain CONTAINS FOLLOWING FIELDS :

id

RefNo

Equipment
I need when a new record is added field RefNo to be updated automatically from table tblrefnumber and

field REF.

I try following query BEFORE RECORD ADDED but return NO results , so pls help :
global $conn;
$sql="SELECT REF FROM tblrefnumber WHERE id=1";

$result= db_query($sql,$conn);

$data=db_fetch_array($result);

$values["RefNo"]=$data;
PLEASE HELP ME AS ALWAYS .
IMPORTANT NOTE : PLEASE DO NOT REPLY THAT I CAN USE THE LOOK UP OPTION AS IT IS IMPORTANT FOR ME ABOVE QUERY TO WORK OUT-THANKS.
RGDS

CHRIS
C
 		ckapote author 2/1/2011



HI EVERYONE ,
I HAVE A PHPRUNNER PROJECT CONNECTED WITH AN ACCESS MDB TABLE .
ONE TABLE NAMED tblmain CONTAINS FOLLOWING FIELDS :

id

RefNo

Equipment
I need when a new record is added field RefNo to be updated automatically from table tblrefnumber and

field REF.

I try following query BEFORE RECORD ADDED but return NO results , so pls help :
global $conn;
$sql="SELECT REF FROM tblrefnumber WHERE id=1";

$result= db_query($sql,$conn);

$data=db_fetch_array($result);

$values["RefNo"]=$data;
PLEASE HELP ME AS ALWAYS .
IMPORTANT NOTE : PLEASE DO NOT REPLY THAT I CAN USE THE LOOK UP OPTION AS IT IS IMPORTANT FOR ME ABOVE QUERY TO WORK OUT-THANKS.
RGDS

CHRIS


finally I did it .
$str = "select * from tblrefnumber where id=1";

$rs = db_query($str,$conn);

$data = db_fetch_array($rs);

$values["VesselRefNo"]=$data["Ref"];

return true;