- // Order placed in queue...
- $result = SQL_QUERY_ESC("SELECT
- po.url, po.subject, po.sender, pay.payment, po.payment_id
-FROM
- `{?_MYSQL_PREFIX?}_pool` AS po
-INNER JOIN
- `{?_MYSQL_PREFIX?}_payments` AS pay
-ON
- po.payment_id=pay.id
-WHERE
- po.id=%s
-LIMIT 1",
- array($id), __FILE__, __LINE__);
-
- // Update wents fine?
- if (SQL_NUMROWS($result) == 1) {
- // Load data
- $content = SQL_FETCHARRAY($result);
-
- // Free result
- SQL_FREERESULT($result);