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
