|
|
Posted by Christo on 11/15/06 23:12
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.
Chris
Shelly wrote:
> "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
Navigation:
[Reply to this message]
|