Board index   FAQ   Search  
Register  Login
Board index PHP PHP General

how to UPDATE a DB?

General discussions related to php

Moderators: macek, egami, gesf

how to UPDATE a DB?

Postby Godiwa » Thu May 08, 2003 6:27 am

I have a DB with quite a few fields in it and I can get the info INSERT'ed and I can get it out again as a result, but how do I UPDATE it?

I know how to get the info back into the form EXCEPT for scroll down menues and check boxes, how do I get them to get the result from the DB so the right think is selected in the scroll down menu and so the check box is checked, if it is listed as checked in the DB?

on all normal text fields I just put in value=$varname and that puts the info in just fine and in textfields you just have to put the $varname inbetween the <texfield> and </textfield>

any suggestions on how to do this thing?

Godiwa

***edited in***
I forgot to add, how do you make sure that it writes on top of the old row and doesn't make a new one?
***edited in***
Godiwa
New php-forum User
New php-forum User
 
Posts: 40
Joined: Wed Mar 05, 2003 5:55 am

Postby bezmond » Thu May 08, 2003 7:22 am

User avatar
bezmond
Moderator
Moderator
 
Posts: 312
Joined: Sat Apr 05, 2003 4:33 am
Location: Mansfield, UK

Postby Godiwa » Fri May 09, 2003 8:54 am

you got a solution to how I get my info from the database into the CHECK BOXES and ROLL DOWN MENUS?

all other I get in nicely but I can't figure out how to enter the state of those two with info from the DB

Godiwa
Godiwa
New php-forum User
New php-forum User
 
Posts: 40
Joined: Wed Mar 05, 2003 5:55 am

Postby Oromian » Fri May 09, 2003 6:41 pm

Oromian
New php-forum User
New php-forum User
 
Posts: 38
Joined: Fri Apr 04, 2003 2:44 pm
Location: Canada

Postby bezmond » Fri May 09, 2003 11:48 pm

I couldn't find that link, so I went for the MySQL website instead ;o)
User avatar
bezmond
Moderator
Moderator
 
Posts: 312
Joined: Sat Apr 05, 2003 4:33 am
Location: Mansfield, UK


Return to PHP General

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron