View Cetain records, Edit And Delete Records Help

[cnagra]

hi

i need to figure out how to view certain records, edit existing records and delete records...does anyone know of any good tutorial sites, or can help me out?

thanks

[cnagra]

can anyone please please help....i jus need the html and php code to input one ID, then view, edit and delete...please help

[Orio]

Just google... Here's one I found using: mysql php tutorial.
[a href=\"http://www.freewebmasterhelp.com/tutorials/phpmysql\" target=\"_blank\"]http://www.freewebmasterhelp.com/tutorials/phpmysql[/a]

Orio.

[christite214]

[!--quoteo(post=365914:date=Apr 18 2006, 02:44 AM:name=Orio)--][div class=\'quotetop\']QUOTE(Orio @ Apr 18 2006, 02:44 AM) [snapback]365914[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Just google... Here's one I found using: mysql php tutorial.
[a href=\"http://www.freewebmasterhelp.com/tutorials/phpmysql\" target=\"_blank\"]http://www.freewebmasterhelp.com/tutorials/phpmysql[/a]

Orio.
[/quote]




Use a select query and use mysql_fetch array to view a particular coloum.
Eg: try understanding the following code.. it gives the value of email stored in the database.
$name=$_POST['txt_name'];
$query="Select email from emp where Name ='$name'"

$result=mysql_query($query) or die(mysql_error());

//$numrows=mysql_numrows($resultset);
if(mysql_num_rows($result)==1 )
{

$row=mysql_fetch_array($result);
$email= $row['email'];
echo $email;
}

[cnagra]

hi,

im very new to php, will i put that code in a php file, what kind of html file would i have to make. i didnt understand that tutprial, can you please break it down what i have to do for me. thanks

[GingerRobot]

Perhaps your best bet is to put that idea to the side for a minute and concentrate on getting a better knowledge of php. Use the beginner tutorials on this site - they may not be specifically for what you want, but they will include elemnts you can appy to any situation.