help on mysql/php query

[bimmer528]

I am trying to develop multiple dynamic menu fields with a simple submit to a query page. My questions is this,

I have the query page setup np with say this....

query.php?name=member&theresults=showme

I can call info np.

I can also call info even more sorted...

query.php?name=member&field2=blahblah&theresults=show+me

my questions is say I do want to have the option to my users to be able to query only certain fields. So if they wanted to only query name and not field2 it wouldn't give them an error.

I tried setting this up....

All menu's are dynamic, there are 4 of them total that 'get' from form in my query page.

How can I set it to where maybe the user wants to specify only 2,3, or 4 menu options and the query page will only return the results of 2,3, or 4.

I tried setting up just a blank value and label of N/A so that when a user has that option, it doens't return any results for them in the query page. so....

query.php?name=member&field2=&theresults=showme

the query page wont parse since their is no such blank entry in the database to which tries to call on.

dam im confusing.

[dalecosp]

Originally posted by bimmer528
dam im confusing.

A bit perhaps.

Worse than that, you posted absolutely no code. Mindreaders.com is another domain 😉

Tried looking at things like if_exist() and isset()?

[bimmer528]

🙁

SELECT name,sum(total_frags) AS tf,sum(total_hp) AS hp,sum(total_maps_sides) AS tms, sum(totoal_deaths) AS td,
vrs,map,team FROM ctf_fraggers WHERE name = '%s' AND vrs = '%s' GROUP BY name

Thats the query.php page where the mysql query will select and pull the info from my dynamic menu.

how can I set my query.php page to accept non selected menu options and only parse what was selected from the previous page.

example,
name=nick&vrs=blah&showme=result

This would pull the info np since thier is a nick in my name field and there is a blah from the vrs field.

How can I set my menu items to where say I could specify a non listed filed entry and still have my query page parse the info

Example, vrs does NOT have a entry called N/A

name=nick&vrs=N/A=showme=result

This will not work so how can I set the menu options to where I can have a non listed field entry and have the query php pass the info from only the name

little more sence now?

[bimmer528]

Well, i have not really gotton a response probally due to my lack of explanation, lol 😛

Here is an example

Here

Now, If (name) has a listing in the database as well as (vrs) it can display the fields no problem. However if you choose (name) bimmer which has a listing and (vrs) Not Selected which does not have a listing, no results show for anything. How can I set the query to where even if there is not a listing in (vrs) the results from (name) will still show up.

For example...

query="select from table where name='%s' OR vrs = '%s'

[dalecosp]

I'd have to admit to giving this little thought. It seems like a judicious application of logic would go a long way in helping you solve your issue [not that I'm too good at that :rolleyes: ].

Given that we have a table name and four fields (and therefore four possible variables) we should be able to construct a scheme that could construct a dynamic query quite simply using 'if' and a concatenation operator.

$sql="select * from table_name where";
if ($foo) {
     $sql.=" table1='".$foo."'";
}
if ($bar) {
     if ($foo) {
          $sql.=",";  // gotta determine if we need a comma
     }
     $sql.=" table2='".$bar."'";
} // etc. etc....