CORT0619

Yes I did for testing purposes after the fact. but excuse me if I thought this forum was for helping ppl, u don't have to be nasty.

No, I set up my code like requinix where the variable is set to array.

Okay, I'm having a problem with the implode function. I'm getting the error message "Invalid arguments passed" and I set $conditions equal to a string to verify that it wasn't coming up as null so I'm not sure what the problem is. My code is: if($conditions) { $query .= " WHERE " . implode(" AND ", $conditions); echo $query; }

Oh ok. Well there is only one field that isn't coming from a selection list.

Ok I will do that Christian. Requinix so where the code says /* escape($name) */ am I supposed to just put the variable name?

I was wondering if I can do an if statement within the sql query such as "if(empty($name) || $name == '' || $name == null) {}else{name='$name'}" however I'm not sure how to write it correctly, because the sql query is embedded within php.

Well an example of my current query is $query = "SELECT ticket#, date, name, phone, email, description, tech, notes FROM table WHERE name='$name' OR email='$email' OR phone='$phone' OR tech='$tech'"; But for instance if the administrator selects just the name and that's it, all of the tickets still come up because OR is used in the WHERE part of the query.

Does anyone know of a way that I can use php to determine if a variable is included in a query? But the thing is that I don't think it could be a simple if statement because it's not just one variable I'm testing it's many. My problem is that I'm trying to check whether the variable has a value and if it does to then include it in the query but in the "WHERE" part of the sql query. But like I said any of the variables that have a value would also be included in the same query. Thanks.

Thanks alot to everyone who responded. I'm on the right track!

Well i have the opening and closing form tags as well as get as the action and search.php as the method which is the current page.

So, I'm using the get request to send values input by the user through the url to another page: <a href="tms.php?ticket_num=$ticket_num&name=$name&email=$email&phone=$phone&problem=$problem&tech=$tech"><input type="submit" value="Search" /></a> however, once I click the above button the url reads: <form>http://localhost/get?ticket_num=1234&name=Tiffany+Happy&email=tharmon15%40gmail.com&phone=3523453643&problem=hardware+issue&tech=Calvin+Schaffer</form> So, I'm wondering why the url changes to get? instead of tms.php? Thanks, -Crystal.

Thanks Drongo this is perfect!

I'm creating a form and I don't know much javascript but I have a value that displays in a textbook before the user enters anything and I would like to clear the textbook on click but I was wondering if I could set it to only be cleared on the first click or something like that because if the user enters a value and accidentally clicks again I don't want that value to be cleared. Thanks, -Crystal.

I don't think so. This pretty much allows the developer to create pages keeping the content and design separate.

Does anyone know where I can get information about pagelets from? Just in case they go by another name a pagelet is where you pretty much build your entire website off of a template and it doesn't require as much code. On one page you would have the general template where you would put a variable that would maybe represent the page title, something to represent where the body would go for each page that would be based off of the name of the page, maybe an include for the navigation bar and maybe an include for the footer. Then on another page you would define what those variables were for each page. Then there would be individual pages for each page with the information that will be in the body of the page.