Radio buttons

arelgee

First off, it will help to see what I plan to search through. This is a page with 25 tables of the 135 I have.

My List
Some of you may be familiar with stock screeners on some financial websites. As you can see in the tables, I have 33 fields with varying data. I want to write a php script to sort through it.
I will use financial rank for an example, but there will be at least 17 others.

Financial Rank Don't Care Mid 1/3 * Top 1/3

If the user selects "Don't Care", there is nothing to do. But if the user selects Mid or Top, I will use the appropriate value. One set has a value of 0 (lowest) to 9 (highest) integers only. The number would be like this

Don't Care No coding // 0-9
Mid FinRnk > 3; // 4-9 at least 4
Top FinRnk > 5; // 6-9 at least 6

So the query would go like this:

Select * from MrBig where FinRnk > 3;

This is fairly simple so far, but how do I construct the SELECT statement and only use the values that are mid or top?

I know about the printf function but can I use an if clause to check if the button is "Don't Care" and skip that line in the query. If so, how?
I will tell the user in the instructions not to enter TOP in all fields because there is no chance he will get any "hits". I would say that no more that 4 middles and 4 tops should be chosen at one time, and a maximum of 10 choices other than Don't care.
Thanks in advance

My List

mysql_query

Uhh, I'm really not sure what you mean, so I will tell you what I did when I needed a rating system with values that go from 1 (low) to 5 (Very High)

I made the radio buttons in Front Page and gave them the variable names 1 through 5. Looked like this:

<input type="radio" value="5" checked name="rating">Excellent&nbsp;
  <input type="radio" name="rating" value="4">Good&nbsp;
  <input type="radio" name="rating" value="3">OK&nbsp;
  <input type="radio" name="rating" value="2">Not-so-good&nbsp;
  <input type="radio" name="rating" value="1">Sucks</p>

Then I worked with them as they are, without any arrays or anything similar. For example, if a user selects "Sucks", the number 1 goes into the database. In retrospect, if a user selects "Excellent", the number 5 goes into the database.

I'm not sure exactly what you need, but I hope this points you in the right direction.

Good luck.

arelgee

Many Thanx. As you can probably tell, I have about a month in php and on this forum. I tried to paste my php code but the explorer wouldn't take pasting. But below is a snippet from the code I already have. Just multiply it by about 11 times.

Financial Rank------->

<input type="radio" value="1" checked name="FR">Don't Care;
<input type="radio" name="FR" value="2"> 2nd 1/4;
<input type="radio" name="FR" value="3"> 3rd 1/4;
<input type="radio" name="FR" value="4"> Top 1/4

<br>
Volatility Rank------>

<input type="radio" value="1" checked name="VR">Don't Care
<input type="radio" name="VR" value="2"> 2nd 1/4
<input type="radio" name="VR" value="3"> 3rd 1/4
<input type="radio" name="VR" value="4"> Top 1/4

If a user selects FR as "3rd 1/4 but leaves VR as Don't Care, I need to code this.

if($FR ==3)....Query text = "Select from MrBig where FinRnk >67 (135 / 4) 2 = 67)

And since VR = 1 I don't want anything added to my query statements.
if($VR ==1) Do nothing.

At the end, I would have at most 10 choices to code in the query statement. I use C++ Builder for regular programming and I would simply code it this way.

if(FR ==3)QueryString->Lines->Append("Select * from MrBig where FinRnk >67 ");
And for VR
if(VR ==1) //Emptyness;

So, my select statement needs to look like this:
(Select * from MrBig where
$FR >67 AND
$GT > 6 AND
$LD > 3 AND
$UT > 5 AND
etc.
Order by $FinFNK);// I keep forgetting the $$$$'s;

I have 3 years invested in the code for my stock analysis program that produced the tables on my list. I am getting close to finishing it.
arelgee@are-l-gee.com

arelgee

Anybody interested in seeing how complicated a radio button form can be should load this up. Believe it or not, I have 3 more lines of buttons to add.

<h2>Hello and Welcome to arelgee's penny stock screener</h2>

<p>
Financial Rank------->
<input type="radio" value="1" checked name="FR">Don't Care
<input type="radio" name="FR" value="2"> 2nd 1/4
<input type="radio" name="FR" value="3"> 3rd 1/4
<input type="radio" name="FR" value="4"> Top 1/4

