inserting data into database!
| From: | Ronald Allen | Date: | Fri, 14 May 2004 19:23:02 +0000 |
| Subject: | inserting data into database! | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34431@lists.php.net to get a copy of this message | ||
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;
?>