Results 1 to 5 of 5
  1. #1
    Action Jackson - King of the World
    Join Date
    January 18th, 2005
    Posts
    2,201
    Products only appearing on first page
    I have something like

    $query = "SELECT * FROM sears where category='$interest' order by name LIMIT

    echo("<a href=\"sears-links.php?interest=$interest&page=$i\">

    For some reason tho only products are appearing on the first page so the query must work right?

    Anyone have any ideas?

    This worked fine when I did like %

  2. #2
    Action Jackson - King of the World
    Join Date
    January 18th, 2005
    Posts
    2,201
    I found out it's showing categories like http://jacksretail.com/toolking-link...Compressors%0D

    I can't seem to see this extra %0D in Excel tho?

    Anyone else seen this before?

  3. #3
    Action Jackson - King of the World
    Join Date
    January 18th, 2005
    Posts
    2,201
    31200181 MCD-24 Altraco Altraco MCD-24 Heavy Duty Dial Caliper Stainless steel fully hardened frameShock proofReading 1/1,000With thumb roll and lock screwMeasuring faces hardened, ground and lapped4-way measurement: inside, outside, depth and stepSingle revolution dial graduated 0 100 with .100 per revolutionCovered rack Open Cover - Each piece fitted in a plastic boxSpecifications: Reading: .001, Jaw Depth: 4", Range: 0 - 24 Hand tools Measuring Tools Calipers http://www.toolking.com/images/Produ...umacMCD-18.jpg http://www.toolking.com/images/Products/bigacMCD-18.jpg http://www.avantlink.com/click.php?p...tlink%3DMCD-24 Altraco MCD-24 Heavy Duty Dial Caliper, Calipers, Measuring Tools, Hand Tools 174.19 133.99 <img src="http://tracking.avantlink.com/dfpv.php?p=215&pn=Altraco+MCD24+Heavy+Duty+Dial+Caliper" width=0 height=0>


    sample record

  4. #4
    Action Jackson - King of the World
    Join Date
    January 18th, 2005
    Posts
    2,201
    Wanted to let everyone know that I have the problem fixed. A huge thnak you to Scott who helped me figure out what the problem was and how to fix it.

    For some reason Excel adds a trailing char at the end of a line so I had to set \r\n in the import.

  5. #5
    ABW Ambassador Snib's Avatar
    Join Date
    January 18th, 2005
    Location
    Virginia
    Posts
    5,303
    No problem. Now you just need to start building import scripts so you don't have to use Excel anymore

    - Scott
    Hatred stirs up strife, But love covers all transgressions.

  6. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. datafeed products with their own page
    By chillini in forum Programming / Datafeeds / Tools
    Replies: 21
    Last Post: December 4th, 2008, 12:59 AM
  2. Multiple products per page
    By Tami in forum WebMerge (Fourthworld.com)
    Replies: 3
    Last Post: May 9th, 2007, 05:40 PM
  3. Limit No of products per page
    By admad1 in forum WebMerge (Fourthworld.com)
    Replies: 0
    Last Post: January 22nd, 2005, 08:50 AM
  4. Products per page
    By bbb in forum Midnight Cafe'
    Replies: 3
    Last Post: September 10th, 2003, 06:07 AM

Posting Permissions

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