record id

[blitz2190]

I have a logic hook that will fire on before_retrieve to update a field depending on what is entered in to other field of a related module i have the code working all except how to retrieve the id of the record currently open

 <?php
$id="THIS IS WHERE I NEED THE RECORD ID";
 
mysql_connect("localhost", "username", "password");
mysql_select_db("database");
 
$query = "SELECT adf21_testecd6testing_ida from adf21_testif21_testing2_c where adf21_test3552esting2_idb='$id' and deleted=0";
$results = mysql_query($query);
 
while($row=mysql_fetch_array($results)){
    $id2=$row['adf21_testecd6testing_ida'];
    $query2="SELECT num1_c, num2_c from adf21_testing_cstm where id_c='$id2'";
    $results2 = mysql_query($query2);
    while($row2=mysql_fetch_array($results2)){
            $num1=$row2['num1_c'];
            $num2=$row2['num2_c'];
            $num3=$num3+$num2+$num1;
    }
}
$update_query="UPDATE adf21_testing2_cstm SET num3_c='$num3' WHERE id='$id'"
?>  

[Angel]

Try using $bean->id to retrieve it.

Also, unless you are connecting to another server/database, you should be able to run your query without having to establish a new connection.

Check out this post for an example:

http://cheleguanaco.blogspot.com/200...k-example.html

[blitz2190]

thanks i knew about the connection thing i was on another machine connecting when i wrote that but ill give $bean->id a try thank you

[Angel]

I just realized you are doing it in a "before_retrieve". Not sure if my suggestion will work in that case, as it may not yet be populated by the time that logic hook fires. I suppose the best way of knowing would be to try it.

[blitz2190]

no it does not have an id until after retrieve but i manage to make it work by also setting $bean->field_name to equal what was just entered into the table so that way it would show current information thank you for the help

[rocoyotte]

Try with $_REQUEST var. I've succed with $_REQUEST['record'] to fill the record_id that I needed