Not to mention that read would most likely be a tinyint(1), and thus
shouldn't be fed a character.
Stut wrote:
Please include the list when replying.
James Blandford wrote:
It seems i have fixed it >_< thanks for your time thou. It turns out
that I couldn't have "read" as a field name due to
<[EMAIL PROTECTED]>
Cc:
Sent: Saturday, June 30, 2007 10:55 PM
Subject: Re: [PHP-WIN] MySQL query error
James Blandford wrote:
Hello,
I am making a private messaging system for my website, and if you
click on the pm, it --should-- set it as "read" rather than "unread"
James Blandford wrote:
Hello,
I am making a private messaging system for my website, and if you click
on the pm, it --should-- set it as "read" rather than "unread". I am
using the query:
UPDATE pms SET read=1 WHERE id='{$assoc['id']}'
but it is giving me this error:
You have an error in your
Check out my thread on a similar issue...
http://www.sitepoint.com/forums/showthread.php?t=158703
Tryst
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
rch 22, 2004 11:58 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] MySQL query to generate Array
Are you trying to create a breadcrumb trial?
Tryst
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing Lis
Are you trying to create a breadcrumb trial?
Tryst
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Try something like this (UNTESTED)
// array1 is temporary array
// array2 is the one to fill with query results
$array1= array("URL"=>"nul","URLN"=>"nul");
$array2= array(
1=>array("URL"=>"","URLN" => "")
);
// $n is counter of registers
// begin mysql query
// foreach element
// $row[0] i
s" <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>; "PHP Helplist Windows"
<[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 2:30 PM
Subject: RE: [PHP-WIN] MySQL Query
> Ok, solved that problem, can anyone help me on my last query, i need to
ssage-
From: Ignatius Reilly [mailto:ignatius.reilly@;free.fr]
Sent: Fri 25/10/2002 12:57
To: James Meers; PHP Helplist Windows
Cc:
Subject: Re: [PHP-WIN] MySQL Query
arrays are not a datatype for MySQL.
arrays are not a datatype for MySQL.
You have to serialize your array into a string. You must choose a suitable
delimitor that will not conflict with your data. Taking as an example ",":
$to_feed = implode( "," , my_array ) ;
$query = " update user_table set categories in '({$to_feed})' where
us
well I'm not sure how you would acomplish the first two tasks, but you can
at least get an accurate feel for how long a page (or section of code) takes
to execute.
There are several timer classes available, the one I use is called
Deathead's Timer, wich you can download from:
http://www.phpclasse
> Is there a way to get the cost in cpu cycles or the milliseconds it
> takes to process a query and output that statistic in PHP? Or maybe the
> processing time of the whole page?
The most naive approach is the brute force test: Run the query and
count the time it toke to execute it. However thi
12 matches
Mail list logo
