problem with function to call query

habs20

Hi I need help with the following function:

function getsubact ($snam) {
$query = "SELECT files.id, files.snam, files.acct, files.doc_date, files.flag, files.file, files.rep_id, files.mgr_id, files.lname, files.mkval, files.dir FROM files WHERE files.snam = '$snam' ";
return;
}

This function is called when the use clicks on the "C" by click on the C the user is asking for all records that share $snam in the snam field of the mysql db.

What I am trying to do I get the function to display the new results to the same page buy using a new query, but with now
luck.

Any suggestion are a point in the correct direction will be appreciated.

sijis

i think your problem is that you are not returning a value in your function.

your function should be able to return a value. It looks like this:

function getsubact ($snam) { 
$query = "SELECT files.id, files.snam, files.acct, files.doc_date, files.flag, files.file, files.rep_id, files.mgr_id, files.lname, files.mkval, files.dir FROM files WHERE files.snam = '$snam' "; 
return $query; //return the $query string to whatever called this function. :)
}

you must realize that this function will return this string:
SELECT files.id, files.snam, files.acct, files.doc_date, files.flag, files.file, files.rep_id, files.mgr_id, files.lname, files.mkval, files.dir FROM files WHERE files.snam = '2'

since i'm not sure exactly what you are doing, besides trying to get all the record if a user click on a link, i can't help you further. But i will honestly say, you are most likely heading in the wrong direction.

i'm thinking something like this:

if($value =="yes"){
//show link with all values
// <a href='list_all.php'>List all</a>
// here you just use the sql query that is in the function, i suppose
}
else {
// show regular link
}

habs20

Thanks for the input! So if I use the href to point to a new page, how can I pass a variable to the sql query from the first page results to the second page.

Thanks for your help

mo0ness

Just 2 say..
You can select all columes from a table by replacing all the colume names with "" (without quotes); ie: "select from table" instead of "select col1, col2, col3, col4 " etc.

I know its "off-topic" but just incase u didnt know 🙂

kellog

Originally posted by habs20
Thanks for the input! So if I use the href to point to a new page, how can I pass a variable to the sql query from the first page results to the second page.

<td align="center" width="100"><?echo "<a href=\"$dir/$file\" target=\"_blank\">$acct</a>"; if ($flag == "Y"){ echo "<A HREF=\"newpage.php\"> C</A>"; }?></td>

Thanks for your help

Can try something like this:

Page1

<a href="somePage.php?Var=SomeValue">Click Here</a>

Page2

<?
Function SomeFunction(Var)
{

}

//Now, call the function and pass the variable from the first page in
SomeFunction($_GET[Var]);
?>

habs20

Thanks for the input! So if I use the href to point to a new page, how can I pass a variable to the sql query from the first page results to the second page.

Thanks for your help

mo0ness

Example of passing a variable via url:


$var1 = "2"; // the value of $var1 is 2

echo "<a href=\"page.php?varname=$var1\">link</a>";

Here, the $var1 is the variable, its value is 2. Ur aim is to pass this to another page. You do this by including it in the url.

varname can be anythining u want, its value must be $var1 if thats what u wish to pass to the next page. So on page.php, say u wanted 2 print the value of $var1, you would simply echo "$varname"; <-- the variable name assigned to the value of $va1 carried via the url 🙂

Use the above method. But there is a built-in php functin called urlencode();

Example:


$varname = "varnames value";

$varname = urlencode($varname);

echo "<a href=\"page.php?var=$varname\">link</a>";

This method is kinda the same really, but personally I wud go for the first method, the second method was just 2 inform you of the urlencode(); function. 🙂