<br>
Volatility Rank------>
<input type="radio" value="1" checked name="VR">Don't Care
<input type="radio" name="VR" value="2"> 2nd 1/4
<input type="radio" name="VR" value="3"> 3rd 1/4;
<input type="radio" name="VR" value="4"> Top 1/4

<br>
Fundamental Rank->
<input type="radio" value="1" checked name="FDR">Don't Care
<input type="radio" name="FDR" value="2"> 2nd 1/4
<input type="radio" name="FDR" value="3"> 3rd 1/4
<input type="radio" name="FDR" value="4"> Top 1/4

<br>
EarnScore Rank---->
<input type="radio" value="1" checked name="ER">Don't Care
<input type="radio" name="ER" value="2"> 2nd 1/4
<input type="radio" name="ER" value="3"> 3rd 1/4
<input type="radio" name="ER" value="4"> Top 1/4

<hr>
Earnings----->
<input type="radio" name="EF" value="1" checked>Don't Care
<input type="radio" name="EF" value="2">Mid 1/3
<input type="radio" name="EF" value="3">Top 1/3
<br>

Sales-------->
<input type="radio" name="SF" value="1" checked>Don't Care
<input type="radio" name="SF" value="2">Mid 1/3
<input type="radio" name="SF" value="3">Top 1/3
<br>

Book Value--->
<input type="radio" name="BF" value="1" checked>Don't Care
<input type="radio" name="BF" value="2">Mid 1/3
<input type="radio" name="BF" value="3">Top 1/3
<br>

Cash Flow---->
<input type="radio" name="CF" value="1" checked>Don't Care;
<input type="radio" name="CF" value="2">Mid 1/3
<input type="radio" name="CF" value="3">Top 1/3

<br>
Cash on Hand->;
<input type="radio" name="CH" value="1" checked>Don't Care
<input type="radio" name="CH" value="2">Mid 1/3
<input type="radio" name="CH" value="3">Top 1/3

<hr>
Current Ratio--->;
<input type="radio" name="CRF" value="1" checked>Don't Care
<input type="radio" name="CRF" value="2">Mid 1/3
<input type="radio" name="CRF" value="3">Top 1/3
<br>

TotD/E Factor--->;
<input type="radio" name="TDF" value="1" checked>Don't Care
<input type="radio" name="TDF" value="2">Mid 1/3
<input type="radio" name="TDF" value="3">Top 1/3
<br>

ROA Factor---->;
<input type="radio" name="RF" value="1" checked>Don't Care
<input type="radio" name="RF" value="2">Mid 1/3  
<input type="radio" name="RF" value="3">Top 1/3

<br>
Gross Margins->;
<input type="radio" name="GM" value="1" checked>Don't Care
<input type="radio" name="GM" value="2">Mid 1/3
<input type="radio" name="GM" value="3">Top 1/3

<hr>
Short % Factor--->;
<input type="radio" name="SPC" value="1" checked>Don't Care
<input type="radio" name="SPC" value="2">Mid 1/3
<input type="radio" name="SPC" value="3">Top 1/3
<br>

CPL(curr to low)--->;
<input type="radio" name="CPL" value="1" checked>Don't Care
<input type="radio" name="CPL" value="2">Mid 1/3
<input type="radio" name="CPL" value="3">Top 1/3
<br>

Churn Factor--->;
<input type="radio" name="CHF" value="1" checked>Don't Care
<input type="radio" name="CHF" value="2">Mid 1/3
<input type="radio" name="CHF" value="3">Top 1/3
<br>

NTA Factor---->;
<input type="radio" name="NTA" value="1" checked>Don't Care
<input type="radio" name="NTA" value="2">Mid 1/3
<input type="radio" name="NTA" value="3">Top 1/3

<br>
Burn Year------->;
<input type="radio" name="BY" value="1" checked>Don't Care
<input type="radio" name="BY" value="2">Mid 1/3
<input type="radio" name="BY" value="3">Top 1/3

<br>
Burn Quarter--->;
<input type="radio" name="BQ" value="1" checked>Don't Care
<input type="radio" name="BQ" value="2">Mid 1/3
<input type="radio" name="BQ" value="3">Top 1/3
<br>

Volume Factor---->;
<input type="radio" name="VF" value="1" checked>Don't Care
<input type="radio" name="VF" value="2">Mid 1/3
<input type="radio" name="VF" value="3">Top 1/3
<br>

