Re: [PHP-DB] date format to dateformat

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 CrossWal

[PHP-DB] Date Select help

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

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

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

[PHP-DB] date format to dateformat

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

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

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:

[PHP-DB] NEW help finding sum or average

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:

[PHP-DB] mail function

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

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

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

[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

Re: [PHP-DB] SORT resutls

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 P

[PHP-DB] counting records

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.

[PHP-DB] mail function help

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:

Re: [PHP-DB] Email Validation

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

[PHP-DB] using sendmail w/ windows

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

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

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 *

Re: [PHP-DB] sql query

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 si

[PHP-DB] Email Validation

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

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

[PHP-DB] mail options

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

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

Re: [PHP-DB] currency formating

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

[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);

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

s. 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 lab

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

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

Re: [PHP-DB] Include

t 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

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

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

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

0$[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 tw

[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

Re: [PHP-DB] Include

ROTECTED]... 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 t

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

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

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

s:[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 servi