[discount code script problem]

I am sorry, but I don't see where you pull anything from the db. Could you explain a bit better where/what is the problem?

[Redirect]

To get a "cleaner" code I would recommend something like:

$location = "MainPageindexAsbuiltsDisplayYr.php?Dept=" . $_GET['Dept'] . "&Yr=" . $_GET['Yr'];

header("Location: $location");

[Calling function inside IF statement]

You are missing semicolons ( ; ) at the end of those lines. Try:

function choosejob($frmfunction) {
	if ($frmfunction === 2)
		{
		create_zip($file_path,$files,$zipname);
		} 
	else 
		{
		smtpmailer($to, $from, $from_name, $subject, $body, $file_path,$files);
		}
}
choosejob($frmfunction);

[Sorting titles without definite article advice]

You can stick to your query and just add this in the where clause, when you are searching for letter 't':

AND ((SUBSTRING(title,1,3) <> 'the')

[how to generat random 10 digit numbers]

I don't know if this question deserves an answer, but just googling what you wrote here, got me this as a first response:

http://elementdesignllc.com/2011/06/generate-random-10-digit-number-in-php/

 

So please don't be that lazy and try using google from time to time.

[3 tables joining, output errors]

You can do something like:

Select table1.*, table2.field as t2field, table3.field as t3field ..

 

Use the * for the table where you need all of the columns and from the other tables specify which fields you need and add "as" where needed (fields that have same name in more tables).

Avoid using the "*" when doing a select. Its not a good practice. Always fetch only the fields you need. Fetching more data then needed is never a good idea.

[3 tables joining, output errors]

Yes, but that should throw a query error that you have ambiguous field name. But that can be solved by adding in the query something like:

SELECT table1.field1 as t1field1, table2.field1 as t2field1, table3.field1 as t3field1 .....

 

So then you can pull out the field you need with $row['t1filed1'], $row['t2field1'] and so on.

[Update not working]

First of all - never use the $_POST values directly in the query!!! Clean the values and validate them before using.

Now for your problem. Like Barand pointed out, your update query will affect all the rows that are equal to what ever you have in the $_POST['hidden'] or if you removed that it will be every row that has product = ''. 

Figure out a uniqe key for the row that you want to update and put that in you where clause.

[I need a checkbox stay checked and ...]

Actually, local storage is a replacement for cookies that can be used for storage for javascript. Cookies are becoming outdated with javascript now.

I agree, but You will need a fallback for olderbrowsers (if you support them, iex. IE7).

[Checkboxes - Capturing user input, creating an array, and preserving values via session variables]

I see. $_SESSION['share_category'] is set, but it is empty (has not value). Change your if condition to:

$selectedCategories = (isset($_SESSION['share_category']) AND !empty($_SESSION['share_category'])) ? $_SESSION['share_category'] : array();

[Checkboxes - Capturing user input, creating an array, and preserving values via session variables]

Fails how? Whats the error?

[I need a checkbox stay checked and ...]

I am sorry if I don't understand your problem right, but my opinion is that you would like to use cookies. If it is some info that you need to preserve for a user, put that value in a cookie and check for that cookie on page load and ofcourse if you find the needed value do whatever you need to do with that.

[How to post multiple keys to php script?]

... if you're not understanding what i mean, then dont try to help me!

I was going to GUESS what you mean and try to help you, but after reading this, my will is gone.

[Need some help with figuring out a query please]

The $_POST['code'] can be your id field from the db, so add that to the query instead of the hardcoded id = 1. Also don't forget to clean and validate the $_POST param before using it inside a query.

[make image link bigger]

Yes you can, but not with php, You will need javascript for doing that. To set an event on that link and do what you want to do.

[Unset variable/array which has been passed to function]

If you want you in-function changes to have effect on a global variable, like You said pass that variable by reference inside the function and change it.

[Checkboxes - Capturing user input, creating an array, and preserving values via session variables]

 

Ah, okay, I *think* have created the array correctly?

$share_category = implode(', ', $_POST['share_category']);

 

The $share_category variable that you are crating is a string and not an array. Dont implode it (which creates the string), just use it as an array. Add all of the checked values to an array with:

 

array_push($array_name, $value);

 

which is the same as:

 

$array_name[] = $value;

 

And then the condition with in_array will work, since the second param should be the array to search in.

[Help - parse text file, find keyword]

Use this http://www.php.net/manual/en/function.json-decode.php to get the result out of that string. That is JSON object that you can use.

[Help - parse text file, find keyword]

Take a look at ths php function: http://www.php.net/manual/en/function.preg-match.php

Use a regex to find the matches and do what you want with that.

[binding a date variable and inserting to sql table]

I dont know what You have inside those params ($time, $date), but in order to get that date 04/30/2013 into a date field in the db you need to get it into this format: yyyy-mm-dd.

[substr() not working?]

As the documentation says http://www.php.net/manual/en/function.substr.php

 

string substr ( string $string , int $start [, int $length ] )

 

You need to put something like:

 

 

$code = substr($file_contents, $start, ($end - $start));

[Find Term within an array]

What You have is correct. If there is 12 in the array it will print yes.

[Find Term within an array]

I don't understand whats the question here. What do You need help with?

[need to add to cookie]

I am guessing that monkuar needs this to toggle some element on client side.

So the logic should be if ?hide=1 and 1 is in the cookie remove it otherwise add it. Same thing for ?hide=2.

So in order to do this, You need to get the cookie content ($_COOKIE['cookie_name']) check if the value is in there and set the new value.

[Stretching div's width]

True what You say that the widest div gives the width of the box. The problem is (and I think it is only in IE9) that when the width of the div should be determined by the width of the description row, it pushes the floated span in the next row.

There is nothing more to the code because this is a absolute positioned div on the screen (like a lightbox)