TalkPHP - View Single Post - Adding data

Orc · 01-25-2008, 06:59 AM

To display the values from the MySQL rows from the columns you would do:

PHP Code:


			
 while ($row = mysql_fetch_array($query) )
 {
    echo $row['actorfirstname'];
    echo $row['actorlastname'];
 }

Also the id column would be set to null considering it increments whenever there are new values put inside the other columns, so when you put a new actor's first and last name in, and submit the form inputs
It will put them into the database along with an id knowing already that it increments +1.

You could get the $_GET global for use of the ID column doing:

PHP Code:


			
 $id = $row['actor_id'];
 $_GET['actid'] = $id;

01-25-2008, 06:59 AM	#2 (permalink)
Orc The Prestige Join Date: Dec 2007 Posts: 1,044 Thanks: 193	To display the values from the MySQL rows from the columns you would do: PHP Code: `while ($row = mysql_fetch_array($query) ) { echo $row['actorfirstname']; echo $row['actorlastname']; }` Also the id column would be set to null considering it increments whenever there are new values put inside the other columns, so when you put a new actor's first and last name in, and submit the form inputs It will put them into the database along with an id knowing already that it increments +1. You could get the $_GET global for use of the ID column doing: PHP Code: `$id = $row['actor_id']; $_GET['actid'] = $id;` __________________ VillageIdiot can have my babbies ;d