Hi, That's not a Mysql error, it's an error from the language you are using (i suppose it's PHP). You did not define $dbconn. You're mixing functional programming with object oriented programming (i think). Instead of > $result=$dbconn->Execute("update info set .........
Try $result=mysql_query("update info set ......... or $result=mysql_query("update info set .........",$link); Check the PHP Manual. On Tue, 2002-04-16 at 05:40, bob nt wrote: > i get an error like > > Fatal error: Call to a member function on a non-object > in the line > $result=$dbconn->Execute("update infotab set > infomessage='$file_name' WHERE info_id='$ypid'"); > here $ file_name returns a file name like mirror.txt > or x.gif. & it is doing so. > what's the probs can u help me? > the code i have writtenm is > ------------------------------------------------------- > $user="root"; > $pass=""; > $db="Phyzone2"; > $link=mysql_connect("localhost",$user,$pass); > if(!$link) > die ("couldn't connect to MYSQL"); > mysql_select_db($db,$link) > or die ("couldn't open $db:".mysql_error()); > echo $file_name; > $result=$dbconn->Execute("update info set > infomessage='$file_name' WHERE info_id='$ypid'"); > ------------------------------------------------------ > plz respond me to [EMAIL PROTECTED] > i badly need this > tnx > bobbie > > __________________________________________________ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- dsoares (sql) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php