You could just do this:
$result = ($sql3);
echo "$result";
----- Original Message -----
From: "Michael Brunson" <[EMAIL PROTECTED]>
To: "Matt Rudderham" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 02, 2002 1:35 PM
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,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
>
---------------------------------------------------------------------
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
