Re: [PHP-DB] date format to dateformat

2002-09-22 Thread CrossWalkCentral

What if
$date=10-02-2002;

I tried it this way and the explode causes problems with the - in it
What would be the best way to deal with this should i just parse out the -?


Andrey Sosnitsky [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Hello CrossWalkCentral,

 Sunday, September 22, 2002, 7:06:18 AM, you wrote:

 Try this

 $date= 10 01 2002;
 list ($day, $month, $year) = explode( , $date);
 echo $year-$month-$day;

 C I am having problems coverting the followign date format. Does any one
have
 C any insight on this.
 C $date= 10 01 2002
 C I need to conver this to Y-m-d
 C any help would be great

 www.pskov.ru
 www.invest.pskov.ru
 --
 Best regards,
 Andreymailto:[EMAIL PROTECTED]




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Date Select help

2002-09-22 Thread CrossWalkCentral

Any one have any information on selecting a rake of dates from a mysql
database?

my current query reads.
$result = mysql_query(SELECT * FROM CWC_Memory);



I neeed to select where date is between todays date and todays date +10.



Any help would be realy great thanks in advanced.




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: Re[2]: [PHP-DB] date format to dateformat

2002-09-22 Thread CrossWalkCentral

That did it thanks


Andrey Sosnitsky [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Hello, CrossWalkCentral.

 You wrote 23 ñåíòÿáðÿ 2002 ã., 2:05:38:

 So, explode() requires a seperator as a first argument.
 You code is

 $date= 10-01-2002;
 list ($day, $month, $year) = explode(-, $date);
 echo $year-$month-$day;

 See PHP manual at http://www.php.net/manual/en/function.explode.php

 C What if
 C $date=10-02-2002;

 C I tried it this way and the explode causes problems with the - in it
 C What would be the best way to deal with this should i just parse out
the -?


 www.pskov.ruwebmaster|programmer|DBA
 www.invest.pskov.ru
 www.education.pskov.ru
 --
 Best Regards,
 Andrey  mailto:[EMAIL PROTECTED]





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] date format to dateformat

2002-09-21 Thread CrossWalkCentral

I am having problems coverting the followign date format. Does any one have
any insight on this.

$date= 10 01 2002

I need to conver this to Y-m-d

any help would be great




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] getting table structure

2002-09-06 Thread CrossWalkCentral

I need help getting a specific table structer.

Does any one have any code snips that I can follow on this I want to get the
structer of a table and display it on the screen.





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] AVG fucntion help

2002-06-29 Thread CrossWalkCentral

Using PHP

I need some help running and AVG qery

the syntax is as follows

$results=sql_query(Select AVG(rate) from MYTABLENAME where id=$id,$dbi)

This works but I am not sure how to get is value into a variable.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] NEW help finding sum or average

2002-06-29 Thread CrossWalkCentral

I have a table called TEST , it cotains 3 fileds
A
B
C

I can have several rows where A is the same value.

I need help with PHP I need to obtain the AVERAGE of B where A=1

Can some one help me on this?





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] mail function

2002-06-29 Thread CrossWalkCentral

When using this fucntion listed bellow with the HTML headder

the email sent does not show the FROM in the FORM filed it just displays it
in the email message



Any one have any ideas.



$headers .= From: CrossWalkCentral [EMAIL PROTECTED] \n;




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] limiting the amount of data to be show on one page.

2002-05-25 Thread CrossWalkCentral

If I want to use the bellow liste senario.
How would i go about setting up the 1 2 3 4 5 6 7 8
page #'s how would I know when to stop counting?





You should also add an ORDER BY clause in there, as the SQL standard doesn't
guarantee the order that rows are retrieved in. There's a chance that
you'll get, say, 20 rows on the first page, go to the second page and get
some of the rows you've already seen on the first page. If you use an ORDER
BY, you'll at least guarantee that you'll get them in the same order each
time.

J


Kevin Stone wrote:

 $query = SELECT * FROM mytable LIMIT $i, 20;

 Where 20 is the number of rows to retrieve and $i is the starting row.

 By incrementing $i + 20 you can do next, prev buttons, or parse the total
 number of rows into page links (prev - 1, 2, 3, 4, 5, 6.. 10.. 20 - next).

 Search www.mysql.com for more information about using LIMIT in your
 queries.

 -Kevin



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] SORT resutls

2002-05-21 Thread CrossWalkCentral

I am using the code bellow however this is not a proper way to sort my data
it groups my data. Is their a similar command that i can replace the group
with like sort?

