ReClMaples wrote:
All,
Here is the code that I'm using. I have a form that feeds that top
values to this page:
<?php
$pos = $_POST['sel_pos_name'];
$year = $_POST['sel_year_name'];
$cat_name = $_POST['sel_cat_name'];
$display = $_POST['display'];
$div = $_POST['Div'];
//MySql and Database Connection
$conn = mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("",$conn) or die(mysql_error());
//Gets the id,cat_name,sql1 field sql2 field and cat_descript from the table
$get_cat_info = "select Id,Cat_Name,Cat_Descript,sql1,sql2 from
stat_categories where Cat_Name = '$cat_name'";
$get_cat_info_res = mysql_query($get_cat_info) or die(mysql_error());
while ($recss = mysql_fetch_array($get_cat_info_res))
{
$id = $recss['Id'];
$cat_name1 = $recss['Cat_Name'];
$cat_descript = $recss['Cat_Descript'];
$sql1 = $recss['sql1'];
$sql2 = $recss['sql2'];
}
//Displays the top of the table
echo "<b>Results for $cat_name</b>";
echo "<table border='1' cellpadding='1' cellspacing='1'>";
echo "<tr>";
echo "<td bgcolor=\"#C0C0C0\"><center><b>Player Name</b></center></td>";
echo "<td bgcolor=\"#C0C0C0\"><center><b>Position</b></center></td>";
echo "<td bgcolor=\"#C0C0C0\"><center><b>Team</b></center></td>";
echo "<td bgcolor=\"#C0C0C0\"><center><b>$cat_descript</b></center></td>";
echo "</tr>";
if ($div == 'NFL')
{
//sql2
$get_results = "$sql2 limit $display";
//echo $get_results;
$get_results_res = mysql_query($get_results) or die(mysql_error());
while ($res = mysql_fetch_array($get_results_res))
{
$player_name = $res['name'];
$position = $res['position'];
$team = $res['team'];
$Results = $res['Results'];
echo "<tr>";
echo "<td><center>$player_name</center></td>";
echo "<td><center>$position</center></td>";
echo "<td><center>$team</center></td>";
echo "<td><center>$Results</center></td>";
echo "</tr>";
echo "</table>";
}
}
else
{
//sql1
$get_resultss = "$sql1 limit $display";
echo $get_results1;
$get_results_res1 = mysql_query($get_results1) or die(mysql_error());
while ($res1 = mysql_fetch_array($get_results_res1))
{
$player_name = $res1['name'];
$position = $res1['position'];
$team = $res1['team'];
$Results = $res1['Results'];
echo "<tr>";
echo "<td><center>$player_name</center></td>";
echo "<td><center>$position</center></td>";
echo "<td><center>$team</center></td>";
echo "<td><center>$Results</center></td>";
echo "</tr>";
echo "</table>";
}
}
?>
There are no functions and I'm using double quotes. In my table. I have
two fields sql1 and sql2.
Here are the values in each of the fields:
Sql1
select a.name,a.position,a.team,sum(b.yards) as Results from player
a,passing b
where
a.player_num = b.player_num
and a.position = '$pos'
and b.year >= '$year'
and a.team_div = '$div'
group by a.name
order by Results desc
In the past I have run into something similar, I resolved it by
if you can echo the $pos and $year and $div here then the following
should work.
$Sql1 = "select a.name,a.position,a.team,sum(b.yards) as Results from";
$Sql1 .= " player a,passing b where a.player_num = b.player_num ";
$Sql1 .= " and a.position = '".$pos."' ";
$Sql1 .= " and b.year >= '".$year."' ";
$Sql1 .= " and a.team_div = '".$div."' ";
$Sql1 .= " group by a.name ";
$Sql1 .= " order by Results desc";
;You might echo $Sql here to make sure that it has the correct values
echo "My Sql statement = $Sql1 <br>";
;Then run this statement through mysql client and see if you see the
;results you were looking for
$theresults = mysql_query($Sql1);
Sql2
select a.name,a.position,a.team,sum(b.yards) as Results from player
a,passing b
where
a.player_num = b.player_num
and a.position = '$pos'
and b.year >= '$year'
group by a.name
order by Results desc
I'm stumped. I have tested each variable and they all come back, except in
the variables sql1 and sql2.
Thanks
-Rich
-----Original Message-----
From: Bastien Koert [mailto:bastien_k@xxxxxxxxxxx]
Sent: Tuesday, June 07, 2005 7:21 PM
To: reclmaples@xxxxxxxxxxxxx; desktophero@xxxxxxx
Cc: php-db@xxxxxxxxxxxxx
Subject: RE: Can someone help me out?
can you show the code around it? are you using single quotes in defining the
sql statement? or double quotes?
Bastien
From: "ReClMaples" <reclmaples@xxxxxxxxxxxxx>
To: "Jason Walker" <desktophero@xxxxxxx>
CC: "PHP" <php-db@xxxxxxxxxxxxx>
Subject: RE: Can someone help me out?
Date: Tue, 7 Jun 2005 19:00:59 -0500
Jason,
After looking at this a little more, the variable aren't being changed
into their value.
The echo looks like this:
select a.name,a.position,a.team,sum(b.yards) as Results from player
a,passing b where a.player_num = b.player_num and a.position = $pos and
b.year >= $year and a.team_div = $div group by a.name order by Results desc
limit '$display'
As you can see the variables aren't being changed, any ideas?
Thanks
-Rich
-----Original Message-----
From: Jason Walker [mailto:desktophero@xxxxxxx]
Sent: Tuesday, June 07, 2005 6:54 PM
To: 'ReClMaples'
Subject: RE: Can someone help me out?
In your PHP page, can you echo the actual query variable to the browser and
send that to the mail group?
I don't necessary see anything 'wrong' with your query but see the three
variables, as they are interpreted by PHP, may help.
Thanks,
-----Original Message-----
From: ReClMaples [mailto:reclmaples@xxxxxxxxxxxxx]
Sent: Tuesday, June 07, 2005 4:05 PM
To: PHP
Subject: Can someone help me out?
I am having a problem getting a sql statement to run.
I have this in a table called stat_categories, in a field called sql2
select a.name,a.position,a.team,sum(b.yards) as Results from player
a,passing b where a.player_num = b.player_num and a.position = '$pos'
and b.year >= '$year'
group by a.name
order by Results desc
limit '$display'
when I try to display this I get this error:
You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near ''$display'' at
line 8
I tried removing the ''s but this didn't help.
If I put in the sql instead of the variable, it works fine. What am I
doing
wrong?
Any help would be greatly appreciated.
Thanks
-Rich
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.5 - Release Date: 6/7/2005
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
