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 argumen

[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: [PHP-DB] date format to dateformat

;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

[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] 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 Ma

[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: http://www.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: htt

[PHP-DB] EMail Parser

Any one have some code snip that I could use to build a Email parser in PHP. I have been looking arround and I cant find much on this subject. I want to parse emails that are sent to a certain email address and store that data in a database. -- PHP Database Mailing List (http://www.php.net/

[PHP-DB] HELP USING THE MAIL FUNCTION WITH HTML

How can I use the Mail function to send html data. I have like a welcome letter I am working on and when the user signs up for such services I want this to be sent to them. -- 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.

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 yo

[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. so

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: Wednesda

[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 unsub

[PHP-DB] last 10

How can i obtain the last 10 entries that are in mydatabase that have a certain colum set to 1? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: compareing variables

Thanks I took you up on option b and it worked great. Thanks again. "Hugh Bothwell" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > "Crosswalkcentral" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECT

[PHP-DB] compareing variables

I am usinf the usual if statement here If ($dservice == $olddservice) { Echo ("TRUE"); exit(); } My question is that if $dservices = Main and $olddservice = main then the above statement will not display TRUE. How can i get it to were it will see that Main is the same as main and so on? --

[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: $custpdes\

[PHP-DB] Re: Split a long db record into multiple pages

I am interested in receiving some help on this one as well. "Will" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Does anyone know how to limit a long record, like a news article that has 5 > > pages? > > I want to limit it so it displays the first page then a

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 a

[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.

Re: [PHP-DB] sql query

nd 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

[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

[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] 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] 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 k

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

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

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

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

[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

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 [EMA

Re: [PHP-DB] getting ID

IL PROTECTED]... > At 19:19 8/19/2001, CrossWalkCentral wrote the following: > -- > >I have a script where I submit user data to the database in my script I need > >to get the id # how can I do this w/o creating a query t

[PHP-DB] getting ID

I have a script where I submit user data to the database in my script I need to get the id # how can I do this w/o creating a query that does the following considering that user could have 10 other entires. // Request info $result = mysql_query( "SELECT * FROM supportsys WHERE email = $email");

Re: [PHP-DB] Include

> 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 >

Re: [PHP-DB] Include

rote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > chuck all the common variables in var.php > > then just put > > require("var.php"); > ?> > > - seb > > -Original Message- > From: CrossWalkCentral [mailto:[EMAIL PROTECTED]] &

[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 Centra

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

01c127a1$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]&

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

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 > >

[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 ww