ok, well if that's the case then do this
$db = mysql_connect('biggie', 'user', 'password', 'test');
That should fix the problem.
On Thu, Feb 26, 2009 at 12:46 PM, PJ <af.gourmet@xxxxxxxxxxxx> wrote:
> It is commented out because I am using "mysql_connect...."
> I don't think it would be good to use both, since the db1 references
> another db. But even when I use the db1.php and change the database and
> table, I get the same error message.
>
> But what I did miss is my typo in "What is wrond with this file?" :-)
>> Hi PJ,
>> Could it be that you have "//include ("lib/db1.php"); " commented
>> out? Try uncommenting that line and see what happens. The error
>> message will always print because the query is never executing
>> properly if you have the db connections file commented out.
>>
>> On Thu, Feb 26, 2009 at 12:28 PM, PJ <af.gourmet@xxxxxxxxxxxx> wrote:
>>> What is wrond with this file? same identical insert works from console
>>> but not from this file :-(
>>>
>>> <html>
>>> <head>
>>> <title>Untitled</title>
>>> </head>
>>>
>>> <body>
>>> <?
>>> //include ("lib/db1.php"); // Connect to database
>>> mysql_connect('biggie', 'user', 'password', 'test');
>>> $sql1 = "INSERT INTO example (name, age) VALUES ('Joe Blow', '69')";
>>> $result1 = mysql_query($sql1,$db);
>>> if (!$result1) {
>>> echo("<P>Error performing 1st query: " .
>>> mysql_error() . "</P>");
>>> exit();
>>> }
>>> ?>
>>>
>>> </body>
>>> </html>
>>>
>>> Seems to be good to print out the error message, but that's all. db not
>>> written.
>>>
>>> --
>>>
>>> Phil Jourdan --- pj@xxxxxxxxxxxxx
>>> http://www.ptahhotep.com
>>> http://www.chiccantine.com
>>>
>>>
>>> --
>>> MySQL General Mailing List
>>> For list archives: http://lists.mysql.com/mysql
>>> To unsubscribe:
>>> http://lists.mysql.com/mysql?unsub=dsteplight@xxxxxxxxx
>>>
>>>
>>
>
>
> --
>
> Phil Jourdan --- pj@xxxxxxxxxxxxx
> http://www.ptahhotep.com
> http://www.chiccantine.com
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