Float Factor--->;
<input type="radio" name="FF" value="1" checked>Don't Care
<input type="radio" name="FF" value="2">Mid 1/3
<input type="radio" name="FF" value="3">Top 1/3
<br>

</form>
</body>
</html>

I have experimented with the code to make the query statement but so far have figured out only how to do it with a bunch of if statements. There will be about 70 or 80 of them. If anyone has any ideas, I would appreciate it.
arelgee
Yes, I know how to spell receive, but I needed a second one and didn't want to use receive2.

nemonoman

The method you describe of constructing a SELECT statement using if 70-80 if statements may be exactly what's required.

Might have the 'don't care' value of a radio button =0, however,

THEN construct the WHERE directly -- using ALL radiobutton values without checking, like this

WHERE
colONEvalue>=$radiobuttonONE AND
colTWOvalue>=$radiobuttonTWO AND...

etc.

since your default value ('don't care')==0, you'll select all records using the criteria >=0

This saves you having to come up with a special 'if' for each test of a radiobutton value as 'don'tcare'

arelgee

Good idea about checking to see if the value is Don't care. I was thinking about listing the if's like this:
if($FR == 1) $line1 = "";
if($FR == 2) $line1 = "FinRnk > 25"
if($FR ==3) $line1 = "FinRnk > 50" etc.

I can save some computer time by this:
if($FR != 1)
{

     code 

   }

if $FR is 1 then the other code is skipped. Also, I have decided to limit the search to ten choices. With so few stocks, eliminating 25% each choice quickly cuts down the possibilities.

I have decided to split the stock screener up into two parts. I have 3 sections of buttons that have 5, 4, and 8 rows of buttons each. I am going to combine the sections into one row. I call the first one Price Factors, these are factors that differ with the price.
This page will only have a total of 7 buttons. The catch is that the last 3 rows will have more choices, at least 5 each.
The logic in the screener is a little difficult. When you are selecting the 2nd 1/4 of the stocks, you are actually excluding the bottom 1/4 and selecting all the others.
I should get busy on my site now, I just got an email from a user that said he just made $2500 from a stock he found on my site.
rlg

arelgee

For a minute I thought I had it figured out. The code below works for the first 4 of the buttons. The only catch is that on the last line of the select statement, I have to figure out how to delete the AND.
It would be a piece of cake if each query had the same number of parameters.
Anyone have any ideas????


 <html>
<body>
<body bgcolor="#FFFFF0" text="#000000">

<?php

if($FR != 1)
    {
    	if($FR == 2)$L1 = "FinRnk < 90 AND ";
        if($FR == 3)$L1 = "FinRnk < 60 AND ";  

        if($FR == 4)$L1 = "FinRnk < 30 AND ";
    }

if($VR != 1)
    {
    	if($VR == 2)$L2 = "VltRnk < 90 AND ";
        if($VR == 3)$L2 = "VltRnk < 60 AND ";  

        if($VR == 4)$L2 = "VltRnk < 30 AND ";
    }

if($FDR != 1)
    {
    	if($FDR == 2)$L3 = "FundRnk < 90 AND ";
        if($FDR == 3)$L3 = "FundRnk < 60 AND ";  

        if($FDR == 4)$L3 = "FundRnk < 30 AND ";
    }

if($ER != 1)
    {
    	if($ER == 2)$L4 = "EarnRnk < 90  ";
        if($ER == 3)$L4 = "EarnRnk < 60  ";  

        if($ER == 4)$L4 = "EarnRnk < 30  ";
    }

$L9 = "Select * from MrBig where ";
$L8 = $L9 .= $L1 .= $L2 .= $L3 .= $L4;
echo $L8;

 $db = mysql_connect("localhost", "root") or die("Could not connect");
        mysql_select_db("STOCKS",$db);


   $result = mysql_query($L8 ,$db);

   if ($rw = mysql_fetch_array($result))
   {


 do
  { 
echo "<br><table border=1>\n";
   echo " <tr><td>Symbol</td><td>QtrEnd</td><td>FinScr</td><td>FinRnk</td><td>VltScr</td><td>VltRnk</td><td>FundScr</td><td>FundRnk</td><td>EarnScr</td><td>EarnRnk</td><td>1 Wk</td></tr>\n";

   printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n",$rw["SYMBOL"],$rw["QTREND"],$rw["FINSCR"],$rw["FINRNK"],$rw["VLTSCR"],$rw["VLTRNK"],$rw["FUNDSCR"],$rw["FUNDRNK"],$rw["EARNSCR"],$rw["EARNRNK"],$rw["ONEWK"]);

   echo" <tr><td>EFtr</td><td>SFtr</td><td>BFtr</td><td>CFFtr</td><td>CshFtr</td><td>PrcFtr</td><td>CRFtr</td><td>TDEFtr</td><td>RoaFtr</td><td>GMFtr</td><td>NPFtr</td></tr>\n";

   printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td>\n", $rw["EFTR"],$rw["SFTR"],$rw["BFTR"],$rw["CFFTR"],$rw["CSHFTR"],$rw["PRCFTR"],$rw["CRFTR"],$rw["TDEFTR"],$rw["ROAFTR"],$rw["GMFTR"],$rw["NPFTR"]);

   echo "<tr><td>ShrtFtr</td><td>CPLFtr</td><td>ChrnFtr</td><td>NTAFtr</td><td>BYFtr</td><td>BQFtr</td><td>VolmFtr</td><td>FltFtr</td><td>Total</td><td>2 Wks</td><td>4 Wks</td></tr>\n";

   printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td>\n", $rw["SHRTFTR"],$rw["CPLFTR"],$rw["CHRNFTR"],$rw["NTRFTR"],$rw["BYFTR"],$rw["BQFTR"],$rw["VOLMFTR"],$rw["FLTFTR"],$rw["TOTAL"],$rw["TWOWKS"],$rw["FOURWKS"]);

 	echo "</table>\n"; 

  } while ($rw = mysql_fetch_array($result));

   } else
     {
    	echo "Sorry, no records were found!";	
     }

?>

</body>
</html>

arelgee

It is very poor coding but I figured out one way to do it. With a dummy parameter for the last line.
I have a field ONEWK that is the gain for the past week. It could be from -99 to possibly 200, which would be a triple in stock price. So I used for my last line this:

$L99 = "ONEWK <> 999"

I wasn't sure what to do about the Don't Care values, but they kind of took care of themselves. Adding $L5 to the query string when $L5 isn't defined seems to work.
rlg

arelgee

I finally got the short version of my stock screener up and working. I did not post a link to it here because it will change soon. But anyone interested in seeing it can go to http//www.are-l-gee.com and choose Investing and then Investor Tools. I will make the code available but most of it is in this thread. There were some significant changes.
I still haven't figured out a better workaround than using the last part of the query statement as "ONWK > 999.
If you have any suggestions, let me know. I already know that the short factor does not show up and the tde factor is a repeat of another field. I will wait and complete all the fixes at once.
arelgee@are-l-gee.com

nemonoman

If you need a dummy parameter, use '1'. It selects everything

SELECT *
FROM presidents
WHERE 1

selects all rows of the table.

The following four statements select EXACTLY the same rows:

SELECT *
FROM presidents
WHERE lastname='BUSH'
AND firstname='GEORGE'

SELECT *
FROM presidents
WHERE lastname='BUSH'
AND firstname='GEORGE'
AND 1

SELECT *
FROM presidents
WHERE lastname='BUSH'
AND firstname='GEORGE'
OR 1

SELECT *
FROM presidents
WHERE lastname='BUSH'
AND firstname='GEORGE'
OR 1
AND 1

Nice stictuitiveness w. your program. As the Good Book says: Persistence in a righteous course brings reward.

arelgee

Is there any advantage in using 1 instead of ONWK <>999?(How often does a stock gain 999% in a week?)
This is the short version, on the long version I have 21 rows of radio buttons. I limit the length of the $QueryStmt by adding a counter on the long version. I have not decided yet how many to allow but logic would dictate about 8 to 10. The table I have to search is now only 126 rows and 34 columns, but that is subject to change. I don't want to slow down my site to a crawl with a lot of unneeded cycles.
When I get this finished, it will be for paying subscribers only so it behooves me to make it as fast as possible.

if($FR != 1)
    {
        if($FR == 2)$L1 = "FinRnk < 90 AND ";
        if($FR == 3)$L1 = "FinRnk < 60 AND ";  

        if($FR == 4)$L1 = "FinRnk < 30 AND ";
    }
else $counter++;

arelgee

nemonoman

Only that 'AND 1' provides certainty whereas '<>999' entails some uncertainty, albeit a rather small amount.