mySQL Query with varchar(5000) fields will not pull data from thesefields

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Justin
    #1

    mySQL Query with varchar(5000) fields will not pull data from thesefields

    I have a SELECT query which pulls data from a mySQL 5 database using PHP

    When run in mySQL console I can see it pull the data from the
    varchar(5000) ok but when the same query is executed under PHP I cannot
    get any information from the varchar(5000) fields.

    Why would this be?

    Any suggestions as to what I need to look for to fix this.

    Regards

    Justin
    Tags: None
    • Justin
      #2
      Re: mySQL Query with varchar(5000) fields will not pull data fromthesefields

      Justin wrote:[color=blue]
      > I have a SELECT query which pulls data from a mySQL 5 database using PHP
      >
      > When run in mySQL console I can see it pull the data from the
      > varchar(5000) ok but when the same query is executed under PHP I cannot
      > get any information from the varchar(5000) fields.
      >
      > Why would this be?
      >
      > Any suggestions as to what I need to look for to fix this.
      >
      > Regards
      >
      > Justin[/color]
      Self fixed.

      Spent far too much time coding this as I missed the fact that I had
      typed $fieldname instead of $row['fieldname'].

      Memo to self. Check own output syntax before posting drivel to newsgroup.

        Comment

        Previous template Next
        Working...