[PHP-DB] Re: Creating an autonumber setup

First of all let me tel you that in MySQL you don't have an option to define your autonumber value format. You can use this approach which is flexible: Make users to enter the autonumber format for each of these: Quote, Project,Customer,Supplier,Invoice Quote - user entere "Q+" as autonumber for

Re: [PHP-DB] Problem in executing linux command from PHP

- Original Message - From: Sean Burlington <[EMAIL PROTECTED]> Newsgroups: php.db To: <[EMAIL PROTECTED]> Sent: Sunday, September 07, 2003 3:26 PM Subject: Re: [PHP-DB] Problem in executing linux command from PHP > Gnanavel wrote: > >>>$output=exec("cp file1 file2"); > >>>echo "$output";

Re: [PHP-DB] RH 8.0 Mysql help

One comand and you are done: apt-get install mysql-server httpd php php-mysql Don't have apt for RedHat? Download this: http://ftp.freshrpms.net/pub/freshrpms/redhat/8.0/apt/apt-0.5.5cnc6-fr0.rh80.1.i386.rpm and run 'rpm -i' on it. There's no better way to install software than apt. Pre

[PHP-DB] RH 8.0 Mysql help

Would some kind soul who has installed MySql on a RH8.0 box please email me (off list) and help me get this running?? I have installed it a dozen times, followed the post-installation and testing from the Mysql manual and STILL can't make this run. I need this for a e-commerce site like yesterday!!

Re: [PHP-DB] foreach() & db brainiacs please help?

couldn't this be accomplished with a Left Join? Depending on how your tables are arranged you should be able to get all (sub)sub-names out and in the same result set using the top_name with a Left Join. any key that relates to the parent key would be returned. it looks like you have them all in

[PHP-DB] foreach() & db brainiacs please help?

I have a database full of names. each name could be linked to any number of sub-names, each sub-name could be linked to any number of sub-sub-names, to infinity (unlikely but possible). I need to iterate through this nest of names starting with a main name; lets call the main name Peter. Peter cou

Re: [PHP-DB] Creating an autonumber setup

--- Richi Watts <[EMAIL PROTECTED]> wrote: > Hi, > > Could someone explain to me how this could be done? I have seen > something similar using Access on a local machine and would like to > know if it is posible to do it in PHP and Mysql > In a project management web based applicaton using PHP and

[PHP-DB] Creating an autonumber setup

Hi, Could someone explain to me how this could be done? I have seen something similar using Access on a local machine and would like to know if it is posible to do it in PHP and Mysql In a project management web based applicaton using PHP and Mysql I would need to allow the user to create Quot

Re: [PHP-DB] Determining if checkbox is selected in PHP

> I'm storing the values from a groups of checkboxes > in an array "keyword[]", but $_POST['keyword'] is > undefined if none of the checkboxes is checked. The fact that it is undefined if none of the checkboxes are checked is expected behavior. Just do: if( isset( $_POST['keyword'] ) { } to det

Re: [PHP-DB] Determining if checkbox is selected in PHP

you could first check for isset($_POST['keyword']) and then if that passes check what keywords you have. or you could write an additional html tag to the page like. . This would force the $_POST['keyword'] array to exist and then you'd have to strip that from your array when processing it hth

[PHP-DB] Determining if checkbox is selected in PHP

I'm storing the values from a groups of checkboxes in an array "keyword[]", but $_POST['keyword'] is undefined if none of the checkboxes is checked. I tried using "in_array()" with $_POST to determine if any of the group of 'keyword' checkboxes is checked, but can't get it to work; does anyone hav