"Ronald Allen" <sesel@xxxxxxxxxxxxxx> wrote in message news:20040514192305.43601.qmail@xxxxxxxxxxxxxxx > 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; > ?> You have to initialize $temp before using it with '.=' $temp = ''; $temp .= 'my string'; Or just set the first line with = $tmp = "ID : $row->ID <br>\n"; $tmp .= "Base : $row->Base <br>\n"; $tmp .= "Date_and_Time : $row->Date_and Your insert should look like this (if ID is an auto-increment field): $insert = "INSERT INTO $db_table SET "; $insert .= "Base = '" . $row->Base . "', "; $insert .= "Date_and_Time = '" . $row->Date_and_Time . "', "; $insert .= "Event_Type = '" . $row->Event_Type . "', "; $insert .= "Description = '" . $row->Description . "', "; $insert .= "Initials = '" . $row->Initials . "'"; mysql_query($insert, $conn); Hope this helps, Regards, Torsten -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
