Viewing a profile

[chrisC]

Im having problems displaying the fields of a persons profile that someone is friends with on the database.

When I click the persons profile it comes up with the following

 

Name:

birthday:

interests:

 

No information appears why is this???

 

<?php

session_start();

if ( !isset ($_SESSION["gatekeeper"]))

{

    echo "Sorry, You are not logged in please try again! <a href=\"home.html\">login</a> ";

}

else

{

 

?>

 

<?php

$a = $_SESSION["gatekeeper"];

$b = $_GET["username"];

echo "You are viewing $b profile:";

 

$conn = mysql_connect("localhost", "ccheckley", "4aPRaJew");

mysql_select_db("ccheckley");

 

$result = mysql_query("SELECT name FROM users WHERE username='$b'");

$row = mysql_fetch_array($result);

echo "<br />name: $row[name]";

 

$result2 = mysql_query("SELECT username FROM users WHERE username='$b'");

$row = mysql_fetch_array($result2);

echo "<br />username: $row[username]";

 

$result3 = mysql_query("SELECT birthday FROM users WHERE username='$b'");

$row = mysql_fetch_array($result3);

echo "<br />birthday: $row[birthday]";

 

$result4 = mysql_query("SELECT interests FROM users WHERE username='$b'");

$row = mysql_fetch_array($result4);

echo "<br />interests: $row[interests]";

 

 

 

?>

 

 

<?php

}

?>

[allworknoplay]

  Quote

Im having problems displaying the fields of a persons profile that someone is friends with on the database.

When I click the persons profile it comes up with the following

 

Name:

birthday:

interests:

 

No information appears why is this???

 

<?php

session_start();

if ( !isset ($_SESSION["gatekeeper"]))

{

    echo "Sorry, You are not logged in please try again! <a href=\"home.html\">login</a> ";

}

else

{

 

?>

 

<?php

$a = $_SESSION["gatekeeper"];

$b = $_GET["username"];

echo "You are viewing $b profile:";

 

$conn = mysql_connect("localhost", "ccheckley", "4aPRaJew");

mysql_select_db("ccheckley");

 

$result = mysql_query("SELECT name FROM users WHERE username='$b'");

$row = mysql_fetch_array($result);

echo "<br />name: $row[name]";

 

$result2 = mysql_query("SELECT username FROM users WHERE username='$b'");

$row = mysql_fetch_array($result2);

echo "<br />username: $row[username]";

 

$result3 = mysql_query("SELECT birthday FROM users WHERE username='$b'");

$row = mysql_fetch_array($result3);

echo "<br />birthday: $row[birthday]";

 

$result4 = mysql_query("SELECT interests FROM users WHERE username='$b'");

$row = mysql_fetch_array($result4);

echo "<br />interests: $row[interests]";

 

 

 

?>

 

 

<?php

}

?>

 

Your $row's are calling from the first query, not each individual query...

 

 

 

[allworknoplay]

Should be:

 

 

$result = mysql_query("SELECT name FROM users WHERE username='$b'");
$row = mysql_fetch_array($result);
echo "<br />name: $row[name]";

$result2 = mysql_query("SELECT username FROM users WHERE username='$b'");
$row2 = mysql_fetch_array($result2);
echo "<br />username: $row2[username]";

$result3 = mysql_query("SELECT birthday FROM users WHERE username='$b'");
$row3 = mysql_fetch_array($result3);
echo "<br />birthday: $row3[birthday]";

$result4 = mysql_query("SELECT interests FROM users WHERE username='$b'");
$row4 = mysql_fetch_array($result4);
echo "<br />interests: $row4[interests]"

[chrisC]

still no information appeared ???

[Drewser33]

Possibly an easier way with less sql:

$result = mysql_query("SELECT name, username, interests, birthday FROM users WHERE username='$b'");

$row = mysql_fetch_array($result);

echo "<br />name: $row['name']";

echo "<br />name: $row['username']";

echo "<br />name: $row['birthday']";

echo "<br />name: $row['interests']";

 

NOTE the single quotes around your fieldnames following the row.

[allworknoplay]

  Quote

still no information appeared ???

 

Ok, well I am assuming that your GET[username] variable works?

 

What happens when you echo out $b??

[chrisC]

  Quote

Possibly an easier way with less sql:

$result = mysql_query("SELECT name, username, interests, birthday FROM users WHERE username='$b'");

$row = mysql_fetch_array($result);

echo "<br />name: $row['name']";

echo "<br />name: $row['username']";

echo "<br />name: $row['birthday']";

echo "<br />name: $row['interests']";

 

This also didnt show up right :S

 

NOTE the single quotes around your fieldnames following the row.

[Drewser33]

Try

$result = mysql_query("SELECT name, username, interests, birthday FROM users WHERE username='$b'");

$row = mysql_fetch_array($result);

echo '<br />'.'name: '.$row['name'];

echo '<br />'.'name: '.$row['username'];

echo '<br />'.'name: '.$row['birthday'];

echo '<br />'.'name: '.$row['interests'];

[Philip]

<?php
session_start();
if(!isset ($_SESSION["gatekeeper"]))
{
    echo "Sorry, You are not logged in please try again! <a href=\"home.html\">login</a> ";
}
else
{

?>

<?php
$a = $_SESSION["gatekeeper"];
$b = $_GET["username"];
echo "You are viewing $b profile:";

$conn = mysql_connect("localhost", "*****", "******"); // dont forget to change password 
mysql_select_db("ccheckley");

$result = mysql_query("SELECT `name`,`birthday`, `interests` FROM `users` WHERE `username`='$b' LIMIT 1") or die(mysql_error());
$row = mysql_fetch_array($result);
echo '<br />name: ',$row['name'];
echo '<br />username: ',$b;
echo '<br />birthday: ',$row['birthday'];
echo '<br />interests: ',$row['interests'];

?>


<?php
}
?>

 

