Best Way to do this. Some Help here..

bimmer528

I am trying to clean up a script consisting of several pages. What I would idealy like to do is create a page with all my sql queries and include it in all my pages. Reason being.. alot of differant pages with the same type of query needed. What is the best method of doing this? I am having problems with the loops....

$sql = "SELECT * FROM table GROUP BY name ORDER BY name LIMIT 5";
$result = $DB->query($sql);
while($row = mysql_fetch_array($result)){
$name = $row['name'];
echo $name;  // here i can echo this since in the loop. 
}

Problem is if I were to include my query page in another page,
$name = $row['name']; no longer exists and cant do another loop.

Any help on how I should do this would be apprieciated.

thx

iNFERiON

What you'd best do is put $row['name'] in a session, so it is remembered on every page within your site.

Make your page look something like this

if(!session_id()){
  session_start();
}
$_SESSION['name'] = $row['name'];
$sql = "SELECT * FROM table GROUP BY name ORDER BY name LIMIT 5"; 
$result = $DB->query($sql); 
while($row = mysql_fetch_array($result)){ 
echo $_SESSION['name']; }

and everytime you want to call $row['name'] back, you just use $_SESSION['name'] instead, because it has been remembered in the session. And make sure that every page has this on the very top (on line 1 of your code).

if(!session_id()){
  session_start();
}

otherwise your session might get lost and it will result in an error again.

Good luck !

bimmer528

What I was trying to do is this.

sql query page

function avg() {
  global $DB;
$sql="SELECT * FROM table ORDER BY name LIMIT 5";
$result= $DB->query($sql);
while($row=mysql_fetch_array($sql)) {
$row['name']=$name;
}
return $result; 
}

Now the page to do the tables and results...

$var=avg(); 
while($row=mysql_fetch_array($var)) { 
echo $name;
}