D'oh. Meant to call mysql_query! Thanks! - Matt
"Bonum volens duceris in Tartarum" > -----Original Message----- > From: Michael Brunson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 02, 2002 3:36 PM > To: Matt Rudderham > Cc: [EMAIL PROTECTED] > Subject: Re: Could you look at this PHP/MySQL Code? > > > On Wed, 2 Jan 2002 15:30:51 -0400, "Matt Rudderham" > <[EMAIL PROTECTED]> wrote: > > | Hi, > | This is generating an error: > | > | Warning: Wrong parameter count for mysql_result() in > | /usr/local/www/html/matt/add.php on line 27 > | > | I can't figure out what the problem is, here is the code in > question, > | it is part of an HTML form: > | > | <--Snip connect etc.. --> > | // process form > | > | $sql = "INSERT INTO members > | > (first,last,position,organization,address,postal_code,county,phone,fax > | ,e > | > mail,website,member_type,on_directory,on_website,description,a > ctive,expi > | re_date) VALUES > | > ('$first','$last','$position','$organization','$address','$pos > tal_code', > | '$county','$phone','$fax','$email','$website', > | > '$member_type','$on_directory','$on_website','$description','$ > active','$ > | expire_date')"; > | $result = mysql_query($sql); > | echo "Member Added\n"; > | $sql2 = "select max(member_id) from members"; > | $member_id = mysql_query($sql2); > | echo "$member_id"; > | $sql3 = "INSERT INTO skills (member_id, name, schooling, > | certifications, description) VALUES > | > ('$member_id','$skill_name','$schooling','$certifications','$s > kill_descr > | iption')"; > | $result = mysql_result($sql3); > | echo "$result"; > | ?> > > http://www.php.net/manual/en/function.mysql-result.php mixed mysql_result (resource result, int row, mixed [field]) Requires at least 2 arguments. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Intercosmos Media Group, Inc. --- www.intercosmos.com www.directnic.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