Did this happen? Is there a video on youtube now?

I am not sure I understand what your problem is. Are you trying to get only the data from the "youtube" column? If you said that it works when you use

WHILE($rows = mysql_fetch_array($query)):

     $artist = $rows['artist'];
     $title = $rows['title'];
     $lyrics = $rows['lyrics'];

     echo $artist." - ".$title;
endwhile;

You should try $rows['youtube'];

If this is not the problem please make me understand what is and I will try to help you further.

It is better practice to switch to using mysqli or PDO instead of mysql.

Thank you very much! It now works and I will read about that interface.

Kruithne, on 05 November 2012 - 12:40 PM, said:

array (size=2)
  'action' => string 'search' (length=6)
  'params' => 
    array (size=1)
      'query' => string 'big' (length=3)

The getJsonMethod is below. I have it to be able to make a json_encode on the object later on.

public function getJsonData()
    {
        return get_object_vars($this);
    }

thanks for the answer guys. In

tracker.php

I have this:

if(isset($_POST['request']))
{
    try{
//        sendMail("was set----->");
        $request_dispatcher = new RequestDispatcher($_POST['request']);
        echo json_encode($request_dispatcher->getResponse()->getJsonData());
    }
    catch(Exception $e)
    {
        //todo return response with fail message
    }
}

And in the request dispatcher I am doing this in the constructor:

public function __construct($raw_request)
    {
        $this->controller = new RequestsController();
        $decoded = json_decode($raw_request);
        try
        {
            $this->request = new Request($decoded->action, $decoded->params);
            $this->response = $this->dispatchRequest();
        }
        catch(Exception $e)
        {
            //todo improve logic
            $response = new Response(0, "error",false, array());
            $response->addError($e->getMessage());
            $this->response = $response;
        }
    }

But my problem is when I set the Post request params. Because I don't get further down the road.
I'm trying to post one param named "request" and that fails for me..