Can't Insert into Database

Hoangsta

I can't understand why I can't insert the my information from a form to a database....My form has the required information and the syntax below calls for this to happen..., but it doesn't want to insert into my two tables....is it because my two tables has auto_increments?

$sql = "INSERT INTO Customer (cust_address, gen_city, generalacct_state_country, gen_zip, home_phone)
		VALUES('$cust_address', '$gen_city', '$generalacct_state_country', '$gen_zip', '$home_phone', now())";
//Insert into table BusinessName 
$sql = "INSERT INTO BusinessName (business_type, business_name, business_address, bus_city, businessacct_state_country, bus_zip, business_phone, business_fax, webpagelink)  

		VALUES('$business_type','$business_name', '$business_address', '$bus_city', '$businessacct_state_country', '$bus_zip', '$business_phone', '$business_fax', '$webpagelink', now())";
	$result = mysql_query($sql);
if(!$result){
	$feedback = 'ERROR - There has been an error adding your business to our directory. Please contact the webmaster.';
} else {
	$feedback = 'SUCCESS - Your information was stored! <br />';
	return $feedback;
	$user_id = mysql_insert_id();
}

dalecosp

I think you should be getting error messages, what does $feedback say when the script is run?

It seems as if you are telling MySQL to stick 6 objects into 5 fields on the first query
and 10 into 9 fields on the second...I believe that'd give you some kind of 'mismatch'
error in MySQL...what is now(), anyway?

Pests

now() is the current date/time I believe.

Hoangsta

my $feedback doesn't say anything when I hit submit...I checked out my "MySQL" and all I see are varchar.

when i do fill out all required information on my form and hit submit...it just doesn't pass anything from the form to the database....after submitting, it just show me the same form...

cgraz

Checkout the sticky in the Database forum entitled "Database forum FAQ + Bookmarked threads"

Cgraz

DeltaRho2K

now() is not the function to produce today's date. The function you want is date(). Also, you should just assign the value to a variable, and use that variable to add to your tables. Check the manual for all of the applicable Date and Time functions, because I personally recommend using a UNIX Timestamp myself...

Next, don't forget your close parenthesis on your INSERT stamenets.

Lastly, you have to identify ALL of the fields in your INSERT statements. Apply these changes, and let us know how it goes.


// Establish today's date for insertion into a mySQL DATE field
$today = date("Y-m-d");

// Setup the SQL to insert into the customer table and execute
$sql1 = "INSERT INTO Customer (cust_address, gen_city, generalacct_state_country, gen_zip, home_phone, dateinserted) 
        VALUES('$cust_address', '$gen_city', '$generalacct_state_country', '$gen_zip', '$home_phone', '$today')"; 
$result1 = mysql_query($sql1);


// Setup the SQL to insert into the business table and execute 
$sql = "INSERT INTO BusinessName (business_type, business_name, business_address, bus_city, businessacct_state_country, bus_zip, business_phone, business_fax, webpagelink, dateinserted)   

        VALUES('$business_type','$business_name', '$business_address', '$bus_city', '$businessacct_state_country', '$bus_zip', '$business_phone', '$business_fax', '$webpagelink', '$today')"; 
    $result = mysql_query($sql); 

if(!$result){ 
    $feedback = 'ERROR - There has been an error adding your business to our directory. Please contact the webmaster.'; 
} else { 
    $feedback = 'SUCCESS - Your information was stored! <br />'; 
    return $feedback; 
    $user_id = mysql_insert_id(); 
}