PHP - Function Not Displaying

When I put this chunk of code into it's own function:


function fetch_all ($dbc, $query) {

include ('knuffix_list_func.php');

pagination_start ($dbc, $query);

$offset = $pag_array[0];

$rows_per_page = $pag_array[1];

$query = $query . " LIMIT $offset, $rows_per_page";

echo "test query: " . $query;

knuffix_list ($query, $dbc);

pagination_end ($pag_array);
}


And when I echo out the query as you can see in the example, then I notice that the variables $offset and $rows_per_page never get appended.
I set the variable $pag_array to a global inside the function pagination_start(). It usually works when I DON'T wrap a function around this chunk of code, but if I do wrap a function around everything then the global suddenly won't work anymore.

Btw, this also won't work if I wrap a function around the function DECLARATIONS.

Any ideas, how I could make it work?

Hi all, I want to call a javascript function from a php function like this:

        public function Buscar()
        {
            $HoraInicio = $_POST['edtHoraInicio'];
            $HoraFin = $_POST['edtHoraFin'];
            $FechaInicio = $_POST['edtFec1'];
            $FechaFin = $_POST['edtFec2'];

            $FechaMax = $FechaFin." ".$HoraFin.":00";
            $FechaMin = $FechaInicio." ".$HoraInicio.":00";

            $_GET["FechaMax"] = $FechaMax;
            $_GET["FechaMin"] = $FechaMin;

            echo $FechaMin;

            echo "<script language=javascript>alert('Hi.')</script>";
           
        }

but the function Buscar never show the alert but shows the $FechaMin

I hopu u guys can help me out with this probem

Thanks,

Siddhartha

Hi I have a table class and functions I want to call in another function but can't get it working. Some help will be very welcome.

It seesm that the new table class is not working in this function if I pass the values to it, I have tested the class, it does get the post values I post to it so $_POST['id'] are being received as well as all the other $_POST's but the table class and find function is not working, it works fine if I don't put it in a function..

function edit() {
   
   if (isset($error)){ $error.="Please fix the error(s) above";}
   else {

      if ($_POST['id'] <> "") { 
                   
         $update =& new table($db, 'publisher');

         $update->find($_POST['id']);
         $update->name       = $_POST['name'];
         $update->url        = $_POST['url'];
         $update->contact    = $_POST['contact'];
         $update->address    = $_POST['address'];
         $update->phone        = $_POST['phone'];
         $update->email        = $_POST['email'];
         $update->save();

         $error = "The Publisher has been edited";   
                }
   }
  }

im using a function which connects to a db called 'comments' and then inside that function i again called another function that will connect to the db 'main' to get avatars.... but as i put Code: [Select]
mysql_select_db("main") or die(mysql_error()); on the new function, the original function stops to fetch rows.

