How to display the result of this code into a table ?

[Max45]

Hi there,
I have written this code and now I want to put show its result in a table .
The code is

$sql='SELECT id , fname , reg_date ,
CONCAT("Registerd ", DATEDIFF(CURDATE(), reg_date), " Days Age.")
AS RegisteredSence 
FROM users;

Any idea?

[HarshShah]

Hii Max45,

If you want to display the results of a query in a table, I recommend Ado.net.

Try this code...

<asp:GridView ID="GridView1" runat="server"></asp:GridView>
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            string query = "";
            using (SqlConnection con = new SqlConnection(constr))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter(query, con))
                {
                    using (DataTable dt = new DataTable())
                    {
                        sda.Fill(dt);
                        GridView1.DataSource = dt;
                        GridView1.DataBind();
                    }
                }
            }

I hope it will helpful to you!!