Jump to content

Whatsthis4

Members
  • Posts

    2
  • Joined

  • Last visited

Whatsthis4's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. I'm trying to update multiple columns at once in my database. The updated information is coming from another form page. This is my code and below it is the error. I have also tried this with single quotes and no brackets and I receive the same error message without the brackets with quotes.line 21> $query = "UPDATE inventory SET type = $type [, order = $order] [WHERE id = $id] LIMIT 1";could not execute query.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 '[, order = 02] [WHERE id = 2] LIMIT 1' at line 21Below works fine for a single column, so the connection gets made.line 21> $query = "UPDATE vehicles SET type='$type' WHERE id='$id' LIMIT 1";Thank you in advance for any help offered.
  2. This problem has been solved. When I setup my DB I dropped the http:// in my first link and then compounded the problem with copy/paste. Lack of sleep I guess. Sorry--------------------------------------------------------------------------------------------My page is retrieving html links from my database. The links are written in the DB like this. <a href="www.retrievedlink.com" target="_blank">Retrieved Link</a>When the link shows up on the page it appears fine, but when I mouse over the link it shows in the browser status bar that it is stacked behind my domain url like this:http://www.mydomain.com/www.retrievedlink.comHow do I stop my domain url from being inserted in the link.If this is a stupid question please forgive me, I am very new to this. Thank you in advance for any help offered.
×
×
  • Create New...