Re: [PHP-DB] Using PHP to import a DB

d the password mysql -u user -pyourpassword -h somehost db < /tmp/mydb -- Met vriendelijke groeten, Tim Van Wassenhove <http://timvw.madoka.be> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: mysql_fetch_assoc to ADOdb??

eys are field names instead of > the key fields themselves? IE: What's wrong with: $db->setFetchMode(ADODB_FETCH_ASSOC); $rs = $db->Execute('...'); $rows = $rs->getRows(); -- Met vriendelijke groeten, Tim Van Wassenhove <http://timvw.madoka.be> -- PHP D

[PHP-DB] Re: &

age you should use http://www.php.net/htmlentities. -- Met vriendelijke groeten, Tim Van Wassenhove <http://timvw.madoka.be> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Newbie needs help with multiple MySQL databases

-- Met vriendelijke groeten, Tim Van Wassenhove <http://www.timvw.info> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Wait Statement... ?

aining (ip - timestamp) pairs, the other containing (username - timestamp) pairs. Every time someone tries to authenticate, you count the number of failures in both queues. The larger the number, the longer the sleep will take. (removing old entries once in a while might speed up things) -- Tim Va

[PHP-DB] Re: Temporary table name

567'; Probably you'll want to make the name the primary key or at least unique. This way you save yourself from adding duplicate entries with the same name. -- Tim Van Wassenhove <http://home.mysth.be/~timvw> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Easy reg expression problem

dvantage of using a regex is that you can perform some form of > validation on the address. And in the end compare your regular expression with the one at: http://www.ex-parrot.com/~pdw/Mail-RFC822-Address.html -- Tim Van Wassenhove <http://home.mysth.be/~timvw> -- PHP Dat

[PHP-DB] Re: LAST_INSERT_ID?????

all zeroes for this > output. > I can't even get this function to work in a SQL query window. > Please help!!! I would attach code to this, but I am not sure what to > attach. Try "SELECT LAST_INSERT_ID() AS id"; -- Tim Van Wassenhove <http://home.mysth.be/~timv

[PHP-DB] Re: Restrict account access to single user

ssion with the ones in the database. This way: Every user that tries to login with a valid uid/pwd gets access. Every session with the same uid but older timestamp expires. Don't applaud, just throw money :D -- Tim Van Wassenhove <http://home.mysth.be/~timvw> -- PHP Database Mailing List

Re: Re[2]: [PHP-DB] Table locking

and Peterson etc... Every website on computer algorithms will know how they work... -- Tim Van Wassenhove <http://home.mysth.be/~timvw> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Validate Value

> { > > Statements; > } > > But here still system not supporting for space. If you don't bother to read my advices, i don't bother to answer anymore. -- Tim Van Wassenhove <http://home.mysth.be/~timvw> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Validate Value

is already written (and cut the irrelevant things out) , things stay clear for everybody. As i mentionned before, use your regular expressions manual. There you will find what \s and \w mean. -- Tim Van Wassenhove <http://home.mysth.be/~timvw> -- PHP Database Mailing List (http://www.

[PHP-DB] Re: Validate Value

t mistaken (consult a regular expressions manual to be sure) -- Tim Van Wassenhove <http://home.mysth.be/~timvw> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Table locking

s you to have 1-n relationships between clients-sales and products-sales. Apart from the links to the client_id and the product_id, you also may want to have a sales_id, quantity, date of order, ... -- Tim Van Wassenhove <http://home.mysth.be/~timvw> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: table locking ... not required ?

start again. update 'rows you would update anyway' and 'oca=oca+1' where 'regular stuff' and 'oca=$ocaFromHiddenField' If you don't update the 'rows you would update anyway' and 'oca=oca+1' at the same time you run again into con

[PHP-DB] Re: Storing Date in mysql

ulatie differences between timestamps etc... -- Tim Van Wassenhove <http://home.mysth.be/~timvw> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php