[PHP-DB] Email Article, Print Article
Hello, I am running an article-based site, where I would like to add two buttons: print this article and email this article. Does anyone know where I could look to find out how to program this code into my article.php page? Thanks in advance, Eddie Wonder
Re: [PHP-DB] Email Article, Print Article
Thank you Bastian and Micah. I had no idea the concept was so straightforward. I guess I was close to making a mountain out of a molehill. Thanks again, E. Wonder
Re: [PHP-DB] RE: HTML Tables in PHP...
Hello Jusa, I was wondering. Your server URL is: C:\FoxServ\www\Dad\proofing\index.php Have you ever been able to get a php script to work on this particular server? This looks like an NT server, and while your web host may state that PHP functions properly on this server, I would show them your error and see if they know what's going on here. I was with an NT server that also hosted PHP script, but it was not configured correctly. And while my code did have issues, the errors that were posted weren't because of coding errors, they were because the PHP plug-in files were not properly configured. Just a suggestion, though you probably already checked this. Eddie Wonder
[PHP-DB] select * from table where column 'CONTAINS' more than one value (how?)
Hello all, I have no problem creating a table, using a query from my dbase table news: SELECT * FROM table where column = VALUE. However, now that most of our articles have more than one column type (i.e. instead of just technology, the column can now contain technology, politics, local. My question is now that I have more than one value, what format can I use for a contain command. EXAMPLE: articles needed local political articles: SELECT * FROM table where column contains politics, local. Does anyone know how to format the above command into a proper SQL query language? Thank you in advance.
[PHP-DB] auto-generating next id (in order) for an add script
Hello, I have a site that allows reporters to enter their articles into a forum. I am then spilling their articles onto the main page from a MySQL dbase via a php script, read LATEST ARTICLES. I am now entering the data myself after they email it to me, however this is becoming more of a task I dont' have time for as the number of articles increase per day. Right now, I have an addarticle.php page where they can enter their information. I have ran a test of this script, and it works great. However, I have been entering the PHP IDs myself in ascending order (i.e. 0005, 0006, 0007) because I can see all of the articles. The reporters however are not able to see these articles, and instead of having them enter a random php ID, I'd like my add script to check for the last ID entered and then enter the number above (i.e add row to table, check PHP ID, if 0007 is last row entered, enter 0008 for php ID for new article). Does anyone know how to add this particular command to a page, and if so, where? Thank you in advance. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] auto-generating next id (in order) for an add script. .
Thanks Aman and guy from 'listmail.innovate.net'... I will change my primarykey ID colum to auto_increment. I am off to try your suggestions. Thanks again. -Original Message- From: Patel, Aman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Mon, 20 Jun 2005 12:27:01 -0500 Subject: Re: [PHP-DB] auto-generating next id (in order) for an add script. . I'd recommend you use what mysql provides for this. Auto_increment flag. Here's more information on how to make your id column be an auto_increment primary key. http://dev.mysql.com/doc/mysql/en/example-auto-increment.html - Aman Patel, Sys Admin / Database / Web Devloper, International Outreach x4076 [EMAIL PROTECTED] wrote: Hello, I have a site that allows reporters to enter their articles into a forum. I am then spilling their articles onto the main page from a MySQL dbase via a php script, read LATEST ARTICLES. I am now entering the data myself after they email it to me, however this is becoming more of a task I dont' have time for as the number of articles increase per day. Right now, I have an addarticle.php page where they can enter their information. I have ran a test of this script, and it works great. However, I have been entering the PHP IDs myself in ascending order (i.e. 0005, 0006, 0007) because I can see all of the articles. The reporters however are not able to see these articles, and instead of having them enter a random php ID, I'd like my add script to check for the last ID entered and then enter the number above (i.e add row to table, check PHP ID, if 0007 is last row entered, enter 0008 for php ID for new article). Does anyone know how to add this particular command to a page, and if so, where? Thank you in advance. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] auto-generating next id (in order) for an add script
Thanks Bastien, I am off to try the auto increment. I will post back if I cannot get it to work properly. Again, thanks everyone. -Original Message- From: Bastien Koert [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net Sent: Mon, 20 Jun 2005 13:30:13 -0400 Subject: RE: [PHP-DB] auto-generating next id (in order) for an add script post your code and db structure, it might be simpler to use an auto increment value and let the db do the work in assigning the next number... bastien From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] auto-generating next id (in order) for an add script Date: Mon, 20 Jun 2005 12:54:20 -0400 Hello, I have a site that allows reporters to enter their articles into a forum. I am then spilling their articles onto the main page from a MySQL dbase via a php script, read LATEST ARTICLES. I am now entering the data myself after they email it to me, however this is becoming more of a task I dont' have time for as the number of articles increase per day. Right now, I have an addarticle.php page where they can enter their information. I have ran a test of this script, and it works great. However, I have been entering the PHP IDs myself in ascending order (i.e. 0005, 0006, 0007) because I can see all of the articles. The reporters however are not able to see these articles, and instead of having them enter a random php ID, I'd like my add script to check for the last ID entered and then enter the number above (i.e add row to table, check PHP ID, if 0007 is last row entered, enter 0008 for php ID for new article). Does anyone know how to add this particular command to a page, and if so, where? Thank you in advance. -- 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
