[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

[PHP-DB] data from db

ption'], and I searched for "%bryan%", the word 'bryan' would be a different color within the field $row['description']? The closest thing I could come to would be strstr( ) function this is just for convenienc not neccessity. Thanks for your help bryan Bryan

[PHP-DB] data from db[2]

nevermind. i was having trouble with the str_replace (i saw where I said strstr, but I meant str_replace).. I thought it should do what it did, and I finally got it! $edited_user = str_replace ($seperated[0], "$seperated[0]", $row['topic']); thanks for your time

[PHP-DB] subtotal

uot;Total : ".round($hoursrow[0], 2).""; ******* thanks... Bryan Fitch Programmer Concept Factory [EMAIL PROTECTED] http://www.concept-factory.com

[PHP-DB] md5

7;$username' "; but if I make the code (as below) with the md5, it does not. I must be doing something wrong, or it does not like to md5 random things or something. Any Advice? for ( $a=0; $a<1; $a++) { $password = newpwd( 10 ); $verify = $password; $dbcnx =

Re: [PHP-DB] md5

andom 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]>

[PHP-DB] jacked up quotes

nd here is what I am trying to get.... Test 1 Test 2 Test 3 Thanks for the help bryan [ bryan fitch . programmer . [EMAIL PROTECTED] ]

[PHP-DB] class method

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

Re: [PHP-DB] class method

an use 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 Subje

[PHP-DB] images

typing 2001/apr/a1/image2.jpg or 2001/apr/a2/image1.jpg, and gaining access to all the files? If anyone has any guidance on this, I would appreciate it! Thanks bryan [ bryan fitch . programmer . [EMAIL PROTECTED] ]

Re: [PHP-DB] images

, and that is to password protect a directory. Maybe thats the only way to do this If I have 43 images in 1 directory, .htaccess wouldn't stop me from typing in the direct path, would it? Thanks for your help and any more help with this issue would be greatly appreciated. bryan - O

[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 tag works sorry for the stupid question [ bryan fitch . programmer . [EMAIL PROTECTED] ]

Re: [PHP-DB] forget it

lines of what you tried the > first time, is to render the line breaks as HTML. PHP has a function to do > that nicely... nl2br($str). > > -alex > > > > -Original Message- > > From: bryan [mailto:[EMAIL PROTECTED]] > > Sent: Friday, April 20, 2001 5:2

[PHP-DB] export

, fwrite, and just make a *.txt file but, is there a way to make it unique for the specified date? Thanks for your help b- [ bryan fitch . programmer . [EMAIL PROTECTED] ]

[PHP-DB] products

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

[PHP-DB] mysql_fetch_array

mysql_fetch_array places 2 records for each one returned (example) Array ( [0] => 56 [location_id] => 56 ) Is there any way to delimate that and have the key present only once? here is my code : /* * * * Start code * * */ while ($aRow = mysql_fetch_array($sResult) ) {

[PHP-DB] mssql connecting

I'm trying to connect to mssql 2000 on a windows server 2003 standard box using php v5.1.6/apache 2.2.2 fedora core 4 on a separate box, of course. Any ideas? It just gives me the wonderful error: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified,

[PHP-DB] Re: mssql connecting

do I 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.

[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 installin

[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 in

[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 and not

[PHP-DB] sql statement - complex order by

SELECT * FROM productgroup WHERE groupid = $productid AND label = 'Cats' ORDER BY title SELECT * FROM productgroup WHERE groupid = $productid AND label != 'Cats' ORDER BY label,title I'd like to find a way to combine these 2 statements. I want to list out all the products, ordered by title but

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 must

[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

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

uot;); echo "Connection established!"; --- 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

[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 Mai

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'

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 sure

[PHP-DB] database or array?

Question, Should I design the program so that it will take all the information out of the database and put it into arrays and then print it? or should it directly acess the database?

[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.

[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

Re: [PHP-DB] Re: mysql_connect

quot; has the user. Well thanks. 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 >

[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

to make id the primary key/index -Bryan

[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

Re: [PHP-DB] SQL file,

So I would send the file through with a sql query? -Bryan - Original Message - From: "Brad Bonkoski" <[EMAIL PROTECTED]> To: "Bryan McLemore" <[EMAIL PROTECTED]> Cc: "PHP DB LIST" <[EMAIL PROTECTED]> Sent: Saturday, September 21, 2002 8:18

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: &l

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