The forums have permanently moved to forum.kirupa.com. This forum will be kept around in read-only mode for archival purposes. To learn how to continue using your existing account on the new forums, check out this thread.


Results 1 to 3 of 3

Thread: Need a tip -SQL query with googlemaps link

  1. #1

    Need a tip -SQL query with googlemaps link

    HI

    I have an mySQL query to insert a google map link into a database. The problem is that because the URL have one ' (I don't know how to say the symbol name in english, sorry) the mySQL in PHPmyAdmin is giving me an error.

    I have here a short example of mine sqlquery:

    INSERT INTO `postos` ( `id` , `nome` , `contactos` , `morada` , `codigo` , `link` , `localidade` , `distrito` ) VALUES (NULL , 'd/'alia', 'd/'alia', 'd/'alia', 'd/'alia', 'd/'alia', 'd/'alia', 'd/'alia')

    please pay atention to d/'alia. I've tried with d'alia and it give the same error. How can I pass this symbol through?

    Thanks '''''

  2. #2
    If it was in MS SQL I would suggest you to replace single quotas with '' double quotes
    Perhaps you can try something like
    INSERT INTO postos (
    `id` , `nome` , `contactos` , `morada` , `codigo` , `link` , `localidade` , `distrito`
    ) VALUES (
    NULL , 'd''alia', 'd''alia', 'd''alia', 'd''alia', 'd''alia', 'd''alia', 'd''alia'
    )

    or you can set the d'alia to a sql variable then use that variable within the insert statement

    I hope this helps
    Eralper
    SQL Tutorials

  3. #3
    if you're running this code through a php page, just add slashes to the variables before adding them to the database query
    eg:
    $foo = "d'alia";
    $foo2 = addslashes($foo);
    INSERT INTO `postos` ( `id` , `nome` , `contactos` , `morada` , `codigo` , `link` , `localidade` , `distrito` ) VALUES (NULL , '$foo2', '$foo2', '$foo2', '$foo2', '$foo2', '$foo2', '$foo2');

    If you are running it through phpmyadmin, use the forward slash instead of the backslash:

    'd/'alia' Becomes:
    'd\'alia'

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012