SELECT * FROM supportsys WHERE status=1 and know=0 GROUP BY $G);



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] SORT resutls

2002-05-21 Thread CrossWalkCentral

thanks that did it.

Beau Lebens [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 ORDER BY foo [ ASC | DESC ]

 // -Original Message-
 // From: CrossWalkCentral [mailto:[EMAIL PROTECTED]]
 // Sent: Wednesday, 22 May 2002 10:42 AM
 // To: [EMAIL PROTECTED]
 // Subject: [PHP-DB] SORT resutls
 //
 //
 // I am using the code bellow however this is not a proper way
 // to sort my data
 // it groups my data. Is their a similar command that i can
 // replace the group
 // with like sort?
 //
 // SELECT * FROM supportsys WHERE status=1 and know=0 GROUP BY $G);
 //
 //
 //
 // --
 // 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] counting records

2002-05-21 Thread CrossWalkCentral

OK when i pull data oout of the database i want to count the number of
records where 3 field are the same.

I have 6 fileds
field1=my first name
filed2=my last name
filed3=my email
filed4=other
field5=other
field5=other

I want to count the records that have the same field1,field2, and field3.

so i know how many submissions a person has made,



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] mail function help

2002-04-04 Thread CrossWalkCentral

For some reason the mail command will not work on all systems mybe I am
using it wrong can some one provide some feedback on this.

here is a code snip.

$msg = \tFirst Name: $custfname\n

\tLast Name: $custlname\n

\tEmail Address: $custemail\n

\tCategory: $dservice\n

\tDescription: $custpdes\n;

$recipient = $custcatergory;

$subject = $adminsubsupport;

$mailheaders = From: $adminfrmsupport  \n;

$mailheaders .= Reply-To: $email\n\n;

mail($recipient, $subject, $msg, $mailheaders);




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Email Validation

2002-03-07 Thread CrossWalkCentral

How would I go about doing the DNS look up part?


Markus Lervik [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 On Tuesday 12 February 2002 06:19, CrossWalkCentral wrote:

  I am working on a form that I have in php and am looking for some advise
  on form validation or specifically email address validation so i can
  insure that some one has put in a properly formatted email address

 Well. something like

 if (!eregi(^[A-Za-z0-9\_-]+@[A-Za-z0-9\_-]+.[A-Za-z0-9\_-]+.*, $email))
{
 echo $email doesn't seem to be a valid e-mail address!;
 }

 would do the job. Of course, that doesn't stop people from entering a
false
 email address. You could do a DNS-lookup to see if the domain-part of
 the address really exists, too.


 Cheers,
 Markus

 --
 Markus Lervik
 Linux-administrator with a kungfoo grip
 Vaasa City Library - Regional Library
 [EMAIL PROTECTED]
 +358-6-325 3589 / +358-40-832 6709



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] using sendmail w/ windows

2002-02-25 Thread CrossWalkCentral

any one know how to use send mail with windows instead of linux. Will 
this work are their other options?


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Need smoe code examples on creating tables for mysql in php

2002-02-19 Thread CrossWalkCentral

Need some code examples on creating tables for mysql in php

can any one help me on this . I searched the php.net site and only found info on 
creating a database I just want to create a php script that will make 2 tables with 
lets say 5 fields each in them.




[PHP-DB] sql query

2002-02-18 Thread CrossWalkCentral

I am having a minor problem doing a simple sql query. 

Error performing service query : You have an error in your SQL syntax near '' at line 1

Here is a snip of the code: Please let me know what you think.

if ($submit):

$status=0;

// REQUEST INFO FOR SERVICES
$results = mysql_query(
SELECT * FROM supportsyscat WHERE display=$custcatergory);
if (!$results) {   
echo(PError performing service query :  .
mysql_error() . /P);
exit();
}

// Display the text
while ( $rows = mysql_fetch_array($results) ) {
$dservice=$rows[display];
$eservice=$rows[address];
}


$sql = UPDATE supportsys SET  .
   pdes='$custpdes',  .
   sdes='$adminsdes',  .
   status='$status'  .
   WHERE ticket=$ticketnum;

