| @@ 36-42 (lines=7) @@ | ||
| 33 | $new = []; |
|
| 34 | $sql = 'SELECT employer,position,jobstart,jobstop,description FROM ' . $xoopsDB->prefix('smallworld_user') . " WHERE userid ='" . $id . "'"; |
|
| 35 | $result = $xoopsDB->query($sql); |
|
| 36 | while ($row = $xoopsDB->fetchArray($result)) { |
|
| 37 | $employer = unserialize($row['employer']); |
|
| 38 | $position = unserialize($row['position']); |
|
| 39 | $jobstart = unserialize($row['jobstart']); |
|
| 40 | $jobstop = unserialize($row['jobstop']); |
|
| 41 | $description = unserialize($row['description']); |
|
| 42 | } |
|
| 43 | $start = 0; |
|
| 44 | $end = count($employer) - 1; |
|
| 45 | while ($start <= $end) { |
|
| @@ 49-55 (lines=7) @@ | ||
| 46 | $msg = []; |
|
| 47 | $sql = 'SELECT employer,position,jobstart,jobstop,description FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_user') . " WHERE userid ='" . $id . "'"; |
|
| 48 | $result = $GLOBALS['xoopsDB']->query($sql); |
|
| 49 | while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) { |
|
| 50 | $employer = unserialize($row['employer']); |
|
| 51 | $position = unserialize($row['position']); |
|
| 52 | $jobstart = unserialize($row['jobstart']); |
|
| 53 | $jobstop = unserialize($row['jobstop']); |
|
| 54 | $description = unserialize($row['description']); |
|
| 55 | } |
|
| 56 | $start = 0; |
|
| 57 | $end = count($employer) - 1; |
|
| 58 | while ($start <= $end) { |
|