Skip to main content
Harm_Millaard
Harm_Millaard
Inspiring
July 7, 2011
Question

Basic help with radio buttons and functions

  • July 7, 2011
  • 1 reply
  • 1206 views

I have a page, http://ppbm5.com/DB-PPBM5-3.php

which contains several radio button groups in tabbed panels. I can use the alert function to display the clicked button to see the value of the selected button.

I need to use that value to create a WHERE statement to requery a mySQL database in a real-time manner.

For instance:

When clicking on 'Asus' in the Manufacturer panel, I need to modify the query to:

$new_query = $old_query . "Manufacturer LIKE " .  "the variable now shown as Asus" . "ORDER BY Total, RPI ASC"

and then:

$Result = mysql_query( $new_query, $mysql)

How do I make this work?

I want to have a situation where the database is requeried everytime a radio button is clicked and updated in real time.

This topic has been closed for replies.

1 reply

A
Anonymous
July 7, 2011

You have already posted this question several times and a solution was provided, but you said you were unsuccessful. You did not express desire to pursue the solution and instead decided to attempt your own method. It's useless for others to provide solutions if you do not use them.

http://forums.adobe.com/thread/871475

best,

Shocker

Harm_Millaard
Harm_MillaardAuthor
Inspiring
July 7, 2011

Can't create a Spry data set.

There is no way I can get it to work:

Followed the instruction videos step by step, but no way does it work. So the solution provided was not a solution at all. Merely a suggestion to look at alternative approaches which did not work out.

If it does not work, you have to follow other roads.

Harm_Millaard
Harm_MillaardAuthor
Inspiring
July 7, 2011
There is no way I can get it to work:

Mr. Millard,

No way? There is no way? Are you serious? There IS absolutely a way to get it to work since many others have been able to get it to work for them. Desire to pursue working methods is required along with detailed explanation of what you've tried so far that has resulted in the error message you receive. You have not provided the code for personal_data.xml and/or DB-PPBM5-3.php therefore you can not receive assistance in determining what the problem may be. Do you have your testing server properly defined as suggested in the error message? Upload the dynamic php to xml file to your server and provide a link to the file so others can see the xml syntax that is being produced from your php script.

If you want to tiss about it banging your fists on the ground saying there's no way to get it to work then well... I hope you somehow find a way to get it to work. If you want to describe the steps you've taken thus far then perhaps someone will be able to determine why you can not get it to work and suggest a way to get it to work for you. I have no desire to help someone that does not want to try the methods recommended.

best,

Shocker


Here are the links to both files

http://www.millcon.nl/Harm/Personal_data.xml

http://www.millcon.nl/Harm/DB-PPBM5-3.html

where the last file is just a renamed version of the php file, with the login data and password removed.

My testing server appears to be OK, seeing the V's behind the checkboxes. I have the server behavior in working order and according to the instruction video I need to go to the bindings menu and add a Spry data set. When I do that it always comes back with a schema not found.

I first enter the DB-PPBM5-3.php file and then browse to the Personal_data.xml for the Direct Feed Design. I can't get past this step. The .XML file was a direct export of the first record of the mySQL database from the host and saved locally. In my stupidity I expect that to be OK, but it really has been a trial and error effort over the last couple of days and I'm stuck.

Please let me know what further info you may want or need. I appreciate the help.

BTW, I also tried to export the current database as XML from the host and that gave the same problem. I tried to enter that as the source for the binding, but that did not work either. I also tried to figure out what XPath should be set to, but I have no idea.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices