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@hotmail.com] Sent: Tuesday, June 07, 2005 7:21 PM To: reclmaples@sbcglobal.net; desktophero@cox.net Cc: php-db@lists.php.net Subject: RE: [PHP-DB] 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@sbcglobal.net> To: "Jason Walker" <desktophero@cox.net> CC: "PHP" <php-db@lists.php.net> Subject: RE: [PHP-DB] 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@cox.net] Sent: Tuesday, June 07, 2005 6:54 PM To: 'ReClMaples' Subject: RE: [PHP-DB] 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@sbcglobal.net] Sent: Tuesday, June 07, 2005 4:05 PM To: PHP Subject: [PHP-DB] 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