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.

A
Anonymous
July 7, 2011

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.


Hello friend,

http://www.millcon.nl/Harm/Personal_data.xml has an error message that says

error on line 21 at column 14: error parsing attribute name

Below is a rendering of the page up to the first error.


Line 21 with the error is:

<Date & Time>2011-03-27 12:34:52</Date & Time>

Date & Time is not a preferred method for valid xml tag naming convention. Ideally you would have lowercase, no spaces, and no special characters ie date_and_time

Fix that for all tags and you should be able to create dataSet. Let us know if you have any other problems.

best,

Shocker

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