Posted by Shelly on 11/15/06 20:35

"Christo" <cmw1985@googlemail.com> wrote in message
news:1163598413.488377.287410@e3g2000cwe.googlegroups.com...
> 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
>

$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.

Shelly

[Back to original message]