Posted by william.clarke@gmail.com on 06/01/06 22:13

Did you have a look at the quoting strawberry suggesting in the
previous post?

'$grading_fairness', $grading_fairness_comments'

Notice the missing quotation mark...if that isn't all try doing a dummy
transaction using your MySQL front-end, by grabbing this code and
substituting values in or even better get php to echo the whole
statement on the page and cut and paste that directly into your MySQL
front-end, this should uncover any syntax errors etc. very quickly.


Peschtra wrote:
> Strawberry -
>
> Thanks for your help.
>
> I don't know what it means for something to be automated. :(
>
> I changed my script as you suggested and found one missing ' (where you
> suggested in your previous post), but still no luck.
>
> Thanks again,
>
> Peter
>
> I don't know what
>
> strawberry wrote:
> > Marcin's right, 'a query like that is just begging to be automated'
> > but, in any event, writing the query something like this would make
> > those kind of mistakes much easier to spot;
> >
> > $query = "INSERT INTO table
> > (
> > value1, //you can even add comments
> > value2,
> > value3
> > )
> > VALUES
> > (
> > 'value1',
> > 'value2',
> > 'value3'
> > );";
> >
> > mysql_query($query) etc
> >

[Back to original message]