| PastorRon | Would you be willing to help me with my mysql error |
| jazzrocker | ferguscan: Pasteurization... there's a difference PastorRon: only if you give us the error and ask your question |
| bashusr | PastorRon: i don't get what you're doing |
| PastorRon | http://www.actsministrieschristianevangelism.org/ministrydirectory/search.php |
| ferguscan | jazzrocker, :-) My comment was directed at both. |
| PastorRon | I am creating a directory |
| bashusr | what is $directory_results? what's $i? what's "ministry_directory.name"? |
| kreg | boo-yah! first time i've seen radius auth against a username in mysql |
| PastorRon | $directory_results=mysql_query($query); $i is the counter of the mySQL results |
| bashusr | PastorRon: telling us the query might be helpful... |
| PastorRon | ok |
| jazzrocker | PastorRon: yeah so far your question appears to belong in ##php more or less ferguscan: but you are keen on that lack of nutrients thing... cooked food is evil! |
| TheGambler | empty_mind: did you get an answer? |
| PastorRon | SELECT DISTINCT ministry_directory.name FROM ministry_directory_listing_categories INNER JOIN ministry_directory WHERE ministry_directory.listing_type = '4' AND ministry_directory.name LIKE '%b%' AND ministry_directory.address_line_1 LIKE '%%' AND ministry_directory.address_line_2 LIKE '%%' AND ministry_directory.address_line_1 LIKE '%%' AND ministry_directory.address_line_2 LIKE '%%' AND ministry_directory.city LIKE '%%' AND ministry_directory.provi nce_state_county LIKE '%%' AND ministry_directory.country LIKE '%%' AND ministry_directory.postal_zip_code LIKE '%%' AND ministry_directory_listing_categories.ministry_directory_category_reference = '18' ORDER BY ministry_directory.name ASC |
| empty_mind | the_wench, nope |
| jazzrocker | cooking your food reduces the nutritional value by about 80% |
| bashusr | PastorRon: pastebin... |
| empty_mind | TheGambler, nope |
| bashusr | PastorRon: that's a scary sql query |
| PastorRon | oh ... sorry that is the query |
| BrianB_ | jazzrocker that is very true, raw is the only way to eat |
| PastorRon | It is created on the fly |
| jazzrocker | PastorRon: ouch... even though that appears to be one line... you probably should have pastebin'ed it |
| BrianB_ | although a bit boring |
| TheGambler | PastorRon: you getting too many rows? |
| empty_mind | jazzrocker, then eat raw vegetables :-p |
| PastorRon | No |
| jazzrocker | empty_mind: i do raw fish sometimes too |
| ferguscan | jazzrocker, not always. |
| empty_mind | jazzrocker, raw meat might be injurious to health |
| PastorRon | I am trying to retrieve the listing name, address, web site and contact # |
| jazzrocker | BrianB_: sprouted nut and bean pate's, salt, oil, spices are all still game empty_mind: uhhh, yeah like raw beef... raw fish = sushi |
| PastorRon | What I don't understand is why I am able to retrieve the name and nothing else |