Hey peeps,
I've been reading up on MySql and Php so much my mind has gone blank and dont think I can put any more informaiton in there.
My problem:
I have the following php script but I'm not sure how I can asign each MySql variable to another variable so a flash text file can read it. I'm sure ts something quite obvious but I cannot get my head in gear. Please help..
Is it something like
var $init_int_rate = $flash_init_rate
Thanks for your time.
<?php
if($b>0)
{
$this_buy = new dch_mysql_conx();
$this_buy->my_query = "SELECT a.id,
a.name,
a.description,
a.m_id,
b.name,
a.init_int_rate,
a.spec_rate_period,
a.typical_apr,
a.following_rate,
a.penalties,
a.max_loan_size,
a.min_loan_size,
a.max_ltv_without,
a.max_ltv_with,
a.fee,
a.insurances,
a.interest,
a.other
FROM bestbuys a, mortgages b
WHERE a.id = '$b'
AND b.id = a.m_id
";
$this_buy->run_query();
$id = $this_buy->my_data['Data'][0][0];
$name = $this_buy->my_data['Data'][0][1];
$description = $this_buy->my_data['Data'][0][2];
$m_id = $this_buy->my_data['Data'][0][3];
$m_name = $this_buy->my_data['Data'][0][4];
$spec_rate_period = $this_buy->my_data['Data'][0][6];
$penalties = $this_buy->my_data['Data'][0][9];
$insurances = $this_buy->my_data['Data'][0][15];
$interest = $this_buy->my_data['Data'][0][16];
$other = $this_buy->my_data['Data'][0][17];
($this_buy->my_data['Data'][0][5] >0) ? $init_int_rate = $this_buy->my_data['Data'][0][5] : $init_int_rate = ' - ';
($this_buy->my_data['Data'][0][7] >0) ? $typical_apr = $this_buy->my_data['Data'][0][7] : $typical_apr = ' - ';
($this_buy->my_data['Data'][0][8] >0) ? $following_rate = $this_buy->my_data['Data'][0][8] : $following_rate = ' - ';
($this_buy->my_data['Data'][0][10]>0) ? $max_loan_size = $this_buy->my_data['Data'][0][10] : $max_loan_size = ' - ';
($this_buy->my_data['Data'][0][11]>0) ? $min_loan_size = $this_buy->my_data['Data'][0][11] : $min_loan_size = ' - ';
($this_buy->my_data['Data'][0][12]>0) ? $max_ltv_without = $this_buy->my_data['Data'][0][12] : $max_ltv_without = ' - ';
($this_buy->my_data['Data'][0][13]>0) ? $max_ltv_with = $this_buy->my_data['Data'][0][13] : $max_ltv_with = ' - ';
($this_buy->my_data['Data'][0][14]>0) ? $fee = $this_buy->my_data['Data'][0][14] : $fee = ' - ';
?>
<TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="0">
<TR>
<TD CLASS="title">
<?php print($name);?>
</TD>
</TR>
</TABLE>
<TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="2">
<TR VALIGN="TOP">
<TD CLASS="ptext"><?php print($description);?></TD>
</TR>
</TABLE>
<TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="2">
<TR BGCOLOR="#E7E7ED" VALIGN="TOP">
<TD WIDTH="250" CLASS="ptext" VALIGN="MIDDLE">Initial Interest
Rate</TD>
<TD VALIGN="MIDDLE" CLASS="ptextbold"><?php print($init_int_rate);?>%</TD>
</TR>
<TR VALIGN="TOP">
<TD WIDTH="250" CLASS="ptext" VALIGN="MIDDLE">Special Rate Period</TD>
<TD VALIGN="MIDDLE" CLASS="ptextbold"><?php print($spec_rate_period);?></TD>
</TR>
<TR BGCOLOR="#E7E7ED" VALIGN="TOP">
<TD WIDTH="250" CLASS="ptext" VALIGN="MIDDLE">Typical APR</TD>
<TD VALIGN="MIDDLE" CLASS="ptextbold"><?php print($typical_apr);?>%</TD>
</TR>
<TR VALIGN="TOP">
<TD WIDTH="250" CLASS="ptext" VALIGN="MIDDLE">Rate Following Initial
Rate</TD>
<TD VALIGN="MIDDLE" CLASS="ptextbold"><?php print($following_rate);?>%</TD>
</TR>
<TR BGCOLOR="#E7E7ED" VALIGN="TOP">
<TD WIDTH="250" CLASS="ptext" VALIGN="MIDDLE">Redemption Penalites</TD>
<TD VALIGN="MIDDLE" CLASS="ptextbold"><?php print($penalties);?></TD>
</TR>
<TR VALIGN="TOP">
<TD WIDTH="250" CLASS="ptext" VALIGN="MIDDLE">Maximum Loan Size</TD>
<TD VALIGN="MIDDLE" CLASS="ptextbold">£<?php print($max_loan_size);?></TD>
</TR>
<TR BGCOLOR="#E7E7ED" VALIGN="TOP">
<TD WIDTH="250" CLASS="ptext" VALIGN="MIDDLE">Minimum Loan Size</TD>
<TD VALIGN="MIDDLE" CLASS="ptextbold">£<?php print($min_loan_size);?></TD>
</TR>
<TR VALIGN="TOP">
<TD WIDTH="250" CLASS="ptext" VALIGN="MIDDLE">Maximum Loan To Value
(without MIG)</TD>
<TD VALIGN="MIDDLE" CLASS="ptextbold"><?php print($max_ltv_without);?>%</TD>
</TR>
<TR BGCOLOR="#E7E7ED" VALIGN="TOP">
<TD WIDTH="250" CLASS="ptext" VALIGN="MIDDLE">Maximum Loan To Value
(with MIG)</TD>
<TD VALIGN="MIDDLE" CLASS="ptextbold"><?php print($max_ltv_with);?>%</TD>
</TR>
<TR VALIGN="TOP">
<TD WIDTH="250" CLASS="ptext" VALIGN="MIDDLE">Arrangement Fee</TD>
<TD VALIGN="MIDDLE" CLASS="ptextbold">£<?php print($fee);?></TD>
</TR>
<TR BGCOLOR="#E7E7ED" VALIGN="TOP">
<TD WIDTH="250" CLASS="ptext" VALIGN="MIDDLE">Compulsory Insurances</TD>
<TD VALIGN="MIDDLE" CLASS="ptextbold"><?php print($insurances);?></TD>
</TR>
<TR VALIGN="TOP">
<TD WIDTH="250" CLASS="ptext" VALIGN="MIDDLE">Interest Charged</TD>
<TD VALIGN="MIDDLE" CLASS="ptextbold"><?php print($interest);?></TD>
</TR>
<TR BGCOLOR="#E7E7ED" VALIGN="TOP">
<TD COLSPAN="2" CLASS="ptext"><?php print($other);?> </TD>
</TR>
</TABLE>
<BR>
<SPAN CLASS="ptext"><A HREF="?s=<?php print($s); ?>">Back to best buys</A></SPAN>
<?php
}
else
{
$get_section = new dch_mysql_conx();
$get_section->my_query = "SELECT name
FROM sections
WHERE id LIKE '%$s%'";
$get_section->run_query();
?>
<SPAN CLASS="title">
<?php print($get_section->my_data['Data'][0][0]); ?>
Best Buys</SPAN><BR>
<?php
$best_buys = new dch_mysql_conx();
$best_buys->my_query = "SELECT DISTINCT b_id
FROM bb_defs
WHERE s_id = '$s'";
$best_buys->run_query();
$bb_mtypes = new dch_mysql_conx();
$bb_mtypes->my_query = "SELECT DISTINCT b.id,
b.name
FROM bestbuys a, mortgages b
WHERE ";
for($i=0; $i<$best_buys->my_data['Rows'];$i++)
{
if($i>0)
{
$bb_mtypes->my_query .= " OR ";
}
$bb_mtypes->my_query .= " a.id = '".$best_buys->my_data['Data'][$i][0]."' ";
}
$bb_mtypes->run_query();
for($j=0; $j<$bb_mtypes->my_data['Rows'];$j++)
{
unset($these_buys->my_data);
$these_buys = new dch_mysql_conx();
$these_buys->my_query = "SELECT b.id,
b.name,
b.description
FROM bestbuys b , bb_defs a
WHERE b.m_id = '".$bb_mtypes->my_data['Data'][$j][0]."'
AND a.s_id = '$s'
AND b.id = a.b_id";
$these_buys->run_query();
if($these_buys->my_data['Rows']>0)
{
print('<TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="0">
<TR BGCOLOR="#E7E7ED">
<TD CLASS="title">
<SPAN CLASS="ptextbold">'.$bb_mtypes->my_data['Data'][$j][1].'<BR></SPAN>
</TD>
</TR>
</TABLE>');
print('<TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="2">');
for($k=0; $k<$these_buys->my_data['Rows'];$k++)
{
print('<TR>');
print('<TD CLASS="ptext"><A HREF="?b='.$these_buys->my_data['Data'][$k][0].'&s='.$s.'">'.$these_buys->my_data['Data'][$k][1].'</A> - '.$these_buys->my_data['Data'][$k][2].'</TD>');
print('</TR>');
}
print('</TABLE>');
}
}
}
?>
