[SOLVED] Is it possible to run insert from a form?

[saco721]

Hi,

 

I have a form which performs a post and was wondering if it is possible to run an insert at the same time?

 

the code is:

<?php

 

<form method=\"post\" action=\"https://www.mysite.com\" target =\"mysite\">

$query = "INSERT INTO downloads (user_name, item_name, total_downloads) VALUES('$user_name', '$item_name', '$total_downloads')";

 

<input type=\"image\" src=\"http://www.mysite.com/buttonimage.gif\" border=\"0\" name=\"submit\" width=\"87\" height=\"23\">

 

</form>

?>

 

Problem is when I submit the form the database does not update.

 

I am also presented with the following error:

 

Parse error: parse error, unexpected T_STRING, expecting ',' or ';'

 

Any help would be greatly appreciated.

[fenway]

Seriously? You're mixing php and html code.  You need to issue your query from your action script.

[saco721]

problem is that the action script is at paypal.

sorry for asking silly questions, im new to this.

can I run more than one action script from a form?

[fenway]

problem is that the action script is at paypal.

sorry for asking silly questions, im new to this.

can I run more than one action script from a form?

Nope... but you can have your form call your script, then post to paypal... but that a PHP quesion.

[saco721]

Ok thanks!