List:General Discussion« Previous MessageNext Message »
From:Darryle Steplight Date:February 26 2009 6:08pm
Subject:Re: catch the error
View as plain text  
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@stripped> 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@stripped> 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@stripped
>>>   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=1
>>>
>>>
>>
>
>
> --
>
> Phil Jourdan --- pj@stripped
> http://www.ptahhotep.com
> http://www.chiccantine.com
>
Thread
catch the errorPJ26 Feb
  • Re: catch the errorDarryle Steplight26 Feb
    • Re: catch the errorPJ26 Feb
      • Re: catch the errorJim Lyons26 Feb
        • Re: catch the errorPJ26 Feb
      • Re: catch the errorDarryle Steplight26 Feb
        • Re: catch the errorPJ26 Feb
  • Re: catch the errorRicardo Dias Marques26 Feb
    • Re: catch the errorPJ26 Feb
      • Re: catch the errorDarryle Steplight26 Feb
  • RE: catch the errorJerry Schwartz26 Feb
    • Re: catch the errorPJ26 Feb
  • Re: catch the error [OFF TOPIC]Claudio Nanni26 Feb