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,active,expi
| re_date) VALUES
| ('$first','$last','$position','$organization','$address','$postal_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','$skill_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
