London Jobs – LondonNet’s guide to getting a job in London

London Jobs

“);

echo(“

Moving to London is exhilarating and terrifying, all at once. Big city, lots of people, always busy – and add to that trying to work in London, and you’ve got yourself a significant task: to find good, respectable, gainful employment in the third most expensive city in the world, while still retaining your life and responsibilities.

Thankfully – as always – LondonNet is here to help. Here we have a number of tips, resources and other information to help guide you as you search for good work in London…

“);

echo(“

Browse Job Catogeories

“);

## Connect to LondonNet Database – Jobs

$dbh = @mysql_connect(“192.168.20.3”, “website”, “n1E7JjrE2”); //live

if (!$dbh){
echo(“

Failed to connect to DB server

“);
exit();
}

if (! @mysql_select_db(“londonnet”) ){
echo(“

Failed to find Database

“);
exit();
}

if($dbh){
//echo(“✓ Connected – to Jobs Server
“);
}

$result=mysql_query(“select distinct category from jobs ORDER BY category ASC”);

## Build Category List

$catlist = ‘

‘;

$cattextarray = array();

while ( $row = mysql_fetch_array($result) ){
$cattextarray[] = $row[“category”];
}

foreach($cattextarray as $categorytxtname){

//$count=mysql_query(“select COUNT(*) AS numrows from jobs where category = ‘”.$categorytxtname.”‘;”);

$queryResource = mysql_query(“select COUNT(*) AS numrows from jobs where category = ‘”.$categorytxtname.”‘;”);

$rowdata = mysql_fetch_array($queryResource, MYSQL_ASSOC);

$result=mysql_query(“select * from jobs where category like ‘”.$categorytxtname.”‘”);
//$num_rows = mysql_num_rows($result);
$catpage = str_replace ($removeChars, “”, $categorytxtname);

$catlist .= ‘

‘ . $categorytxtname . ‘ (‘. $rowdata[‘numrows’] .’)

‘;
}

$catlist .= “

“;

mysql_close($dbh); // close DB connections

echo($catlist);

?>