This makes sense but I can't figure out how it should look in the field, can
you help?
Here is what I currently have:
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 run it like this, I get this in my web server error log:
PHP Parse error: parse error in Off_Stat_Leaders.php(35) : eval()'d code on
line 1, referer: Offensive_Stat_Search.php
Any ideas?
Thanks
-Rich
-----Original Message-----
From: Brad Webb [mailto:bradleypaulwebb@xxxxxxxxx]
Sent: Tuesday, June 07, 2005 8:37 PM
To: php-db@xxxxxxxxxxxxx
Subject: Re: Can someone help me out?
eval($recss[sql1]).. variables inside a string have to be expanded
manually, since you're storing the variable names inside the DB, you
have to manually pull them out..
Sorry for not catching this earlier, I didn't realize the query itself
was stored in the DB.
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
>
>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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
**********************************************************************
IMPORTANT NOTICE
This communication is for the exclusive use of the intended recipient(s)
named above. If you receive this communication in error, you should
notify the sender by e-mail or by telephone (+44) 191 224 4461, delete
it and destroy any copies of it.
This communication may contain confidential information and material
protected by copyright, design right or other intellectual property
rights which are and shall remain the property of Piranha Studios
Limited. Any form of distribution, copying or other unauthorised use
of this communication or the information in it is strictly prohibited.
Piranha Studios Limited asserts its rights in this communication and
the information in it and reserves the right to take action against
anyone who misuses it or the information in it.
Piranha Studios Limited cannot accept any liability sustained as a
result of software viruses and would recommend that you carry out your
own virus checks before opening any attachment.
************************************************************************
<<<<GWAVAsig>>>>AdmID:E30F60ABAB080BBEFFC0FD17120B9C84
**********************************************************************
IMPORTANT NOTICE
This communication is for the exclusive use of the intended recipient(s)
named above. If you receive this communication in error, you should
notify the sender by e-mail or by telephone (+44) 191 224 4461, delete
it and destroy any copies of it.
This communication may contain confidential information and material
protected by copyright, design right or other intellectual property
rights which are and shall remain the property of Piranha Studios
Limited. Any form of distribution, copying or other unauthorised use
of this communication or the information in it is strictly prohibited.
Piranha Studios Limited asserts its rights in this communication and
the information in it and reserves the right to take action against
anyone who misuses it or the information in it.
Piranha Studios Limited cannot accept any liability sustained as a
result of software viruses and would recommend that you carry out your
own virus checks before opening any attachment.
************************************************************************
<<<<GWAVAsig>>>>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
