Re: inserting data into database!
| From: | Daniel Clark | Date: | Fri, 14 May 2004 20:20:37 +0000 |
| Subject: | Re: inserting data into database! | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34441@lists.php.net to get a copy of this message | ||
$tmp isn't defined yet, so can't append to it's self.
(no .= )
$tmp = "ID : $row->ID <br>\n";
> Two questions?
> First why am I getting undefined variable tmp , yet it works
> Second how would I insert data into this table?
> <?
> $db_table = 'log';
> $conn = mysql_connect($db_host,$db_user,$db_pass);
>
> if ($conn == true) {
> mysql_select_db($db_name,$conn);
> $result = mysql_query("SELECT * from $db_table",$conn);
> while($row = mysql_fetch_object($result)) {
> $tmp .= "ID : $row->ID <br>\n";
> $tmp .= "Base : $row->Base <br>\n";
> $tmp .= "Date_and_Time : $row->Date_and_Time <br>\n";
> $tmp .= "Event_Type : $row->Event_Type <br>\n";
> $tmp .= "Description : $row->Description <br>\n";
> $tmp .= "Initials : $row->Initials <br><hr>\n";
> }
> } else {
> echo 'could not connect to database : '. mysql_error();
> }
> print $tmp;
> ?>