function problems

[Anon]

before i start i would like you to know that i did search both here and on google for this but couldnt find an answer.

I would like to create a function to get info out of the database. so i can print the values of the fields.

can some one please help me out here. I will be including a file that has the function in it, and then i would need to print some info on various pages.

[rulian]

okay, sounds simple. basically, let's say since your including files, we'll set it up like this:
page one, is page we're on
function.php is the file were calling:

first, make sure your connected to the database:
include ('connect.php') //- you know just make a quick connection file to include as well.

// function.php -- were in the file being called now

function getinfo(){
global $variables, $whatever, $youwant;
$query=mysql_query("select * from table");
$amount=mysql_num_rows($query);

let's say your displaying a re-occuring informatino table, like a user's list:

for ($i=0; $i<$amount; $i++){
$name=mysql_result($query, $i, 'name');
$email=mysql_result($query, $i, 'email);
echo $name;
echo $email;
}
}
or you just want to display once:
$name=mysql_result($query, 0, 'name);
$email=mysql_result($query,0,'email');

at which point $amount will not be needed.

//pageone.php
<?php
include ('connect.php');
include ('funciton.php');
?>
hope that helps, let me know if you need anythign else.

[Anon]

thats good, but i need something a little different.

function user_getallinfo(){
connect to the database;
sql
result

but that is where i get stuck. i have a user_name stored in a cookie so i can select * from users where user_name = $user_name

but i want to be able to to call various field values from different pages.

like pageone.php
user_getallinfo($user_id,$real_name);
print("$user_id hello $real_name");

and pagetwo.php might be..
user_getallinfo($user_email);
print("your email address is $user_email");

like that .. does that make any since??

[rulian]

i think i got what your trying to say.
So the function makes a query, but you want to be able to get what you want out of it. Well, what we could do is set up the function so that it gets the user you want, and performs the tast you desire, which is what i think you want. so let's try something like this:

$perform='realname';

function getinfo($username, $perform);
echo $insidevar;

//function
so inside the function, your going to have to make the switch of which function you want to perform. For example:

switch ($perform){
case "realname":
$query=mysql_query("select realname from users where username='$username'")
$insidevar=mysql_result($query,0,'realname');
break;
case""""
and so fourth, but do this only if you want to set up different searches for different options

because it could be alot cleaner if you run a query with variables that determine what it searches for, like so:
$query=mysql_query"select $perform from users where username = '$username'");
$result=mysql_result($query,0,'$perform');

that way, if perform is realname, it will get the realname column and set it up as a variable.
use the switch if you simply want to run different functions for different scenarios.
Hope this helps, let me know if you need anything else.