[PHP-DB] Using the ALTER statement

2002-05-23 Thread Stephen Rhodes
When i use the alter statement in the PHP function mysql_db_query( ) I get a permission error. I can CREATE tables, DROP them etc so there are no permission problems as far as I know. Can anyone help ? Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: Working with dates

2002-05-23 Thread Stephen Rhodes
Use this: ($dateInYourForm gives the date in three months time in the form you gave below. $threeMonths = mktime(0,0,0,date(m)+3,date(d),date(Y)); $dateInYourForm = date(d/m/Y,$threeMonths); Cheers Steve Manuel [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...

[PHP-DB] Re: output problem

2002-05-23 Thread Stephen Rhodes
When you write the SQL statement write it as: select count(user) AS count from log_request where date='$date' and status = 'open' (note i have added 'AS count' in there so it stores the value in 'count') Now when you output the result write it as $line-count Cheers Steve Chris

[PHP-DB] Re: how can i get field-informationof a table?

2002-05-24 Thread Stephen Rhodes
use the function mysql_list_fields in url http://www.php.net/manual/en/function.mysql-list-fields.php Cheers Steve Hermann Otteneder [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... hi, i'm using a mssql-database. now i want update a record with the information

[PHP-DB] Re: intercative selection menu

2002-06-21 Thread Stephen Rhodes
You could have if statements for every option. May be better if you have a for loop for some of the options -- SEE BELOW. e.g TRTDB?php echo(cell name)?:/B/TD TDselect name=cellname ?php //Do some database stuff (connect, query, get result etc etc) to get the value that is stored. Put

[PHP-DB] Passing multiple form variable in PHP

2002-11-12 Thread Stephen Rhodes
HELLO - this is probably a simple problem !! Wanting to use select multiple ... in a html form and pass multiple value into a php variable but does not work. I only get a single value. Can you tell me what I am doing wrong ? Does the multiple value get passed correctly in php if

[PHP-DB] Re: Passing multiple form variable in PHP

2002-11-12 Thread Stephen Rhodes
Cheers - query Answered Stephen Rhodes [EMAIL PROTECTED] wrote in message news:20021112162930.65021.qmail;pb1.pair.com... HELLO - this is probably a simple problem !! Wanting to use select multiple ... in a html form and pass multiple value into a php variable but does not work. I only