Just Plain Illogical... Look at this-

[ElectricRain]

$query = 
"SELECT 
* 
FROM 
tenants
WHERE
maxrent >= '$maxrent'";

$result = mysql_query ($query) or die(mysql_error()); 

if (mysql_num_rows($result) > 0) { 
    //if results 
 		print "there are records";
    } 


else { 
    // if no results 
    echo "No records found!"; 
     }

A simple enough query, right? Ok so. my table is named tenants, and it has maxrent and maxprice coloumns. Theyre both in the same format (varchar). The form that posts to this query contains maxrent and maxprice select boxes. No spelling mistakes. Both have option values that are simple numbers, with no spaces and no commas. The only thing that is different, is that maxprice is disabled by default until another select box (buyorrent) is changed to the buy value. This should probably not make a difference anyway.

Problem is, that when I change maxrent and $maxrent in the query above to maxprice and $maxprice, it prints 'no records found' even when there are records. I have no idea why...?

[BIOSTALL]

if you echo $maxprice what value does it say??

BIOSTALL

[ElectricRain]

When I leave the rent/buy select box on rent (default) it does not say anything.
When I change that box to buy it echos whatever number Ive selected on the $maxrent select box.
Do you think it is the buy/rent box that is causing the problems?
Im going to try dissasociating it from the others and see if it helps, but I shall be confused if it does, becuase Im not calling on that box in my query atall 😕 .

[ElectricRain]

I tried removing the javascript that enables the maxprice select box on the changing of the buy/rent box. It had a weird effect- with that missing the query above with the maxrent/$maxrent in it always returned that there were results. The same query with maxprice/$maxprice in always returned that there werent.

Whats going on?? Where am I likely to have screwed up here? It all looks right to me =/

[BIOSTALL]

Maybe you could post your code including the bit that deals with the javascript??

BIOSTALL

[ElectricRain]

Ok, its a bit long, so Ive erased everything except the relevant javascripts/ sel boxes.

This is the javascript.

function enableBox(selBox, boxId) { 
var selval = selBox.options[selBox.selectedIndex].value; 
if(selval == 'buy') { 
  document.form1.maxrent.disabled=true;
  document.form1.maxprice.disabled=false;
} 
else { 
  document.form1.maxrent.disabled=false;
  document.form1.maxprice.disabled=true;
} 
}  

Heres the buy/rent box

<SELECT NAME="buyorrent" onchange='enableBox(this);' STYLE="width: 100;">
<OPTION VALUE="rent">Rent</OPTION>
<OPTION VALUE="buy">Buy</OPTION>
</SELECT>

And the maxrent/price boxes

<p>MONTHLY RENT
<br>
<SELECT NAME="maxrent"> 
<OPTION VALUE="100000">£1500+</OPTION>
<OPTION VALUE="1400">£1400</OPTION>
<OPTION VALUE="1200">£1200</OPTION>
<OPTION VALUE="1000">£1000</OPTION> 
<OPTION VALUE="900">£900</OPTION>
<OPTION VALUE="800">£800</OPTION> 
<OPTION VALUE="700">£700</OPTION>
<OPTION VALUE="600">£600</OPTION>
<OPTION VALUE="500">£500</OPTION> 
<OPTION VALUE="400">£450</OPTION>
<OPTION VALUE="300">£300</OPTION> 
<OPTION VALUE="250">£250</OPTION>
<OPTION VALUE="200">£200</OPTION> 
<OPTION VALUE="150">£150</OPTION>
</SELECT> 
&nbsp;p/m
</p>
</td>

<td>
<p>PRICE
<SELECT NAME="maxprice" STYLE="width: 100;" DISABLED> 
<OPTION VALUE="2000000">£2,000,000</OPTION>
<OPTION VALUE="1500000">£1,500,000</OPTION>
<OPTION VALUE="1000000">£1,000,000</OPTION>
<OPTION VALUE="900000">£900,000</OPTION> 
<OPTION VALUE="850000">£850,000</OPTION>
// (...many more opt vaues) 
</SELECT>
</p>

