<?php 
        $username = $_SESSION['username'];
        $result = 'sample';
        $con = mysql_connect("localhost","root","");

        if (!$con)
        {
        die('Could not connect: ' . mysql_error());
        }

        $sql = "Select FirstName from Person Where LoginID = (Select LoginID from UserLogin Where Username = '$username')";
        $result = mysql_query($sql,$con);

        echo $result;
?>

I'm kinda new to this server-side scripting language (php) and I've been burning the midnight oil trying to figure out, how to get my single value result to display... perhaps any of you out there could help me solve this problem? I would appreciate all the help I can get.

Recommended Answers

mysql_query returns a resource datatype on success, which is not simply printable like you are trying …

Jump to Post

Looks like an error occurred. Did you use mysql_select_db ?

Jump to Post

All 7 Replies

Re: Unable to 'echo' my result 80 80

mysql_query returns a resource datatype on success, which is not simply printable like you are trying to do.

You need to call either mysql_fetch_array or mysql_fetch_assoc passing the $result to that function, which will return each row as an Array structure that can be iterated and printed as any typical array.

Example:

$sql = "Select FirstName from Person Where LoginID = (Select LoginID from UserLogin Where Username = '$username')"

$result = mysql_query($sql,$con);

while ($row = mysql_fetch_assoc($result)) {
    echo $row["FirstName"];
}
Re: Unable to 'echo' my result 80 80

$result will returns as resource type.

Better try this,

while($Row = mysql_fetch_array($result)) {
   echo $Row['FirstName'];
}
Re: Unable to 'echo' my result 80 80

Thanks for the replies gentlemen,

okay, I've done as recommended but in return I would get the following warning message upon execution:-

"Warning: mysql_fetch_assoc() expects parameter 1 to be resource, string given..."

am I on the right course, or am I getting farther away from my expected result?

Re: Unable to 'echo' my result 80 80

Looks like an error occurred. Did you use mysql_select_db ?

commented: of course! it would seem that I have forgotten about selecting my database! +0
Re: Unable to 'echo' my result 80 80

@pritaeas: I don't think I have used "mysql_select_db".

actually i'm not entirely sure if my connection has been properly established, because I don't really understand the steps required in making the connection to a database. I only took code snippets from here and there and assumed that it was all i need to get things to work.

Re: Unable to 'echo' my result 80 80

Have a look at this code snippet then.

Re: Unable to 'echo' my result 80 80

@pritaeas: of course! I finally understand what I am missing out on. Thank you for mentioning it!

it would seem that I have forgotten to select my database after making the connection! it was a silly mistake on my part.

Thanks guys!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.