Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Senior Coder
    Join Date
    May 2006
    Posts
    1,673
    Thanks
    28
    Thanked 4 Times in 4 Posts

    Error in SQL syntax ??

    Hello,

    I am getting an error with this code, but can not see
    anything wrong with it

    PHP Code:
    $sql "SELECT *.platforms, site_name.sites FROM platforms, sites WHERE site_no.platforms = site_id.sites AND platform_id = '$Db_platform_id' ";
        
    $result mysql_query($sql)    or die("could not find SITE "mysql_error()); 
    I have tables "platforms" and "sites"

    Error I get is :

    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 '.platforms, site_name.sites FROM platforms, sites WHERE site_no.platforms = site' at line 1
    Can anyone see what I have done wrong. ??

    Thanks


    .
    If you want to attract and keep more clients, then offer great customer support.

    Support-Focus.com. automates the process and gives you a trust seal to place on your website.
    I recommend that you at least take the 30 day free trial.

  • #2
    Senior Coder
    Join Date
    May 2006
    Posts
    1,673
    Thanks
    28
    Thanked 4 Times in 4 Posts
    Ok - no problem.

    I have got the record.table back to front.
    Should have been table.record.

    Thanks for looking.
    If you want to attract and keep more clients, then offer great customer support.

    Support-Focus.com. automates the process and gives you a trust seal to place on your website.
    I recommend that you at least take the 30 day free trial.


  •  

    Posting Permissions

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