Re: [PHP] php cms?

2009-08-26 Thread Miller, Terion
On 8/25/09 11:42 PM, "hack988 hack988" wrote: i like durpal or e107 2009/8/26 Lars Nielsen : > tir, 25 08 2009 kl. 17:05 -0400, skrev Bastien Koert: >> On Tue, Aug 25, 2009 at 4:35 PM, Lars Nielsen wrote: >> > Hey list, >> > >> > I am going to use a cms for some sites and I have looked a litt

Re: [PHP] Re: Undefined Offset Error with Pagination and Sessions

2009-08-18 Thread Miller, Terion
On 8/18/09 12:44 PM, "Shawn McKenzie" wrote: Miller, Terion wrote: > Hi Folks, after days of trying lots of different things, I'm must grovel to > the list and post my problem...which is I am unable to get my pagination to > work, it seems to not carry the session to

Re: [PHP] Undefined Offset Error with Pagination and Sessions

2009-08-18 Thread Miller, Terion
;m missing (prob) but I know that checking if a sesion is set then immediately unsetting it is not logical, and I tried putting it like if isset else unset but same results, nothing work all variables error'd out as undefined. On 8/18/09 11:49 AM, "Miller, Terion" wrote: Hi Folks,

[PHP] Undefined Offset Error with Pagination and Sessions

2009-08-18 Thread Miller, Terion
Hi Folks, after days of trying lots of different things, I'm must grovel to the list and post my problem...which is I am unable to get my pagination to work, it seems to not carry the session to the next page and I get the "undefined offset error" The page code is posted here since my email client

[PHP] OUCH (RESOLVED)

2009-08-05 Thread Miller, Terion
Thank you all for being so brutally honest, I am doing my best, and yes I do get hung up on syntax errors, I mean who doesn't stare at code looking for a misplaced or missing ; or . For what seems like hours with a boss asking repeatedly "is it done, is it done" before freaking out and asking f

Re: [PHP] Re: What makes _SERVER stop working (RESOLVED)

2009-08-04 Thread Miller, Terion
On 8/3/09 7:44 PM, "Shawn McKenzie" wrote: Miller, Terion wrote: > All of a sudden this stopped working and keeps defaulting to A again > > if ($_SERVER['SCRIPT_FILENAME'] = "browse.php" ) { > > $default = "A"; > > } > >

Re: [PHP] Need quick got written up yesterday!! OUCH (RESOLVED)

2009-08-04 Thread Miller, Terion
l life may do you good. On 8/4/09 9:53 AM, "Shawn McKenzie" wrote: Miller, Terion wrote: > THANKFULLY THE BOSS DECIDED TO YELL AT ME AND TOLD ME WHAT THE PROBLEM > WASI HAVE NEVER BEEN SO STRESSED IN MY LIFE > SHOULD WORK BE THIS AWFUL? IT'S HARD ENOUGH WORKING

Re: [PHP] Need quick got written up yesterday!! OUCH (RESOLVED)

2009-08-04 Thread Miller, Terion
On 8/4/09 10:04 AM, "Bastien Koert" wrote: On Tue, Aug 4, 2009 at 10:58 AM, Miller, Terion wrote: > > > > ---snip > ---snip- > > http://pastebin.ca/1517966 > > I don't get why the $_SERVER['browse.php'] stopped working > >

Re: [PHP] Need quick got written up yesterday!! OUCH (RESOLVED)

2009-08-04 Thread Miller, Terion
On 8/4/09 10:03 AM, "Ashley Sheridan" wrote: print_r($_SERVER); I get: Array ( [HTTP_HOST] => getpublished.news-leader.com [HTTP_USER_AGENT] => Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.0.13) Gecko/2009073021 Firefox/3.0.13 [HTTP_ACCEPT] => text/html,application/xhtml+

Re: [PHP] Need quick got written up yesterday!! OUCH (RESOLVED)

2009-08-04 Thread Miller, Terion
---snip Was going to say the exact same thing. No one should have to put up with that crap. I suggest if this was a normal occurrence, a chat with him would be a start. If you get nowhere with that, a trip to HR would be good. Shouting at someone is counter-productive, and there more

Re: [PHP] Need quick got written up yesterday!! OUCH (RESOLVED)

2009-08-04 Thread Miller, Terion
dan" wrote: On Tue, 2009-08-04 at 07:16 -0700, Miller, Terion wrote: > for($i = 0; $i <= 9; $iﯯ) I'm noticing an odd character just here (heaven knows what line number!) I'd presume this was meant to be something like a ++ or +=n, but seems to be interpreted as a multibyte c

[PHP] Need quick got written up yesterday!! OUCH

