data not inserting into database?!

[Anon]

My data is not inserting into my data base. Any suggestions on why? (I am pretty new at this)

And I am getting this error:
"Column count doesn't match value count at row 1 " How do I fix this?

THANK YOU!!!

here is my code:

<?php
include ("password.inc") ;
mysql_connect ( $hostname, $dbuser, $dbpassword ) ;
mysql_select_db ($database) ;
$query = "select member_id , first_name , last_name , email , user_name, decode(password,'enc') , day_phone from member_corp_coach where type in ('P' , 'B') and user_name = '$user_name' and decode(password,'enc')='$password'" ;
$result = mysql_query ( $query) ;
$counter = 0 ;
while ( $row_array = mysql_fetch_row($result))
{
$person = $row_array[1] . " " . $row_array[2] ;
$counter = $counter+1 ;
break ;
}
if ( $counter == 0 ) {
header("Location:http://www.dare2feel.com/eclasses1.php");
exit ;
}
$query = "select course_id, course_desc, member_price, course_email from course" ;
$result = mysql_query ( $query) ;

    $query = "insert into course_member ( course_id , member_id , course_reg_date, 
   member_type , member_price ) values ( '$course_id', '$member_id', sysdate() )" ;
    $result = mysql_query ( $query) ;
if ( $result == 0 ) {
	print ( mysql_error() ) ;	
    } 

?>

[Anon]

Read the error message - it tells you that the column count doesn't match. So count your columns:

$query = "insert into course_member ( course_id , member_id , course_reg_date,
member_type , member_price ) values ( '$course_id', '$member_id', sysdate() )" ;

Your trying to insert into the fields:
course_id
member_id
course_reg_date
member_type
member_price

There are 5.

Now, you're inserting this values into those fields:
$course_id
$member_id
sysdate()

There are 3. Either delete 2 fields, or add 2 more values.

Diego

[Anon]

Thank you Diego! I am getting closer 🙂 It is now inserting, but it is inserting '0' for everything..

[Anon]

Try printing the query:

print $query;

and see what you get. Maybe $course_id and $member_id are wrong...

Diego

[Anon]

Diego,

Thank you, I got it. I had:
course_desc1' = $course_desc

instead of:
$course_desc1' = course_desc

~natalie