[PHP-DB] sortable list w/php ajax

Anyone modify the scripts at http://www.phpriot.com/d/articles/client-side/sortable-lists-with-php-and-ajax/index.html? I'm just looking to include more fields in the listing and possibly in tables. An option to move one at a time to the top of the list by clicking a button on each line would

Re: [PHP-DB] sql statement - complex order by

I think there's one small piece of data I left out. I'm working with php/mssql, no mysql. I'll move to mysql when I get everything else built. Mssql 2000 doesn't seem to like the = sign in the order by clause. It looks like both of you so far have come up with the same syntax though so it must

Re: [PHP-DB] sql statement - complex order by

I think there's one small piece of data I left out. I'm working with php/mssql, not mysql. I'll move to mysql when I get everything else built. Mssql 2000 doesn't seem to like the = sign in the order by clause. It looks like both of you so far have come up with the same syntax though so it

[PHP-DB] IN clause

If I have a SQL statement using the IN clause, how do I keep the order of the list? Example: SELECT * FROM table WHERE (number in (5, 9, 3, 4, 1, 7, 2, 8, 6)) How would I pull records in the order of the numbers to list out as: 5 - Record 5 9 - Record 9 3 - Record 3 4 - Record 4 1 - Record 1 7

[PHP-DB] Re: IN clause

By the way, I want the numbers to list out in the order I have them in the statement, not numerically and not randomly like it does now. Thanks... Bryan wrote: If I have a SQL statement using the IN clause, how do I keep the order of the list? Example: SELECT * FROM table WHERE (number

[PHP-DB] Re: IN clause

Thanks to Benno Rem for pointing out the ORDER BY FIELD(..) that one can use in MySQL. Now to find a way to use it in MSSQL 2000. Wrong group for that I guess. 8-O Bryan wrote: By the way, I want the numbers to list out in the order I have them in the statement, not numerically

[PHP-DB] Re: mssql connecting

need to do now? Any help would be extremely appreciated. ;-) Maybe if someone in the Austin, Texas area can help, I can give them a discount on a bass fishing guide trip. LOL Thanks... Bryan wrote: I'm trying to connect to mssql 2000 on a windows server 2003 standard box using php v5.1.6/apache

[PHP-DB] Re: mssql connecting

I'm trying to connect from a totally different server. I don't think SP4 has anything to do with it. Thanks though. ;-) Sady Marcos wrote: Install SP4 of the SQL Server Bryan [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] I've tried installing php-mssql-5.0.4-10.1.i386.rpm

[PHP-DB] mySQL - can connect with mysqlcc but not PHP code

!; --- And I have verified that the variables $myhost, $myuser, and $mypass contain the correct connection data. Thanks a million! Bryan Green -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] php variables to JS

Could always pass it through a hidden form. Bryan -Original Message- From: Bruce Levick [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 05, 2003 1:09 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] php variables to JS Bruce Levick - VivamotionI am opening a chromless window with some JS

Re: [PHP-DB] advise needed for 'authorized only' site

you could make them log in once per session and just have every page check and see if they already have logged in and if they have not then trigger the login mechanism. Not sure exactly how to implement but I've read on the practice before. -Bryan - Original Message - From: [EMAIL

[PHP-DB] SQL file,

in an example I saw in a book while I was leafing through it at barnes and nobles I saw a .sql file. It appeared to have the schema for a db in it. I was wondering what exactly what it is and how one could use it in a php application like he was doing. Thanks, Bryan

[PHP-DB] PHP Editor?

First off, What html/php editor do you guys think is better? Secondly, perhaps a little more relevant to the database part of this. I just want to clarify that with mysql_query() I can send any valid sql expression and it will do that? -Bryan

[PHP-DB] SQL Query

the primary key/index -Bryan

Re: [PHP-DB] Re: mysql_connect

. Bryan - Original Message - From: David Robley [EMAIL PROTECTED] To: Bryan McLemore [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 8:26 PM Subject: Re: [PHP-DB] Re: mysql_connect On 3 Sep 2002 at 23:00, Bryan McLemore wrote: - Original Message - From

[PHP-DB] mysql_connect

I'm trying to connect using the sample code in the php documentation. IT however dies every time. If someone could please help me? Thanks. Bryan

[PHP-DB] MySQL/PHP

Where can I find a good manual/tutorial on how to access mySQL w/PHP. Keep in mind that I am new to both PHP and mySQL, and my database theory is sketchy at best. Thanks.

Re: [PHP-DB] Re: Error Loading File -- Sort of Fixed

Ok, if anyone else is having the same trouble with PHP 4.2.1, David Robley's suggestion (Thank you David!) works. I am not to proud to have missed the obvious :) If you are having trouble loading files (LOAD INFILE...) with PHP into MySQL, just do a chmod($file, 0777), and it works. Not

Re: [PHP-DB] Re: Error Loading File

Whoops :), Yes, this is using phpMyAdmin, trying to use the Insert data from a textfile into table function, which uploads a file and the attempts to LOAD DATA INFILE. Like I said below, it worked on PHP 4.1.2, then when upgraded to PHP 4.2.1, it gave the error : The file '/tmp/phpr4WYQY'

[PHP-DB] Error Loading File

I am getting this error with a new install of PHP4.2.1 and Zend Optimizer 1.3.1: The file '/tmp/phpr4WYQY' must be in the database directory or be readable by all I just updated PHP and the Zend Optimizer, and it had worked previously with PHP4.1.2, Any ideas?? Thanks -- PHP Database

[PHP-DB] products

number of items in the cart). Could anyone show me another solution to this problem? thanks so much bryan

[PHP-DB] wrapped?

trying to be sneaky and just add breaks, but, that didn't seem to work too well. Any suggestions? thanks bryan [ bryan fitch . programmer . [EMAIL PROTECTED] ]

[PHP-DB] forget it

I found out that the PRE tag works sorry for the stupid question [ bryan fitch . programmer . [EMAIL PROTECTED] ]

[PHP-DB] class method

return; } } ** End thanks!!! [ bryan fitch . programmer . [EMAIL PROTECTED] ]

Re: [PHP-DB] class method

the loop for any query that needs it, and can show any row when I need it. I appreciate your help! Thanks a lot bryan - Original Message - From: "JJeffman" [EMAIL PROTECTED] To: "db" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 1:46 PM Subject: Re: [PHP-DB] class metho

Re: [PHP-DB] md5

string (with letters and numbers) and making it 10 characters long. I think md5 has a problem with this, for some reason Probably just me though. Thanks for the advice. bryan - Original Message - From: "Joe Brown" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, Februar

[PHP-DB] moving

... I have thought of other ways to do this, but I was hoping there would be an easier way, such as this, to do it. Thanks for the help! Bryan Fitch