A few things I noticed... You can condense that query into 1 query, and you can use LIMIT, since you were only needing one row. Also, no need to call username, if $b is username

 

If that doesn't work:

find:

$row = mysql_fetch_array($result);

replace with:

$row = mysql_fetch_array($result);
echo '<pre>'; print_r($row); echo '</pre>';

[chrisC]

  Quote

Try

$result = mysql_query("SELECT name, username, interests, birthday FROM users WHERE username='$b'");

$row = mysql_fetch_array($result);

echo '<br />'.'name: '.$row['name'];

echo '<br />'.'name: '.$row['username'];

echo '<br />'.'name: '.$row['birthday'];

echo '<br />'.'name: '.$row['interests'];

 

:'( nope, im soo confused???

[allworknoplay]

Do this:

 

 

 

$result = mysql_query("SELECT name, username, interests, birthday FROM users WHERE username='".$b."' ");
$row = mysql_fetch_array($result);
echo "<br />name: $row['name']";
echo "<br />name: $row['username']";
echo "<br />name: $row['birthday']";
echo "<br />name: $row['interests']";

[chrisC]

  Quote

<?php
session_start();
if(!isset ($_SESSION["gatekeeper"]))
{
    echo "Sorry, You are not logged in please try again! <a href=\"home.html\">login</a> ";
}
else
{

?>

<?php
$a = $_SESSION["gatekeeper"];
$b = $_GET["username"];
echo "You are viewing $b profile:";

$conn = mysql_connect("localhost", "*****", "******"); // dont forget to change password 
mysql_select_db("ccheckley");

$result = mysql_query("SELECT `name`,`birthday`, `interests` FROM `users` WHERE `username`='$b' LIMIT 1") or die(mysql_error());
$row = mysql_fetch_array($result);
echo '<br />name: ',$row['name'];
echo '<br />username: ',$b;
echo '<br />birthday: ',$row['birthday'];
echo '<br />interests: ',$row['interests'];

?>


<?php
}
?>

 

A few things I noticed... You can condense that query into 1 query, and you can use LIMIT, since you were only needing one row. Also, no need to call username, if $b is username

 

If that doesn't work:

find:

$row = mysql_fetch_array($result);

replace with:

$row = mysql_fetch_array($result);
echo '<pre>'; print_r($row); echo '</pre>';

 

this was what I was going for, but this came up with a whole load of errors

[Philip]

What errors?

[chrisC]

  Quote

Do this:

 

 

 

$result = mysql_query("SELECT name, username, interests, birthday FROM users WHERE username='".$b."' ");
$row = mysql_fetch_array($result);
echo "<br />name: $row['name']";
echo "<br />name: $row['username']";
echo "<br />name: $row['birthday']";
echo "<br />name: $row['interests']";

 

i got an error on this line echo "<br />name: $row['name']";

 

[chrisC]

  Quote

What errors?

 

sorry i cant remember so many replys to this post!

[allworknoplay]

  Quote

  Quote

Do this:

 

 

 

$result = mysql_query("SELECT name, username, interests, birthday FROM users WHERE username='".$b."' ");
$row = mysql_fetch_array($result);
echo "<br />name: $row['name']";
echo "<br />name: $row['username']";
echo "<br />name: $row['birthday']";
echo "<br />name: $row['interests']";

 

i got an error on this line echo "<br />name: $row['name']";

 

 

Why are you putting a slash (/) in your BR tag?

[Philip]

  Quote

  Quote

  Quote

Do this:

 

 

 

$result = mysql_query("SELECT name, username, interests, birthday FROM users WHERE username='".$b."' ");
$row = mysql_fetch_array($result);
echo "<br />name: $row['name']";
echo "<br />name: $row['username']";
echo "<br />name: $row['birthday']";
echo "<br />name: $row['interests']";

 

i got an error on this line echo "<br />name: $row['name']";

 

 

Why are you putting a slash (/) in your BR tag?

@allwork:

In xhtml you have to close the tags, thus requiring a />

  Quote

C.2. Empty Elements

 

Include a space before the trailing / and > of empty elements, e.g. <br />, <hr /> and <img src="karen.jpg" alt="Karen" />. Also, use the minimized tag syntax for empty elements, e.g. <br />, as the alternative syntax <br></br> allowed by XML gives uncertain results in many existing user agents.

 

 

@OP: we're pretty much giving you the same code. Do you get any errors when you run:

<?php
session_start();
if(!isset ($_SESSION["gatekeeper"]))
{
    echo "Sorry, You are not logged in please try again! <a href=\"home.html\">login</a> ";
}
else
{

?>

<?php
$a = $_SESSION["gatekeeper"];
$b = $_GET["username"];
echo "You are viewing $b profile:";

$conn = mysql_connect("localhost", "*****", "******"); // dont forget to change password 
mysql_select_db("ccheckley");

$result = mysql_query("SELECT `name`,`birthday`, `interests` FROM `users` WHERE `username`='$b' LIMIT 1") or die(mysql_error());
$row = mysql_fetch_array($result);
echo '<br />name: ',$row['name'];
echo '<br />username: ',$b;
echo '<br />birthday: ',$row['birthday'];
echo '<br />interests: ',$row['interests'];

?>


<?php
}
?>

[allworknoplay]

  Quote

C.2. Empty Elements

 

Include a space before the trailing / and > of empty elements, e.g. <br />, <hr /> and <img src="karen.jpg" alt="Karen" />. Also, use the minimized tag syntax for empty elements, e.g. <br />, as the alternative syntax <br></br> allowed by XML gives uncertain results in many existing user agents.

 

 

 

HMMM....you learn something new everyday!