#1
  1. No Profile Picture
    Tyrnt
    Guest
    Devshed Newbie (0 - 499 posts)
    I know i have seen this somewhere else but i cant recall it right now. And now i have that problem, can someone please help?

    Thanx,
    --Tyrnt
    http://www.blizzardnexus.com
  2. #2
  3. No Profile Picture
    subburs
    Guest
    Devshed Newbie (0 - 499 posts)
    hi,
    There is a problem in your select(query) statement.but still it will display the content and show's the error,this because u r passing orderby clause as parameter while executing it the orderby is null that's the reason i feel.
  4. #3
  5. No Profile Picture
    Tyrnt
    Guest
    Devshed Newbie (0 - 499 posts)
    now the error is on a different script. i will paste the actual code

    $result = mysql_query( "select * from friends where $type is $search");


    // fetch the rows one at atime, and then echo the data to the page
    while ($row = mysql_fetch_row($result)) {

    os there an error here? the $type and $search are variables from a form that is also on this script.

    Thank you,
    --Tyrnt
    http://www.blizzardnexus.com
    ICQ UIN: 1802676
  6. #4
  7. No Profile Picture
    moderator
    Guest
    Devshed Newbie (0 - 499 posts)
    After your mysql_query line you can put a echo mysql_error() line to print the mysql error to the browser. That should help you troubleshoot your query.

    A couple things to make sure of however, is $type always going to be a correct column name, and perhaps you should put apostrophe's around $search.
  8. #5
  9. No Profile Picture
    Tyrnt
    Guest
    Devshed Newbie (0 - 499 posts)
    i did finally figure out what the problem, it was the syntax or somethin, kinda forgot exactly what i did but it works now and i even made another script and i made it so i can delete entries from my web browser, its really really kewl =) thank you for your help.


    --Tyrnt
    http://www.blizzardnexus.com
    ICQ UIN: 1802676
  10. #6
  11. No Profile Picture
    Paul Cotton
    Guest
    Devshed Newbie (0 - 499 posts)
    I have found the quickest way to debug these errors is to print the query string to the browser and cut and paste iy into a MySQL session (i telnet into the linux web server for this).

    This way you can fine tune the syntax.

Similar Threads

  1. Highlight search result from mysql database search
    By Gurt in forum PHP Development
    Replies: 3
    Last Post: February 17th, 2004, 03:39 AM
  2. Dividing Row By MySQL result
    By allie in forum PHP Development
    Replies: 5
    Last Post: January 19th, 2004, 11:44 PM
  3. displaying mysql result in a select box
    By notaloser in forum PHP Development
    Replies: 4
    Last Post: January 13th, 2004, 05:30 PM
  4. Creating a mysql result?
    By wordracr in forum MySQL Help
    Replies: 4
    Last Post: January 12th, 2004, 02:07 PM
  5. **mysql get result or mysql query question??
    By minemo in forum PHP Development
    Replies: 4
    Last Post: December 31st, 2003, 12:59 PM

IMN logo majestic logo threadwatch logo seochat tools logo