[PHP-DB] Web image database questions
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 list archives for help but have still come up with two questions; For the type and quantity of content, would blob storage of the images be best or should he use OS/directory storage and display them by calling the file path? Is there an easy way to upload an entire folder of images into a MySQL db? (I've checked hotscripts.com etc but most of the image stuff only handled single image uploads) Cheers and thanks Kim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] sql syntax error
- 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=, HTTP_POST_VARS=Array, key=, value=, category=, subcategory=, [EMAIL PROTECTED] Error in query: insert into ads values (year,make,model,color,mileage,condition,price,other,contact,next_,,created) values ('',,NOW()),Error:You have an error in your SQL syntax near 'created) values ('',,NOW())' at line 1 Code: else { foreach($HTTP_POST_VARS as $column_name = $column_value) $column_names .= $column_name . ','; $column_values .= '$column_values',; $query = insert into ads values ($column_names,created) values ($column_values,NOW()); $result = mysql_query($query) or die (Error in query: $query,Error: .mysql_error()); } Try this: foreach($HTTP_POST_VARS as $column_name = $column_value) { $column_names .= $column_name . ','; $column_values .= '$column_value',; } $query = insert into ads values ($column_names created) values ($column_values NOW()); $result = mysql_query($query) or die (Error in query: $query,Error: .mysql_error()); I still don't think it's going to work for you. do you really have a column called 'next_' in your table? It's probably the button you pressed to submit the form, which is in HTTP_POST_VARS, but I don't see a reason it would be in your table... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_insert_id() vs. last_insert_id()
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 both on a per-connection basis. They'd be useless otherwise. I agree. Although, the MySQL docs are confusing on the distinction between these two functions in my opinion. 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? I guess the question is: Why is it useful to only store the first id? When would you want that? -- Randy Phillips www.phillips-it.com phillipsIT, L.L.C. voice: 636.390.9468 Senior Web DevelopereFax: 501.423.3817 -- Get SideKick - for MySQL - http://www.phillips-it.com/sidekick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL
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 remote MySQL Here is my problem. I have PHP running on one machine, mysql on another one. Everything works fine till I put a firewall on the PHP machine, which blocks pretty much every port there is except port 80. Now, PHP can't connect to the mysql database anymore. If I disable the firewall on the PHP machine it works again. So I eliminate the reasons down to that PHP must uses some port for mysql return the query. The question is which port does PHP use for the connection? I'm NOT talking about 3306 which is used by Mysql. Anyone could help? Thanks in advance. Louis -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] mysql_insert_id() vs. last_insert_id()
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 interpreted it and I had the same question as you. Why would you want to do that? The only think I could think of is if your first INSERT statement inserted a parent with an ID and the next, say, 5 inserts inserted children, if you used LAST_INSERT_ID() you could get the ID of the parent. I might be thinking this through the wrong way, but it IS on a per-connection basis and if the first query ON THAT CONNECTION was a parent and the rest were children I guess that scenario would hold true. I'm sure there are many other examples of how this might be beneficial. Any further thoughts? Rich -Original Message- From: Randy Phillips [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 9:30 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] mysql_insert_id() vs. last_insert_id() 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 both on a per-connection basis. They'd be useless otherwise. I agree. Although, the MySQL docs are confusing on the distinction between these two functions in my opinion. 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? I guess the question is: Why is it useful to only store the first id? When would you want that? -- Randy Phillips www.phillips-it.com phillipsIT, L.L.C. voice: 636.390.9468 Senior Web DevelopereFax: 501.423.3817 -- Get SideKick - for MySQL - http://www.phillips-it.com/sidekick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL
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. Matt Vos vos@techcomne To: Louis Feng [EMAIL PROTECTED], [EMAIL PROTECTED] t.com cc: Subject: Re: [PHP-DB] Question on the port PHP uses to connect to 01/29/2003remote MySQL 09:29 AM 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 remote MySQL Here is my problem. I have PHP running on one machine, mysql on another one. Everything works fine till I put a firewall on the PHP machine, which blocks pretty much every port there is except port 80. Now, PHP can't connect to the mysql database anymore. If I disable the firewall on the PHP machine it works again. So I eliminate the reasons down to that PHP must uses some port for mysql return the query. The question is which port does PHP use for the connection? I'm NOT talking about 3306 which is used by Mysql. Anyone could help? Thanks in advance. Louis -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP and VPOS
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
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
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: http://www.php.net/unsub.php
[PHP-DB] Thank you for your help!!!!
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 PROTECTED] _ Tutopia - Acceso a Internet rápido, fácil y a los mejores precios. http://www.tutopia.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] upload time out
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. Thanks Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] upload time out
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 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 1:58 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] upload time out 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. Thanks Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] upload time out
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 messaging for now so that I can see things like the above error. I believe that this is the area that I am to make the change, but when I increase the memory limit I still get the same error ;;; ; Resource Limits ; ;;; max_execution_time = 320 ; Maximum execution time of each script, in seconds (default 30) memory_limit = 8M ; Maximum amount of memory a script may consume (8MB) I think PHP keeps the uploaded file(s) in memory until they have completely finished uploading and are ready to be written to disk. Thus if you're trying to upload a 10MB file you would probably have to increase the memory_limit to 18MB to be on the safe side. as to the question if I should use FTP, yes I can and do for most, but I am trying to get this working for most as this is a lot easier for people to send files, so if I can get it working for larger files then things will fly Remember HTTP uploads doesn't allow you to resume transfer. Thus if a file was 99% uploaded and an error occurs you have a very unhappy user ;-) -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* And miles to go before I sleep. -- Robert Frost */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Odd browser problem with sessions
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 least one phone call a day from people asking why they can't log in, the screen just reloads. I suggest to them to upgrade to Mozilla, Netscape or Opera. -- Chip Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 2:02 PM To: PHP-DB List Subject: [PHP-DB] Odd browser problem with sessions I have a web site that is protected using sessions, and it works fine. Only occasionally when a end-user tries to log in using IE the login screen will just reload, every time they try to log in. I found that by closing IE (all windows) then trying again, it will go on to the proper page. This behavior appears to only effect IE, I saw it once on either Netscape or Mozilla (I don't recall which), and no one I've talked to on the phone has had this problem in any browser other than IE, and there have been many calls about this. Any idea what this might be caused by? Thanks, -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com [EMAIL PROTECTED] There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corporation, 1977 (Then why do I have 8? Somebody help me!) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL
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 could PHP use a port number that is also used by MySQL? Louis [EMAIL PROTECTED] wrote: 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. Matt Vos vos@techcomne To: Louis Feng [EMAIL PROTECTED], [EMAIL PROTECTED] t.com cc: Subject: Re: [PHP-DB] Question on the port PHP uses to connect to 01/29/2003remote MySQL 09:29 AM 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 remote MySQL Here is my problem. I have PHP running on one machine, mysql on another one. Everything works fine till I put a firewall on the PHP machine, which blocks pretty much every port there is except port 80. Now, PHP can't connect to the mysql database anymore. If I disable the firewall on the PHP machine it works again. So I eliminate the reasons down to that PHP must uses some port for mysql return the query. The question is which port does PHP use for the connection? I'm NOT talking about 3306 which is used by Mysql. Anyone could help? Thanks in advance. Louis -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL
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] where PHP resides, then the problem occurs (from other machines without firewall to do the query on [A] work fine). Basically PHP can send out query to [A] (since [A] is open), but when [A] returns the result to PHP, it's blocked by the firewall on [B], because I believe PHP uses certain port for MySQL return the result. Is it clear? I attached a picture and hopefully helps. Thanks! Louis [EMAIL PROTECTED] wrote: loius. how do you know it's the mysql host that can not get to the php host? i may have misunderstood. port 3306 needs to be enabled to allow traffic though the firewall and into the mysql host, since that connection has been established the data is returned back to the php host. the mysql host shouldn't be able to connect to the php host in the same way, only through a connection originating through port 3306. then you can also limit to domain names that are allowed to enter the mysql host on 3306. don't know if this helps, but i think this is your scenario. let me know. i'm definitely interested. Hopefully i explained it correctly, i'm definitely not a firewall guy...but i try to pay attention. Jeff *Louis Feng [EMAIL PROTECTED]* 01/29/2003 07:11 PM To: [EMAIL PROTECTED] cc: Matt Vos [EMAIL PROTECTED], Louis Feng [EMAIL PROTECTED], [EMAIL PROTECTED] bcc: Subject: Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL 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 could PHP use a port number that is also used by MySQL? Louis [EMAIL PROTECTED] wrote: 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. Matt Vos vos@techcomne To: Louis Feng [EMAIL PROTECTED], [EMAIL PROTECTED] t.com cc: Subject: Re: [PHP-DB] Question on the port PHP uses to connect to 01/29/2003remote MySQL 09:29 AM 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 remote MySQL Here is my problem. I have PHP running on one machine, mysql on another one. Everything works fine till I put a firewall on the PHP machine, which blocks pretty much every port there is except port 80. Now, PHP can't connect to the mysql database anymore. If I disable the firewall on the PHP machine it works again. So I eliminate the reasons down to that PHP must uses some port for mysql return the query. The question is which port does PHP use for the connection? I'm NOT talking about 3306 which is used by Mysql. Anyone could help? Thanks in advance. Louis -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Array Trouble
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 platform. I loaded the results from the apple.php form into an array ($item). I need to make a row ($makerow) then, assuming all of the proper columns are there, load each value in the array into its corresponding column in the database. For some reason, PHP is not returning the current value of the array, it is handing MySQL the whole array. Any help would be appreciated. -Tyler Web and Database Administrator East Valley School District ? include './include/dbconnect.php'; include 'accessConnect.php'; include './include/vars.php'; $sql = select * from inventory where ID like $id and notNetworked IS NULL;; $row = odbc_exec($db, $sql) or die (Could not execute SQL query); ? html head title?= $title ?/title script language=javascript function checkAll() { ? $sql = SELECT * FROM FORMITEMS WHERE PLATFORM LIKE '%mac%' ORDER BY ID;; $result = mysql_query($sql); while($list = mysql_fetch_array($result)) { echo if(document.form.item$list[id].value == \1\)\n{\ndocument.$list[id].value = \2\;\n}\n; } ? } /script /head body bgcolor=#CBe5Db link=#405266 vlink=#3F593E alink=#3F593E div align=center center table border=0 cellspacing=0 cellpadding=0 width=780 tr td width=15 height=15img border=0 src=images/corner_tl.gif width=15 height=15/td td bgcolor=#FF height=15img border=0 src=images/clear.gif width=1 height=1/td td width=15 height=15img border=0 src=images/corner_tr.gif width=15 height=15/td /tr tr td bgcolor=#FF width=15img border=0 src=images/clear.gif width=1 height=1/td td bgcolor=#FF table border=0 width=100% cellpadding=0 cellspacing=0 /tr tr td valign=top rowspan=3 bgcolor=#C0C0C0 background=images/main_bg.gifimg border=0 src=images/clear.gif width=18 height=1 /td td valign=topimg border=0 src=./images/logo.png hspace=2 alt=Computer Maintenance align=top /td !--WebAdmin Info--- td valign=top align=rightimg src=./images/macos.gif align=lefttable cellpadding=0 cellspacing=0 border=0trtdApple - ? echo ID b/tdtdb; echo $id; echo /b/td/trtrtdLocation: /tdtdb; echo odbc_result($row, location); echo - ; echo odbc_result($row, roomNo); echo /b/td/trtrtdTeacher: /tdtdb; echo odbc_result($row, teacher); echo /b/td/trtrtdModel: /tdtdb; echo odbc_result($row, modelNo); echo /b/td/trtrtdSerial: /tdtdb; echo odbc_result($row, serialNo); echo /b/td/trtrtdMac Address: nbsp;/tdtdb; echo odbc_result($row, macAddress); echo /b/td/trtrtdDrop: /tdtdb; echo odbc_result($row, dropID); echo /b/td/trtrtdOS: /tdtdb; echo odbc_result($row, OS); echo /b/td/trtrtdProcessor: /tdtdb; echo odbc_result($row, processor); echo /b/td/tr; echo trtda href='http://support.evsd.org/webadmin/edit_entry.asp?database=newDBfound=singledeviceNum=1autoNo=; . odbc_result($row, autoNo) . 'Edit This Info/a/td/tr; ? /table !--End WebAdmin Info--- /td /tr tr td valign=bottom colspan=2 img border=0 src=images/clear.gif width=5 height=5 /td /tr tr td valign=top colspan=2 !-Empty Cell--- table border=0 cellpadding=5 cellspacing=7 tr td valign=top !-Maintenance Form--- form method=post action=data.php name=form table trtd align=bottomNotbrDone nbsp;nbsp;/tdtdN/A nbsp;nbsp;/tdtdDone/tr/tr ? $sql = SELECT * FROM FORMITEMS WHERE PLATFORM LIKE '%mac%' ORDER BY ID;; $result = mysql_query($sql); while($list = mysql_fetch_array($result)) { echo trtdinput type=radio name=item$list[id] value=\1\ checked/tdtdinput type=radio name=item$list[id] value=\2\/tdtdinput type=radio name=item$list[id] value=\3\/tdtd$list[item]/td/tr\n; } ?
[PHP-DB] php includes for templates
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: http://www.php.net/unsub.php
[PHP-DB] MySQL result resource
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 subcategory where id=$row-subcategory); $scrow = mysql_fetch_object($scobj); $cobj = mysql_db_query($dbname,select * from category where id=$scrow-category);//54 $crow = mysql_fetch_object($cobj); ? any ideas, of course, are most appreciated. thank you and best, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED]
RE: [PHP-DB] MySQL result resource
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... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -Original Message- From: Addison Ellis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 10:02 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL result resource 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 subcategory where id=$row-subcategory); $scrow = mysql_fetch_object($scobj); $cobj = mysql_db_query($dbname,select * from category where id=$scrow-category);//54 $crow = mysql_fetch_object($cobj); ? any ideas, of course, are most appreciated. thank you and best, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php