if (mysql_query($sql)) {
Echo(centerPh4Ticket #$ticketnum has been updated./h4/P/center);
Echo(Thank you $custfname $custlname);
Echo(pProblem: $custpdes/P);


if ($statusclose ==true) {
$status=Closed;
} else {
$status =Open;
}




Re: [PHP-DB] sql query

2002-02-18 Thread CrossWalkCentral

Thanks I will try that.

Beau Lebens [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 try replacing

 WHERE display=$custcatergory);

 with

 WHERE display='$custcatergory');

 and also tru echoing the value of that SQL statement (assign it to a var
 first) to make sure you are getting the right thing.

 HTH

 /b

 // -Original Message-
 // From: CrossWalkCentral [mailto:[EMAIL PROTECTED]]
 // Sent: Tuesday, 19 February 2002 9:31 AM
 // To: [EMAIL PROTECTED]
 // Subject: [PHP-DB] sql query
 //
 //
 // I am having a minor problem doing a simple sql query.
 //
 // Error performing service query : You have an error in your
 // SQL syntax near '' at line 1
 //
 // Here is a snip of the code: Please let me know what you think.
 //
 // if ($submit):
 //
 // $status=0;
 //
 // // REQUEST INFO FOR SERVICES
 // $results = mysql_query(
 // SELECT * FROM supportsyscat WHERE display=$custcatergory);
 // if (!$results) {
 // echo(PError performing service query :  .
 // mysql_error() . /P);
 // exit();
 // }
 //
 // // Display the text
 // while ( $rows = mysql_fetch_array($results) ) {
 // $dservice=$rows[display];
 // $eservice=$rows[address];
 // }
 //
 //
 // $sql = UPDATE supportsys SET  .
 //pdes='$custpdes',  .
 //sdes='$adminsdes',  .
 //status='$status'  .
 //WHERE ticket=$ticketnum;
 //
 // if (mysql_query($sql)) {
 // Echo(centerPh4Ticket #$ticketnum has been
 // updated./h4/P/center);
 // Echo(Thank you $custfname $custlname);
 // Echo(pProblem: $custpdes/P);
 //
 //
 // if ($statusclose ==true) {
 // $status=Closed;
 // } else {
 // $status =Open;
 // }
 //
 //



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Email Validation

2002-02-11 Thread CrossWalkCentral

I am working on a form that I have in php and am looking for some advise on form 
validation or specifically email address validation so i can insure that some one has 
put in a properly formatted email address



[PHP-DB] protecting

2002-02-11 Thread CrossWalkCentral

How can I help protect people form modifying a form that submits data to php file that 
stores the data in a database

for example I have a text box that ask for a first name and I am getting a lot of 
garbage back like if they modified my form and submitted a image instead.

I know that their is some sort of parse out their that I can put in the php file that 
will help validate this



[PHP-DB] mail options

2002-02-06 Thread CrossWalkCentral

Can any one tell me what the value of using this statement.

mail($email, $subject, $message, From: $from\nX-Mailer: PHP/ . phpversion());

vs this statement

mail($recipient, $subject, $msg, $mailheaders);

considering all variables are defind in the script



[PHP-DB] PHP safe mode

2002-01-27 Thread CrossWalkCentral

Question?
What is php safe mode.

I have heard that it will allow you to pass information to a mysql database w/o a user 
name and pass.

Has any one heard of this. I am just curious. I would not use it but if this is 
something that is true I would like that could be a security problem.

let me know

Cross Walk Central
www.crosswalkcentral.net
Your Web Hosting Community!



Re: [PHP-DB] currency formating

2001-12-31 Thread CrossWalkCentral

That did it thanks allot Bill.
if you need a support tickett system made in php let me know.

thanks again and happy new year to you all.

Billy Harvey [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 On Tue, 2002-01-01 at 00:08, Webmaster wrote:
  Yea i have read that but did not think it was what i needed considering
it
  is for an automated billing system and the customer may not like it if
they
  are charged and extra .50 cents or so every month. Their has got to me
  another alternative.

 Well, round wouldn't do that, but what you're looking for is
 number_format().

 Billy




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] MySql database data has html code in it

2001-09-01 Thread CrossWalkCentral

Hello
Another question for the pros.

I have a Mysql database which contains a table labled html
in this table I have some short html scripts
I have created a search for my scripts and when I Echo them (example code
below) It only shows me the text and not the html script itself

Echo ($code);

Is their another function that I can use to display to contents of this
variblae?
I assueme that PHP is trying to process it as part of the echo statement.

--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] MySql database data has html code in it

2001-09-01 Thread CrossWalkCentral

Yea I tried that before I posted I even tried editing the data in the table
to but the pre before  and /pre after and it still will not show it.

--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!

