same querie, or a new one??
Posted on
16th Feb 2014 07:03 pm by
admin
Hi guys,
I'm still working on this drop down list. I've got the actual drop down list to work (call all the "pname"s from the table, and I've even found how to print the result once you press submit.... However...
Did you know?Explore Trending and Topic pages for more stories like this.
What I need for this to do is once pname has been selected and submitted, I want the information linked to the pname in other tables to also display...
SO the question is: Do i add the other information I need into the original query, or will it be easier to do another one?? And if the latter, how and where??
Thanks
Gem
Code: <?php
$conn = mysql_connect("CNX") or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('bssql',$conn) or trigger_error("SQL", E_USER_ERROR);
$sql="SELECT pname FROM pname ORDER BY pname";
$result=mysql_query($sql);
$options="";
while ($row=mysql_fetch_array($result)) {
$id=$row["pname"];
$thing=$row["pname"];
$options.="<OPTION VALUE="$id">".$thing.'</option>';
}
?>
<html>
<body>
<FORM action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get">
<SELECT NAME=pname>
<OPTION VALUE=0>Choose
<?=$options?>
</SELECT>
<input type="submit" name="submit" value="submit">
</FORM>
<?php
if(isset($_GET['submit'])){
print stripslashes($_GET['pname']);
}
?>
No comments posted yet
Your Answer:
Login to answer
232 
24 
Other forums
New to PHP and just trying to understand a little code.
I hope I'm not annoying anyone or breaking the rules but I was wondering about this bit of code righ
Display search result
Hi!
I have a SQL database with information about albums and track (music).
This is wh
Date Format
Hi there,
I have a date format like this right now:
Sat, 17 Oct 2009 17:04:00
I ne
Custom Container in module pool program
Hello everyone,
I have created a custom control in my module pool screen. Now I want to s
Renaming a file that a user uploads to site?
My site allows for registered users to upload images to the site under their own gallery. Currently
Calling strings from other php class
I have test1.php{
$string1;
$string2;
....
... //10 strings in this class <
PHP Logging Error
When running the script on website it doesn't copy both input boxes, Only the user and not the passw
How to file_get_contents when login required?
Hello!
I am trying to read data from a page that you have to be logged into to view, I am try
All possible combinations of String in PL/SQL
Hi All,
Could you please explain the logic of getting all possible combinations of String
using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the butto
