[PHP-DB] Query executing

2007-10-05 Thread ron.php
How would I know if this mySQL query: DELETE FROM `table` WHERE `date_to_be_deleted` LIKE '$todays_date' actually deleted any rows from the table? Ron

[PHP-DB] Query syntax

2007-09-15 Thread ron.php
$query="SELECT * FROM table WHERE listing_type LIKE '%$listing_type%' AND listing_approved = '1' OR listing_approved = '2' ORDER BY name ASC"; My question is how can I search for records where listing_approved has a value of either 1 or 2 (while in the same search I am searching for listing_ty

[PHP-DB] Form processing

2007-09-11 Thread ron.php
I am trying to set up a form which will send e-mails for "late breaking news" and urgent e-mailings.   If I have "Today's news" in the subject line on the e-mail it comes out with "Today\'s news" --- how can I prevent this from happening?   Ron

RE: [PHP-DB] Processing web forms

2006-04-16 Thread ron.php
Thanks Bastien. It works now. Amazing. I am understanding the $_POST[] command. Thanks for your help. Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Processing web forms

2006-04-16 Thread ron.php
Good morning Bastien This doesn't help. I am having no problems creating the form of what the current permissions are based on the permission access table. I am not sure what to do with the form once it has been submitted. I am able to create the table which shows each permission function

[PHP-DB] Processing web forms

2006-04-16 Thread ron.php
I am not sure how to apply the array ('priv1', 'priv2', 'priv3' ...); to what I am programming because the number of web functions will be increasing --- it isn't a set number. I have never worked with arrays before. Is there another way to define the array? I am storing information about

Re: [PHP-DB] auto_increment

2004-12-28 Thread ron.php
Thanks Larry. It was mySQL ... Ron On Sun, 26 Dec 2004 20:47:37 -0500, Larry E. Ullman wrote > > I have the auto_increment on one of my variables. During the past few > > days > > I have been doing testing on a "live" database and created several test > > records which I now have deleted from