[Resolved] results of select query

[Tigress7]

I have a couple of select queries and I would like to echo the results but I can't seem to. I know you can use the mysql_fetch_array() function, mysql_result() funct and mysql_fetch_object(), but I don't quiter understand how to use them. I attempted it however in my script and it told me it wasn't 'a valid result resource'. Anyone know how to echo the results properly? here is script

$getmanagerid=mysql_query("SELECT managerid FROM personal WHERE nameid='$nameid'");

$getmanager=mysql_query("SELECT username FROM personal WHERE nameid=$getmanagerid");

echo mysql_fetch_object($getmanager);

thx in adv.🙂

[tekky]

$results =mysql_query("SELECT managerid, username, nameid FROM personal WHERE nameid='$nameid'");
/* ^^^ get all the data at once, note you must SELECT the
     column you are using in your WHERE clauses also otherwise
     mySQL cant see that value to compare it
 */
while($rows=mysql_fetch_assoc($result))
{
     extract($rows); //make $rows['managerid'] available as $managerid, etc etc.
     echo "mgr_id=$managerid<br>mgr_name=$username<br><br>\n"; //output the values
}

you have to "fetch" the results as rows (an array basically) and then read data from those rows

Goodluck Tigress 🙂

[superwormy]

www.php.net/mysql_fetch_array
www.php.net/mysql_query

$result = mysql_query ("SELECT * FROM tablename");
while ($array = mysql_fetch_array ($result)) {

print ($array['my_first_field_name'] . ", " . $array['my_second_field_name'] . "<br />");

}

[Tigress7]

Thanks guys but none of it works. I have to select them seperatley tekky because of this: The user gives me their nameid, and i match this to their managerid in the columns. Next I find out where managerid=nameid to see who their manager is and lastly i look at the username of their manager, which is what i need. Therefore i did the sql statement like so above, but can't seem to get results from it!

once again thanks for taking the time on this.

[tekky]

post what you currently have then

[loureiro]

$query = "select field from table";
$result = mysql_query($query, $dbh);
$final = mysql_fetch_array($result);

echo $final[0];

you can only use this if you know you will get only one result. if you have more you have to throw it into another array and then run a for loop or something to extract the results

hope that helps!

[Tigress7]

Okay i got it! Thanks for the help everyone!