alright apparantly the problem I had before was due to a bit of error in the way I was calling something, but I have a new problem now. It is very similar to the other problem I was having before with mswl_fetch_row... it seems so simple yet it jsut is broken. Okay I hope someone can help me, and I wish I could jsut get whatever it is I have wrong. thanks guys.
if ($_GET['userid']) {
$pname = @mysql_query("SELECT * FROM users WHERE userId = '" . $_GET['userid'] . "'");
while ($myrow = mysql_fetch_row( $pname2 ))
{
?>
User Name: <?php echo "$myrow[1]";?><br><br>
Age: <?php echo "$myrow[8]";?><br><br>
Location: <?php echo "$myrow[7]";?><br><br>
Membership Status: <?php echo "$myrow[3]";?><br><br>
<?php
} } else {
echo "nothing";
}
gives me:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\phpdev5\www\prp\viewprofile.php on line 15
Any ideas? the last issue I had with this required that I place
$pname = @mysql_query("SELECT * FROM users WHERE userId =
this was the problem, I was missing some single quotes in '" . $variable . "'");
'" . $_GET['userid'] . "'");
But this doesn't seem to be the issue here. Thanks guys!
