sessions and id continuing

rdkd1970

Can someone help me with this error message...I tried another layout but I think I am getting the same problem where it is not recognizing the next page of the sessions and including the id for a member to continue

Invalid query:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #4' at line 1 Whole query:Resource id #4

This is the page.

<?php
session_start();
?>
<?php
ini_set ("display_errors", "1");
error_reporting(E_ALL);
?>		
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Welcome</title>
</head>

<body>
<?php
/* Program: login.php
 * Desc:	Displays the new member welcome page. Greets
 *			member by name and gives a choice to enter
 *			restricted section or go back to main page.
 */ 
include('Connections/connect_to_mysql.php'); 

$id = '';
$firstname = '';
$lastname = '';
$country = '';
$email = '';

//Formulate Query
//This is the best way to perform an SQL query
 $query = mysql_query("SELECT id,firstname FROM `Members` WHERE id='%s' AND firstname='%s'");

 //Perform Query
 $result = mysql_query($query);

//Check result
//This shows the actual query sent to MySQL and the error. Useful for debugging.

if(!$result){
	$message = 'Invalid query:' . mysql_error() . "\n";
	$message .= 'Whole query:' . $query;
	die($message);
}
//Use result
//Attempting to print $result won't allow access to information in the resource
//One of the mysql result functions must be used
//See also mysql_result(), mysql_fetch_array(), mysql_fetch_row(), etc.
while($row=mysql_fetch_assoc($result)){
	echo Welcome, $row['firstname'];
}
//Free the resources associated with the result set
mysql_free_result($result);

?>
<p>Your new Member accounts lets you enter the members only section
of our web site. You'll find special discounts, a profile of matches,
live advise from experts, and much more.</p>
<p>Your new Member ID and password were emailed to you. Store them
carefully for future use.</p>
<div style="text-align: center">
<p style="margin-top: .5in; font-weight: bold">
Glad you could join us!</p>
<form action="profile.php" method="post">
	<input type="submit"
		value="Enter the Members Only Section">
		</form>
<form action="index.php" method="post">
	<input type="submit" value="Go to Main Page">
	</form>		
		</div>
</body>
</html>

johanafm

You are querying the database twice. First, you query it using a SQL query. This time around mysql_query returns a result set resource (not a string, but converted to "Resource id #4" or something similar when used in a string context) which you send as a query to the database.

//Perform Query - makes sense
$query = mysql_query("SELECT id,firstname FROM `Members` WHERE id='&#37;s' AND firstname='%s'");

//Perform Query - makes no sense
$result = mysql_query($query); 

// But you could...
$query = "SELECT id,firstname FROM `Members` WHERE id='%s' AND firstname='%s'";
$result = mysql_query($query);

rdkd1970

I made these changes and now get this following messages

It now welcomes everyone at the same time.

//Formulate Query
//This is the best way to perform an SQL query
$query = "SELECT id, firstname FROM `Members` WHERE id={$_SESSION['id']}";

$result = mysql_query($query);

//Check result
//This shows the actual query sent to MySQL and the error. Useful for debugging.

if(!$result){
	$message = 'Invalid query:' . mysql_error() . "\n";
	$message .= 'Whole query:' . $query;
	die($message);
}
//Use result
//Attempting to print $result won't allow access to information in the resource
//One of the mysql result functions must be used
//See also mysql_result(), mysql_fetch_array(), mysql_fetch_row(), etc.
while($row=mysql_fetch_assoc($result)){
	echo "Welcome, {$row[firstname]}";
}
//Free the resources associated with the result set
mysql_free_result($result);

rdkd1970

Okay I added the password field to my form now I get this message. It is not welcoming everyone but is error

Column count doesn't match value count at row 1
:rolleyes:

johanafm

That's when your query doesn't include the same number of columns as it provides values. For example INSERT INTO myTable (field1, field2) VALUES (onlyOneValue).

rdkd1970

I took your advise and changed the query

I am getting this error message

Column count doesn't match value count at row 1

I checked my phpmyadmin SQL it is laid out like SELECT * FROM Members WHERE 1

rdkd1970

This is my form with my insert

$results = mysql_query("INSERT INTO Members (firstname,lastname,country,Email) 
                    values ('".mysql_real_escape_string($_POST["firstname"])."','".mysql_real_escape_string($_POST["lastname"])."','".mysql_real_escape_string($_POST["password"])."','".mysql_real_escape_string($_POST["country"])."','".mysql_real_escape_string($_POST["email"])."')")
					or die (mysql_error());

rdkd1970

Okay I forgot to have password in the insert. I added it and it shows the page but not the Welcome, firstname.