Ali Nayeri [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Hi,

 I'm just a newbie and don't know that much but would putting:

 Echo (pre$code/pre);

 solve the problem. That's what most people use to display HTML code on an
 HTML page.

 As I said I'm new and I never tried it. But you can try and see if it
works.

 Ali

 -Original Message-
 From: CrossWalkCentral [mailto:[EMAIL PROTECTED]]
 Sent: September 1, 2001 6:46 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] MySql database data has html code in it


 Hello
 Another question for the pros.

 I have a Mysql database which contains a table labled html
 in this table I have some short html scripts
 I have created a search for my scripts and when I Echo them (example code
 below) It only shows me the text and not the html script itself

 Echo ($code);

 Is their another function that I can use to display to contents of this
 variblae?
 I assueme that PHP is trying to process it as part of the echo statement.

 --
 Cross Walk Central
 www.crosswalkcentral.net
 Support Center
 Your Web Hosting Community!




 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]


 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] MySql database data has html code in it

2001-09-01 Thread CrossWalkCentral

That did it thanks for the help.


--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!

Paul Burney [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 on 9/1/01 7:12 PM, CrossWalkCentral at [EMAIL PROTECTED] wrote:

  Yea I tried that before I posted I even tried editing the data in the
table
  to but the pre before  and /pre after and it still will not show it.

 You need to encode the  and  characters.  You can do so via the
 htmlspecialchars() function.

 http://php.net/manual/en/function.htmlspecialchars.php

 Sincerely,

 Paul Burney

 ++
 Paul Burney
 Webmaster  Open Source Developer
 UCLA - GSEIS - ETU
 (310) 825-8365
 [EMAIL PROTECTED]
 http://www.gseis.ucla.edu/
 ++





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Include

2001-08-19 Thread CrossWalkCentral

Thank you I got it working good deal

--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!

Tom Carter [EMAIL PROTECTED] wrote in message
001201c12888$bb8a9790$0a00a8c0@bjorn">news:001201c12888$bb8a9790$0a00a8c0@bjorn...
Yes that is correct. On a security point of view therer is something
 extra you can do.. when using require you can require files that are
outside
 the web tree...by this I mean are not accessible thru the internet. So if
 you site was in /home/web then you could setup a directory, say
 /home/web_vars and in this put these kind of files.

 In the require statement you just then simple put in the full path, eg
 require(/home/web_vars/vars.php);

 The advantage of doing this is security When the file with such sensitive
 information is included in the web tree then there are (admittedly
limited)
 possible scenarios in which this could be compramised. It is generally
 accepted that it is sensible to avoid putting such information in the web
 tree.

 Hope I've been clear, let me know if you need any more advice.

  so in var.php i will put something like this
 
  $db=mydatabse;
  $username=myusername;
  $password=mypassword;
 
 
  and so on?
 
 
  --
  Cross Walk Central
  www.crosswalkcentral.net
  Support Center
  Your Web Hosting Community!
 
  Seb Frost [EMAIL PROTECTED] wrote in message
  [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
   chuck all the common variables in var.php
  
   then just put
  
   ?php
   require(var.php);
   ?
  
   - seb
  
   -Original Message-
   From: CrossWalkCentral [mailto:[EMAIL PROTECTED]]
   Sent: 19 August 2001 03:18
   To: [EMAIL PROTECTED]
   Subject: [PHP-DB] Include
  
  
   OK here is one for you folks that know what you are doing.
  
   I am making a script and I have about 5 php files in it. That have
alot
 of
   the same system variables can I create one file with these settings in
 it
   and if so any one want to give me some hints on this
  
   thanks again.
  
   --
   Cross Walk Central
   www.crosswalkcentral.net
   Support Center
   Your Web Hosting Community!
  
  
  
  
   --
   PHP Database Mailing List (http://www.php.net/)
   To unsubscribe, e-mail: [EMAIL PROTECTED]
   For additional commands, e-mail: [EMAIL PROTECTED]
   To contact the list administrators, e-mail:
[EMAIL PROTECTED]
  
 
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, e-mail: [EMAIL PROTECTED]
  For additional commands, e-mail: [EMAIL PROTECTED]
  To contact the list administrators, e-mail: [EMAIL PROTECTED]
 






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Inseting info into MySQL and retrieving all in one SQL command

2001-08-19 Thread CrossWalkCentral

Question how do you use this function?

mysql_insert_id();

I have tried it and it gives me and error every time any one have any sample
conde on this

--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!

Beau Lebens [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 not so much in one step, but once you have inserted it you can call the
 function

 mysql_insert_id();

 and it will return the auto_increment value of the last insert operation.

 see the manual for more.

 HTH
 Beau

 // -Original Message-
 // From: Scott Mebberson [mailto:[EMAIL PROTECTED]]
 // Sent: Thursday, 9 August 2001 8:49 AM
 // To: [EMAIL PROTECTED]
 // Subject: [PHP-DB] Inseting info into MySQL and retrieving
 // all in one SQL
 // command
 //
 //
 // Hi guys,
 //
 // I am adding some information to my MySQL database. It is
 // user's information.
 // So it has things like email address, password, username, all
 // that sort of
 // stuff.
 //
 // What I need to do is once I have added it found out the id -
 // a primary key
 // which auto increments itself. At the moment I am doing two
 // different MySQL
 // queries an INSERT and a SELECT to first of all add the
 // information and then
 // find out the primary key.
 //
 // Is there anyway I can do this in one step?
 //
 // Thanks in advance
 //
 // Scott Mebberson
 // [EMAIL PROTECTED]
 //
 //
 //
 // --
 // PHP Database Mailing List (http://www.php.net/)
 // To unsubscribe, e-mail: [EMAIL PROTECTED]
 // For additional commands, e-mail: [EMAIL PROTECTED]
 // To contact the list administrators, e-mail:
 // [EMAIL PROTECTED]
 //



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] saving to two tables at the same time

2001-08-18 Thread CrossWalkCentral

I got it it appears that i had forgotten my } at the end of my secound
insert

--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!

Jason Wong [EMAIL PROTECTED] wrote in message
004c01c127a1$7efe56a0$[EMAIL PROTECTED]">news:004c01c127a1$7efe56a0$[EMAIL PROTECTED]...
 Do you have any code snippets for us to peruse?

 --
 Jason Wong
 Gremlins Associates
 www.gremlins.com.hk


 - Original Message -
 From: CrossWalkCentral [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Saturday, August 18, 2001 10:58 AM
 Subject: Re: [PHP-DB] saving to two tables at the same time


  I have tried this but it has continued to fail the only way I have
gotten
 it
  to work is via 2 diffrent php scrips
 





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] Include

2001-08-18 Thread CrossWalkCentral

OK here is one for you folks that know what you are doing.

I am making a script and I have about 5 php files in it. That have alot of
the same system variables can I create one file with these settings in it
and if so any one want to give me some hints on this

thanks again.

--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Include

2001-08-18 Thread CrossWalkCentral

so in var.php i will put something like this

$db=mydatabse;
$username=myusername;
$password=mypassword;


and so on?


--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!

Seb Frost [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 chuck all the common variables in var.php

 then just put

 ?php
 require(var.php);
 ?

 - seb

 -Original Message-
 From: CrossWalkCentral [mailto:[EMAIL PROTECTED]]
 Sent: 19 August 2001 03:18
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] Include


 OK here is one for you folks that know what you are doing.

 I am making a script and I have about 5 php files in it. That have alot of
 the same system variables can I create one file with these settings in it
 and if so any one want to give me some hints on this

 thanks again.

 --
 Cross Walk Central
 www.crosswalkcentral.net
 Support Center
 Your Web Hosting Community!




 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] saving to two tables at the same time

2001-08-17 Thread CrossWalkCentral

Question:

I have a form of 1/2 customer data and the other 1/2 service info. that the
custoemr fills out and when they submit it my php scrips adds the customer
infor to the customer table but it will not add the service info to the
service table?

Any one have any ideas

--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] saving to two tables at the same time

2001-08-17 Thread CrossWalkCentral

I have tried this but it has continued to fail the only way I have gotten it
to work is via 2 diffrent php scrips

--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!

Leo G. Divinagracia III [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...


 CrossWalkCentral wrote:
 
  Question:
 
  I have a form of 1/2 customer data and the other 1/2 service info. that
the
  custoemr fills out and when they submit it my php scrips adds the
customer
  infor to the customer table but it will not add the service info to the
  service table?
 
  Any one have any ideas
 

 hmmm... lemme guess...  previous M$ ACCESS user?  where the forms did
 all the work for you?  ;-)))

 simple enough... just do two insert statements.  one for the cust table
 and one for the service table...

 ;-)

 i know, i know... access makes it easy... but trains the wrong
 stuff...   ;-)

 --
 Leo G. Divinagracia III
 [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]