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
need help in update query
hi
i have a dynamic form. i need help in how can i use update query when values from dynamic for
Baffled by Undefined Index in Simple Array: Please Help!
Hello. I have a form which posts an array to this script. However, I can't seem to access the values
Help: calling function
Hi,
Is it possible to call a php function on page close?
If yes, could you explain how and whe
Open link with largest int string first
I have the following links i would like to open either all at once or one-by-one. How would i procee
Need help with basic sql
Hi,
I am using oracle 10g, and having some small doubts related to sql , here goes the si
Calling strings from other php class
I have test1.php{
$string1;
$string2;
....
... //10 strings in this class <
Session login issue
I'm wondering how to fix a problem I'm having with a session-based login system
Say I go to h
if description does not contain the following words
Hello everyone,
I am parsing a MS Excel (.xls) file and adding it's content to a mySQL databa
How to restrict the display of report variants
Hello All,
I want t know how to restrict the display of report variants.
I mean, whe
PHP hyperlinks generator
Hi
I need some help to get this done using php:
1 - I have few hyperlinks say 500