Jul 26, 2008

Calling A Variable From A Dynamic List In A Sql Statement

Free Web Hosting, No Ads > CONTRIBUTE > Computers > Programming Languages > PHP Programming

free web hosting

Calling A Variable From A Dynamic List In A Sql Statement

kvarnerexpress
I would be greatful if anyone could help me out, I have been stuck on this for a while. The problem is that I have a drop down menu which I get the contents of from a database. Then when I press the get details button I want to use the value selected in my drop down menu and pass it into an SQL statement to recieve all te relevent info. Everything works if I specify a known variable, but the problem seems to be passing a variable in which is part of the array. Below is the code for the drop down menu and the Sql statement i'm trying to execute.

drop down menu:

$query ="SELECT sub_title FROM sport_specials"; //run query
$result = mysql_query ($query);
if ($result) {
echo "<select name='cso' class='textarea' id='cso'>";
while ($special = mysql_fetch_array($result, MYSQL_NUM)) {
echo "<option value=".$special[0].">$special[0]</option>"; //Display available sports drop down menu
}

SQL statement:

if($_POST['submit'] == 'Get Details') {
echo 'start';

$sql = "SELECT title, sub_title, details, price FROM sport_specials WHERE sub_title = '$cso' ";
$result = mysql_query($sql);

if(mysql_num_rows($result) > 0)
{
echo 'hello';
$title = htmlentities(mysql_result($result, 0, "title"));
$sub_title = htmlentities(mysql_result($result, 0, "sub_title"));
$details = htmlentities(mysql_result($result, 0, "details"));
$price = htmlentities(mysql_result($result, 0, "price"));
}
else
{
echo 'error';
$error[sizeof($error)] = "There is no description in this offer for selected special";

}
}

I would appreciate it greatly if anyone could help.

 

 

 


Reply

HmmZ
I'm assuming you included a config.php or atleast a connect query?

Also, (that must be me), i dont see an actualy sql query taking place, All your sql querys are inside set variables, to my noobish eye it doesn't seem to ultimately actually run one of those querys

P.S. next time use [code], because not using it is considered hosting credit spam..

Reply

Spectre
There is an SQL query executed:
CODE
$sql = "SELECT title, sub_title, details, price FROM sport_specials WHERE sub_title = '$cso' ";
$result = mysql_query($sql);

Seeing as they aren't getting any connection errors (at least, they haven't mentioned it) I think it's safe to assume that they are connecting to the database prior to this. It doesn't appear to be the entire script.

kvarnerexpress, exactly where does the error occur, and what is it that happens? You are obviously free to do as you will, but I would rewrite the given code to something along the lines of:

CODE
// Drop down menu
$query ='SELECT sub_title FROM sport_specials'; //run query
$result = mysql_query($query);
if ($result) {
 $data = mysql_fetch_array($result);
 echo '<select name="cso" class="textarea" id="cso">';
 while ($special = mysql_fetch_array($result, MYSQL_NUM)) {
    echo "<option value=\"".$special[0]."\">$special[0]</option>\n"; //Display available sports drop down menu
 }
}


I don't think you're structuring the mysql_result() function properly either. So:
CODE
// SQL 'statement'
if( isset($_POST['submit']) && $_POST['submit'] == 'Get Details' ) {
  echo 'start';
  // I'm going to assume that $cso already has a value.
  $sql = "SELECT title, sub_title, details, price FROM sport_specials WHERE sub_title = '$cso' ";
  $result = mysql_query($sql);
  if( mysql_num_rows($result) > 0 ) {
     echo 'hello';
     $db = mysql_fetch_assoc($result);
     $title = htmlentities($db['title']);
     $sub_title = htmlentities($db['sub_title']);
     $details = htmlentities($db['details']);
     $price = htmlentities($db['price']);
  } else {
     echo 'error';
     $error[sizeof($error)] = "There is no description in this offer for selected special";
  }
}


Formatting and coding style obviously doesn't matter, and I don't know if this will fix your error or not - a little more detail of the problem wouldn't go astray.

 

 

 


Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Similar Topics

