Help needed in PHP + MySQL

C

CrackEEr

Apprentice
Can any body here help me out ?

I m using PHP 5 +MySQL + Apache.

I need a code in PHP which does the following ?

When i click the first button it goes to the first item in the table

When i click the last button it goes to the last item in the table

When i click the next button it goes to the next item in the table

When i click the last button it goes to the last item in the table

Please help me guys.Atleast tell me idea how to do it.

Using Access and VB was very easy.But i dont know how to do it in PHP n MySQL.
 
I dont think u can get vb, access functionality in php, wat u can do is that u can display the whole table in the html page or use some specific sql queries like wen the user clicks on the last button a new php page will be called which will display the last record..

search google for php n mysql n ull get tons of tutorials.
 
Its easy in PHP also.

Name the four buttons differently

<form action = "button.php" method = "post">

<input type = "submit" value = "Button1" name="button1">

<input type = "submit" value = "button2" name = "button2">

</form>

and take the PHP script through if else loop having 4 options of those buttons

if($submit == "button1"

{

# MYSQL CODE;

}

elseif ($submit == "button2"

{

}

etc

and write your mysql code. "SELECT FROM ***** WHERE *******"

I could write a code for that but i guess you try to figure it our first. :)
 
Back
Top