On Fri, Mar 25, 2011 at 8:34 AM, Daniel Brown <danbr...@php.net> wrote:

> On Fri, Mar 25, 2011 at 08:24, Daniel Brown <danbr...@php.net> wrote:
>     And, now that I'm not on a three-inch screen, I can see that I
> didn't read your entire message, so my response appears rather idiotic
> --- because you already did the isset().  Sorry for that.
>    You're not even seeing your "it didn't work" error kick out?
> No problem, it is still early here on the East Coast.  No I dohave that
error message kicked out, I put it there as a test to try and isolate the
offending code block, which it did.  Now I just have to figure out how to
get it to work.  I understand your point with the GET so here is what I am
trying to do in the big picture.  I have a form with a drop down menu, for
now, where the user picks a value.  This value is sent using
AJAX(XMLHttpRequest) to the php script.  I want the script to grab this
value, run the prepared query with it and return a table structure again,
using AJAX( innerHTML).  I figured I would start small and try to get it
working with just simple values and then would move on to passing the values
to the script.  On the INSERT statements, I posted one below, I just bind
the value and then set it and it works fine with no errors or warnings,
thats why I am still scratching my head over the query.

//insert values into the default series table
$d_series = $db->prepare("INSERT INTO defaultseries (defaultseries,
publisher) VALUES (:defaultseries, :publisher)");  //SQL statement
$d_series->bindParam(':defaultseries', $defaultseries);  //bind the prepared
value to a php variable
$d_series->bindParam(':publisher', $publisher);//bind the prepared value to
a php variable

//the first row to be inserted
$defaultseries = 'Batman';  //declare the php variable
$publisher = 'DC Comics';  //declare the php variable
$d_series->execute();  //execute the prepared statement

Reply via email to