[Richardtagger]

do you remember to change the post variable?

 
$maxprice = $_POST['maxprice']; // added this in?
$query = "SELECT * FROM tenants WHERE maxprice >= '$maxprice'";

$result = mysql_query ($query) or die(mysql_error()); 

if (mysql_num_rows($result) > 0) { 
    //if results
         echo "there are records";
    } 


else { 
    // if no results
    echo "No records found!"; 
     }  

[ElectricRain]

I tried that, but it did not help, I think it already recognises that $maxprice = $_POST[maxprice] when I ask it to print $maxprice it does come up with whichever select box option was checked.

[Richardtagger]

it doesnt recognise it on its own. why use print anyway? use echo, i prefer it. also note the ' ' within max price. to debug ad lots of echo $variable; then exit(); so itll stop and youll clearly be able to see your output. Echo the query, what does it say? try echoing $result then come back and tell us what you see.

[ElectricRain]

what is the difference between print and echo? Do they not do the same thing?
echo "$result"; outputs

Resource id #5

=/ I have no idea what that means.
explain again about the echo $variables thing?

[Richardtagger]

well basically echo is 4% faster than print, for one, normally its personal preference. i ts quicker to type, its can output multiple strings and basically show anything you want print is a bit different. Most php programmers will use echo but you can use print if you really want to...

when a php script aint working what you have to do is go down line by line and echo the previous line then add an exit(); this helps you pin point where it all goes wrong. Otherwise you get a big script and a problem and you can spend hours fiddling towards wherer you think it is and all you have to is change something early on.

so go through your script and line by line debug it and check its right.

Resource id #5 shows that there are results and the query was succesful.

could you perhaps paste your whole code onto pastebin.com and then link us please.

[ElectricRain]

http://pastebin.com/317271 Here is the link to the entire script, its pretty much as above anyway, Ive simplified it right down to the basics in a attempt to eliminate the problem

Below is the form I am using in its entirity with all j/scripts and everything
http://pastebin.com/317274

[Richardtagger]

well your still over complicating it slightly, also, please dont put your user/pass on paste bin 😮.

<?php
$username = "x";
$password = "x";
$hostname = "localhost";       

$dbh = mysql_connect($hostname, $username, $password)
        or die("Unable to connect to MySQL");
$selected = mysql_select_db("prop807_mark",$dbh)
        or die("Could not select prop807_mark");
// if you put this lot ^^^^^ in a file called db.php then on pages you want a db action put the line 
// include 'db.php'; you can get a db connection easier.
$maxprice = $_POST['maxprice'];

//query
$query = mysql_query("SELECT * FROM tenants WHERE maxprice >='$maxprice'") or die(mysql_error());
$rows = mysql_num_rows($query);
echo $rows;
exit();

//forget below here for now
if (mysql_num_rows($result) > 0) {
    while($row = mysql_fetch_row($result)) {

        echo ("This property is a &nbsp;".$row[7]."<br>");

} // end while

} // end if

else {

// if no results

echo "No records found!";
 }
?> 

what does that output?

[ElectricRain]

I know I know, I realised that as soon as Id done it, n then found out I couldnt delete it 🙁
Shall tell you in a sec...

[ElectricRain]

1 when rent is selected, 0 when buy is selected.

[ElectricRain]

... so I removed the javascript n so seperated the rentorbuy box from the maxprice one. Now I get 0 all of the time..

[Richardtagger]

what yyou need to do is make a new page and on it create a form with the things your testing, create them from scratch and have it post to that simple php script i set out. You mentioned seleected? are you using checkboxes now?

[Richardtagger]

do you have IM like AIM MSN or yahoo?

[ElectricRain]

[e-mail] on msn, I have yahoo too, but s'not set up on this machine, I shall try that with making a simpler form.