2009-08-04 Thread Miller, Terion
Ok I have 45 minutes left to make this script default to show "a" listings on the browse.php page and then show no listings on other pages by default for some reason the _Server function stopped working what have I done wrong... '); } else { if($letter == 'nums') {

Re: [PHP] Re: What makes _SERVER stop working

2009-08-03 Thread Miller, Terion
On 8/3/09 2:22 PM, "Ollisso" wrote: On Mon, 03 Aug 2009 21:48:08 +0300, "Miller, Terion" wrote: > > Thanks but it still doesn't work, it defaults to 'A' and I want it to > default to show 'A" only on browse.php all other pages shou

Re: [PHP] Can a range be passed to a query?(RESOLVED)

2009-08-03 Thread Miller, Terion
Sorry group, I keep thinking they are real text...I'm new on a iMac and Entourage... On 8/3/09 2:13 PM, "Ashley Sheridan" wrote: On Mon, 2009-08-03 at 09:33 -0700, Miller, Terion wrote: Here is is incase anyone else ever needs it. //Cr

Re: [PHP] Re: What makes _SERVER stop working

2009-08-03 Thread Miller, Terion
On 8/3/09 1:40 PM, "Ollisso" wrote: On Mon, 03 Aug 2009 20:26:35 +0300, "Miller, Terion" wrote: > All of a sudden this stopped working and keeps defaulting to A again > > if ($_SERVER['SCRIPT_FILENAME'] = "browse.php" ) { > > $d

Re: [PHP] What makes _SERVER stop working need default view to show nothing

2009-08-03 Thread Miller, Terion
On 8/3/09 12:26 PM, "Miller, Terion" wrote: All of a sudden this stopped working and keeps defaulting to A again if ($_SERVER['SCRIPT_FILENAME'] = "browse.php" ) { $default = "A"; } else { $default = ""; } I was using the ab

[PHP] What makes _SERVER stop working

2009-08-03 Thread Miller, Terion
All of a sudden this stopped working and keeps defaulting to A again if ($_SERVER['SCRIPT_FILENAME'] = "browse.php" ) { $default = "A"; } else { $default = ""; }

Re: [PHP] Can a range be passed to a query?(RESOLVED)

2009-08-03 Thread Miller, Terion
mysql_query($sql) or die(mysql_error()); while($row = mysql_fetch_assoc($result)) {$name = $row['name']; printf('%s%s', $row['ID'], $row['name'], $row['address

Re: [PHP] Can a range be passed to a query?

2009-08-03 Thread Miller, Terion
On 8/3/09 9:46 AM, "sono...@fannullone.us" wrote: On Aug 3, 2009, at 7:19 AM, Miller, Terion wrote: > Not sure why none of these are working for me since you have them > tested against your tableI get this error... Hopefully I'm not speaking out of turn

Re: [PHP] Can a range be passed to a query?

2009-08-03 Thread Miller, Terion
On 8/1/09 1:47 AM, "Andrew Ballard" wrote: On Fri, Jul 31, 2009 at 5:55 PM, Phpster wrote: > What about > > $sql = "SELECT DISTINCT ID, name, address FROM restaurants WHERE > left(name, 1) between 0 and 9"; > > > > > Bastien > > Sent from my iPod You need to wrap the 0 and the 9 in single quo

Re: [PHP] Can a range be passed to a query?

2009-08-03 Thread Miller, Terion
On 8/1/09 12:04 AM, "Paul M Foster" wrote: $values = implode(',', $other); For some reason no matter how I tried to get it to say # should pull anything that does not start with a letter. It pulls all restaurantsor it breaks the full script. Here are all the things I have tried so fa

[PHP] Can a range be passed to a query?

2009-07-31 Thread Miller, Terion
I'm still struggling with using ranges... Can they be passed to a query somehow... I have this so far but it pulls nothing: //Show all with $letter not between "A" and "Z" if ($selectedLetter = "#") { $other = range('0','9'); $sql = "SELECT DISTINCT ID, na

Re: [PHP] ForEach Range Problems

2009-07-31 Thread Miller, Terion
-snip--- So I'm almost almost there, but now when I click the # it shows me all records, is my foreach range not right? //Create array with letters AND number sign $letters = range('A','Z');array_push($letters, '#');

Re: [PHP] ForEach Range Problems

2009-07-31 Thread Miller, Terion
On 7/31/09 3:08 PM, "Bastien Koert" wrote: On Fri, Jul 31, 2009 at 3:10 PM, Miller, Terion wrote: > > > > On 7/31/09 2:00 PM, "Miller, Terion" wrote: > > > > > On 7/31/09 1:56 PM, "Bastien Koert" wrote: > > $letters = '

Re: [PHP] ForEach Range Problems

2009-07-31 Thread Miller, Terion
On 7/31/09 2:00 PM, "Miller, Terion" wrote: On 7/31/09 1:56 PM, "Bastien Koert" wrote: $letters = ''; Nope still gives the same error: Notice: Undefined index: letter Well getting closer with this but now my outpu

Re: [PHP] ForEach Range Problems

2009-07-31 Thread Miller, Terion
On 7/31/09 1:56 PM, "Bastien Koert" wrote: $letters = ''; Nope still gives the same error: Notice: Undefined index: letter -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] ForEach Range Problems

2009-07-31 Thread Miller, Terion
--snip--- -- Well I almost have it with this, I keep getting an undefined index $letter error though and then it outputs the $menu how do I fix that //Create array with letters AND number sign $letters = range('A','Z'); array_push($letters,

Re: [PHP] ForEach Range Problems

2009-07-31 Thread Miller, Terion
On 7/31/09 12:43 PM, "Bastien Koert" wrote: On Fri, Jul 31, 2009 at 1:40 PM, Miller, Terion wrote: > > > > On 7/31/09 12:27 PM, "Bastien Koert" wrote: > > $letter = isset($_GET['letter']) ? $_GET['letter'] :""; > >

Re: [PHP] ForEach Range Problems

2009-07-31 Thread Miller, Terion
On 7/31/09 12:27 PM, "Bastien Koert" wrote: $letter = isset($_GET['letter']) ? $_GET['letter'] :""; echo ''; foreach(range('A','Z') as $c){ ($letter == $c) ? printf('%s ',$c) : printf('%s ',$c,$c); } echo ''; //Other $bNumberShown = false; foreach(range('0','9') as $n){ if($le

[PHP] ForEach Range Problems

2009-07-31 Thread Miller, Terion
I have this script that works, just a couple tweeks needed... 1. I don't want it to default to A being selected 2. I need the number range part to only display one # sign not 10 of them, somehow I have to have it pull any record that does not start with alpha '; fo

Re: [PHP] 2 ifs embedded? (RESOLVED)

2009-07-31 Thread Miller, Terion
On 7/31/09 10:54 AM, "Jim Lucas" wrote: Miller, Terion wrote: > > > On 7/31/09 10:14 AM, "Bastien Koert" wrote: > > On Fri, Jul 31, 2009 at 10:59 AM, Miller, > Terion wrote: >> >> >> On 7/31/09 9:53 AM, "Bastien Koert" wrot

Re: [PHP] 2 ifs embedded?

2009-07-31 Thread Miller, Terion
On 7/31/09 11:03 AM, "Miller, Terion" wrote: On 7/31/09 10:54 AM, "Jim Lucas" wrote: Miller, Terion wrote: > > > On 7/31/09 10:14 AM, "Bastien Koert" wrote: > > On Fri, Jul 31, 2009 at 10:59 AM, Miller, > Terion wrote: >> >>

Re: [PHP] 2 ifs embedded?

2009-07-31 Thread Miller, Terion
On 7/31/09 10:54 AM, "Jim Lucas" wrote: Miller, Terion wrote: > > > On 7/31/09 10:14 AM, "Bastien Koert" wrote: > > On Fri, Jul 31, 2009 at 10:59 AM, Miller, > Terion wrote: >> >> >> On 7/31/09 9:53 AM, "Bastien Koert" wrot

Re: [PHP] 2 ifs embedded?

2009-07-31 Thread Miller, Terion
On 7/31/09 10:14 AM, "Bastien Koert" wrote: On Fri, Jul 31, 2009 at 10:59 AM, Miller, Terion wrote: > > > > On 7/31/09 9:53 AM, "Bastien Koert" wrote: > > On Fri, Jul 31, 2009 at 10:28 AM, Miller, > Terion wrote: >> >> >> >

Re: [PHP] 2 ifs embedded?

2009-07-31 Thread Miller, Terion
On 7/31/09 9:53 AM, "Bastien Koert" wrote: On Fri, Jul 31, 2009 at 10:28 AM, Miller, Terion wrote: > > > > On 7/31/09 8:58 AM, "m0s" wrote: > > (!empty($row['notes']) && IsAlpha($row['notes'])) > > I tried that and this

Re: [PHP] 2 ifs embedded?

2009-07-31 Thread Miller, Terion
On 7/31/09 8:58 AM, "m0s" wrote: (!empty($row['notes']) && IsAlpha($row['notes'])) I tried that and this one: If (!empty($row['notes']) && ctype_alpha($row['notes'])) It didn't display the notes at all... And this one...doesn't display if the field has a 0 in it but I still need it to? I

[PHP] 2 ifs embedded?

2009-07-31 Thread Miller, Terion
I need this to say : If row notes is not empty and is alpha echo notes How do I get the is alpha part in here; If (!empty($row['notes'])) { echo(" $trimNotes "); } I tried. If (IsAlpha($row['notes'])) { echo(" $trimNotes "); } But it broke the whole script. --Terion

Re: [PHP] Re: Page or URL function? (RESOLVED)

2009-07-30 Thread Miller, Terion
I Figured it out using this: if ($_SERVER['SCRIPT_FILENAME'] = "browse.php" ) { $default = "A"; }

[PHP] Page or URL function?

2009-07-29 Thread Miller, Terion
I've been searching php.net for a function to do this: if page_url('browse.php') { $default = "A"; } $letter = isset($_GET['letter'])? $_GET['letter'] :"$default" ; else { $letter = isset($_GET['letter'])? $_GET

Re: [PHP] Ridiculous ..won't print or echo ...(RESOLVED)

2009-07-29 Thread Miller, Terion
Yep I forgot about escaping the $ On 7/29/09 10:51 AM, "Ford, Mike" wrote: > -Original Message- > From: Miller, Terion [mailto:tmil...@springfi.gannett.com] > Sent: 29 July 2009 16:36 > > Ok in my output to Quark I need to have $P printed to the page lik

Re: [PHP] Getting rid of extra lines (RESOLVED)

2009-07-29 Thread Miller, Terion
On 7/29/09 3:16 PM, "Jim Lucas" wrote: Miller, Terion wrote: > > > On 7/29/09 3:05 PM, "Jonathan Tapicer" wrote: > > On Wed, Jul 29, 2009 at 4:20 PM, Miller, > Terion wrote: >> >> >> On 7/29/09 1:45 PM, "Ashley Sheridan" w

Re: [PHP] Getting rid of extra lines (RESOLVED)

2009-07-29 Thread Miller, Terion
On 7/29/09 3:05 PM, "Jonathan Tapicer" wrote: On Wed, Jul 29, 2009 at 4:20 PM, Miller, Terion wrote: > > > > On 7/29/09 1:45 PM, "Ashley Sheridan" wrote: > > [snip/] > > Have you thought of just using a regular str_replace() on your code? You &

Re: [PHP] Getting rid of extra lines

2009-07-29 Thread Miller, Terion
On 7/29/09 2:19 PM, "Jim Lucas" wrote: $clean = preg_replace('|\s+|', ' ', $input); Hi Jim, The extra whitespace lines are in the data store, coming from it I'm going to try your method but is there a way to not have mySQL store it with so many lines (this is data being screen scraped and p

Re: [PHP] Getting rid of extra lines

2009-07-29 Thread Miller, Terion
On 7/29/09 1:45 PM, "Ashley Sheridan" wrote: [snip/] Have you thought of just using a regular str_replace() on your code? You can ask it to replace newlines and carriage returns with nothing and see if that fixes you problem? Thanks Ash www.ashleysheridan.co.uk Yep I have tried str_replac

Re: [PHP] Getting rid of extra lines

2009-07-29 Thread Miller, Terion
On 7/29/09 1:34 PM, "Ashley Sheridan" wrote: On Wed, 2009-07-29 at 11:29 -0700, Miller, Terion wrote: > I am trying to get rid of empty whitespace lines, I can't us chop() because > as I read it it will remove all whitespacesright? > > Right now my db is out

[PHP] Getting rid of extra lines

2009-07-29 Thread Miller, Terion
I am trying to get rid of empty whitespace lines, I can't us chop() because as I read it it will remove all whitespacesright? Right now my db is outputting with extra lines, I have stripped tags I know it isn't that causing it to look like this Blahlajdlkfjlksdjflkdjsf <--

Re: [PHP] Ridiculous ..won't print or echo ...(RESOLVED)

2009-07-29 Thread Miller, Terion
Yep just figured that out too..the escaping thing.. Thanks On 7/29/09 10:45 AM, "Ashley Sheridan" wrote: On Wed, 2009-07-29 at 11:36 -0400, Miller, Terion wrote: > Ok in my output to Quark I need to have $P printed to the page like this: > > <@$p>2118 S. Campbell A

[PHP] Ridiculous ..won't print or echo ...

2009-07-29 Thread Miller, Terion
Ok in my output to Quark I need to have $P printed to the page like this: <@$p>2118 S. Campbell Ave So in my php which is going to be grabbing this info and formatting it for the Quarkisn't echoing that "$p" all I get is the <@> I have tried several things: $p = $p $p = print("$p") $p = e

Re: [PHP] Argh Date problems (RESOLVED)

2009-07-29 Thread Miller, Terion
I had a tiny syntax error keeping it from working in the form of a cap letter. On 7/28/09 3:51 PM, "Miller, Terion" wrote: On 7/28/09 3:48 PM, "Bastien Koert" wrote: On Tue, Jul 28, 2009 at 4:02 PM, Miller, Terion wrote: > Ok so I got the > $inDate

Re: [PHP] Argh Date problems

2009-07-28 Thread Miller, Terion
On 7/28/09 3:48 PM, "Bastien Koert" wrote: On Tue, Jul 28, 2009 at 4:02 PM, Miller, Terion wrote: > Ok so I got the > $inDate = strtotime($results[3][$i]); > > Giving me the unix date now I am trying all the different date functions that > will put it in the

Re: [PHP] Argh Date problems (RESOLVED)

2009-07-28 Thread Miller, Terion
OMG AND I FIGURED IT OUT MYSELF...dang I just may be learning some php.. On 7/28/09 3:02 PM, "Miller, Terion" wrote: Ok so I got the $inDate = strtotime($results[3][$i]); Giving me the unix date now I am trying all the different date functions that will put it in the -00-0

Re: [PHP] Argh Date problems

2009-07-28 Thread Miller, Terion
? $formatDate = date('ymd', $inDate); On 7/28/09 2:41 PM, "Miller, Terion" wrote: Well I was going along smoothly from this morningbut it came down to having to change the field type to date in the mySQL..so now I have this which returns a scraped value formatted like this 0/0

[PHP] Argh Date problems

2009-07-28 Thread Miller, Terion
Well I was going along smoothly from this morningbut it came down to having to change the field type to date in the mySQL..so now I have this which returns a scraped value formatted like this 0/00/00 m/d/y $inDate = $results[3][$i]; Which date function can I use to format for the db so that

Re: [PHP] First of my Quark/php generated Questions (RESOLVED)

2009-07-28 Thread Miller, Terion
Lucas" wrote: Miller, Terion wrote: > > > On 7/28/09 11:05 AM, "Miller, Terion" wrote: > > > echo " > @Normal= > @.LIST > Bold= > @.BODY=[S"", > ".BODY"]<*J*h"Standard"*kn0*kt0*ra0*rb0*d0*p(0,7,0,10,0

Re: [PHP] First of my Quark/php generated Questions (RESOLVED)

2009-07-28 Thread Miller, Terion
On 7/28/09 11:05 AM, "Miller, Terion" wrote: echo " @Normal= @.LIST Bold= @.BODY=[S"", ".BODY"]<*J*h"Standard"*kn0*kt0*ra0*rb0*d0*p(0,7,0,10,0,0,G,"U.S. English")Ps100t-2h100z9.4k0b0cKf"PoynterOSTextTwoNL-Roman">

[PHP] First of my Quark/php generated Questions

2009-07-28 Thread Miller, Terion
Okay I have to echo onto my reverse pub page this chunk of code that is for generating the page in Quark, it has to echo as is...but I'm getting errors--I've tried in brackets, in paraenthesis, double quotes, single quotes etc: echo " @Normal= @.LIST Bold= @.BODY=[S"", ".BODY"]<*J*h"Standard"*

Re: [PHP] Making several variables into 1 variable

2009-07-28 Thread Miller, Terion
On 7/28/09 9:40 AM, "Bastien Koert" wrote: On Tue, Jul 28, 2009 at 10:34 AM, Bob McConnell wrote: > From: Miller, Terion > On 7/28/09 8:35 AM, "Ashley Sheridan" wrote: > >> $pastDays = strtotime("-30 days"); >> $date = date("d/m/y&quo

Re: [PHP] Making several variables into 1 variable

2009-07-28 Thread Miller, Terion
<,snip> > You can also do this right within MySQL without needing to create a variable. This should work: $sql = "SELECT DISTINCT restaurants.ID, name, address, inDate FROM restaurants, inspections WHERE restaurants.name != '' AND datediff(curdate(),inspections.inDate)>=30 GROUP BY restaurants

Re: [PHP] Making several variables into 1 variable

2009-07-28 Thread Miller, Terion
On 7/28/09 8:52 AM, "Ashley Sheridan" wrote: On Tue, 2009-07-28 at 06:46 -0700, Miller, Terion wrote: On 7/28/09 8:44 AM, "Ashley Sheridan" wrote: On Tue, 2009-07-28 at 09:42 -0400, Miller, Terion wrote: > > > On 7/28/09 8:35 AM, "Ashley Sheridan"

Re: [PHP] Making several variables into 1 variable

2009-07-28 Thread Miller, Terion
On 7/28/09 8:44 AM, "Ashley Sheridan" wrote: On Tue, 2009-07-28 at 09:42 -0400, Miller, Terion wrote: > > > On 7/28/09 8:35 AM, "Ashley Sheridan" wrote: > > $pastDays = strtotime("-30 days"); > $date = date("d/m/y", $pastDays); &g

Re: [PHP] Making several variables into 1 variable

2009-07-28 Thread Miller, Terion
On 7/28/09 8:41 AM, "Bob McConnell" wrote: From: Ashley Sheridan > On Tue, 2009-07-28 at 09:32 -0400, Miller, Terion wrote: >> I need to take this: >> >>$pastDays = strtotime("-30 days"); >> >> >> >> $past_da

Re: [PHP] Making several variables into 1 variable

2009-07-28 Thread Miller, Terion
On 7/28/09 8:35 AM, "Ashley Sheridan" wrote: $pastDays = strtotime("-30 days"); $date = date("d/m/y", $pastDays); Well I tried and got no results from my query and I know there results with date ranges in the last 30 days, I basically need to count backward from now() 30 days I thought strt

[PHP] Making several variables into 1 variable

2009-07-28 Thread Miller, Terion
I need to take this: $pastDays = strtotime("-30 days"); $past_day = date("d", $pastDays); $past_month = date("m", $pastDays); $past_year =date("y", $pastDays); And make it into one var to compare to a db field that is formatted like 00/00/00 -- PHP General Mailing List (http://www.php

Re: [PHP] Imposing a range on what is stored in a session variable

2009-07-27 Thread Miller, Terion
=snipped > I would page the data with the LIMIT call as Jim suggested. What is the user doing with 1K records and how are they getting 1K records? -- Bastien Cat, the other other white meat Here is a link to the code at PasteBin It's a db full of the town's restaurant inspections

Re: [PHP] Imposing a range on what is stored in a session variable

2009-07-27 Thread Miller, Terion
On 7/27/09 9:40 AM, "Jim Lucas" wrote: Miller, Terion wrote: > I want to store only 1000 records at a time in the session variable thought I > could use a range(1,1000 > > How would you do this, store the first 1000 , then the second on refresh etc

Re: [PHP] Imposing a range on what is stored in a session variable

2009-07-27 Thread Miller, Terion
eed ranged sessions...would my thinking on using the foreach(range work though? On 7/27/09 9:34 AM, "Bastien Koert" wrote: On Mon, Jul 27, 2009 at 10:30 AM, Miller, Terion wrote: > I want to store only 1000 records at a time in the session variable thought I > could use a range(1,

[PHP] Imposing a range on what is stored in a session variable

2009-07-27 Thread Miller, Terion
I want to store only 1000 records at a time in the session variable thought I could use a range(1,1000 How would you do this, store the first 1000 , then the second on refresh etc My snippet so far --- // Process all results in

Re: [Fwd: Re: [PHP] Undefined Index ...confusion] (RESOLVED)

2009-07-23 Thread Miller, Terion
Thanks On 7/23/09 9:52 AM, "Kyle Smith" wrote: Sorry, list, I did a reply instead of a reply-to-all. This is what I sent to "Miller, Terion" Miller, Terion wrote: > Thanks for the link Kyle!! Great thing there...(seriously I didn't know...I > learn something

Re: [PHP] Undefined Index ...confusion

2009-07-23 Thread Miller, Terion
On 7/23/09 9:24 AM, "Kyle Smith" wrote: Miller, Terion wrote: I keep getting this error while trying to use the field 'ID' to pass in a url.. And it's odd because the query is pulling everything BUT the ID which is the first field... code: We're going to

[PHP] Undefined Index ...confusion

2009-07-23 Thread Miller, Terion
I keep getting this error while trying to use the field 'ID' to pass in a url.. And it's odd because the query is pulling everything BUT the ID which is the first field... code: -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Back again with query problems and row problems

2009-07-21 Thread Miller, Terion
Okay I'm back guys...not sure what happened it was working..now it's all hung up... Here are the errors: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/getpublished.news-leader.com/httpdocs/ResturantInspections/restaurants.php on line 464

Re: [PHP] Search Query on two tables not working (RESOLVED)

2009-07-21 Thread Miller, Terion
Yep, sure was the spacesOMG...will I ever get it... On 7/21/09 12:29 PM, "Ashley Sheridan" wrote: On Tue, 2009-07-21 at 13:24 -0400, Andrew Ballard wrote: > On Tue, Jul 21, 2009 at 1:20 PM, Miller, > Terion wrote: > > Here it is...I see where it's doing the res

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Miller, Terion
Here it is...I see where it's doing the restaurant.name LIKE statement 2x which is prob messing it up right...but in the code why is it doing that twice.. SELECT name, address, inDate, inType, notes, critical, cviolations, noncritical FROM restaurants, inspections WHERE restaurants.name <> '' AN

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Miller, Terion
, but need to see the final SQL statement. Miller, Terion wrote: > Why isn't this working for searching? > > // Run query on submitted values. Store results in $SESSION and redirect > to restaurants.php$sql = "SELECT name, address, inDate, inType, > notes, crit

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Miller, Terion
On 7/21/09 12:04 PM, "Ashley Sheridan" wrote: On Tue, 2009-07-21 at 12:59 -0400, Miller, Terion wrote: > > > On 7/21/09 11:47 AM, "Dan Shirah" wrote: > > Why isn't this working for searching? > > // Run query on submitted values. Store results

Re: [PHP] Search Query on two tables not working

2009-07-21 Thread Miller, Terion
On 7/21/09 11:47 AM, "Dan Shirah" wrote: Why isn't this working for searching? // Run query on submitted values. Store results in $SESSION and redirect to restaurants.php$sql = "SELECT name, address, inDate, inType, notes, critical, cviolations, noncritical FROM restaurants, inspe

[PHP] Search Query on two tables not working

2009-07-21 Thread Miller, Terion
Why isn't this working for searching? // Run query on submitted values. Store results in $SESSION and redirect to restaurants.php$sql = "SELECT name, address, inDate, inType, notes, critical, cviolations, noncritical FROM restaurants, inspections WHERE restaurants.name <> '' AND rest

[PHP] Characters causing problems in search strings?

2009-07-16 Thread Miller, Terion
My little browse /search restaurant project is coming along, but I just noticed that any restaurant with a &, () or # in the name like say for example Arby's Store #12 ...will not return results... Yet if a name has a / or a - it's not a problem... 1. why is this and how do and where do I escape th

Re: [PHP] Invalid Argument why? (RESOLVED)

2009-07-16 Thread Miller, Terion
($row['critical']),'' ; echo ($row['cviolations']),''; }} On 7/16/09

[PHP] Invalid Argument why?

2009-07-16 Thread Miller, Terion
Why is this an invalid argument? foreach(($row['inType']) as $inType){ echo $inType,'';} I am trying to output results from a data base that may have multiple results for the same name So trying to use an array and foreach that is the right track ...right? -- PHP General Mailing List (ht

Re: [PHP] Syntax Snag need extra eyes (RESOLVED)

2009-07-16 Thread Miller, Terion
Thanks Jim!! I did read the manual and don't get it, like why is printf used and not echo...how do you decided which to use? On 7/16/09 11:25 AM, "Jim Lucas" wrote: printf( '%s%s', $row['name'], $row['name'], $row['address'] ); -- PHP General Mailing List (ht

[PHP] Syntax Snag need extra eyes

2009-07-16 Thread Miller, Terion
I'm almost there with my little pagination script but now I'm hung on the "Unexpected T_Variable" error...which in the past has been a semi-colon missing so I'm not sure why this is throwing it...eyes please: printf('%s%s',$row['name'] ,$row['address']); -- PHP General Mailing List (http://www.

Re: [PHP] Alphabetical pagination (RESOLVED)

2009-07-16 Thread Miller, Terion
One question I still have...I had help with this script of course and I'm confused with the %s what does it do? On 7/16/09 9:53 AM, "Martin Scotta" wrote: On Thu, Jul 16, 2009 at 11:01 AM, Andrew Ballard wrote: On Thu, Jul 16, 2009 at 9:33 AM, Miller, Terion wrote: > >

Re: [PHP] Alphabetical pagination (RESOLVED)

2009-07-16 Thread Miller, Terion
printf('%s%s%s',$row['name'],$row['address'],$result['cviolations']); } ?> Thanks again everyone!! On 7/15/09 10:48 AM, "tedd&qu

Re: [PHP] Alphabetical pagination

2009-07-15 Thread Miller, Terion
--snip How do I write the for each loop in here: //alphabetical pagination links if (!isset($_GET['letter'])) {$letter = "A";} else {$letter = $_GET['letter'];}

Re: [PHP] Alphabetical pagination

2009-07-15 Thread Miller, Terion
On 7/15/09 10:30 AM, "Ashley Sheridan" wrote: On Wednesday 15 July 2009 16:21:22 tedd wrote: > At 12:38 PM -0700 7/14/09, Miller, Terion wrote: > >I am trying to make a page that displays a-z like a b c d e etc as links > >then when you click open one it reloads

[PHP] Alphabetical pagination

2009-07-14 Thread Miller, Terion
I am trying to make a page that displays a-z like a b c d e etc as links then when you click open one it reloads itself and shows only the query results that go with that letter...i'm not getting itI get a page that says ARRAY over and over... What I have so far:

Re: [PHP] What is this called?

2009-07-06 Thread Miller, Terion
On 7/6/09 10:07 AM, "Daniel Brown" wrote: On Mon, Jul 6, 2009 at 10:48, Miller, Terion wrote: > Ok, say you have a database with 16000 records in it, but you only want to > call out say 2000 records at a time as the search/query is performed, then > store the first 2000 in

[PHP] What is this called?

2009-07-06 Thread Miller, Terion
Ok, say you have a database with 16000 records in it, but you only want to call out say 2000 records at a time as the search/query is performed, then store the first 2000 in a session and then retrieve the next 2000 etc etc as a way to minimize server strain? (I'm tasked to do this and ) 1. do

Re: [PHP] Select and compare problems still ...

2009-07-01 Thread Miller, Terion
On 7/1/09 10:29 AM, "Andrew Ballard" wrote: $data = array($ucName, $ucAddress, $inDate, $inType, $notes, > $critical, $cleanViolations, $noncritical); > > $sql = vprintf("INSERT INTO `restaurants` (name, address, inDate, > inType, notes, critical, cviolations, noncritical) VALUES ('%s', '%s',

Re: [PHP] Select and compare problems still ...

2009-07-01 Thread Miller, Terion
On 7/1/09 10:06 AM, "Phpster" wrote: On Jul 1, 2009, at 10:56 AM, "Miller, Terion" wrote: > Why doesn't this work? > > >$query = "SELECT * FROM `restaurants` WHERE name ='$ucName' AND > address = '$ucAddress' "

[PHP] Select and compare problems still ...

2009-07-01 Thread Miller, Terion
Why doesn't this work? $query = "SELECT * FROM `restaurants` WHERE name ='$ucName' AND address = '$ucAddress' " ; $result = mysql_query($query) or die(mysql_error()); echo $result; $row = mysql_fetch_array ($result); $sql = "INSERT INTO `restaurants` (name, address, in

Re: [PHP] Compare and inserting with php

2009-06-30 Thread Miller, Terion
On 6/30/09 1:31 PM, "Tom Worster" wrote: On 6/30/09 11:17 AM, "Ashley Sheridan" wrote: > It's a bad way of doing it, but could you not create a unique index on the > particular key you want to be unique, and then just try the select anyway > with the mysql_query() call preceeded with an @ to

Re: [PHP] Compare and inserting with php

2009-06-30 Thread Miller, Terion
>> > > Does this list of inspections exist in the db? Could you not use an > INSERT INTO SELECT * FROM TABLE WHERE type statement...much less > processing overhead then > > -- > > Bastien > > Cat, the other other white meat > > Hi Bastien, > > Something like this is what you mean? > > if (!emp

Re: [PHP] Compare and inserting with php

2009-06-30 Thread Miller, Terion
On 6/30/09 10:40 AM, "Bastien Koert" wrote: On Tue, Jun 30, 2009 at 11:17 AM, Ashley Sheridan wrote: > On Tuesday 30 June 2009 15:42:01 Miller, Terion wrote: >> Okay, what I am trying to do is this: >> >> I have a db full of inspections, daily I need to run

[PHP] Compare and inserting with php

2009-06-30 Thread Miller, Terion
Okay, what I am trying to do is this: I have a db full of inspections, daily I need to run a script that will grab the posting of inspections, check them against the db to make sure they aren't duplicates and then insert all the new entries. Not sure if my logic of going about it this way is r

[PHP] Php and regex help or advice

2009-06-17 Thread Miller, Terion
Hi Everyone, Ok, so I've been plunged further into using php by being tasked to use it with regex (yes tylenol extra strength needed please) So far I have my code that grabs a full block of text by paragraphs, now I have to somehow write a snippet that goes inside this block and pulls out each lin

[PHP] Php and Imagemagick problems

2009-06-09 Thread Miller, Terion
I am having a heck of a time getting a script to convert images to workit worked fine for a few hours, then someone "tweaked it" and now it doesn't work and I can't get it back...they "tweaked" the original file The script runs and uploads files but no longer "converts" them with the Image

Re: [PHP] Not a regular file? (RESOLVED)

2009-06-04 Thread Miller, Terion
Issue is resolved, all I needed to do was put $ImageName on the remote path too> duhlol $remote_path = "/httpdocs/Announcements/photos/obitsTest/$ImageName"; On 6/4/09 9:35 AM, "kyle.smith" wrote: echo "I'm going to upload $FilePath to $remote_path."; -- PHP General Mailing List (htt

Re: [PHP] Not a regular file?

2009-06-04 Thread Miller, Terion
cho "There was a problem while uploading $ImageName\n";} // close the connection ftp_close($conn_id); Since it is passing a full path I don't know how it can be only going to the directory? On 6/4/09 9:22 AM, "haliphax" wrote: On Thu, Jun 4, 2009 at 9:07 A

  1   2   >