Re: [PHP-WIN] MySQL query error

2007-07-07 Thread Ben
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

Re: [PHP-WIN] MySQL query error

2007-06-30 Thread Stut
<[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"

Re: [PHP-WIN] MySQL query error

2007-06-30 Thread Stut
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

[PHP-WIN] MySQL query error

2007-06-30 Thread James Blandford
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 SQL syntax; check the ma

[PHP-WIN] MySQL query error

2007-06-30 Thread James Blandford
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 SQL syntax; check the ma

RE: [PHP-WIN] MySQL query to generate Array

2004-03-22 Thread trystano
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

RE: [PHP-WIN] MySQL query to generate Array

2004-03-22 Thread Tony Devlin
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

Re: [PHP-WIN] MySQL query to generate Array

2004-03-22 Thread trystano
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

Re: [PHP-WIN] MySQL query to generate Array

2004-03-22 Thread Luis Moreira
ot;] = $row[1]; array_push ($array2,$array1[1]); } // end foreach // Example // $array2[10]["URL"] now contains the 10th URL value // $array2[10]["URLN"] now contains the 10th URLN value - Original Message - From: "Tony Devlin" <[EMAIL PROTECTED]> To:

[PHP-WIN] MySQL query to generate Array

2004-03-22 Thread Tony Devlin
How do you setup a mysql query to generate an array? I want to take URL and URLName from a database and use it to create an array called links. I know how to do the array and the mysql seperately, I don't know how to make the results of the mysql become the key=>value pairs in the array. Any

Re: [PHP-WIN] MySQL Query

2002-10-25 Thread Ignatius Reilly
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

RE: [PHP-WIN] MySQL Query

2002-10-25 Thread James Meers
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.

Re: [PHP-WIN] MySQL Query

2002-10-25 Thread Ignatius Reilly
s in '({$to_feed})' where userid='1' " ; HTH Ignatius - Original Message - From: "James Meers" <[EMAIL PROTECTED]> To: "PHP Helplist Windows" <[EMAIL PROTECTED]> Sent: Friday, October 25, 2

[PHP-WIN] MySQL Query

2002-10-25 Thread James Meers
i want to update a field and add an array, this is what i have so far, however it doesnt work, can anyone help? update user_table set categories in ('5','6') where userid='1' James

RE: [PHP-WIN] MySQL Query from PHP - CPU Cost?

2002-05-07 Thread Robin Bolton
from: http://www.phpclasses.org/browse.html/package/431.html -Original Message- From: Matt Babineau [mailto:[EMAIL PROTECTED]] Sent: May 7, 2002 07:53 To: 'Php-Win (E-mail)' Subject: [PHP-WIN] MySQL Query from PHP - CPU Cost? Is there a way to get the cost in cpu cycles or the milliseconds i

RE: [PHP-WIN] MySQL Query from PHP - CPU Cost?

2002-05-07 Thread Svensson, B.A.T. (HKG)
> 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

[PHP-WIN] MySQL Query from PHP - CPU Cost?

2002-05-07 Thread Matt Babineau
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? Matt Babineau Freelance Internet Developer - e: [EMAI