[PHP-DB] Re: I want to upload

2003-01-30 Thread Geckodeep
Here are some articles I found on different forums while on uploading files etc, these should give you a head start. use the move_uploaded_file ( string filename, string destination) - the one below is great it explains it in a very simple manner: How do I find the file I just uploaded to the

[PHP-DB] Re: I want to upload

2003-01-30 Thread Geckodeep
Well its me again ,you can also check this thread i've posted to get some more information: Help/Advice/Suggestions need to Upload 9 images on one submit button. GD Quique Notelodigo [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I want to upload a image, from

Re: [PHP-DB] PHP and ORACLE conection error

2003-01-30 Thread Maxim Maletsky
xxx [EMAIL PROTECTED] wrote... : hy, i'm having a problem with my project i have an oracle server on a computer named oracle and in apache htdocs files i have a directory special for my project... 1 in that dir i have a html file named index.html here i get the username and the

RE: [PHP-DB] function needed

2003-01-30 Thread Gary . Every
Use str_replace $FQDN = www.domain.com $domain_only = str_replace(array('www.','.com','.mil','.edu','.org','.gov'),'',$FQDN); Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From:

RE: [PHP-DB] PHP-WIN MYSQL Double results

2003-01-30 Thread Hutchins, Richard
Post your code. -Original Message- From: Chris Deam [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 2:27 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP-WIN MYSQL Double results Please help: I am getting double results when loading an html/php page. I am not

[PHP-DB] Re: PHP-WIN MYSQL Double results

2003-01-30 Thread Chris Deam
? $pquery = SELECT problem_list.code,freetext,problems.DESC1,stopdate,problem_list.problem_id from problem_list, problems where patient_id='$patid' AND problem_list.code = problems.code ORDER BY stopdate DESC; $prcp = mysql_query($pquery); ? TABLE BORDER=2 CELLPADDING=0 CELLSPACING=0 WIDTH=100%

[PHP-DB] Storing IP into DB

2003-01-30 Thread web man
Hi, I wondered if anyone could help me. I would like to store the user IP only once per multiple visits. The code below store the user IP on every visit which is not my intention. Please I would like to have the IP stored at once upon repetitive visits of the user. Thank Below is my code ?

[PHP-DB] Storing IP into DB

2003-01-30 Thread web man
Hi, I wondered if anyone could help me. I would like to store the user IP only once per multiple visits. The code below store the user IP on every visit which is not my intention. Please I would like to have the IP stored at once upon repetitive visits of the user. Thank Below is my code ?

Re: [PHP-DB] Storing IP into DB

2003-01-30 Thread 1LT John W. Holmes
I wondered if anyone could help me. I would like to store the user IP only once per multiple visits. The code below store the user IP on every visit which is not my intention. Please I would like to have the IP stored at once upon repetitive visits of the user. Thank Below is my code ?

RE: [PHP-DB] Re: PHP-WIN MYSQL Double results

2003-01-30 Thread Hutchins, Richard
Try this: After this line: $prcp = mysql_query($pquery); add this line: print_r($prcp); (For additional info: http://www.php.net/manual/en/function.print-r.php) What that should do is print the results directly from your query (which are stored as an associative array) before anything else is

Re: [PHP-DB] Storing IP into DB

2003-01-30 Thread Chris Boget
Make your 'ip' column UNIQUE in your table and ignore errors. Or, set a flag in a session or cookie when you save the IP and if that flag is present on other pages, then don't save the IP. Or I believe you can use REPLACE INTO... Chris -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] PHP - mysql_info question

2003-01-30 Thread Mark McCulligh
I have written a PHP function that uses the MySQL command: LOAD DATA INFILE ... The command returns the result in mysql_info() Records: 42 Deleted: 0 Skipped: 0 Warnings: 5 My question is how do you find out what the 5 warnings are. Does MySQL put them in a log file somewhere and is there a way

Re: [PHP-DB] Storing IP into DB

2003-01-30 Thread 1LT John W. Holmes
Make your 'ip' column UNIQUE in your table and ignore errors. Or, set a flag in a session or cookie when you save the IP and if that flag is present on other pages, then don't save the IP. Or I believe you can use REPLACE INTO... True. I don't think all databases implement REPLACE,

Re: [PHP-DB] Re: PHP-WIN MYSQL Double results

2003-01-30 Thread Chris Deam
Okay, I used print_r but now I get Resource Id #19 no sort of array info. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Make thumbnail of a jpg image.

2003-01-30 Thread Rene Groothuis (Aeqis)
Hi All, Small question: How can I make a thumbnail of a jpg image? Your help is appreciated. Thanks. Rene. === R. Groothuis - Aeqis Gruttosingel 50 2496 HX Den Haag - The Netherlands E-mail: [EMAIL PROTECTED] Tel: +31-15-3618824 Mobile: +31-6-51807877 Fax:

RE: [PHP-DB] SQL: Limit 1 usage?

2003-01-30 Thread Nick Hajek
Your missing a ' before the area code. -Original Message- From: jason wesley upton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 2:43 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] SQL: Limit 1 usage? Currently I have a script that contains this piece of code: $sql =

Re: [PHP-DB] SQL: Limit 1 usage?

2003-01-30 Thread 1LT John W. Holmes
$sql = SELECT * FROM accessnums WHERE areacode=$_POST[areacode]' and city='$_POST[cityselected]' ORDER BY network LIMIT 1; It can't execute the query. Any suggestions? Unless it's a typo, you're missing a single quote around $_POST[areacode]... ---John Holmes... -- PHP Database Mailing

[PHP-DB] more info about data connection with Microsoft Access Driver

2003-01-30 Thread qt
Dear Sirs, I am working with ms access database and I am using following connection; $conn-Open(DRIVER={Microsoft Access Driver (*.mdb)}; .. . I want to learn more for handling data Where can I find good source for this subject? Best Regards -- PHP Database Mailing List

[PHP-DB] data inserting problem

2003-01-30 Thread qt
Dear Sirs, I am using following script to insert data into ms access data with php script $UserName = ara; $Password = 123456; $conn = new COM(ADODB.Connection) or die(Cannot start ADO); // Microsoft Access connection string. $conn-Open(DRIVER={Microsoft Access Driver (*.mdb)};

Re: [PHP-DB] Flash, MySQL PHP

2003-01-30 Thread Jeffrey_N_Dyke
flash is server independent. if you call a flash file on another server it is much like calling an image on another server. yes, PHP can feed flash(info from a DB...to keep this on topic). And flash can send back infomation to PHP via get and post variables(not sure about the post). I've run

Re: [PHP-DB] SQL: Limit 1 usage?

2003-01-30 Thread jason wesley upton
Hmm, I trried your syntax and same problem. I tried it exactly like this: (though i'd like to stress that it worked with the code labeled ORIGINAL below) ?php $connection = mysql_connect(,*,*) or die(Couldn't make connection...because I hate you.); $db =

[PHP-DB] to connect access mdb

2003-01-30 Thread qt
Dear Sirs, I try to connect my access mdb with following script but I can not succed. I get following error. This server is currently overloaded - please try again later Any idea where is the my mistake. I am using xitami server under windows 98. ? $conn = new COM(ADODB.Connection) or

Re: [PHP-DB] Re: PHP-WIN MYSQL Double results

2003-01-30 Thread Chris Deam
Okay, I kinda fixed it. I added the DISTINCT option to the sql query. DISTINCT returns only one row when multiples arre found. What I don't understand is that there is only one row returned in the MYSQL console. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: more info about data connection with Microsoft Access Driver

2003-01-30 Thread Manuel Lemos
Hello, On 01/30/2003 05:31 PM, Qt wrote: I am working with ms access database and I am using following connection; $conn-Open(DRIVER={Microsoft Access Driver (*.mdb)}; .. . I want to learn more for handling data Where can I find good source for this subject? You need the latest

[PHP-DB] check box help

2003-01-30 Thread Matt
Hey can anyone help me out? I am a bit of an amatuer at this. Here is my problem: I have an SQL table with a three fields in it. They are ClassTitle, InstructorName, and CourseDescription. I am setting up a table that lists the records with a check box in front of it. Then if the user checks

Re: [PHP-DB] Make thumbnail of a jpg image.

2003-01-30 Thread mike
Check out imagecopyresampled in the php manual at http://www.php.net/manual/en/function.imagecopyresampled.php Rene Groothuis (Aeqis) wrote: Hi All, Small question: How can I make a thumbnail of a jpg image? Your help is appreciated. Thanks. Rene. === R.

[PHP-DB] check box help

2003-01-30 Thread Matt
Hey can anyone help me out? I am a bit of an amatuer at this. Here is my problem: I have an SQL table with a three fields in it. They are ClassTitle, InstructorName, and CourseDescription. I am setting up a table that lists the records with a check box in front of it. Then if the user checks

[PHP-DB] check box help

2003-01-30 Thread Matt
Hey can anyone help me out? I am a bit of an amatuer at this. Here is my problem: I have an SQL table with a three fields in it. They are ClassTitle, InstructorName, and CourseDescription. I am setting up a table that lists the records with a check box in front of it. Then if the user checks

RE: [PHP-DB] SQL: Limit 1 usage?

2003-01-30 Thread John W. Holmes
Display mysql_error() in your die() statement... so you actually know why your query is failing instead of a generic, worthless error message. If you're not getting the statement in your die() function, then the query is running, but it's not matching any rows. Also, FYI: Inside of a double

RE: [PHP-DB] check box help

2003-01-30 Thread Rich Hutchins
If I understand your question correctly, you really don't have to do much to accomplish what you're looking to do. If you name your checkboxes as an array ($myCheckboxes[]) then, when the form data is submitted, all of the $myCheckboxes[] will be passed as an indexed array called, surprisingly

RE: [PHP-DB] check box help

2003-01-30 Thread Matt Palermo
Thanks. I tried that, and maybe I am doing something wrong with it, but it didn't work. What I did was I made a counter variable, $counter and put it outside the while loop. Then, inside the while loop, when it makes a checkbox, I named the check box, $CheckBox[$counter], so that it would put

[PHP-DB] passing variables through frames

2003-01-30 Thread Matt
Does anyone know how to pass a variable to a different frame? For example, I have a navigation frame, and when you click a link, it opens inside a different frame. Can anyone tell me if there is a way to pass variables from the navigation frame to the main frame? Thanks a lot. Matt -- PHP

[PHP-DB] Re: passing variables through frames

2003-01-30 Thread Matt
Nevermind everyone... I found out. Thanks Matt [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Does anyone know how to pass a variable to a different frame? For example, I have a navigation frame, and when you click a link, it opens inside a different frame.

Re: [PHP-DB] check box help

2003-01-30 Thread Jason Wong
On Friday 31 January 2003 11:40, Matt Palermo wrote: Thanks. I tried that, and maybe I am doing something wrong with it, but it didn't work. What I did was I made a counter variable, $counter and put it outside the while loop. Then, inside the while loop, when it makes a checkbox, I named

[PHP-DB] - Update help

2003-01-30 Thread nikos
Hello list I've download some patches for PHP 4.0.6. and I dont know how to use it. For example rfc1867.c.diff-4.0.6 file how can I run it and do the update? I have PH 7,2 Linux and Apache 1,32 Thank you

[PHP-DB] variable conversion

2003-01-30 Thread bismi jomon
hi, while creating a php page , how can ipass avalue in a text box or any boxex to another page? i hav created one page wiht text boexes in one file and i hav to send it to another program. i did it with post method and in order to get that value i did like: ?php echo($fname); ? where

Re: [PHP-DB] Make thumbnail of a jpg image.

2003-01-30 Thread Rajesh Fowkar
On Thu, Jan 30, 2003 at 09:41:37PM -0800, Rene Groothuis (Aeqis) wrote: Hi All, Small question: How can I make a thumbnail of a jpg image? Your help is appreciated. Take a look at the following Image manupulation functions in PHP : ImageCreateFromJPEG() ImageCopyResized() ImageJPEG() Peace