Keywords : calling variable dynamic sql statement

  1. Can I Make Dynamic Menu In Php - is it posible to make dynamic menu in php without javascript (7)
    As there are many java script by which we can have event based interaction like,message on mouse
    over etc,that we can create dynamic menu in javascripts to make navigation bar ,but is it possible
    in php to have this acomplished without javascripts,i am new to php,is it possible?. Thanks...
  2. Unexpected T_variable... - Help! (3)
  3. Script Help Required: Undefined Variable - A fault I cannot spot in PHP (3)
    Hi, when running a PHP script I keep getting the error: QUOTE Notice: Undefined variable: bret
    in c:\program files\easyphp1-8\home\poll.php on line 294 Notice: Undefined
    variable: bret in c:\program files\easyphp1-8\home\poll.php on line 294 (And,
    yes, I get it twice). The code related to the variable is as follows: CODE function
    LogString($string,$type)     {         $t_log = "\n";
            $t_log .=
    $this->globaldata->server_vars['REMOTE_ADDR']."...
  4. Dynamic Php Pages - Nice tutorial (5)
    This is a really good tutorial on making php pages that normally appear as
    www.domainname.com/links.php appear as www.domainname.com/index.php?page=links
    http://nuwen.com/tutorials/php-dynamic-pages ...
  5. Dynamic Image / Signature Generator - a simple code to change text on an image (12)
    In search of dynamically changing quote, saying or all other types of text on an image I came across
    a code that I have modified to fit my initial usage. This procedure requires two files and short
    knowledge of PHP. If you are familiar with Trap17's sig rotation code you will understand this
    procedure very fast. Code 1: dynamic_sig.php (you can rename this to index.php and you'll see
    at the end why) Code 2: a simple text file named anything (I will call it name.txt ) Code 1
    CODE <?php header("Content-type: image/png"); �...
  6. Getting An Array Value Of A Dynamic Variable - (9)
    Ok i can't believe I need help in php but I can't figure this out... If i have an array,
    lets say called test, how do i get a certain value from that array when referencing it dynamically
    by either a string or another variable? Example: CODE $test=array(1,2,5);
    $name="test"; //Doesn't work: echo $$name[0]; /Doesn't
    work: echo ${$name}[0]; ...
  7. Trap17 Board Status Dynamic Image - (13)
    I was really board a few days ago and decided to make a trap17 board status image for my sig
    /tongue.gif" style="vertical-align:middle" emoid=":P" border="0" alt="tongue.gif" /> That is the
    current beta. I'm still working on it so that it might display the most recent post or
    somthing, i'm not sure. After I finish it ill give out the source code but if you want one
    right now you can pm me and ill set one up to get the info on your account ^.^ So I was wondering
    how you members liked it? You'll probably think that its a waist of time, but alas as I sai...
  8. More Dynamic ?id=browsing With Php (associative Array) - Just create array and watch php code do the rest (1)
    The thing that has been bugging me for a while was that switch statement that we use to create ID
    browsing (some use If-Ifelse but results are the same for both). I wanted to figure out a way to use
    more dynamic switch statement so that i only need to update my links array in order to create links
    for template. With use of foreach, array_keys, and in_array functions finally i managed to do so.
    Also i'm planing on changing foreach with array_walk but i'll do that later. Now for the
    code.. First we create an associative array something like this CODE $gl...
  9. What Is Wrong With This Php-sql Select Where Statement? - (5)
    Hi all Im having problems with this peice of code: CODE   $result =
    mysql_query("SELECT 'ID' FROM 'login' WHERE
    username=$dusername",$link);      if($result != NULL){
        //username DOES exsist so they cant have it!
        include("scripts/userexsists.php"); The idea is, this query will take the
    variable $dusername which is the usernbame that a user wants to have, and check it in the
    database to see if it already exsists. and depending on whether it does or not it will inc...
  10. Php Form Help! - Parse error T_LNUMBER - expecting T_VARIABLE (3)
    Hello, I am trying to make an employee application. I was just wondering if anyone knows how to spot
    a php code error, when the code directly around the line with the error looks the same. below is
    some of my process.php code. I beleive the error is on line 41. QUOTE PHP parse error: PHP
    Parse error: parse error, unexpected T_LNUMBER, expecting T_VARIABLE or '$' in
    /home/wwwange/public_html/FORMS/forms/process.php on line 41 Process.php code: CODE
    <?php include("global.inc.php"); $errors=0; $error="The foll...
  11. Converting Characters In A Variable To Individual Values In An Array - turning variables into arrays (2)
    Say I have a variable such as $nav_item and it had to contents Home . IE: CODE
    $nav_item = 'Home'; How would I make so that $nav_item was an array and
    had the following contents? CODE $nav_item = array ('h', 'o',
    'm', 'e'); With the case changing (ie H would become h and U
    would become u ) EDIT: Okay found out that I could change the case with
    array_change_key_case ($nav_item, CASE_LOWER); ...
  12. Complex Php Echo Statement Assistance - Can't quite get this one, help appreciated (3)
    Can someone help me out with this one, please. I have a PHP script in which I am trying to write a
    fairly complex piece of html and I can't seem to get the coding of the PHP echo statement.
    There are single and double quotes scattered throughout this line of html and it is driving me nuts
    attempting to manage the output. So far, the only way I can get it to work is to break the
    echo'ing of the line of html code into the following lines of PHP: HTML echo "\t" ;
    echo ' li > a href ="'; echo $full_dir . $file ; echo '" alt=" full-s...
  13. <textarea> Tag Is Not Accepting Php Variable - for display, although <Input> tag does accept it (2)
    I have a single page template which has a Form on it. Logic is to check for a valid Querystring and
    place the variables accepted from a form back into the form and re-display this form with error or
    acceptance messages. I'm sure everyone here has done this a million times. The Form accepts
    data from a user for First name, Last name, email address, and message-body named
    'note_wide' then re-displays the values into the Form, but for some reason, I can't get
    the value to display into a Textarea. Sample of the php code is as follows: first the good one:...
  14. Dynamic Drop Down List <select> - (3)
    Hi, What I am trying to achieve is when you have a form drop down menu, it displays all the
    categories from the directory, with all the indentations. Something like when you submit your site
    to a directory. Now I've got it almost working, but I can figure out how to indent it. The code
    below, I've used a spacer gif, but obviously that won't work! I've had a go at
    this, as you can see, but that does do the indentations, unless I'm doing something wrong here.
    Any help appreciated - thanks. PHP Code: CODE function maketree($root...
  15. Dynamic Included Menus - path specification (8)
    I am looking for a way to make a dynamic menu using php and include, basicly I want to make a file
    that contains html formating source and links and include it somewhere in all my pages, the problem
    is that links are taken literaly and refered to as to where the html is running from. So is there a
    way I can make a file and include it in my pages, then it will determin where the page is running
    from, and generate the links with an approperate amount of ../../'s so if my index is at root,
    but every section has it's own folder, I want to be able to include this fil...
  16. Determining Whether A Phrase Is In A Variable - deciding whether a string is a url (2)
    I have a input box in a form called "button" and when the user clicks Submit! I want php to
    determine whether or not this is a url or just text. All urls have "http://" in them so I have
    decided I need a script which can determine whether or not "http://" is in a variable or a string.
    The problem with using strings is that I've never needed to use them before (and thus have no
    knowledge about them). When I was using asp, I knew there was a function called instr() but I
    can't find php's equivalent. Does anybody know? Thanks in advance!...
  17. Calling A False Variable... - like $count . $val (6)
    Okay I'm very new to PHP still, although you may recognize me from the threa before, just go
    finished finals so now back to PHP! On one page I accept an input which will tell the next page
    how many form lines to generate, that part I have worked out, or so I think. Because the number of
    forum fields could vary I need to have a number of forum variables, so I used this code: CODE
    echo   "<td><input name=\"wname" . $appendval . "\"
    type=\"text\" id=\"wname" . $appendval . "...
  18. Php Parse Error - Including Variable in post (2)
    ok this is my config script that runs my site: CODE <? # Set up info for left column on the
    top page: # It should begin with html tag <td> and finish with tag </td>
    $top_leftcol=" <td width='195' bgcolor='#eeeeee'
     valign='top'> <table width='100%'  bgcolor='#777799' border=0
    cellspacing='0' cellpadding='0'> <tr><td> <font
    FACE='ARIAL, HELVETICA' color='#ffffff' size='-1'>  
    <b>MMORPG Trade Center<...
  19. Stored Or Global Variable? - (1)
    I've created a form, nothing special, that uses a php script as a form action to input data into
    mysql. Nothing special at all about this scenario. One thing I'd like to do is have the php
    script redirect the user back to the html page that has the form the user just completed. I
    don't want to have to hard code the url into the header function because I use this php script
    with a bunch of other pages. Does PHP store the value of this page into some variable that the php
    script can use? Thanks. kvarnerexpress...
  20. Php Dynamic News Updating Using Mysql - changing a sites news using MySQL and PHP (3)
    Hey everyone. It appears to me that everyone really know what they are doing in this forum and im a
    pretty new to this PHP and MySQL combo. I know some PHP but not MySQL....I am trying to make a new
    website but i want to be able to go to a certain update page and change the news on the main index.
    For example: - The main page show news updates of the last 10 post. - I go to the update page
    and then fill in the form and it will add this post to the top of the list and still only print the
    top 10. I have no clue how to do this with MySQL. At the moment i am doing it u...
  21. Elseif Statement Not Doing The Right Thing - (3)
    CODE elseif
    ("$username=''.$password=''.$fullname=''.$countr
    y=''.$email=''") { print "<table border='0'
    align='center' valign='center' width='400'
    height='400'><tr><td align='center'><font
    size='2'><b>You did not fill out all the fields</b><br><A
    HREF='javascript:history.back()'><img
    src='http://www.online.trap17.com/images/go_backb...
  22. Calling All Php Programmerss Help Needed - as soon as possible (2)
    hello people im currently working on an open source web software installer kinda like fantastico ,
    but actually for webservers running apache on windows based systems and the biggest part of this
    will be an update website, where people that have already got this installed can actually update the
    existing packages, i have already figured out how the downloads work but im kinda running out of
    ideas, so if anyone has any idea what i could include please tell me, jus give me the idea and ill
    try sort out the code. so any suggestion all i have got so far is 1.i know how to ge...
  23. Possible To Put An If Statement Inside A Variable? - (2)
    Ok, so I'm using the include() function on my website. Problem is I'm trying to include a
    search engine form into the layout which is stored in a variable, except the form has an if
    statement in it and I can't seem to get it working. Here's the code I'm trying to
    include... CODE Search: > Just wondering if it is possible for me to put this
    form with the if statement into a variable, or if there's another way that I could go about
    doing this. Thanks....



Looking for calling, variable, dynamic, list, sql, statement

Searching Video's for calling, variable, dynamic, list, sql, statement
advertisement



Calling A Variable From A Dynamic List In A Sql Statement



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE