in add_page i want to use dropdown menu to display picture in the same add_page.

Here is the link to sample code that can change the image based on dropdown box selection:

http://www.ahfb2000.com/webmaster_help_desk/showpost.php?p=29853&postcount=2
You need to modify this code accordingly and plug it in using Javascript API. Here is an example of adding code to dropdown box "change" event:

http://xlinesoft.com/phprunner/docs/show_dropdown_list_of_us_states.htm

Hi admin
I already created dropdown list from lookup wizard

and I used php code snippet to display the pictures, I have 3 pictures in files.
I used this is code in php code snippet.
$sql = "SELECT Presidents FROM President";

$rs = CustomQuery($sql);

$data = db_fetch_array($rs);

echo "<img width=\"95\" height=\"90\" src=\"files/".$data["Presidents"]."\">";
this the picture

this is the table.

SELECT

PresidentID,

UserID,

Haiti,

Presidents,

VotezPour,

Nom,

Photo,

InitialeParti,

Departement,

Arrondissement,

Commune,

Section/Ville,

View

FROM Presiden

If you want to dynamically load images from the database you need to modify your code to make an AJAX call.

Hi Gile

can you show me some example about code AJAX call, and can I use the code in PHP-code-Snippet.

The server side code you will call with the AJAX call should be put in a external file or in the "List page: Before process" event. I will opt for the second solution:
On the Add page, near the dropdown, enter a template var like this:

In the "Before display" event of the Add page enter the following code:

In the "Javascript onload" event of the President Add page enter the code to handle the change of the dropdown value:

In the "List page: Before process" event of the President page:

In the "Before display" event of the Add page enter the following code:

In the "Javascript onload" event of the President Add page enter the code to handle the change of the dropdown value:

In the "List page: Before process" event of the President page:

Hi Gile

Thank you

I used this code you sent me, no picture display I dont know if I miss something,

or do i have to modify some of the code you sent me?
thanks agian

Change the SQL query according to your table structure.

Hi Gile

thanks again

yes i Changed the SQL query according to my table structure.

but no picture display in {president_photo}.
look at the pictures i put

If you can send me a demo link (as a PM if it is more comfortable), I will try to fix the error for you.

Hi Gile

How can i send the demo link to you

http://xlinesoft.com/phprunner/docs/what_is_demoaccount.htm

Hi Gile

I have a problem to login to demo account

i have an orther table like that
this is the table.

the table name is vote
SELECT

candidatID,

UserID,

Name,

Photo,

FROM vote
Thanks

Joel,
When you get your problem solved, do you mind sharing the final working code with us? Thanks!

yes i will

Joel,
you need to contact support directly in this regard. Open ticket at http://support.xlinesoft.com sending your sending your project file.

Hi Gile
this is the link : for open ticket

http://xlinesoft.com/dss/support.asp?link=history&mess=ok