I created TINYINT columns in my MySQL database to interpret boolean variables, which based on whether checkboxes are checked or not in the html store the values (0 for false, everything else for true) in the DB. But it won't update the values when the php file is called. Is there something wrong with my SQL? Are TINYINTs inputted as below? Simply with a 0 and a 1?  &lt;?php include_once("createConnection.php"); session_start(); $checkbox = $_POST['name']; $checked = $_POST['checked']; $currentUser = $_SESSION['validUser'];  if($checked=='yes'){     $request='UPDATE projectDB.Members          SET :name=1 WHERE username=:currentUser';     $preparedStatement = $bdd-&gt;prepare($request);      $preparedStatement-&gt;bindParam(':name', $checkbox, PDO::PARAM_STR);     $preparedStatement-&gt;bindParam(':currentUser', $currentUser, PDO::PARAM_STR);     $preparedStatement-&gt;execute(); } else{     $request='UPDATE projectDB.Members          SET :name=0 WHERE username=:currentUser';     $preparedStatement = $bdd-&gt;prepare($request);      $preparedStatement-&gt;bindParam(':name', $checkbox, PDO::PARAM_STR);     $preparedStatement-&gt;bindParam(':currentUser', $currentUser,     PDO::PARAM_STR);     $preparedStatement-&gt;execute(); } ?&gt;
Why can't I pass the table name to a prepared PDO statement?  $stmt = $dbh-&gt;prepare('SELECT * FROM :table WHERE 1'); if ($stmt-&gt;execute(array(':table' =&gt; 'users'))) {     var_dump($stmt-&gt;fetchAll()); }   Is there another safe way to insert a table name into a SQL query? With safe, I mean that I don't want to do  $sql = "SELECT * FROM $table WHERE 1"
How do you repair an "input/output error" in an NTFS partition? In linguistics, is there a term describing this phenomenon, i.e., when the syllables of two words are slurred together in the spoken language?  They are not contractions. While contractions are acceptable in any register, this combination of words is very informal and hardly ever found in formal writing.  kinda (kind of)   sorta (sort of)   coulda (could have)   shoulda (should have)   lotta (lot of)   oughta (ought to)   betcha (bet you)   lemme (let me)   tseasy (it's easy)   willya (will you)  Inasmuch as English Language speakers (just like the speakers of any natural language) have a tendency to join word sounds in speech, examples abound and a complete list would be hard to produce. I’m looking for a word or phrase describing this linguistic phenomenon as it occurs in speech. Proving that $a \mathbb{Z} \cap b\mathbb{Z} = \operatorname{lcm}(a,b)\mathbb Z$ Given $m \in \mathbb{Z}$, let $m\mathbb{Z}$ denote the set of integer multiples of $m$, i.e. $m\mathbb{Z} := \{mk\mid k \in \mathbb{Z}\}$.   Now let $a,b \in \mathbb{Z}$ with $a,b$ not both $0$. Prove that $a\mathbb{Z} \cap b\mathbb{Z} = \operatorname{lcm}(a,b)\mathbb{Z}$.   I am trying to write a proof for this, but I am unsure of what method to use. Also I am confused by $mk\mid k$, because wouldn't $m=1$ for this to be true. Determine accuracy of model which estimates probability of event I hope someone can help me.  I am currently on holiday for 3 months in America under the Visa Waiver Program and would like to stay an extra 2 or 3 weeks. I know I will have to leave the country, renew my visa waiver and then reenter and so wanted to know if I will have an issue reentering.  I will only be out of the country for about 24 to 48 hours, just enough to renew the visa and get on a plane. I understand it is up to the border control person on the day, but does anyone think I will have an issue?? Integral of sinc function multiplied by Gaussian I am wondering whether the following integral $$\int_{-\infty}^{\infty}  \frac{\exp( - a x^2 ) \sin( bx )}{x} \,\mathrm{d}x$$ exists in closed form. I would like to use it for numerical calculation and find an efficient way to evaluate it. If analytical form does not exist, I really appreciate any alternative means for evaluating the integral. One method would be numerical quadrature including Gaussian quadrature, but it may be inefficient when the parameters $a$ and $b$ are very different in scale.  EDIT : In view of  discussion, we have decided to add OP's self-answer to the end of the question, for it does not qualify as an answer yet contains vital details. The copying is unabridged. Thanks very much for your comments, and the following result was obtained including the case for $x_0 \ne 0$: $$ \int_{-\infty}^{\infty} dx \exp[-a(x-x_0)^2] \frac{ \sin(bx) }{ x } = \pi \exp(-a x_0^2) \mathrm{Re}\left(\mathrm{erf}\left[\frac{b+2iax_0}{2\sqrt{a}}\right] - \mathrm{erf}\left[\frac{2iax_0}{2\sqrt{a}}\right]\right) $$ where $a\gt0, b, x_0$ are assumed to be all real. (note: coefficients etc may be still wrong...) This integral appears in a type of electronic structure calculation based on a grid representation (sinc-function basis). I believe the above result should be definitely useful. Thanks much!! --jaian A new tab for a record Type! Hello Folks,              I have a question which might be more on the admin side of the force.com platform but involves development.  Question: If I create record types for an object, how can I create separate tabs for the same object but different record types. And, since they all are going to share the same fields, how can I distinguish the labeling?  I dont think this is currently possible, but I would like to know how can it be achieved?  What I have tried: I tried creating visualforce pages with enhanced lists but then in the enhanced list I can not specify the record type.  Please let me know how can I achieve this! Thank you for the help. If F is a finite field, then $F^F=P_F$. I've been using the beta iCloud Photo Library for a week and a bunch of photos got duplicated and I'd like to wipe all the photos out and start over.  I have backups of all the photos and have turned off iPhoto Cloud Library on all iOS devices. When I log into the web app - it still shows dozens of albums and I can delete all the photos, then go to deleted items and then purge them, but the ghost albums are still there messing things up.  I've turned off the library entirely and you can see there is a 30 day waiting period.     If I click on albums, there are pages of them and no delete button anywhere. If I turn on the library on an iOS device, data starts flooding back as if I wanted to recover the photos.  I don't want to recover anything, I want a clean wipe and clean slate.  Currently, there are 7807 photos in the deleted album and no way to mass delete them. I have 31 albums that show up in iCloud and no way to delete them.  Is there some way to accelerate this or must people wait a month for a corrupt library to eventually be purged to start over?  (I have tickets open with AppleCare after  and it's escalated to engineering, but I was informed that it might be a week or two before it gets seen :-( Perhaps someone has a better idea to clear things out or noticed something I've missed.) How did this character come to be in the Nethersphere? How is it that       The Master   Came to be in the Nethersphere?  The last time we saw him      He died and refused to regenerate.  The Doctor even cremated his body.   So, given what previously happened to him, how was he now able to      Regenerate as Missy and take over the Nethersphere? Can you make a bonus-action attack from Two-Weapon Fighting before you take your action? Many people (at least in Germany) think that Italians add olive oil to the boiling water for spaghetti. However, Italians tend to tell the opposite (from my experience).  So, can you please state objective reasons for or against adding olive oil to the boiling water for spaghetti? I'm a US passport holder. What documents do I need when I fly from the U.S. to Germany?  Assume I'm going for a few weeks of vacation.  Obviously I need my passport.  What about a "visa"?  Anything else? What is the opposite category of $\operatorname{Top}$? My question is rather imprecise and open to modification. I am not entirely sure what I am looking for but the question seemed interesting enough to ask:   The opposite category of rings is the category of affine schemes. This is usually thought of as the category of spaces. Can we run the construction backwards for categories usually thought of as containing spaces?  For instance, does $\operatorname{Top}^{\operatorname{op}}$ have a nice description as some "algebraic" category?  Note that it does not seem easy to describe the opposite category of all schemes. Therefore, the above question might be asking too much. Perhaps the following is a more tractable (or not) question:  Can we find an "algebraic" category $C$ such that we can embed $C^{\operatorname{op}}$ in $\operatorname{Top}$ such that every topological space can be covered by objects in $C^{\operatorname{op}}$? Perhaps one would like to replace this criterion of being covered by objects by a more robust notion in general.  One can repeat the question for other categories of spaces like:   Category of manifolds (perhaps closer to schemes than general topological spaces) Compactly generated spaces Simplicial Sets   and so on. A perhaps interesting example is the category of finite sets, it's opposite category is the category of finite Boolean algebras. Text not very readable on different image backgrounds The question is:     When $f(x+1)-f(x)=f'(x)$, what are the solutions for $f(x)$?   The most obvious solution is a linear function of the form $f(x)=ax+b$. Is this the only solution?  Edit  I should add that $f:\mathbb R\to\mathbb R$ to the question. What is the range of the validity of Coulomb's law? How do I get console output in C++ with a Windows program? I have 12.10 ubuntu and when I try to remove / install programs I get notification :      Software can't be installed or removed because the authentication service is not available.    (org.freedesktop.PolicyKit.Error.Failed: ('system-bus-name', {'name':  ':1.104'}): org.debian.apt.install-or-remove-packages   When I log in as root user (instead of user account that I regulary use) i have no problems. I want to build a personal portfolio so my questions related are as follows:   What should I include in the portfolio apart from Home, About, Work, Contact? I have never worked on any real life examples so what to display in the work/portfolio page? What kind of design samples do I need to include? Ex: Website, Logo, Banner etc   Any help is appreciated.  Thanks!