is my insert statment right?

Hoangsta


$user_id = $_SESSION['user_id'];
$bus_id = $_GET['bus_id'];
$query = "INSERT INTO BusinessName (template_id)  

	VALUES (\'$buzz_template\')
	WHERE customer_id  = '$user_id'
	AND business_id = '$bus_id'";

I just want to insert if the two conditions are matched. but i don't think my syntax is right. any help is appreciated.

laserlight

looks ok to me.

Was there an error?

Hoangsta

$bus_id = $_GET['bus_id'];

the business id is blank...

Invalid query: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; WHERE customer_id = '19' AND business_id = ''' at line

i think i know what the problem is...i was thinking that $bus_id = $GET['bus_id']; would be retreived from mysqladmin (mysql). but it didn't. the $user_id = $SESSION['user_id']; work because i put it in session in the stages before.

the page before this one was to insert in a business to my table, and having bus_id autoincrement for each business. I just want to retrieve my bus_id from my database.

Hoangsta

i took out the bus_id and instead now have this

$user_id = $_SESSION['user_id'];

$query = "INSERT INTO BusinessName (template_id)  

	VALUES ('$buzz_template')
	WHERE customer_id  = '$user_id'";

Invalid query: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE customer_id = '14'' at line 3

Weedpacket

Perhaps customer_id is a numeric type? In which case it shouldn't be in quotes.

Hoangsta

 
$user_id = $_SESSION['user_id'];

$query = "INSERT INTO BusinessName (template_id)  

	VALUES ('$buzz_template'}
	WHERE customer_id  = $user_id";

Invalid query: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '} WHERE customer_id = 14' at line 2

i tried what u say, and it came up with this...i'm thinking that Insert Into doesn't allow WHERE

Weedpacket

You're right. It doesn't. You want UPDATE. After all, if you're inserting a new record, it doesn't have a customer_id yet.

Hoangsta

i got it to work. i decided not to do it this way of the insert into...but gathered the information and attached it to a form previous to shoing the insert into stage.

my intention was to allow the customer to insert in their business information and when they hit submit, the form will redirect them to a template form.

that's where the insert into....where takes place.

if i'm confusing, it is because i'm soooo tired right now...it's 3:45 in the morning and i need some sleep. :o