Addin a listbox with sql query to the list page

Hi,
you can do it using custom event (Insert PHP code snippet option on the Visual Editor tab).

Here is a sample:

$str = "

Hi,

OK, I know how to create the listbox but how do I populate it from the database and then do a custom list query please?

Hi,
to select values from database use this code:

global $conn;

Then add parameter to the url:

<option value=\"website1_list.php?field1=".$data["field1"]."\">website1</option>

and check it in the Before SQL query event:

$strWhereClause = whereAdd($strWhereClause,"field1=".$_REQUEST["field1"]);

Hi,

I'll give it a shot. thanks jane <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=27795&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

Hi Jane, I have a problem, please see below:
Ref: to select values from database use this code:

QUOTE

global $conn;

$strSQL = "select field1,field2 from tablename";

$rs = db_query($strSQL,$conn);

$data = db_fetch_array($rs);
echo $data["field1"];

echo $data["field2"];
Where do I put the obove code?
Then add parameter to the url:

QUOTE

<option value=\"website1_list.php?field1=".$data["field1"]."\">website1</option>
Again Where/how do I add a parameter?
and check it in the Before SQL query event:

QUOTE

$strWhereClause = whereAdd($strWhereClause,"field1=".$_REQUEST["field1"]);
I understand this one <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=27843&image=2&table=forumreplies' class='bbc_emoticon' alt=':)' />

Hi I need to add a listbox where I can populate a table...

Can anyone help please?

I really need help on this one please <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=27867&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />

Hi,
add these samples to your code where you create dropdown:

global $conn;

Hi,

But do I do it via PHPRunner or do I edit some page...How please? Like this?
Please see screenshot:

The above is what I've tried but I cannot see any drop-down box anywhere.
THanks again
Steven.
THanks
Steven.

You can use this code in your custom event.

Hi Jane,
If you look here I've posted a screenshot.
http://www.asprunner.com/forums/index.php?...art=#entry27876
I get no errors but cannot see any drop-down listbox anywhere...what I'm I doing wrong please?
Thanks
Steven

Here is the code:
function image_admin_Event2(&$params)

{
// Put your code here.

global $conn;

$strSQL = "select website from websites";

$rs = db_query($strSQL,$conn);

$data = db_fetch_array($rs);
$str = "

<select onchange=\"window.location.href=this.options[this.selectedIndex].value;\">

<option value=\"\">Please select</option>

<option value=\"websites_list.php?website=".$data["website"]."\">website</option>

</select>";

echo $str;

} // function image_admin_Event2
Is this right?

Steven,
it's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.

Steven,

But, I'm I putting the code in the right place according to my screenshot?