Search results for query: *

I have this statement for sql: SELECT * FROM `used_autos` WHERE `mileage` >= 25000 AND <= 50000 ORDER by make I'm trying to pull all used autos where the mileage is greater than or equal to 25,000 and less than or equal to 50,000. Obviously, I have something wrong in my syntax. Thanks in...

I have this sql statement: SELECT * FROM projects WHERE `username` = 'FAA' OR `username` = 'faa' AND `password` = 'ASW2004' OR `password` = 'asw2004' in order to check for whether for the correct combination whether the user used upper or lower case. It's returning 2 rows from the database but...

I have a file where I want a Reset button to clear the form. I have put <SCRIPT LANGUAGE="JavaScript"> function clear(form) { document.form1.wid.value=""; document.form1.heigh.value=""; } </script> as the script within the head codes and <INPUT TYPE="reset" VALUE="=RESET="...

I know this should be a piece of cake but I've looked at the code until I'm foggy-eyed and can't see my problem; maybe a fresh pair of eyes can spot the problem. I have two php pages; I "think" I have identical code on the reset button for both but cannot get it to refresh the fields to empty...

I need to select two projects from my database. I have the statement: Select * from projects WHERE `project_name` = "A New Project" && WHERE `project_name` = "John's Project" It doesn't like that; what is the syntax for selecting multiple entries? I tried it without the second "WHERE" and...

I have a php which takes input from a form. I do error-checking on what the user has keyed in; if there are problems, I re-display the form and populate the fields with what they originally keyed in. I have the program working with the exception of the "description" field which comes from a text...

I have a regular vanilla form with 2 dropdown menus. An AOL friend does not see the dropdown choices - that area is just blank. Is it AOL and, if so, how can I fix it so AOL users see the choices? Thanks in advance. Anna Sue

I am new to PHP and I know this is a very simple question; please forgive me. I want to write a function that will print an entire table in html. I have: function writetable() { ?> "ALL THE HTML TABLE STUFF" <?php } then I try calling the function as: writetable(); I'm getting an error -...

Is there a way, like in perl, to print all the data being returned to your .php file from a form? I have a Submit button and "think" I have it coded correctly but if I test: if ($submit) I get a false. Thanks in advance.

I am very new to php and mysql and I know this is simple but I've searched the www.php.net site as well as the www.mysql.com site and can't locate the answer. I have one of my fields in my table set to a date field. I cannot determine how to write today's date to it. Thanks in advance.

I am VERY new to PHP but have cgi/perl experience. I have a dropdown box on my form: <p><font face="Verdana"><small>Question 5 :</small><br> <small><select name="champ5[]" size="2" multiple> <option selected value="0">Choose</option> <option...