adding to form?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
novice with mysql so be slow.

Want to be able to update the contents of a database row through a
form, i want to be able to load the contents of a specific row

my database table is as follows

id(pk)    |    title    |    body    |    date(text field)
1          |   hello    |   test      |    15-11-2006 13:44
2          |   again   |   test2    |    15-11-2006 13:45

basically i want to be able to add the contents of one of thw rows into
various forms, for instance lets say i want to edit all of the stuff in
the table which i do, and i want to add the title and the body into
forms respectively named title and body how would i do this?

I tried using a select statement to select all of the items from the
table in the database and put where id='".$id."'
Basically i dont have a clue wehre to start here so can someone please
help me

Re: adding to form?

Christo wrote:
Quoted text here. Click to load it

   Okay, at this point you need to start with:


Re: adding to form?

Marcin Dobrucki wrote:
Quoted text here. Click to load it

Do you think searching in French (or Portuguese, or Chinese, ...) will
not return adequate results? :)

I (almost) never check the dodgeit address.
If you *really* need to mail me, use the address in the Reply-To
header with a message in *plain* *text* *without* *attachments*.

Re: adding to form?

Quoted text here. Click to load it

$query = "SELECT * FROM theTableName WHERE id='" . $idChosenForSearch . "'";
                                      (That is a '  folled by a ";  then  
later a " followed by a '  followed by a ")

you have:

mysql_select_db($database, $dbLogin);
$result = mysql_query($query, $dbLogin) or die(mysql_error());

Where $dbLogin is the result of connecting to the database.

You extract the information as:

$row = mysql_fetch_assoc($result);
$title = $row['title'];
$body = $row['body'];
$date = $row['date'];

Hope that helps to get you started.


Re: adding to form?

Thanks i got it all sorted now, was kind of a botch of everything that
i have read and it works so im smiling thanks everyone.


Shelly wrote:
Quoted text here. Click to load it

Site Timeline