Maq

Just as I suspected, the error lies between the chair and the computer...

I'm not really sure, I did a google search for you and found this link: microsoft CGI header error Are you using another CGI script you're aware of? If you are, they said put this in it. print "HTTP/1.0 200 OK\n"; print "Content-Type: text/html\n\n\n"; I could be entirely wrong...

Try this just to make sure... $limit = $_POST['limit']; $value = $_POST['value']; IF ($value != ""){ $cl = mysql_query("SELECT * FROM `data` WHERE `$value` = 'yes'")or die(mysql_error()); $num = mysql_num_rows($cl); } $num = 4; $limit = 3; IF ($num > $limit){ Echo 'It is workin'; }

Check out Count(*). It allows you to collect the number of records for your desired condition. There's plenty of examples online.

Do you get any errors? What is the output? And, as zanus said, post the entire script there's obviously something else wrong...

Could you post the entire code?

Seems like there are so many young people on these forums.  I mean I'm only 22 but I keep seeing kids like 15-20 years old with more years experience than I have...  :P

You should start your table above the while loop and end it after the while loop.

The double breadcrumbs issue happens randomly but I've noticed it always appears for replies. Would you like me to keep track of when this occurs for you?

agreed.

Correct me if I'm wrong, but I think you're forgetting a single quote towards the end: $query="SELECT * FROM Property ORDER BY PROPERTY_ID WHERE Property_suburb LIKE '%{$_POST['search']}%'";

Yep, if you use GET to pass your database name via URL and you're prone for SQL injections. Plus, people have more information about your database, which in my opinion, isn't bad.

I don't want people knowing the names of my databases, especially hackers?

Are there errors? What's happening?

It's hidden from the URL.

Then you need to $_GET a variable which isn't safe because you're passing your database via HTTP. You should $_POST it in a hidden type, which is basic HTML. I don't see your problem, can you post your code?

Yes, thorpe is right, as always. Look at the link it shows you how to do this. This is something that needs to be self taught. These forums are for help here and there, unless you want to post in the freelance section and have someone do it for you...

Try: $query="SELECT * FROM Property ORDER BY PROPERTY_ID" WHERE Property_suburb like '$_POST['search']'";

Yeah, well holiks registered back in '03 so much has probably changed, as I've only been here since this year. Go to that sticky link I provided, it explains a lot of this.

First of all that link is 404'd. Do you have any knowledge of HTML?

I know cause I used the code tags and started it with "<?php". Can you echo the $variable5 to make sure there's a value?

I think there is a sticky for this stuff, but my time shows up correctly, idk... Sticky Link

So it's probably the script. Please post it. What does this script do? Are there any errors? Without this information we really can't help you.

Try something like this (not tested): $user="root"; // usually $host="localhost"; // usually $password="your_password"; $database = "video1"; $connection = mysql_connect($host,$user,$password) or die ("couldn't connect to server"); $db = mysql_select_db($database,$connection) or die ("Couldn't select database"); $query = "SELECT Name, Code, Uploader, Description FROM stuff "; $results = mysql_query ($query) ; while ( $row = mysql_fetch_array($results)) { echo $row['Name']; echo $row['Code']; echo $row['Uploader']; echo $row['Description']; } Of course you have to create the HTML part.

I didn't see this mentioned, but maybe it was, what are the major differences/upgrades? Looks pretty much the same except for minor CSS modifications...