Kryptronic Software Support Forum

lazarus42 · 03-23-2013 05:43:41

Is it possible to access the contents of a particular field from an existing table from within a custom shipping script?

I used to use functionality like this in CCP5.1 in perl and wish to replicate it in CCP8 in php.

Does anyone have a code fragment they could share with me? Alternatively if it is not possible, please let me know.

Phill

webmaster · 03-25-2013 07:55:44

Code:

$CORE_DB =& $this->quick_object('CORE_DB','core','CORE_DB_1');

$table = 'SOME_TABLE';
$sql = 'SOME_SQL_STATEMENT';

$result = $CORE_DB->sql_do(array('sql'    => $sql,  'table'  => $table, 'order'  => array('id' => 'ASC')));

foreach ($result as $num => $row) {

     //DO SOMETHING...

} // End of foreach statement.

lazarus42 · 03-25-2013 08:23:51

Thanks, Nick

Kryptronic Software Support Forum

#1 03-23-2013 05:43:41

Access table within custom shipping script?

#2 03-25-2013 07:55:44

Re: Access table within custom shipping script?

Code:

#3 03-25-2013 08:23:51

Re: Access table within custom shipping script?

Board footer