Help converting OSC SQL code to Zencart

[ozetrade]

There have been a number of requests to migrate the Australian FASTWAY Shipping module from OSC MS2 to Zencart, and this is what I am attempting to do. Unfortunately I am stuck on one section.

If someone could help convert the following OSC MS2 MYSQL code to Zencart compliant MYSQL code, I'm certain the module will work.

$sql = "SELECT * FROM fastway_zones WHERE $topcode >= f_postcode and $topcode <= f_postcode";
$qResult = tep_db_query($sql); 
$rec = tep_db_fetch_array($qResult);

Thanks

[mdc]

There have been a number of requests to migrate the Australian FASTWAY Shipping module from OSC MS2 to Zencart, and this is what I am attempting to do. Unfortunately I am stuck on one section.

If someone could help convert the following OSC MS2 MYSQL code to Zencart compliant MYSQL code, I'm certain the module will work.

$sql = "SELECT * FROM fastway_zones WHERE $topcode >= f_postcode and $topcode <= f_postcode";
$qResult = tep_db_query($sql); 
$rec = tep_db_fetch_array($qResult);

Thanks

I have the same problem like this, can anyone help me?

Thanks

[kobra]

In the wiki
http://www.zen-cart.com/wiki/index.p...dules_from_osC

[mdc]

In the wiki
http://www.zen-cart.com/wiki/index.p...dules_from_osC

Thank you for the reply, i was trying to change the query into:

$sql = "SELECT * FROM fastway_zones WHERE $topcode >= f_postcode and $topcode <= f_postcode";
$qResult = $db->Execute($sql); 
$rec = $db->Execute($qResult); 

But still getting errors, could you advise me how should it be?

Thanks

[kobra]

But still getting errors

What error?
And is this correct?
From:

$sql = "SELECT * FROM fastway_zones WHERE $topcode >= f_postcode and $topcode <= f_postcode";
$qResult = tep_db_query($sql); 
$rec = tep_db_fetch_array($qResult);

To:

$sql = "SELECT * FROM fastway_zones WHERE $topcode >= f_postcode and $topcode <= f_postcode";
$qResult = $db->Execute($sql); 
$rec = $db->Execute($qResult);

[mdc]

What error?
And is this correct?
From:

$sql = "SELECT * FROM fastway_zones WHERE $topcode >= f_postcode and $topcode <= f_postcode";
$qResult = tep_db_query($sql); 
$rec = tep_db_fetch_array($qResult);

To:

$sql = "SELECT * FROM fastway_zones WHERE $topcode >= f_postcode and $topcode <= f_postcode";
$qResult = $db->Execute($sql); 
$rec = $db->Execute($qResult);

I'm not so sure about this, i followed the instructions on the wiki.
$my_var_query = tep_db_query("query stuff"); >> $my_var = $db->Execute("query stuff");

$rec = tep_db_fetch_array($qResult); >>$rec = $db->Execute($qResult); (Not sure about this)