results is failing

rdkd1970

Hi I am not sure what I am doing wrong can someone help me. I have been getting this result error when I submit the form.

Warning: Wrong parameter count for mysql_result() in login.php on line 25 Could not execute query

YES I DO HAVE THE PHP? CODES IN ANY HELP WOULD MAKE ME SO HAPPY
if (@$_SESSION['auth'] != "yes")

@include('Connections/connect_to_mysql.php');
$query = "SELECT firstName, lastName FROM Members
WHERE email='{$_SESSION['id']}'";
$result = mysql_result($query)
or die("Could not execute query");
echo "<html>
<head><title>New Member Welcome</title></head>
<body>
<h2 style='margin-top: .7in; text-align: center'>
Welcome $firstName </h2>\n";

rdkd1970

I forgot in Chrome it is not downloading but in IE it downloads but does not show the next page.

bradgrafelman

[man]mysql_result/man expects to be given a resource returned by [man]mysql_query/man. You, however, are simply passing it a string.

rdkd1970

I am not sure what you mean. sort of new to this php

Derokorian

$result = mysql_query($query) or die('Could not execute query.');

instead of mysql_result call.