See PHP manual > Chapter 6. Types > Strings
for an explanation of single & double quotes.
>From the doc:
"If the string is enclosed in double-quotes ("), PHP understands more escape
sequences for special characters"
"But the most important feature of double-quoted strings is the fact that
variable names will be expanded."
In your case it would be ' within ".
$query = "INSERT INTO MainTable (RecordID,UserID,.........)
values(null,null,'$f1a','$f2a',...)";
Graham.
> -----Original Message-----
> From: Stuart Felenstein [mailto:stuart4m@xxxxxxxxx]
> Sent: 14 October 2004 15:43
> To: dpgirago@xxxxxxxxxxxxxx
> Cc: php-db@xxxxxxxxxxxxx
> Subject: RE: mysql error and resource ID:
>
>
> Quote as in "string" or quote as in 'string' ?
> Those two confuse me.
>
> Stuart
> --- dpgirago@xxxxxxxxxxxxxx wrote:
>
> > If any of the variables used to insert data are
> > strings ($f1a, $f2a,
> > etc...), you'll need to have quotes around them.
> >
> > dave
> >
> >
> >
> >
> >
> >
> > Stuart Felenstein <stuart4m@xxxxxxxxx>
> >
> > 10/14/2004 08:26 AM
> >
> >
> >
> >
> >
> > To:
> > Graham Cossey <graham@xxxxxxxxxxxxxxx>,
> > php-db@xxxxxxxxxxxxx
> > cc:
> >
> >
> >
> >
> >
> > Subject:
> > RE: mysql error and resource ID:
> >
> >
> >
> > Not much luck here on placing the
> > mysql_error($link);
> > I know the server and database is reachable. So I
> > imagine the error is happening in the query. I've
> > moved the $link around with no luck.
> >
> > Stuart
> >
> > Revised code below:
> > --- Graham Cossey <graham@xxxxxxxxxxxxxxx> wrote:
> >
> > <?php
> >
> > function begin()
> > {
> > mysql_query("BEGIN");
> > }
> > function commit()
> > {
> > mysql_query("COMMIT");
> > }
> > function rollback()
> > {
> > mysql_query("ROLLBACK");
> > }
> > mysql_connect("myserver","myusername", "mypassword")
> > or die(mysql_error());
> >
> > mysql_select_db("mydatabase") or die(mysql_error());
> >
> > $query = "INSERT INTO MainTable
> > (RecordID,UserID,.........)
> > values
> >
> (null,null,$f1a,$f2a,$f2c,$f2d,$f2e,$f2g,$f5b,$f3m,$f3n,$f3e,$f3f,
> $f3g,$f3h,$f3i,$f3j,
> > $f3k,$f3l)";
> > begin(); // transaction begins
> > $result = @mysql_query($query, $link);
> >
> > if(!$result)
> > {
> > rollback(); // transaction rolls back
> > echo "You rolled back ".mysql_error($link);
> > exit;
> > }
> > else
> > {
> > commit(); // transaction is committed
> > echo "your insertion was successful";
> > }
> > ?>
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
