Jump to content

jamiegee

Members
  • Posts

    6
  • Joined

  • Last visited

jamiegee's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. SELECT oc_option_value_description.option_id, oc_option_value_description.name, oc_product_option_value.quantity FROM oc_option_value_description LEFT JOIN oc_product_option_value ON oc_option_value_description.option_id = oc_product_option_value.option_id WHERE product_id = 447 AND oc_option_value_description.option_id = 11 Hi I haven't posted all the table data just yet as this seems it could be a simple fix. I am quite new to mysql/php but am trying to learn more technical code. I run the above sql code and it should return 3 rows, i know this for a fact, but it actually returns 9, it returns 3 of each row. Is it just something im missing off? i have googled but can seem to run into an article or post about this error. if you need to see my database structure im happy to post it. Kind regards and many thanks in advanced cheers jamie
  2. unfortunately that was the first thing i tried :/
  3. HI David thanks for you reply, its from a pdf to text class thats then run through a str_replace to get rid of a load of other stuff which is then put into a variable with the content what you see at the top, i just run this through a var_dump and htmlentities and all looks to be ok, theres all spaces no other characters. When i echo or print the array all i get is array or array ( ) Thanks Jamie
  4. haha jessica I am quite new at php but now that new, i replaced string with my variable name as that goes without saying and if you look at the code closely i even noticed that the first 2 attributes of preg_match_all where round the wrong way and fixed accordingly not sure if you picked that up? and just to be precise error reporting is turned on Thanks for your input
  5. Hi Christian F Your solutions looks perfect however i just put that into my project but when i try to echo or print our the $name and $answers i get nothing? Any Ideas? Thanks Jamie
  6. Hi I have just got a string from a PDF which you can see below Age Smith Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Joe Main Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Zoe Smith Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Megan Smith Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Damon Rodgers Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Sean Murray Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No No No No No No No No No No No Tom Greenwood Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Hollie Michie Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Jordan Farrell Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Jasmine Roll Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes mikel Yussuff Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Matt Clarke Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No No No No No No No No No No No Javan Jackson Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Adele Barham Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Greg McPherson Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Toni Salter Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Louise Smith Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Jack Lenton Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes fran Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No roxy Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Matt Anderson Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Craig Hill Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Rob Pearson Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Jade Twigg Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Kamal Alaykan No No No No No No No No No No No No No No No Yes No No No No No No No No No No No No No No No No Aiden Harrison Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Gemma Marciano Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Fran Moy Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Roxanne McDade Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Abbi Moore Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Jade Warne Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes robert Parks Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Joe Clark Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Russell Rodriguez Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Tom Stevenson No No No No No No No No No No No No No No No Yes Chris Moore Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Bea Wyatt Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Gavin Seamer Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No teejay Carnahan Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No No No No No No No No No No No No Harry Dickason No No No No No No No No No No No No No No No Yes Matty Downing Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Lucca Harrison Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No Chris Brown Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Liam Barnett No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No As you will see there is a persons name and then 16 Yes/No then onto the next persons name, what i am looking to do is put each set of them into table data so i can then format the data into a html table. I have been trying many different methods and search the whole of Google a dozen times but just cant seem to find a method to do this. Is this even possible? Thanks in advance Jamie
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.