Can someone help with how to make this work, trying to get the number of
rows but am getting the trying to get property of non-object
Code-
$query = select blah, blah, blah from table where .$type. like
'%.$name.%';
$result = mysql_query($query);
$num_results =
On 4/28/09 11:23 AM, Jan G.B. ro0ot.w...@googlemail.com wrote:
2009/4/28 Miller, Terion tmil...@springfi.gannett.com:
Can someone help with how to make this work, trying to get the number of
rows but am getting the trying to get property of non-object
Code-
$query
On 4/28/09 12:27 PM, Lex Braun lex.br...@gmail.com wrote:
Terion,
On Tue, Apr 28, 2009 at 1:14 PM, Miller, Terion tmil...@springfi.gannett.com
wrote:
Here is my code now:
$query = select name, age, warrant, bond, wnumber, crime FROM warrants
where .$warranttype. = .$warranttype
Thanks folks!!
On 4/28/09 12:30 PM, Miller, Terion tmil...@springfi.gannett.com wrote:
On 4/28/09 12:27 PM, Lex Braun lex.br...@gmail.com wrote:
Terion,
On Tue, Apr 28, 2009 at 1:14 PM, Miller, Terion tmil...@springfi.gannett.com
wrote:
Here is my code now:
$query = select name, age
: ini_set(max_execution_time, time in seconds);
On Mon, May 4, 2009 at 3:43 PM, Martin Zvarík mzva...@gmail.com wrote:
Miller, Terion napsal(a):
I need help/advice figuring out why my query dies after 2 records. Here
is
the query:
// Build your INSERT statement here
$query = INSERT
Ok I have a script that grabs data from a page and puts it in a db, I need
to run this script 26 times on 26 different pages on the same site, is there
a way to do this without making 26 different scripts load? Should I post the
script?
Thanks,
T.Miller
--
PHP General Mailing List
On 5/5/09 8:31 AM, php news feed maarte...@scullix.co.za wrote:
post the script, and example of data
Miller, Terion tmil...@springfi.gannett.com wrote in message
news:c6259e7b.e91%kmille...@springfi.gannett.com...
Ok I have a script that grabs data from a page and puts it in a db, I need
On 5/5/09 8:47 AM, Maarten Schalekamp maarte...@scullix.co.za wrote:
$targets[] = http://www.greenecountymo.org/sheriff/warrants.php;;
$targets[] = http://www.greenecountymo.org/sheriff/page2.php;;
$targets[] = http://www.greenecountymo.org/sheriff/page3.php;;
foreach ($targets as
On 5/5/09 9:23 AM, Wolf lonew...@nc.rr.com wrote:
Miller wrote:
Ok I have a script that grabs data from a page and puts it in a db, I need
to run this script 26 times on 26 different pages on the same site, is there
a way to do this without making 26 different scripts load? Should I
On 5/5/09 9:52 AM, Wolf lonew...@nc.rr.com wrote:
Miller wrote:
On 5/5/09 9:23 AM, Wolf lonew...@nc.rr.com wrote:
Miller wrote:
Ok I have a script that grabs data from a page and puts it in a db, I need
to run this script 26 times on 26 different pages on the same site,
Trying to run a script on several different pages within the same site by
making the url's an array...anyone see a better way to do this?
Trying to resolve some curl errors and need some help, here are the errors:
Notice: Array to string conversion in
On 5/8/09 8:04 AM, Jônatas Zechim zechim@gmail.com wrote:
Try to change this:
curl_setopt($ch,CURLOPT_URL,$targets);
to:
curl_setopt($ch,CURLOPT_URL, $target_url);
Zechim
zechim.com
São Paulo/Brazil
Thanks for the suggestion:
Tried it and get this error now:
Warning:
On 5/8/09 8:49 AM, Jônatas Zechim zechim@gmail.com wrote:
Try to echo the $target_url var. What's on it?
Try to echo the $args var. What's on it?
How do you pass the $args?
I echo'd the $target_url and I got all the correct urls -did I mention this
error reports one time for every
I'm back. I thought I had this script working but it seems to always stop
at the end of the C's, so I can get it to go thru pages A-C then it stops, I
have tried setting the time-out to a very large amount but it never
continues to run past the same spot, it gathers all records to the end of C,
The error I get is from my INSERT statement
It does insert the records up to C page though...
The problem area:
// Build your INSERT statement here $query = INSERT into
warrants (wid, name, age, warrant, bond, wnumber, crime) VALUES (;$query
.= '$wid', '$name', '$age',
Bastien, could you give me an example of what you mean?
would it be $Name =
like that?
Thanks for the ideas everyone!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Try Imitliazing the variables at the top of the loop to empty
Bastien, could you give me an example of what you mean?
would it be $Name =
like that?
Thanks for the ideas everyone!
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Try Imitliazing the variables at the top of the loop to empty
I am trying to get an image to display but I get nothing if done like this:
tr
tdScout Photo:/td
tdimg src=?php echo $row['ePhoto'];?/td
/tr
If I just echo the field I do get the file name
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe,
On 5/27/09 12:49 PM, Bastien Koert phps...@gmail.com wrote:
On Wed, May 27, 2009 at 1:46 PM, Shawn McKenzie nos...@mckenzies.netwrote:
Miller, Terion wrote:
I am trying to get an image to display but I get nothing if done like
this:
tr
tdScout Photo:/td
tdimg
Thanks for the suggestions everyone, I have this now, but still no image
showing up
It is stored as a blob in the database.
on the output page I am calling it like this:
img src=image.php?filename=?php echo $row['ePhoto']; ?
Then on the image.php page I have this:
?php
Well I have tried Numerous scripts and ways and still can't get the image to
display.
I have echoed the file and have been able to get the gibberish image code to
display but not a real image, here is my full code if anyone wants to have a
look, I am going crossed eyed here.
These are
I wrote this little script (part of a much much larger one I am working at)
anyways, I am trying to get it to compare a file name from a db to an actual
file in a folder and then tell me if it does or doesn't exist, the problem I
have is that the files do exist, I echo them out, but it says file
an /output/ that $BackupPath doesn't.
Also, make sure you don't have safe_mode or open_basedir restricting the files
php can see, although I'm reasonably sure the fact that it's an URL should
nullify that. Also, make sure you have allow_url_fopen turned on.
On Wed, Jun 3, 2009 at 2:31 PM, Miller
Tried that too with no luck...
On 6/3/09 2:01 PM, João Cândido de Souza Neto j...@consultorweb.cnt.br
wrote:
$_SERVER[document_root]./HarrisAutomate/output/WebImagesHiRes/$ImageName;
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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 halip...@gmail.com wrote:
On Thu, Jun 4, 2009 at 9:07 AM, Miller, Terion
tmil...@springfi.gannett.com
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 kyle.sm...@inforonics.com wrote:
echo I'm going to upload $FilePath to $remote_path.;
--
PHP
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
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
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
On 6/30/09 10:40 AM, Bastien Koert phps...@gmail.com wrote:
On Tue, Jun 30, 2009 at 11:17 AM, Ashley
Sheridana...@ashleysheridan.co.uk 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
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 (!empty($Go)) {
On 6/30/09 1:31 PM, Tom Worster f...@thefsb.org wrote:
On 6/30/09 11:17 AM, Ashley Sheridan a...@ashleysheridan.co.uk 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
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,
On 7/1/09 10:06 AM, Phpster phps...@gmail.com wrote:
On Jul 1, 2009, at 10:56 AM, Miller, Terion tmil...@springfi.gannett.com
wrote:
Why doesn't this work?
$query = SELECT * FROM `restaurants` WHERE name ='$ucName' AND
address = '$ucAddress' ;
$result = mysql_query($query
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.
On 7/6/09 10:07 AM, Daniel Brown danbr...@php.net wrote:
On Mon, Jul 6, 2009 at 10:48, Miller,
Teriontmil...@springfi.gannett.com 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
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:
On 7/15/09 10:30 AM, Ashley Sheridan a...@ashleysheridan.co.uk 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 itself
--snip
How do I write the for each loop in here:
//alphabetical pagination links
if (!isset($_GET['letter'])) {$letter = A;} else
{$letter = $_GET['letter'];}
-0700 7/15/09, Miller, Terion wrote:
Hi all thanks for all the suggestions, I really had no idea this was
going to be so difficult..
I think you are making it more difficult than it has to be.
Please review what I said and try it out.
Cheers,
tedd
--
---
http://sperling.com http
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('a
href=view.php?name=$row['name']b%s/bbr%s/brbr/a',$row['name']
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 li...@cmsws.com wrote:
printf(
'a href=view.php?name=%sb%s/bbr /%sbr /br //a',
$row['name'],
$row['name'],
Why is this an invalid argument?
foreach(($row['inType']) as $inType){
echo $inType,'br';}
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
($row['cviolations']),'br';
}}
On 7/16/09 2:53 PM, Kyle Smith kyle.sm...@inforonics.com wrote:
Miller, Terion wrote:
Why is this an invalid argument?
foreach(($row
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
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
On 7/21/09 11:47 AM, Dan Shirah mrsqua...@gmail.com 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
On 7/21/09 12:04 PM, Ashley Sheridan a...@ashleysheridan.co.uk wrote:
On Tue, 2009-07-21 at 12:59 -0400, Miller, Terion wrote:
On 7/21/09 11:47 AM, Dan Shirah mrsqua...@gmail.com wrote:
Why isn't this working for searching?
// Run query on submitted values. Store results in $SESSION
a
problem, 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, critical, cviolations
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 '' AND
Yep, sure was the spacesOMG...will I ever get it...
On 7/21/09 12:29 PM, Ashley Sheridan a...@ashleysheridan.co.uk wrote:
On Tue, 2009-07-21 at 13:24 -0400, Andrew Ballard wrote:
On Tue, Jul 21, 2009 at 1:20 PM, Miller,
Teriontmil...@springfi.gannett.com wrote:
Here it is...I see where
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
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:
a href=view.php?ID=?php echo $_SESSION['fullRestaurantList']['ID']??php
echo
On 7/23/09 9:24 AM, Kyle Smith kyle.sm...@inforonics.com 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:
a href=view.php?ID=?php
Thanks
On 7/23/09 9:52 AM, Kyle Smith kyle.sm...@inforonics.com 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 everyday
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
Well there are currently about 17000 records in the db, and my manager wants to
have it only pulling in 1000 at a time as a session range
And why do my code snippets always look so messed up , I put them in using the
rich text or html settings in my Entourage mail...
They look fine when I send
On 7/27/09 9:40 AM, Jim Lucas li...@cmsws.com 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
My snippet so far
=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
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.net/)
On 7/28/09 8:35 AM, Ashley Sheridan a...@ashleysheridan.co.uk 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
On 7/28/09 8:41 AM, Bob McConnell r...@cbord.com 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_day = date(d, $pastDays);
$past_month = date(m, $pastDays);
$past_year =date(y
On 7/28/09 8:44 AM, Ashley Sheridan a...@ashleysheridan.co.uk wrote:
On Tue, 2009-07-28 at 09:42 -0400, Miller, Terion wrote:
On 7/28/09 8:35 AM, Ashley Sheridan a...@ashleysheridan.co.uk wrote:
$pastDays = strtotime(-30 days);
$date = date(d/m/y, $pastDays);
Well I tried and got
On 7/28/09 8:52 AM, Ashley Sheridan a...@ashleysheridan.co.uk wrote:
On Tue, 2009-07-28 at 06:46 -0700, Miller, Terion wrote:
On 7/28/09 8:44 AM, Ashley Sheridan a...@ashleysheridan.co.uk wrote:
On Tue, 2009-07-28 at 09:42 -0400, Miller, Terion wrote:
On 7/28/09 8:35 AM, Ashley Sheridan
,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.ID
On 7/28/09 9:40 AM, Bastien Koert phps...@gmail.com wrote:
On Tue, Jul 28, 2009 at 10:34 AM, Bob McConnellr...@cbord.com wrote:
From: Miller, Terion
On 7/28/09 8:35 AM, Ashley Sheridan a...@ashleysheridan.co.uk wrote:
$pastDays = strtotime(-30 days);
$date = date(d/m/y, $pastDays);
Well
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 v6.52e0
@Normal=Ps100t-2h100z9.4k0b0cMfHelvetica
@.LIST
On 7/28/09 11:05 AM, Miller, Terion tmil...@springfi.gannett.com wrote:
echo v6.52e0
@Normal=Ps100t-2h100z9.4k0b0cMfHelvetica
@.LIST
Bold=Ps100t-4h110.001z8.7k0b0cKfInterstateNL-BlackCondensed
@.BODY=[S,
.BODY]*J*hStandard*kn0*kt0*ra0*rb0*d0*p(0,7,0,10,0,0,G,U.S.
English)Ps100t
...@cmsws.com wrote:
Miller, Terion wrote:
On 7/28/09 11:05 AM, Miller, Terion tmil...@springfi.gannett.com wrote:
echo v6.52e0
@Normal=Ps100t-2h100z9.4k0b0cMfHelvetica
@.LIST
Bold=Ps100t-4h110.001z8.7k0b0cKfInterstateNL-BlackCondensed
@.BODY=[S,
.BODY]*J*hStandard*kn0*kt0*ra0*rb0*d0
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
?
$formatDate = date('ymd', $inDate);
On 7/28/09 2:41 PM, Miller, Terion tmil...@springfi.gannett.com 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
OMG AND I FIGURED IT OUT MYSELF...dang I just may be learning some php..
On 7/28/09 3:02 PM, Miller, Terion tmil...@springfi.gannett.com 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-00 like sql stores it because I ran it with the
unix stamp and it just stored 00 in the db
Hoping something like this works?
$formatDate = date('ymd', $inDate);
On 7/28/09 2:41 PM, Miller, Terion tmil...@springfi.gannett.com wrote:
Well I was going along smoothly from
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 tmil...@springfi.gannett.com wrote:
On 7/28/09 3:48 PM, Bastien Koert phps...@gmail.com wrote:
On Tue, Jul 28, 2009 at 4:02 PM, Miller,
Teriontmil...@springfi.gannett.com wrote
Ok in my output to Quark I need to have $P printed to the page like this:
@$p2118 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 = echo $p
Yep just figured that out too..the escaping thing..
Thanks
On 7/29/09 10:45 AM, Ashley Sheridan a...@ashleysheridan.co.uk 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:
@$p2118 S. Campbell Ave
So
On 7/29/09 1:34 PM, Ashley Sheridan a...@ashleysheridan.co.uk 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 outputting
On 7/29/09 1:45 PM, Ashley Sheridan a...@ashleysheridan.co.uk 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
On 7/29/09 2:19 PM, Jim Lucas li...@cmsws.com 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
On 7/29/09 3:05 PM, Jonathan Tapicer tapi...@gmail.com wrote:
On Wed, Jul 29, 2009 at 4:20 PM, Miller,
Teriontmil...@springfi.gannett.com wrote:
On 7/29/09 1:45 PM, Ashley Sheridan a...@ashleysheridan.co.uk wrote:
[snip/]
Have you thought of just using a regular str_replace() on your
On 7/29/09 3:16 PM, Jim Lucas li...@cmsws.com wrote:
Miller, Terion wrote:
On 7/29/09 3:05 PM, Jonathan Tapicer tapi...@gmail.com wrote:
On Wed, Jul 29, 2009 at 4:20 PM, Miller,
Teriontmil...@springfi.gannett.com wrote:
On 7/29/09 1:45 PM, Ashley Sheridan a...@ashleysheridan.co.uk
Yep I forgot about escaping the $
On 7/29/09 10:51 AM, Ford, Mike m.f...@leedsmet.ac.uk 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 like
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'])?
I Figured it out using this:
if ($_SERVER['SCRIPT_FILENAME'] = browse.php ) {
$default = A;
}
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
On 7/31/09 8:58 AM, m0s d...@lenss.nl 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
On 7/31/09 9:53 AM, Bastien Koert phps...@gmail.com wrote:
On Fri, Jul 31, 2009 at 10:28 AM, Miller,
Teriontmil...@springfi.gannett.com wrote:
On 7/31/09 8:58 AM, m0s d...@lenss.nl wrote:
(!empty($row['notes']) IsAlpha($row['notes']))
I tried that and this one:
If
On 7/31/09 10:14 AM, Bastien Koert phps...@gmail.com wrote:
On Fri, Jul 31, 2009 at 10:59 AM, Miller,
Teriontmil...@springfi.gannett.com wrote:
On 7/31/09 9:53 AM, Bastien Koert phps...@gmail.com wrote:
On Fri, Jul 31, 2009 at 10:28 AM, Miller,
Teriontmil...@springfi.gannett.com wrote:
On 7/31/09 10:54 AM, Jim Lucas li...@cmsws.com wrote:
Miller, Terion wrote:
On 7/31/09 10:14 AM, Bastien Koert phps...@gmail.com wrote:
On Fri, Jul 31, 2009 at 10:59 AM, Miller,
Teriontmil...@springfi.gannett.com wrote:
On 7/31/09 9:53 AM, Bastien Koert phps...@gmail.com wrote
On 7/31/09 11:03 AM, Miller, Terion tmil...@springfi.gannett.com wrote:
On 7/31/09 10:54 AM, Jim Lucas li...@cmsws.com wrote:
Miller, Terion wrote:
On 7/31/09 10:14 AM, Bastien Koert phps...@gmail.com wrote:
On Fri, Jul 31, 2009 at 10:59 AM, Miller,
Teriontmil...@springfi.gannett.com
On 7/31/09 10:54 AM, Jim Lucas li...@cmsws.com wrote:
Miller, Terion wrote:
On 7/31/09 10:14 AM, Bastien Koert phps...@gmail.com wrote:
On Fri, Jul 31, 2009 at 10:59 AM, Miller,
Teriontmil...@springfi.gannett.com wrote:
On 7/31/09 9:53 AM, Bastien Koert phps...@gmail.com wrote
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
?php
On 7/31/09 12:27 PM, Bastien Koert phps...@gmail.com wrote:
$letter = isset($_GET['letter']) ? $_GET['letter'] :;
echo 'div align=centerb';
foreach(range('A','Z') as $c){
($letter == $c) ? printf('%snbsp',$c) : printf('a
href=browse.php?letter=%s%s/anbsp;',$c,$c);
}
echo 'br';
On 7/31/09 12:43 PM, Bastien Koert phps...@gmail.com wrote:
On Fri, Jul 31, 2009 at 1:40 PM, Miller,
Teriontmil...@springfi.gannett.com wrote:
On 7/31/09 12:27 PM, Bastien Koert phps...@gmail.com wrote:
$letter = isset($_GET['letter']) ? $_GET['letter'] :;
echo 'div align=centerb';
--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');
On 7/31/09 1:56 PM, Bastien Koert phps...@gmail.com 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
On 7/31/09 2:00 PM, Miller, Terion tmil...@springfi.gannett.com wrote:
On 7/31/09 1:56 PM, Bastien Koert phps...@gmail.com wrote:
$letters = '';
Nope still gives the same error: Notice: Undefined index: letter
Well getting closer with this but now my output menu is not a clickable link
On 7/31/09 3:08 PM, Bastien Koert phps...@gmail.com wrote:
On Fri, Jul 31, 2009 at 3:10 PM, Miller,
Teriontmil...@springfi.gannett.com wrote:
On 7/31/09 2:00 PM, Miller, Terion tmil...@springfi.gannett.com wrote:
On 7/31/09 1:56 PM, Bastien Koert phps...@gmail.com wrote:
$letters
-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, '#');
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, name,
1 - 100 of 121 matches
Mail list logo