Google!?? are we getting lazy??

This is funny.  You know the new Google feature that shows your search or query as you type.  You don’t have to hit enter, Wow.  So now I find myself waiting  for the search to start in other programs like Microsoft. Or after I enter numbers in the calculator …. not really.  But it has happened with other programs…. I’m waiting… I’m waiting…. I’m yawning….

So to conclude, Google saves us time in Google searches but we’re wasting it in other programs.  Is it balancing out??  Are we getting so trained to be reliant on Google pressing enter that we wait for Google to do it in other situations.  Like making coffee… turning on the stove, starting the car when you sit in it….  Like waiting for this blog entry to be published…… GOOGLE! What UUUUUP. Lukeup.

PHP MySQL Make query results into a Clickable Link

I searched for a week to find out how I can turn one column of mysql results into a clickable link.  Now I can produce another query to show more information about a product.  In the first field there can be no spaces in the content.  The Product can have spaces in the description but to make the Product field into a clickable link, no spaces in the first field’s contents.  A unique ID would be good.  This will add an extension to the id so you can map it to another file to produce another query or what ever you need, description etc,.

  echo “<th align=left>” . “<a href=” . $row[‘p_id’] . “.php” . “>” . $row[‘Product’] . “</th>”;

MySQL #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

If you get 

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

 or

ERROR 1064 (42000) at line 9: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

and it’s on or during an insert, verify the table’s fields are the correct length to match the data you’re inserting.  I received my errors during an insert with a select substring.  Sometimes it’s a comma or an apostrophe. 

This did not correct my issue this time, though.  This time, I had a field called INOUT, which is aparantly a reserved word/process.  I guess that’s what happens when you hack your way around MySQL.  If nothing else works, change the field name.

© 2011-2024 Lukeup Solutions All Rights Reserved