Stanley Stanley - 1 year ago 94
MySQL Question

İncrease one by one php variable in sql query

I have a table. The table have id, name and sname columns. I want to run a sql query in php. For example my query is

Select * from mytable where id=$n;

Here $n is a variable first value is 1. When the page is loaded this query is running. I listed a table query result. I want to increase $n value with a html button. The button is clicked $n value must be 2 and query must execute with new $n variable. Any idea?

Answer Source

You can post with a form and increment the id

if (isset($_GET["increment"]) && $_GET["increment"] == 1)

$sql = "Select * from mytable where id=$n;";

// display data as usual


    <input type="hidden" name="increment" value="1"/>
    <button type="submit">increment</button>
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download