Problem with Login/Registration System

[sheaguevara]

This is my first post onto the forum. So first off, I'd like to say hello to everyone.

I just started working on a login/registration system and I am trying to have a feature where the user will login and they can see all of their information about their account (e-mail, website, state, etc.). Unfortunately I have something wrong with the code and I keep receiving the following error message.

"Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/home/cyphrs07/public_html/database/memberspage.php on line 38"

Obviously something is wrong with the SQL query. I've tried messing around with all sorts of different variables and structures for the query but to no avail. Here is the code below.

<?php 
// Database connection
$dbhost = "localhost";
$dbname = "********";
$dbuser = "*******";
$dbpass = "*********";
 
mysql_connect($dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());
 
// Check for cookie, if cookie exists, set variable
if(!empty($_COOKIE['electionday'])) {
 
#######PROBLEM############
// Grab information about user
$check = mysql_query("SELECT * FROM users WHERE userid = '$electionday'")or die(mysql_error());
$result = mysql_query($check);
$num = mysql_num_rows($result); 
######PROBLEM#############
 
// Loop for grabbing results
$i=0;
while ($i < $num) {
$userid=mysql_result($result,$i,"userid");
$datejoined=mysql_result($result,$i,"datejoined");
$name=mysql_result($result,$i,"name");
$country=mysql_result($result,$i,"country");
$state=mysql_result($result,$i,"state");
$zip=mysql_result($result,$i,"zip");
$im=mysql_result($result,$i,"im");
$website=mysql_result($result,$i,"website");
$politics=mysql_result($result,$i,"politics");
$privemail=mysql_result($result,$i,"privemail");
$pubemail=mysql_result($result,$i,"pubemail");
$dob=mysql_result($result,$i,"dob");
$college=mysql_result($result,$i,"college");
$occupation=mysql_result($result,$i,"occupation");
$gender=mysql_result($result,$i,"gender");
$marital=mysql_result($result,$i,"marital");
?>
<p>User Name: <?php echo "$userid"; ?></p>
<p>Member Since: <?php echo "$datejoined"; ?></p>
<p>Real Name: <?php echo "$name"; ?></p>
<p>Country: <?php echo "$country"; ?></p>
<p>State: <?php echo "$state"; ?></p>
<p>Zip Code: <?php echo "$zip"; ?></p>
<p>Instant Messaging: <?php echo "$im"; ?></p>
<p>Website: <?php echo "$website"; ?></p>
<p>Politics: <?php echo "$politics"; ?></p>
<p>E-Mail for Password: <?php echo "$privemail"; ?></p>
<p>Public E-Mail: <?php echo "$pubemail"; ?></p>
<p>Date of Birth: <?php echo "$dob"; ?></p>
<p>College: <?php echo "$college"; ?></p>
<p>Occupation: <?php echo "$occupation"; ?></p>
<p>Gender: <?php echo "$gender"; ?></p>
<p>Status: <?php echo "$marital"; ?></p>
<?php
++$i;
}
mysql_close();
 
// Display error message
} else {
echo "You are not logged in, please log in below.<br><br>";
include 'login.php';
}
?>
 

If anyone can help me it would be much appreciated, I'm trying to get this done within the next few days. Thank you.

[pbmods]

Heya, sheaguevara. Welcome to TSDN!

The only valid MySQL resource identifier in your code is $check, not $result. You only need to call mysql_query() once per query.

You may also find mysql_fetch_assoc() to be a more efficient way to fetch your result set.

[sheaguevara]

Thanks for the advice! Everything seems to be working now!