Question: There exists an RSS feed with over 1000 items. I want to create a Yahoo Pipes RSS feed that returns a subset of the feed's items, specified by the index of the first and last item. For example, I could pass in first=500 and last=600, and the Pipe will return an RSS feed with only the 500th through 600th itemd in the source feed. Is this possible with Yahoo Pipes, and if so can someone point me in the right direction?

Answer: 
Try this:

```
$query  = "SELECT id, title, content, contactname, contactemail, contactnumber ".
         "FROM vacancies ".
         "WHERE id = '".$_GET['id']."'";

```

I always try to leave the variables out of my strings, just add them in with periods, I find it eliminates a lot of confusion.
Remove the quotes around 

```
 {$_GET['id']}

```

and

```
 $id

```

in all your queries.

Your id is of type integer I assume, which can't take a quoted version or it tries to match the integer key to the string "1"

--
Change this line

```
$result = mysql_query($query) or die('Error : ' . mysql_error());

```

to

```
$result = mysql_query($query) or die('Error : ' . mysql_error() . "\n\n" . $query);

```

Then you can see exactly what query is going into the DB. Which you can then post here for us to see.

Also please post a 

```
describe <tablename>;

```