[PHP-DB] Web image database questions

2003-01-29 Thread Kim Kohen
Hi folks, A friend of mine would like to use PHP/MySQL to host a web based photo archive. I believe it will hold around 20,000 to 30,000 photos at a reasonable size for web display - perhaps 100 k or so each. I expect he'd have a small preview 'clickable' to a larger version. I searched the

Re: [PHP-DB] sql syntax error

2003-01-29 Thread 1LT John W. Holmes
- Original Message - From: Addison Ellis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 10:46 PM Subject: [PHP-DB] sql syntax error hello, i can not pinpoint this. your time and help is very much appreciated. best, addison Error: id=,

Re: [PHP-DB] mysql_insert_id() vs. last_insert_id()

2003-01-29 Thread Randy Phillips
on 1/28/03 11:42 AM, John W. Holmes at [EMAIL PROTECTED] wrote: The reason I ask is, if you use mysql_insert_id() on a busy server and it does not function on a per-connection basis, don't you run the risk of getting the last ID of somebody else's INSERT query on the server? Yes, they are

Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL

2003-01-29 Thread Matt Vos
In a default setup, I believe the port is 3306. Check your MySQL config files, as this can be changed. Matt - Original Message - From: Louis Feng [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 10:34 PM Subject: [PHP-DB] Question on the port PHP uses to connect to

RE: [PHP-DB] mysql_insert_id() vs. last_insert_id()

2003-01-29 Thread Hutchins, Richard
The one thing that jumps out at me is that if you insert multiple rows at the same time with an insert statement, LAST_INSERT_ID() returns the value for the first inserted row only, whereas MYSQL_INSERT_ID() returns the last id inserted. Am I reading that right? Yeah, that's the way I

Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL

2003-01-29 Thread Jeffrey_N_Dyke
it IS 3306(in a default setup) that you'll need to allow traffic through the firewall for this scenario. I have similar needs and that is the port we open.

[PHP-DB] PHP and VPOS

2003-01-29 Thread Altug AZCANLI
Hi, Is there anybody who knows the links/sites about PHP and VPOS? I still search about it, but i couldn't any useful information yet. Thanks.

[PHP-DB] Connecting to Mysql Server

2003-01-29 Thread web man
Hi, How can I change the default connecting port using php script. Thanks - Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now

RE: [PHP-DB] Connecting to Mysql Server

2003-01-29 Thread Neil Lathwood
web man wrote: How can I change the default connecting port using php script. That depends on hwo you connect currently, try this: http://www.php.net/manual/en/function.mysql-connect.php Neil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Thank you for your help!!!!

2003-01-29 Thread Sabina Alejandr Schneider
Hello to everybody!!! this time I'm writing to you to thank you all for the help you have iven to me this last days. I'm very satisffied with this language and with the group of persons that are working here. Thank you once more for your time and help! :-) Sabina Alejandra Schneider [EMAIL

[PHP-DB] upload time out

2003-01-29 Thread Ryan Holowaychuk
I have an upload page on my website, and when I do large files via this process, system times out. Are there some setting that I need to tweek to allow this process to finish, so if some one was to send a 10 meg file it will go through. Right now it will not even copy any part of the file.

RE: [PHP-DB] upload time out

2003-01-29 Thread Hutchins, Richard
Yeah, it's a configuration directive, check here: http://www.php.net/manual/en/configuration.directives.php#ini.upload-max-fil esize If you're moving 10MB, is it possible to use FTP instead? Don't know your situation. Just a suggestion. -Original Message- From: Ryan Holowaychuk

Re: [PHP-DB] upload time out

2003-01-29 Thread Jason Wong
On Thursday 30 January 2003 04:39, Ryan Holowaychuk wrote: Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 4000 bytes) in Unknown on line 0 I have gone in and made some changes to allow the file upload larger files. I have gone in as well and turned on the

Re: [PHP-DB] Odd browser problem with sessions

2003-01-29 Thread chip wiegand
On Wed, 29 Jan 2003 08:30:31 -0600 [EMAIL PROTECTED] wrote: IE 5.01 has an issue with its basic auth. There is no patch, only an upgrade path Gary Every I wish it were that simple, it happens in all versions of IE. I've tested it myself in the latest versions and it happens. I get at

Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL

2003-01-29 Thread Louis Feng
Thanks for reply, I'm going to try that, but how could this be? I just want to make sure I was clear that there is no problem to connect to the remote MySQL server and there is nothing blocking that machine. It's the PHP machine that's blocking any incoming traffic from the MySQL machine. How

Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL

2003-01-29 Thread Louis Feng
Hi Jeff, Thanks for your help. The machine [A] is running MySQL is Not behind a firewall, therefore all connection to [A] works fine (including 3306). The machine [B] running PHP/apache is behind a firewall, and only port 80 is open on [B]. If I want to do some query on MySQL of [A] from [B]

[PHP-DB] Array Trouble

2003-01-29 Thread Tyler Whitesides
Hi, I e-mailed this before, but the attachments didnt go through. I am designing something that my tech team can use to track the maintenancing of our school district computers. I have a table of data (formitems) that contains tasks that must be completed for that computer depending on the

[PHP-DB] php includes for templates

2003-01-29 Thread Russell Griechen
Daniel Cardenas graciously offered the script but I can not develop the right syntax. see code at: http://sportsmenafield.com/index.txt Russell Griechen...trying to escape frames to a php include template. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] MySQL result resource

2003-01-29 Thread Addison Ellis
hello, i have a new issue... :-) i am getting: Warning: Supplied argument is not a valid MySQL result resource in /users/infoserv/web/register/ca/admin/catads.php on line 54 from: ? while($row = mysql_fetch_object($obj)) { $scobj = mysql_db_query($dbname,select * from

RE: [PHP-DB] MySQL result resource

2003-01-29 Thread John W. Holmes
It means your query failed... it always means your query failed for some reason (unless you typo a variable name...). Learn to use mysql_error() in conjunction with mysql_query(). Also, like I said before, mysql_db_query() is depreciated, you should be using mysql_query(). ---John W. Holmes...