php-general Digest 2 Jul 2007 00:06:55 -0000 Issue 4879
Topics (messages 258021 through 258024):
Re: Flash / Ajax / PHP
258021 by: David Giragosian
Re: mail function problem
258022 by: Chris
Re: Selecting Rows Based on Row Values Being in Array
258023 by: kvigor
Anybody had luck compiling memcache with php6 ?
258024 by: Cathy Murphy
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
On 7/1/07, Ryan A <[EMAIL PROTECTED]> wrote:
> but the image, when updated, is still unstable on IE while still
> _perfectly_ stable on FireFox.
This might be due to cacheing on IE.... which anyone who has messed with
php online for a little time will be familier with. IE is a bitch at
times... just likes the company that makes the software ;)
Sometimes this gets solved with spitting out some headers telling IE not
to cache while others have (dirty) solved it by adding a hash or something
else unique to the page or the image...
for example:
php_script.php?get_img=img_name&random=something_random_here
HTH.
Cheers!
R
------
- The faulty interface lies between the chair and the keyboard.
- Creativity is great, but plagiarism is faster!
- Smile, everyone loves a moron. :-)
------------------------------
Get the Yahoo! toolbar and be alerted to new email
<http://us.rd.yahoo.com/evt=48225/*http://new.toolbar.yahoo.com/toolbar/features/mail/index.php>wherever
you're surfing.
Thanks, Ryan. That gives me something to explore when I get to work on
Monday.
David
--- End Message ---
--- Begin Message ---
[EMAIL PROTECTED] wrote:
Hi,
I'm running PHP 5.2.3 on Solaris 10 (AMD64).
My mail function doesn't send any mail, the return value of mail
function is false...
But sendmail_path value is OK in php.ini, and I've tried to send a mail
with sendmail on console with the same user (the apache user), and
everything's ok...
Does anyone have solution ?
Check your mail logs and your apache logs to see if any errors are
showing up.
--
Postgresql & php tutorials
http://www.designmagick.com/
--- End Message ---
--- Begin Message ---
Jim,
Please excuse the ignorance, I'm a newbie, but I'm only use to simple
SELECT, INSERT statements.
Your original code: $SQL = "SELECT * FROM my_Table WHERE CONCAT(value1,
value2, value3) IN ('".join("','", $list)."')
OK, I get everything up to the ('''.join(''','''$list).''')
I'm guessing that the .join( ). putting together some values, but I don't
know what
also the .join( ). is to be preceded by something... I don't know what.
//Forgive my ignorance, I'll can get it.
Also the .join( ). what is this doing I looked at the PHP and MySQL function
of each, and haven't seen comparable code.
I'm asking because I don't know where we're telling the code to compare the
values.
You stated...
>>> and create one string from them
Where do I give the name to the string?
So this is where I am so far:
$sql = "SELECT* FROM table WHERE CONCAT(size,color,weight) IN( )";
"Jim Lucas" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> K. Hayes wrote:
>> Will do. Thanks.
>>
>>
>> ----- Original Message ----- From: "Jim Lucas" <[EMAIL PROTECTED]>
>> To: "kvigor" <[EMAIL PROTECTED]>
>> Cc: <[EMAIL PROTECTED]>
>> Sent: Saturday, June 30, 2007 1:46 AM
>> Subject: Re: [PHP] Selecting Rows Based on Row Values Being in Array
>>
>>
>>> kvigor wrote:
>>>> Hello All,
>>>>
>>>> I'm attempting to return rows from a mysql DB based on this criteria:
>>>>
>>>> I have a list, in the form of an array that I need to compare against
>>>> each row
>>>> in the table. Where theres a match I need that entire row returned.
>>>>
>>>> e.g. $varListof 3outOf_10Fields = array(6blue40lbs, 7orange50lbs,
>>>> 8orange60lbs, 9purple70lbs);
>>>>
>>>> The array contains 3 of the db row fields in 1 value. However there are
>>>> 10 fields/columns in the table.
>>>>
>>>> ===============
>>>> what table looks like |
>>>> ===============
>>>> size color weight
>>>> ROW 1 | value1 | value1 | value1 | value1 | value1 | value1 |
>>>>
>>>> So how could I set up a query that would SELECT the entire row, if the
>>>> row contained $varListof 3outOf_10Fields[1].
>>>>
>>>> Open to any suggestions or work arounds. I'm playing with extract()
>>>> but code is too crude to even post.
>>>>
>>> I would suggest approaching the problem with a slightly different
>>> thought.
>>>
>>> just have the sql concat() the columns together and then compare.
>>>
>>> something like this should do the trick
>>>
>>> $list = array(
>>> '6blue40lbs',
>>> '7orange50lbs',
>>> '8orange60lbs',
>>> '9purple70lbs',
>>> );
>>>
>>> $SQL = "
>>> SELECT *
>>> FROM my_Table
>>> WHERE CONCAT(value1, value2, value3) IN ('".join("','", $list)."')
>>> ";
>>>
>>> mysql_query($SQL);
>>>
>>> this should take, for each row in the DB, value1 + value2 + value3 and
>>> create one string from them, then it will compare each string in the
>>> IN (...) portion to each entry in the $list array().
>>>
>>> Let me know if you need any further help
> one other thing, make sure that you run each of the values in the $list
> array() through mysql_real_escape_string(). That way it is all nicely
> encoded for the SQL statement.
--- End Message ---
--- Begin Message ---
I am trying to compile memcache 2.1.2 with php6 , but getting errors .
Anybody had luck with this?
Thanks,
Cathy
www.nachofoto.com
--- End Message ---