kvarnerexpress
Mar 30 2005, 10:07 PM
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
Mar 30 2005, 11:20 PM
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
Mar 31 2005, 04:19 AM
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
Recent Queries:--
php post to same page - 389.60 hr back. (1)
Similar Topics
Keywords : calling variable dynamic sql statement- 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...
Unexpected T_variable...
- Help! (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']."...
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 ...
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"); ...
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]; ...
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...
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...
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...
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...
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); ...
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...
<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:...
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...
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...
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!...
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 . "...
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<...
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...
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...
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...
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...
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
|
|