i tried to remove "mysql_select_db("main") or die(mysql_error());" and used the new function to return some text only and it worked, so i guess the connection to the db was the problem... i tried doing Code: [Select]
mysql_query("SELECT * FROM  main.avatar
INNER JOIN main.list ON main.avatar.title=main.list.id
WHERE main.avatar.page_id='$id'"); but it also didnt work

I've followed the PHP Freaks pagination tutorial which you can find here.

And I also got it to work, the only problem is that the script won't work when I use the query outside of the function.

Here's the function:



<?php 
function knuffix_list ($query, $dbc) {

// find out how many rows are in the table:
$query_row = "SELECT COUNT(*) FROM con";
$query_run = mysqli_query ($dbc, $query_row);
$row = mysqli_fetch_row($query_run);
$num_rows = $row[0];

// number of rows to show per page
$rows_per_page = 5;

// find total pages -> ceil for rounding up
$total_pages = ceil($num_rows / $rows_per_page);

// get the current page or set a default
if (isset($_GET['current_page']) && is_numeric($_GET['current_page'])) {

// make it an INT if it isn't

$current_page = (int) $_GET['current_page'];

} else {

// default page number

$current_page = 1;

}


// if current page is greater than total pages then set current page to last page
if ($current_page > $total_pages) {

$current_page = $total_pages;

}

// if current page is less than first page then set current page to first page
if ($current_page < 1) {

$current_page = 1;

}

// the offset of the list, based on current page
$offset = (($current_page - 1) * $rows_per_page);

echo "test " . $query;

// SCRIPT ONLY WORKS IF I INSERT QUERY HERE

$query

= "SELECT * FROM con, user WHERE con.user_id = user.user_id ORDER BY contributed_date DESC LIMIT $offset, $rows_per_page";

$data = mysqli_query ($dbc, $query) or die (mysqli_error ($dbc));

// Loop through the array of data

while ($row = mysqli_fetch_array ($data)) {

global $array;

// Variables for the table

$con_id = $row['con_id'];

$likes_count = $row['likes'];

$dislikes_count = $row['dislikes'];

$dbuser_name = $row['nickname'];

$dbuser_avatar = $row['avatar'];

$user_id = $row['user_id'];

// The TABLE

echo "<table padding='0' margin='0' class='knuffixTable'>";

echo "<tr><td width='65px' height='64px' class='avatar_bg' rowspan='2' colpan='2'><img src='avatar/$dbuser_avatar' alt='avatar' /></td>";

echo "<td class='knuffix_username'><strong><a href='profile.php?user=$dbuser_name' title='Profile of $dbuser_name'>" . $dbuser_name . "</a> ___ " . $user_id . "____ <form action='' method='POST'><button type='submit' name='favorite' value='fav'>Favorite</button></form>";

echo "</strong><br />" . $row['category'] .  " | " . date('M d, Y', strtotime($row['contributed_date'])) . "</td></tr><tr><td>";

echo "<form action='' method='post'>

<button class='LikeButton' type='submit' name='likes' value='+1'>Likes</button>

<button class='DislikeButton' type='submit' name='dislikes' value='-1'>Dislikes</button>

<input type='hidden' name='hidden_con_id' value='" . $con_id . "' />

</form></td><td class='votes'>Y[" . $likes_count . "] | N[" . $dislikes_count . "]</td></tr>";

echo "<tr><td class='knuffix_name' colspan='3'><strong>" . htmlentities($row['name']) . "</strong><br /></td></tr>";

echo "<tr><td colspan='2' class='knuffix_contribution'><pre>" . $row['contribution'] . "</pre><br /></td></tr>";

echo "</table>";

// POST BUTTONS inside the table

$likes = $_POST['likes'];

$dislikes = $_POST['dislikes'];

$con_id = $_POST['hidden_con_id'];

$favorite = $_POST['favorite'];

$array = array ($likes, $dislikes, $con_id, $user_id, $favorite);

}

/********* build the pagination links *********/

// BACKWARD
// if not on page 1, show back links and show << link to go back to the very first page
if ($current_page > 1) {

echo " <a href='{$_SERVER['PHP_SELF']}?current_page=1'><<</a> ";

// get previous page number and show < link to go to previous

$prev_page = $current_page - 1;
 

echo " <a href='{$_SERVER['PHP_SELF']}?current_page=$prev_page'><</a> ";

}

// CURRENT
// range of number of links to show
$range = 3;

// loop to show links in the range of pages around current page
for ($x = ($current_page - $range); $x < (($current_page + $range) + 1); $x++) {

// if it's a valid page number...

if (($x > 0) && ($x <= $total_pages)) {

// if we're on current page

if ($x == $current_page) {

// highlight it but don't make a link out of it

echo "[<b>$x</b>]";

// if it's not the current page then make it a link

} else {

echo "<a href='{$_SERVER['PHP_SELF']}?current_page=$x'>$x</a>";

}

}
}


// FORWARD
// if not on the last page, show forward and last page links
if ($current_page != $total_pages) {

// get next page

$next_page = $current_page + 1;

// echo forward link for next page

echo " <a href='{$_SERVER['PHP_SELF']}?current_page=$next_page'>></a> ";

// echo forward link for last page

echo " <a href='{$_SERVER['PHP_SELF']}?current_page=$total_pages'>>></a> ";

}

/***** end building pagination links ****/

mysqli_close($dbc);

}

?>


As you can see above, the script will only work if I put the query right below the $offset variable and above the $data variable.

I put the test echo above the query to see how the query looks like when I induce the query from the outside through the function parenthesis into the function, and this is what I get printed out:


test SELECT * FROM con, user WHERE con.user_id = user.user_id ORDER BY contributed_date DESC LIMIT ,


Obviously the $offset and the $rows_per_page variables are not set, when I induce the query from the outside into the function.

So in that sense my question is:

How can I induce the query from the outside into the function SO THAT the $offset and the $rows_per_page variables are set as well and NOT empty?


p.s.

I need the query outside of the function because I'm using a sort by category functionality.

Okay, so I am trying to display players usernames and kills and deaths from my highscores page and I have different div classes set for each block This is my code:

<div id="table">
<div class="tr ttl">
<div class="col st1">Rank</div>
<div class="col st2">Username</div>
<div class="col st3">Rating</div>
<div class="col st4">Deaths</div>
<div class="col st5">Kills</div>
</div>
<?php
if($_GET['skill'] == 0) {
$skill = $_GET['skill'];
$page = ($_GET['page']-1);
$limit = RESULTS_PER_PAGE*$page.', '.RESULTS_PER_PAGE;
$limitt = RESULTS_PER_PAGE*$page;
$query = "SELECT * FROM hs ORDER BY `elo` DESC LIMIT ".$limit."";
$result = mysql_query($query);
$counter = 1;
while ($fetch = mysql_fetch_assoc($result)) {
echo '<div class="tr normal ftr rd1">
<div class="col st1">'.($counter+$limitt).'</div>
<div class="col st2"><a href="?user='.$fetch['username'].'">'.$fetch['username'].'</a></div>
<div class="col st3">'.number_format($fetch['kills']).'</div>
<div class="col st4">'.number_format($fetch['deaths']).'</div>
<div class="col st5">'.$fetch['elo'].'</div>
</div>
';
$counter++;
}
}
?>

See where it says echo '<div class="tr normal ftr rd1">    I'd want it to print out like this:  (tr normal ftr rd1) for the first one, (tr normal ftr rd2) for second one and (tr normal ftr rd3) for the 3rd one. Then (tr normal) and (tr odd normal) for the rest Can anyone help me out here?  

I'm trying to grab something on a different page with the layout:

Code: [Select]
0 day, 10 hours, 35 min, 59 sec
My code to display this information on another page is:

<?php
$page_contents = file_get_contents("http://www.mysite.com");
$matches = array();
preg_match('/([0-9,]+) day, ([0-9,]+) hours, ([0-9,]+) min, ([0-9,]+) sec /', $page_contents, $matches);
echo $matches[0];
?>


Why is it displaying nothing?

Quick background... I bought an auction program with plenty of bugs. Todays bug that I can't figure out is that it is displaying a - (dash) when I would prefer it to display 0 (zero) in instances of "total fees due" or in the "fee chart" if it's a flat fee of 0.  0% works fine.

The code related to it is spread out on a handful of files but I think it's mostly related to the following.

   
if (is_array($setup_fee))
    {
    foreach ($setup_fee as $key => $value)
    {
    if ($value['amount'])
    {
    if ($value['calc_type'] == 'flat')
    {
    $output['amount'] += $value['amount'];
    $fee_display = $this->display_amount($value['amount'], $this->setts['currency']);
    }
    else if ($value['calc_type'] == 'percent')
    {
    $output['amount'] += $this->round_number($item_details['start_price'] * $value['amount'] / 100);
    $fee_display = $value['amount'] . '%';
    }

    if ($item_relist)
    {
    $output['amount'] = $this->round_number($output['amount'] - $output['amount'] * $this->fee['relist_fee_reduction'] / 100);
    }

    $output['display'] .= '<tr class="c1"> '.
    ' <td width="150" align="right"><b>' . GMSG_SETUP_FEE . ':</b></td> '.
    ' <td align="left" nowrap colspan="2"><b>' . $fee_display . $value['display'] . '</b></td> '.
    '</tr> ';

    ## now add the row on the invoices table
    if ($user_payment_mode == 2 && $add_invoices)
    {
    $account_balance += $output['amount'];

    $tax_settings = $this->tax_amount($output['amount'], $this->setts['currency'], $user_details['user_id'], $this->setts['enable_tax']);

    $sql_insert_invoice = $this->query("INSERT INTO " . DB_PREFIX . "invoices
(user_id, item_id, name, amount, invoice_date, current_balance, can_rollback, tax_amount, tax_rate, tax_calculated, reverse_id) VALUES
('" . $user_details['user_id'] . "', '" . $item_details['auction_id'] . "', '" . GMSG_SETUP_FEE . "',
'" . $output['amount'] . "', '" . CURRENT_TIME . "', '" . $account_balance . "', " . $can_rollback . ", '" . $tax_settings['amount'] . "', 
'" . $tax_settings['tax_rate'] . "', '1', '" . $item_details['reverse_id'] . "')");

    $sql_update_user_balance = $this->query("UPDATE " . DB_PREFIX . "users SET
balance='" . $account_balance . "' WHERE user_id='" . $user_details['user_id'] . "'");
    }
    }
    }
    }

    foreach ($fees_no_tier as $key => $value)
    {
    if ($value[1])
    {
    $fee_details = $this->display_fee($key, $user_details, $item_details['category_id'], $item_details['list_in'], $voucher_details, $apply_tax);

   if ($item_relist)
   {
   $fee_details['amount'] = $this->round_number($fee_details['amount'] - $fee_details['amount'] * $this->fee['relist_fee_reduction'] / 100);
   }

    $output['amount'] += $fee_details['amount'];

    if ($fee_details['amount']) ## only do this if there is a fee
    {
    $output['display'] .= '<tr class="c1"> '.
    ' <td width="150" align="right"><b>' . $value[0] . ':</b></td> '.
    ' <td nowrap colspan="2"><b>' . $fee_details['display'] . '</b></td> '.
    '</tr> ';


    ## now add the row on the invoices table
    if ($user_payment_mode == 2 && $add_invoices)
    {
    $account_balance += $fee_details['amount'];

    $tax_settings = $this->tax_amount($fee_details['amount'], $this->setts['currency'], $user_details['user_id'], $this->setts['enable_tax']);
   
    $sql_insert_invoice = $this->query("INSERT INTO " . DB_PREFIX . "invoices
(user_id, item_id, name, amount, invoice_date, current_balance, can_rollback, tax_amount, tax_rate, tax_calculated, reverse_id) VALUES
('" . $user_details['user_id'] . "', '" . $item_details['auction_id'] . "', '" . $value[0] . "',
'" . $fee_details['amount'] . "', '" . CURRENT_TIME . "', '" . $account_balance . "', " . $can_rollback . ", '" . $tax_settings['amount'] . "', 
'" . $tax_settings['tax_rate'] . "', '1', '" . $item_details['reverse_id'] . "')");

    $sql_update_user_balance = $this->query("UPDATE " . DB_PREFIX . "users SET
balance='" . $account_balance . "' WHERE user_id='" . $user_details['user_id'] . "'");
    }
    }
     }
    }

$output['display'] .= '<tr class="c5"><td colspan="3"></td></tr><tr class="c2"> '.
   ' <td width="150" align="right"><b>' . GMSG_TOTAL . ':</b></td> '.
   ' <td nowrap colspan="2"><b>' . $this->display_amount($output['amount'], $this->setts['currency']) . '</b></td> '.
'</tr> '.
     '<tr class="c5"> '.
         ' <td><img src="themes/' . $this->setts['default_theme'] . '/img/pixel.gif" width="150" height="1"></td> '.
' <td colspan="2"><img src="themes/' . $this->setts['default_theme'] . '/img/pixel.gif" width="1" height="1"></td> '.
   '</tr> ';

    return $output;
}


I'll really really appreciate the help.

can you do that with php?

Code: [Select]
Database2() {
function test($id) {

$newdb = new Database2();
$newdb->test($id);


}
}

window.setInterval(function(){

s="<?= $lastid ?>";

$.post('../action/updatestream.php',{statusid:s.val()},function(e){
 
alert(e)

 });


}, 10000);

Why isn't it working?

Thanks,  

I have a PHP while loop that pulls from an SQL database and displays the contents in a table with two columns.

// Check Connection
    if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

// Select Data Table
    $result = mysqli_query($con,"SELECT * FROM Recommendations") or die(mysqli_error);

// Split Data
    $mid = ceil(mysqli_num_rows($result)/2);

// Display Content
    while ($rows = mysqli_fetch_array($result)) {
        $Name = $rows['Name'];
        $Author = $rows['Author'];
        $Cover = $rows['Link to Cover'];
        $Link = $rows['Link to Profile'];
    echo "<table><tr><td>
    <a href='" . $Link . "' >$Name</a>
    <br />
    $Author
    <br />
    <a href='" . $Link . "' ><img src='" . $Cover . "' /></a>
    </td>
    <td>
    <a href='" . $Link . "' >$Name</a>
    <br />
    $Author
    <br />
    <a href='" . $Link . "' ><img src='" . $Cover . "' /></a>
    </td></tr></table>";
    }
?>

I want to be able to display the looped results side by side in columns of two. Example: 1 2 3 4
5 6   I've tried using pseudo classes to display only the even and odd results in the different table columns, but honestly have no idea how to do this. I'm new to PHP, so my apologies if the results are really obvious. Thanks in advance!

hi guys I am having trouble displaying a table in a mySQL database
i get the error message
Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /home/students/accounts/s7188633/hit3323/www/htdocs/Assiment2V2/main.php on line 47

Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /home/students/accounts/s7188633/hit3323/www/htdocs/Assiment2V2/main.php on line 53

these are the two line that it realtes to

row  47:   $Row = mysqli_fetch_row($result);
   
row  53:   $Row = mysqli_fetch_row($result);

below is all the code if you wanted to look at it,

thanks

<?php
$choice = addslashes ($_POST["selection"]);
{
   $DBConnect = @mysqli_connect("neptune.it.swin.edu.au", "*****", "***")
      Or die("<p>Unable to connect to the database server.</p>"
      . "<p>Error code " . mysqli_connect_errno()
      . ": " . mysqli_connect_error()) . "</p>";
   $DBName = "*****_db";
   if (!@mysqli_select_db($DBConnect, $DBName))
      echo "<p>The database is not available.</p>";

   $SQLstring = "SELECT * FROM Books";// WHERE category = 'Programing'";
   $QueryResult = @mysqli_query($DBConnect, $SQLstring)
      Or die("<p>Unable to execute the query.</p>"
      . "<p>Error code " . mysqli_errno($DBConnect)
      . ": " . mysqli_error($DBConnect)) . "</p>";
   $NumRows = mysqli_num_rows($QueryResult);
   if ($NumRows == 0)
       echo "<p>No records returned.</p>";
   else
   {
      mysqli_select_db($DBConnect, $DBName);
 
     $SQLstring = "SELECT * FROM Books";
  $result = @mysql_query($DBConnect, $SQLstring);

   $Row = mysqli_fetch_row($result);
   do {
      echo "<tr><td>{$Row[0]}</td>";
      echo "<td>{$Row[1]}</td>";
      echo "<td align='right'>{$Row[2]}</td>";
      echo "<td align='right'>{$Row[3]}</td></tr>";
      $Row = mysqli_fetch_row($result);
   } while ($Row);
}
   
   }
         
mysqli_close($DBConnect);
   

?>

i have it set up so the user picks the year and session and then the database shows all the games in that specific year and session and then displays them with a link to their photo galleria and also shows the record(wins - losses - ties) but the way i have it know its not displaying the first result here is the code
Code: [Select]
<?php
 //declares $y as year played and $s as session
 $y = ' ';
 $s = ' '; 
 
 //handles submition of form for picking year and session
 if (isset($_POST['submit'])) {
 $data = mysql_real_escape_string($_POST['session']);
 $exploeded = explode(",", $data);
 $y = $exploeded[0];
 $s = $exploeded[1];
 }

  //Query for the selection menu
    $squery = "SELECT DISTINCT(Year_Played), Sessions FROM pinkpanther_games";
    $sresults = mysql_query($squery) or die("squery failed ($squery) - " . mysql_error());
   
    //checks $y and $s to see if their is a vaule
    if ($y == ' '){$y = '20112012';}
    if ($s == ' '){$s = '2';}
   
    //Query for getting record and for getting all the appropriate info for displaying the games
    $query = " SELECT (SELECT COUNT(id) FROM pinkpanther_games WHERE Year_Played = $y AND Sessions = $s AND Win_Loss = 'Tie' ) AS 'Tie', 
         (SELECT COUNT(id) FROM pinkpanther_games WHERE Year_Played = $y AND Sessions = $s AND Win_Loss = 'Win') AS 'Win',
         (SELECT COUNT(id) FROM pinkpanther_games WHERE Year_Played = $y AND Sessions = $s AND Win_Loss = 'Loss') AS 'Lose',
         Opponent AS Opponent, Score AS Score, Gallery_no AS Gal, Win_Loss AS Record FROM pinkpanther_games WHERE Year_Played = $y AND Sessions = $s";
    $results = mysql_query($query)  or die("Query failed ($query) - " . mysql_error());
    $row_a = mysql_fetch_assoc($results);   
    //Set record variables
    $wins = $row_a['Win'];
    $loss = $row_a['Lose'];
    $tie = $row_a['Tie'];

    //creates from and selection menu for year and session
echo "<tr><td colspan='2'><form method='post' action=''><select name='session' class='txtbox2'>";
while ($srow = mysql_fetch_assoc($sresults)){
echo "<option value='" . $srow['Year_Played'] . "," . $srow['Sessions'] . "'>" . $srow['Year_Played'] . " Session " . $srow['Sessions'] . "</option>";
}
echo "</select><input type='submit' name='submit' value='Go'  class='txtbox2' /></form></td></tr>";
//displays  record
echo "<tr><td colspan='2'>" .$wins . " - " . $loss . " - " . $tie . "</td></tr>";
echo "<tr></tr>";
//displays games and scores in appropriate year and session
while ($row = mysql_fetch_assoc($results)){
$opp = $row['Opponent'];
$score = $row['Score'];
$gal = $row['Gal'];
$wlt = $row['Record'];
//styles games acording to if win lose or tie
if ($wlt == 'Win'){
echo "<tr><td class='win'>";
echo "<a  href='galleries.php?g=$gal'" . $gal . " >" . $opp . "</a>";
echo "</td><td class='win'>";
echo   $score . "";
echo "</td></tr>";
}
if ($wlt == 'Loss'){
echo "<tr><td class='loss'>";
echo "<a  href='galleries.php?g=$gal'" . $gal . " >" . $opp . "</a>";
echo "</td><td class='loss'>";
echo   $score . "";
echo "</td></tr>";
}
if ($wlt == 'Tie'){
echo "<tr><td class='tie'>";
echo "<a  href='galleries.php?g=$gal'" . $gal . " >" . $opp . "</a>";
echo "</td><td class='tie'>";
echo   $score . "";
echo "</td></tr>";
}
}
?>

Could someone please tell me why this displays 3 columns correct and then all moves over.  Here is the page you can see what I am talking about http://www.woodrun.org/includes/news.php I have looked the code over and over and can't see it.  Thanks in advance.

Code: [Select]
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$maxRows_Recordset1 = 1000000;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_woodrun, $woodrun);
$query_Recordset1 = "SELECT * FROM news ORDER BY id DESC" ;
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $woodrun) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_fwragain, $fwragain);
$query_Recordset1 = "SELECT * FROM news ORDER BY id DESC";
$Recordset1 = mysql_query($query_Recordset1, $woodrun) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

<table width="100%" border="0" align="center" cellpadding="5" cellspacing="5">
  <?php do { ?>
  <tr>
    <td colspan="4" align="left" valign="top"><?php echo "<img src=http://woodrun.org/images/".$row_Recordset1['photo'] ."> "; ?></td>
    <td width="550" align="left" valign="top"><?php echo $row_Recordset1['title']; ?>
      <hr />
      <?php echo $row_Recordset1['article']; ?><br /></td>
  </tr>
  <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>



  <?php
mysql_free_result($Recordset1);
?>

Hey Guys. I am using php to output to frames. When I add an "\n" tag of even a PHP_EOL the second frame shows blank. The weird thing is when I view the page source I can clearly see the HTML of both frames... Can anyone help me resolve this issue? Thanks!

$iframe =  "<iframe src='menu_new.php' width='65%'  name='menu' id='menu' title='Menu Frame' ></iframe>\n"; //iframe not working when adding the /n on this line


$iframe .= "<iframe src='menu-items.php' width='35%' name='menu-items' id='menu-items' scrolling='yes' noresize='noresize'  title='Menu Items Frame'></iframe>\n";


    echo $iframe;