ay, November 06, 2003 1:58 PM
Subject: Re: [PHP-DB] Select Value with 's
> why the backticks and not quotes ?
>
> pete
> Ma wrote:
>
> > hi!
> >
> > do not quite understand your problem.. pls post some code?
> > heres a small snippet that s
From: "pete M" <[EMAIL PROTECTED]>
> > do not quite understand your problem.. pls post some code?
> > heres a small snippet that should work well...
> >
> > $qry = 'SELECT `customer` FROM `customerList` ORDER BY `customer`';
> > $res = mysql_query($qry);
> > while($customer = mysql_fetch_object($re
why the backticks and not quotes ?
pete
Ma wrote:
hi!
do not quite understand your problem.. pls post some code?
heres a small snippet that should work well...
$qry = 'SELECT `customer` FROM `customerList` ORDER BY `customer`';
$res = mysql_query($qry);
while($customer = mysql_fetch_object($r
You are most welcome, Aleks. Glad it helped.
> -Original Message-
> From: Aleks @ USA.net [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 05, 2003 3:01 PM
> To: 'Hutchins, Richard'; 'PHP-DB'
> Subject: RE: [PHP-DB] Select Value with 's
riginal Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 2:52 PM
To: PHP-DB
Subject: RE: [PHP-DB] Select Value with 's
Using your variables and query, the following, based on one of my own
functional pages, the following should work:
$FF = a
; -Original Message-
> From: ma [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 05, 2003 2:29 PM
> To: PHP-DB
> Subject: Re: [PHP-DB] Select Value with 's
>
>
> hi
>
> hm - it would help if you'd send us the code where you
> generate the query
PROTECTED]>, "'PHP-DB'" <[EMAIL PROTECTED]>
> Betreff: RE: [PHP-DB] Select Value with 's
>
> Tried both... Still no joy...
>
> The statement becomes
> $info = mysql_query('Select * From customer Where customer.customer LIKE St
> Mary&#
27;] is confusing it
-Original Message-
From: ma [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 2:07 PM
To: PHP-DB
Subject: Re: [PHP-DB] Select Value with 's
hi
ok - than make it this way:
$info = mysql_query( Select * From customer Where customer.customer LIKE "
.customer LIKE
"'.$FF.'"');
_ma
# life would be easier if i knew the source code...
> Von: "Aleks @ USA.net" <[EMAIL PROTECTED]>
> Datum: Wed, 5 Nov 2003 14:01:37 -0500
> An: "'ma'" <[EMAIL PROTECTED]>, "'
Von: "Aleks @ USA.net" <[EMAIL PROTECTED]>
> Datum: Wed, 5 Nov 2003 13:52:51 -0500
> An: "'CPT John W. Holmes'" <[EMAIL PROTECTED]>, "'ma'"
> <[EMAIL PROTECTED]>, "'PHP-DB'" <[EMAIL PROTECTED]>
&g
et" <[EMAIL PROTECTED]>
> Datum: Wed, 5 Nov 2003 13:52:51 -0500
> An: "'CPT John W. Holmes'" <[EMAIL PROTECTED]>, "'ma'"
> <[EMAIL PROTECTED]>, "'PHP-DB'" <[EMAIL PROTECTED]>
> Betreff: RE: [PHP-DB
rning mysql_fetch_array(): supplied argument is not a valid MySQL result
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 1:45 PM
To: Aleks @ USA.net; 'ma'; 'PHP-DB'
Subject: Re: [PHP-DB] Select Value with &#
From: "Aleks @ USA.net" <[EMAIL PROTECTED]>
> First I build my select list:
>
>
> All Customers
>
> While ($Site = mysql_fetch_array($S))
> {
> $Sid = $Site["CID"];
> $SName = htmlspecialchars($Site["Customer"]);
> echo("$SName\n");
Easy fix: echo("$SName\n");
Long version:
htm
lue I get on the Result.php page is St Mary
-Original Message-
From: ma [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 1:18 PM
To: PHP-DB
Subject: Re: [PHP-DB] Select Value with 's
hi!
do not quite understand your problem.. pls post some code?
heres a small snippet that sho
hi!
do not quite understand your problem.. pls post some code?
heres a small snippet that should work well...
$qry = 'SELECT `customer` FROM `customerList` ORDER BY `customer`';
$res = mysql_query($qry);
while($customer = mysql_fetch_object($res)) {
echo stripslashes($res->customer).''."\n";
15 matches
Mail list logo
