Why cant anyone give a straigth answer?

vtec

Hi,

Im new to this. I have a code written in PHP which pulls info out of a MySql database with a select statement. I would like to add javascript to the HTML select code once its created. The current PHP code looks like this:

<? sysGetSelect(country, dt_countries) ?>

Once the code is generated in the browser, it looks like this:

<select name="country">
<option value="" selected>Select One</option>
<option value="6">Albania</option>
</select>

I just want to add this javascript line in there somehow:

How do I do that??

This won't work:

<? sysGetSelect(country, dt_countries) onChange=ChangeDetail(this.form)?>

What do I do? Im a newbie...

Also, when I use this variable:

$country

A numeric number is displayed for the country instead of the country NAME.
For example, using the info above, 6 would be displayed, instead of Albania.

In the MySql database, for the table dt_countries, I have these fields:

ID and NAME

ID is the numeric part and NAME is the letters.

So how do I call the Name part of the database from my PHP code?

Basically instead of 6, I want to display Alabama.

PLEASEEEE helpppp....... 🙁

move3rd

Also, when I use this variable:

$country

A numeric number is displayed for the country instead of the country NAME.
For example, using the info above, 6 would be displayed, instead of Albania.

The reason it displays 6 is becouse the value is 6 .

If you want it to display the country name:

<select name="country">
<option value="" selected>Select One</option>
<option value="Albania">Albania</option>
</select>

vtec

I cannot change the value from 6 to Albania. That is the ID field in the database. It cannot accept letters.

No one knows the answer to this. This is my 4th forum!

Frederick

You have to reference the id to get the field data. MySQL will only supply you with the data of the field you are quering.

So only referencing the id will give you the id number. You need to set a varaible to represent the field you want. Below is a different way to make your drop menu

$sql = mysql_query("SELECT * FROM tablename ORDER BY country")
or die(mysql_error());
while ($var = mysql_fetch_array($sql)) {
echo "<option value=\"".$var["country"]."\">".$var["country"]."</option>\n";
}

vtec

Hi,

I added this code and it does nothing:

<?
$sql = mysql_query("SELECT * FROM dt_countries ORDER BY country")
or die(mysql_error());
while ($var = mysql_fetch_array($sql)) {
echo "<option value=\"".$var["country"]."\">".$var["country"]."</option>\n";
}
?>

I didnt reference the ID field. I just use the variable $country, and it pulls out the ID from the database, instead of the country. I didnt write the script, I am just trying to customize it for me.

Everything would be fine if I just knew how to add this in the select drop down statement:

Currently it has this:

any ideas?

what and where in the code do i need to modify? can i email you the files? ahhhhhhhhhhh

it uses this to pull the full select drop down menu:

<? sysGetSelect(country, dt_countries) ?>

What can I replace it with so that I can add my javascript code to it?

helppp---> when i say newbie, i mean newbie...

Frederick

This example is based on you already having a DB connection established for this page.

<form action="pagename.php" method="post">
	<select name="country" onchange="this.form.submit();"> 
		<option value="" selected>Select One</option> 
		<option value="6">Albania</option>
	</select>
</form>
<?php
if (isset($submit)) {
	echo "<hr>\n";
	$sql = mysql_query("SELECT * FROM dt_countries WHERE country = $country")
	or die(mysql_error());
	$var = mysql_fetch_array($sql);
	echo "Country: ".$var["counrty"]."\n";
}
?>

dalecosp

Originally posted by vtec
Hi,

Im new to this. I have a code written in PHP which pulls info out of a MySql database with a select statement. I would like to add javascript to the HTML select code once its created. The current PHP code looks like this:

<? sysGetSelect(country, dt_countries) ?>

Once the code is generated in the browser, it looks like this:

<select name="country">
<option value="" selected>Select One</option>
<option value="6">Albania</option>
</select>

I just want to add this javascript line in there somehow:

<select name="country" onChange=ChangeDetail(this.form)>

How do I do that??

You must find the file in which the function "sysGetSelect" is defined, and add your javascript to the print() or echo() statement used by this function to produce the HTML output you have shown us....

This won't work:

<? sysGetSelect(country, dt_countries) onChange=ChangeDetail(this.form)?>

Of course it won't --- you are quite right about that.

Are you on a 'Nix box?

 $grep -R sysGetSelect *

may find the function for you ... otherwise, look manually through either the documentation or the source code itself until you find where this function is located, and you'll probably see what to do. Otherwise, post the code for this function back to this thread and somebody will probably help you out [if you ask nicely 😉 😃 ]

dalecosp

On second thought, even if you make the changes yourself, you might want to post your "improved" PHP code back here for purview. I'm thinking that that looks like a real broad function [IOW, used to create several selects of different types throughtout your app], so you might break other SELECTs if you don't rewrite the function carefully....

vtec

:p 😉 :p 😉 😃

I got it!!! Thanks sooo much. i was doing this for 18 hours, but I knew it was a VERYYYYY small thing...

I was actually just about to give up, and I decided to check the forum once more.

Thanks sooooo much!! I was sooo frustrated!!

🆒

dalecosp

You should never sit at a computer for 18 hours ... could be dangerous :eek: 😃 You are welcome, of course. PHPBuilder is a PGF, maybe even a RGF, and most often you'll get an answer if you ask a good question (check some of the FAQ's, etc. and you'll see some advice on this ... not to say your question was bad; it wasn't, though it could have had a better subject line), but you do need to remember that people sleep, work, take vacations, etc. and don't necessarily live on the boards. I myself am trying to limit my postings so I can actually work for my company a little more in the future ... 😉

*Pretty Good Forum(tm), Real Good Forum(tm)