Creating a mysql counter variable

gistfile1.aw

<?php

// I am using Symfony2 with it!

// Getting the connection
$conn = $this->getDoctrine()->getConnection();

// Sets the SQL counter variable
$conn->exec("SET @I := 0");

//Retrieve the data
$result = $conn->fetchAll("SELECT @I := @I+1 AS counter, others_columns FROM table");