RE: mysql error and resource ID:

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux