are pain in the neck :)
-afan
Brian wrote:
Why do you want your array to start with 1 so badly?
On Mon, 18 Oct 2004 13:33:22 -0500, Afan Pasalic [EMAIL PROTECTED] wrote:
It's not what I was looking for. Looks like I didn't explain very well :)
look at this case:
$query
?
TIA,
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
in c:\Inetpub\wwwroot\palms\htdocs\bookmarks.php on line 5
Any suggestions on how I can do this without throwing notices? I'm
aware that I can turn notices off but I like them kept on to help me
with debugging.
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit
Those of us that view emails as a list of conversations would
appreciate not changing subject lines.
On Wed, 6 Oct 2004 16:01:32 -0400, Aaron Wolski [EMAIL PROTECTED] wrote:
Hi All,
Just wanted to thank everyone for their advice and help.
What I ended up doing is simply doing an include()
Make sure you are doing a session_start first.
On Tue, 5 Oct 2004 19:00:57 +0530, Kevin Javia [EMAIL PROTECTED] wrote:
Hi there,
I have got PHP 5 installed on IIS6 with 'register_globals = on'.
When run my page with session variable at top of the page
?
$_SESSION['_user'] ==
$var=##testcode##this is a ##code1## test of the ##code2## code
replacement system ##code3##;
$varParsed=strParse($var);
echo $varbr;
echo $varParsed;
function strParse($origString)
{
while ( $offsetstrlen($origString)
!(($foundBeg=strpos($origString, ##, $offset))===FALSE))
{
if
As the others said, this isn't a function of php, php is a server-side
script and a refresh is on the client side. A meta-refresh tag is
fine depending on how reliable you want your refresh to be as it'll
stop working after a day or so. If you need it to refresh forever
you'll need to use
Along with the other tips people gave, make sure that if you have
register globals turned on, do not ever reference a session variable
that way, always use $_SESSION
On Thu, 30 Sep 2004 08:39:42 -0400, Aaron Todd [EMAIL PROTECTED] wrote:
Can anyone tell me how secure a session variable is. I
If you already resolve the proxy before the exec, just don't run the
exec if it doesn't resolve, and set the proxy to the ip it resolved to
so curl won't try to resolve it again.
On Thu, 30 Sep 2004 16:27:52 +0200, Nick Wilson [EMAIL PROTECTED] wrote:
Hello everyone,
I'm using cURL and have
if ( apples oranges ) {echo apples comes before orangesbr;}
On Thu, 30 Sep 2004 17:59:39 +0200, Diana Castillo [EMAIL PROTECTED] wrote:
Is there any way you can use the numerical comparisons or to see if one
word comes first alphabetically to another ?
what can I use to see if
oranges
of one of the in-between needles, so that I
can use substr() to trim everything from there on. What very obvious
function was I unable to find in the manual?
Thanks,
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
looking for a function that will return the value 19,
given the above example string.
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I don't understand why explode won't work for you.
The explode solution is working. Thanks very much to everyone who
replied with so much great information!
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Mon, 2004-09-20 at 19:37, Stut wrote:
On Mon, 20 Sep 2004 16:20:21 -0700, AMC [EMAIL PROTECTED] wrote:
Is there a tool that will generate a script that can be run to rebuild a
mysql database? I need to move my database to a different server
No need to use PHP which also makes this OT
bell
is rung once at the beginning of the screen capture and twice when
it completes.
--
s/:-[(/]/:-)/g
BrianGnuPG - KeyID: 0x04A4F0DC | Key Server: pgp.mit.edu
==
gpg --keyserver pgp.mit.edu --recv-keys 04A4F0DC
. This works on my development server and on another domain,
but it's not working here (just dumps them to the login page on the
secure domain). Any suggestions?
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks! And, *wow* yes I just did try php2asp. Pretty good translation,
although a few things need adjusting, it seems to do a remarkable job. I'll
definitely have to play with it some more.
:)
-Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
If
-Brian
, I'd appreciate a
recommendation to a good one. I couldn't find one via STFW that had any
kind of volume.
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks Pablo - but it's more complicated than that. I'm trying to
return totals for all calendar months, not all records within the past
month. I'll word my question better and post it to one of your
suggested lists. :)
On Sep 10, 2004, at 4:27 PM, Pablo Gosse wrote:
Brian Dunning wrote:
I
Amazing - that did it, first try! THANKS. I knew it had to be simple.
SQL rocks.
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
in production. It sounds like it should be
correctible by editing something in php.ini but nothing jumps out at
me...
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
It seems the problem is that port 1129 is blocked somewhere, which lphp
needs to communicate with Cardservice. Sorry for the noise, hope this
is helpful to someone else. :)
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
they get wise and change patterns
again.)
Many thanks,
- Brian
PS - If anyone wants an update: the orders stopped for a while but
started up this weekend with a vengeance. Now they are coming with
valid address verification AND card validation numbers! Pretty darn
good, whoever's doing it. One
that
it's supposed to. I am properly including the lphp.php file, and I've
verified that curl is turned on. Anyone have a clue, or is there any
more info I need to provide?
TIA,
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
that the php class file can be downloaded from and
manually installed? Anybody know?
-Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
one fake Amex order has gone
through. This may be as good as I can get it without resorting to user
accounts, etc.
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
The plot thickens. I added AVS *and* CVM to the site - and the Amex
orders are still going through. Amex ignores CVM, and the address was
correct, so the thieves must have gotten ahold of printed statements
that show the billing address. Any idea how to combat THAT? They are
using fake IP
.
Nicely done, Linkpoint. Thanks to all for the help. :)
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Solved. As suggested, the tech guy at EFS was on paint. The first
transaction should be an AUTH, and the second transaction should be
PRIOR_AUTH_CAPTURE, not just CAPTURE.
Thanks everyone for confirming there was no way what the guy said could
be true... :)
--
PHP General Mailing List
Does anyone know of a class or technology that can convert an EPS
document in memory to an outputtable PDF? GD? ImageMagick?
Thanks,
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
never seen anything like this on
my own credit card statements, and I can't imagine that Amazon, et. al.
have this problem, though they follow our same business process. Can
anyone shed any light on this?
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http
is
not clear to me: does anybody know which of Linkpoint's ordertypes
these would be? Would the first be PREAUTH and the second be POSTAUTH?
Many thanks,
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
dynamic. I'll get a lot of orders from one IP address for a
few hours, but then the address changes.
I wonder if anyone has any experience with this, and if so, can you
suggest a way to deal with it?
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
Thanks to all of you for your suggestions. Yes I have been logging IP
address in my orders database.
I think I may have solved it by an even simpler method: I emailed the
perpetrator to thank him for all of his orders to see what he'd say.
His first few orders came with real email addresses,
On Aug 16, 2004, at 10:07 AM, Ed Lazor wrote:
Geesh, this sounds scary. Are you requiring account login before
processing
payments?
Not on this store, it's a really competitive market.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
phpcollab.com:
You should ask your hosting provider to install those for you, probably
they will do without much problem. Or, if they don't want to, you should
consider choosing another provider.
If it is an issue, does anyone know of a hosting provider that allows these
extensions?
-Brian
Thanks, both John and Jay. I will take a look at both those sites.
Regards,
-Brian Anderson
From: John Nichel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 10, 2004 9:50 AM
Subject: Re: [PHP] hosting provider won't enable ftp_connect()
Brian Anderson wrote:
I am trying
Hey all,
Thanks all for the good reference links. I will see what they offer. Bummed
if I have to switch hosts, because I have been happy with Godaddy in
general.
:)
-Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
($subtree, $node);
}
return $subtree;
} else
return NULL;
}
Be careful with this, because I didn't actually test this at all. Run it
on a few test cases and make sure it gives you what you want.
Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit
Thanks very much to everyone for all the suggestions. I tried them all,
and even the most minimal stripped down attempt:
mail('[EMAIL PROTECTED]','Test','Test');
fails with a 501 error, Bad address syntax. This is on a Windows box.
Anything else I can try? Is it possible that there is some
On Aug 6, 2004, at 8:35 AM, Nicklas Bondesson wrote:
Do you know what SMTP software they are running on the mailserver?
Just whatever IIS uses by default on my Windows box...
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Turns out I was doing one of these in my config file:
ini_set(sendmail_from, 'First Last [EMAIL PROTECTED]');
And there's that Windows-unfriendly format again. Thanks much to all
who showed me what to look for! :) :)
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe
it with one query instead of
five?
thanks a bunch in advance,
brian
code:
?php
$query2 = SELECT value FROM element_values WHERE element=48 AND
user=$user_id;
$result2 = mysql_query($query2) or die(could not $query2 .
mysql_error());
list($username) = mysql_fetch_row($result2);
$query3 = SELECT value
;
$result2 = mysql_query($query2) or die(could not $query2 .
mysql_error());
list($user_name, $address_street, $address_city, $address_state,
$address_zip, $phone) = mysql_fetch_array($result2);
do i need to do a while loop and create an array or something?
thanks again.
brian
--
PHP General
myTotal x
Just say
SELECT * FROM Table WHERE Table.a + Table.b + Table.c x
That should work, and it will be faster than using a HAVING clause.
Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
the finished
array should look like, I can help you with some code ideas.
Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Developing on a Windows server to be deployed on Linux. I get SMTP
server response: 501 Bad address syntax. Here's my code:
$mail_from = 'My Name [EMAIL PROTECTED]';
$mail_server = 'mail.servername.com'; // This is hosted externally
ini_set(SMTP, $mail_server);
ini_set(sendmail_from,
this helps. :)
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I've got a function where I reset an expiration datetime to 3 days in
the future, using:
update table set expire = NOW()+300 where ...
Has always worked great, but today it always sets the field to
-00-00 00:00:00. No code was touched. Anyone have a clue? A problem
with the ISP's
On Jul 29, 2004, at 10:18 AM, Jay Blanchard wrote:
Have you asked the ISP?
No - that's like asking a black hole, unfortunately - I was hoping
someone here might spot a problem on my end.
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Jul 29, 2004, at 10:45 AM, Jay Blanchard wrote:
Please read this now, before you post again...
http://catb.org/~esr/faqs/smart-questions.html
Thank you for not trying to be a condescending smartass at all.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
knows everything so you can masturbate all you want.
Please flame me back channel,
Brian Dunning
http://www.briandunning.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
don't suppose there is an example or tutorial of this process
anywhere, geared toward B1FF the n00b? Obviously this has been done a
thousand times before...
Thanks for any clueing-in,
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I'm a Brian, but you can't pick me unless you're a really hot chick.
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks for all the suggestions guys, I took your advice and currently
have a working login script (hopefully :) ). If I have any more
problems I'll be sure to ask you, it's nice to know that there's a place
I can always go for questions.
Thanks,
Brian
--
PHP General Mailing List (http
While I'm trying not to be paranoid of spam, I received 3 copies of this
message, and it seemed suspicious. Is this a legit email? (I didn't
know who else to ask besides the actual mailing list users) I included
all the relevant headers...
From - Tue Jul 20 10:49:01 2004
Return-Path: [EMAIL
While I know there are many scripts out there, and have spent many hours
looking through them, I am having trouble finding a login script that
fits my needs. I am looking for the following:
A MySQL-based login system that doesn't use Pear :: DB. All I would
like is for it to support cookies
Well I already have a db with username/password fields, etc. I'm just
looking for code for a login page and a file to include at the top of
each page for auth.
Jay Blanchard wrote:
[snip]
While I know there are many scripts out there, and have spent many hours
looking through them, I am having
[snip]
a. do not reply off-list unless asked, your question may not receive the
attention it needs
[/snip]
Sorry, I got the email before the board post so I assumed you were only
replying off-list.
[snip]
2. You do know basic PHP, correct? Create a page that accepts a username
and password.
Not sure if I understand the issue completely, but if it's a matter of
displaying the text from the database you could use the nl2br function.
http://us3.php.net/manual/en/function.nl2br.php
Hope that helps,
Brian
on 7/15/04 4:40 PM, Andrew Wood at [EMAIL PROTECTED] wrote:
Sorry, its
Does anyone know a way to programmatically determine if a given URL is
already in Google's index? I don't see anything like this in their
documentation. Thanks,
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
That's the documentation I was referring to. Are you sure? Like I said,
I didn't see anything like that in there.
On Jul 14, 2004, at 12:13 PM, Greg Donald wrote:
On Wed, 14 Jul 2004 11:27:09 -0700, Brian Dunning
[EMAIL PROTECTED] wrote:
Does anyone know a way to programmatically determine
to submit?
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
,
Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello,
Anyone have any recommended(reputable) resources for online PHP
training/certification? I would like good training but a certificate and
course documentation of would be good too.
Thank you,
-Brian Anderson
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http
is still visible in the shaded areas.
Or, if anyone knows another technology that might accomplish that, I'd
appreciate those suggestions too. :)
Thanks,
Brian Dunning
http://www.briandunning.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
THANKS!! :) :)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
by rate of sales:
Dick 1 sale in 2 tries, 50.0%
Tom1 sale in 3 tries, 33.3%
Is this possible with a single SQL statement? Many thanks,
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I'm not sure if this is a complex SQL query or a PHP array sorting
thing, but what's the best way to take this data:
Tom
Greg
Brian
Tom
Brian
Tom
And return the following results, sorted by number of records:
Tom - 3
Brian - 2
Greg - 1
Any thoughts?
--
PHP General Mailing List
n e 1 know of a web based front end for CVS? Not just a file/project
browser but a fully functioning web based GUI.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Sat, 2004-05-29 at 13:49, lists wrote:
tortoise is nice
http://www.tortoisecvs.org/
So is Cervisia but not sure what that has to do with the original
question... ;-)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
with some
sort of primitive version control.)
--
s/:-[(/]/:-)/g
BrianGnuPG - KeyID: 0x04A4F0DC | Key Server: pgp.mit.edu
==
gpg --keyserver pgp.mit.edu --recv-keys 04A4F0DC
Key Info: http://gfx-design.com/keys
Linux Registered
How do I check for the presence of an optional $_GET param without
throwing a Notice: Undefined index when the param is not present?
Tried all three of these, they all produce the Notice when the param is
not passed:
if ($_GET['id'])
if ($_GET['id'] != )
if (isset $_GET['id'])
--
PHP General
The first line of my file is session_start(); but whenever I try to set
or reference $_SESSION['anything'] I get:
Undefined variable: _SESSION
What's up with that???
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Here is the top of my file:
?php
// Start the session
session_start();
Which looks OK to me, but it returns:
Parse error: parse error, unexpected T_STRING in
c:\inetpub\wwwroot\palms\htdocs\start-selling.php on line 3
What's going on here??
- Brian
--
PHP General Mailing List (http://www.php.net
On May 25, 2004, at 9:06 AM, Craig wrote:
It doesnt necessarily mean the error occured on that line, that may
have
been the last executed statement
post a few more lines or we cant help you.
?php
// Start the session
if (! session_id()) session_start();
if (not
This is 4.3.2 and sessions are enabled.
Session handling was added in PHP 4.0.
The first line of my file is session_start(); but whenever I try to
set
or reference $_SESSION['anything'] I get:
Undefined variable: _SESSION
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe
sessions and variables on it, so it's entirely
possible that there is a configuration problem. phpinfo() looks OK to
me but I admit that I don't really know what to look for. Sessions are
enabled, that's about all I can tell... :)
- Brian
--
PHP General Mailing List (http://www.php.net
to the list. They're certainly not sent by
anyone at PHP or who runs this list. :)
The same thing can happen with every mailing list in the world. This
excellent resource should not be blamed.
Brian Dunning
http://www.briandunning.com/
--
PHP General Mailing List (http://www.php.net
In case anyone cares, here is a site that gives away a free zip code
database that's complete and current, and includes latitude and
longitude so you can do distance calculations:
http://www.zipwise.com/free-zip-database.php
Hope it's useful to someone,
- Brian
--
PHP General Mailing List
I have a form and the people who submit are likely to include a bunch
of ¶ characters. (That's a paragraph symbol in case it doesn't come
through the list correctly.)
However when I read it out of MySQL it comes back as ¶. What can I
do about this? Thanks!
- Brian
--
PHP General Mailing List
I'm sure there's a really simple way to do this: how can I grab the
source code of a specified web page and store it in a variable? Is
there something like this:
$siteCode = functionI'mLookingFor('www.123.com/index.htm');
Thanks,
- Brian
--
PHP General Mailing List (http://www.php.net
On May 20, 2004, at 5:43 PM, raditha dissanayake wrote:
I'm sure there's a really simple way to do this: how can I grab the
source code of a specified web page and store it in a variable?
Never mind, I found it:
$string = get_file_contents('www.123.com');
- Brian
--
PHP General Mailing List (http
You probably mean...
$string = file_get_contents(http://www.123.com;);
Whoops
Well, it worked, so I must have typed it correctly in my code... :) :)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
(through PHP)? I will happily implement something else for
those who must run inferior OS's.
Thanks,
-brian muldown
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
a lot of fun
digging through Microsoft support docs but have had no luck. The IIS
setting seems to override whatever you tell PHP to do.
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
).
Are you certain you don't have an error above/below this code snip
(maybe missing a trailing curly bracket somewhere)?
-brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
. Depending on the size of your resultset and the srength of your
MySQL Server, this may or may not provide a mild performance boost.
-brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I STFW and RTFM and I still can't figure out why this returns a 1064
parse error:
SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR
'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND
'status' = 'active';
Anyone? TIA!
- B1ff Lamer
--
PHP General Mailing List
?
-Original Message-
From: Brian Dunning [mailto:[EMAIL PROTECTED]
Sent: Friday, April 23, 2004 11:19 AM
To: [EMAIL PROTECTED]
Subject: [PHP] OK SQL experts...
I STFW and RTFM and I still can't figure out why this returns a 1064
parse error:
SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword
It gives the same error when I run it in phpmyadmin.
On Apr 23, 2004, at 8:34 AM, Edward Peloke wrote:
does it just return the error when running in the php page? If you
pull it
out can you run it in mysql without errors?
-Original Message-
From: Brian Dunning [mailto:[EMAIL PROTECTED
Backticks, single quotes, or nothing at all makes no difference. I
believe the parsing error is due to my parentheses or AND/OR structure.
Any thoughts on that?
On Apr 23, 2004, at 8:32 AM, John W. Holmes wrote:
From: Brian Dunning [EMAIL PROTECTED]
I STFW and RTFM and I still can't figure
Message-
From: Brian Dunning [mailto:[EMAIL PROTECTED]
Sent: Friday, April 23, 2004 11:36 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] OK SQL experts...
Backticks, single quotes, or nothing at all makes no difference. I
believe the parsing error is due to my parentheses or AND/OR structure.
Any
phpmyadmin echoes it out exactly as I copied pasted into my first
post.
On Apr 23, 2004, at 8:56 AM, Edward Peloke wrote:
if you echo out the query..what is the output?
-Original Message-
From: Brian Dunning [mailto:[EMAIL PROTECTED]
Sent: Friday, April 23, 2004 11:36 AM
To: [EMAIL
I don't have access to the MySQL command line; it's hosted at my ISP.
:(
On Apr 23, 2004, at 8:54 AM, Mark wrote:
--- Brian Dunning [EMAIL PROTECTED] wrote:
Yes, I've checked and rechecked the spelling on everything. I've
been
testing with a word that I know appears in at least one
if that works move up into:
SELECT * FROM my_table WHERE (field_1 LIKE '%$keyword%') AND status =
'active';
Yes, I actually did exactly that. Everything works until I have more
than one statement inside the (x LIKE x OR x LIKE x) parens. That's why
I figured there has to be something wrong with
On Apr 23, 2004, at 10:13 AM, John Nichel wrote:
Brian Dunning wrote:
I STFW and RTFM and I still can't figure out why this returns a 1064
parse error:
SELECT * FROM 'my_table' WHERE ('field_1' LIKE '%$keyword%' OR
'field_2' LIKE '%$keyword%' OR 'field_3' LIKE '%$keyword%') AND
'status
On Apr 23, 2004, at 10:27 AM, Edward Peloke wrote:
doesn't look like your $keyword value contains anything.
My error. Here is the actual return:
You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near
''my_table'
You have an error in your SQL syntax. Check the manual that
corresponds
to your MySQL server version for the right syntax to use near
''my_table' WHERE ('field_1' LIKE '%%' OR 'field2'
Because you are using a single quotes around your table/field
names. Remove them or use ` (back tick). As
601 - 700 of 1716 matches
Mail list logo