RE: [PHP-DB] Re: Mail problem

2002-10-03 Thread Snijders, Mark
I also have such a script, but i use perl, but there are no difference.. use a for or while loop and put a sleep() function or another function in the loop.. so the server has more time to process the mail, and there will be no timeout anymore Mark SNijders -Original Message- From:

RE: [PHP-DB] deleting a file

2002-10-03 Thread Snijders, Mark
first try to search more on php.net and for this time: use unlink(); -Original Message- From: Karel [mailto:[EMAIL PROTECTED]] Sent: donderdag 3 oktober 2002 14:16 To: [EMAIL PROTECTED] Subject: [PHP-DB] deleting a file hi how do i delete a file from server using php? thanks

RE: [PHP-DB] Table question....

2002-10-03 Thread Snijders, Mark
you have to make it yourself... make a counter, for every row do $counter++; and the if ($counter%2==0){ blue }else{ red } the % is the difference math function... you got a rest-value or not... hope you get it :) -Original Message- From: Rodrigo [mailto:[EMAIL

RE: [PHP-DB] Error query : mysql_result

2002-10-10 Thread Snijders, Mark
would be nice if you would tell which line is 140 -Original Message- From: Burgess [mailto:[EMAIL PROTECTED]] Sent: donderdag 10 oktober 2002 11:14 To: [EMAIL PROTECTED] Subject: [PHP-DB] Error query : mysql_result Hi I have used the mysql_result function to return some specific

RE: [PHP-DB] Re: easier way to do this? (time interval)

2002-10-11 Thread Snijders, Mark
maybe i dont get the question, but for all records for the last 24 hours (1 day) i use: this is an insteresting page: http://www.mysql.com/doc/en/Date_and_time_functions.html i says: Here is an example that uses date functions. The following query selects all records with a date_col value

RE: [PHP-DB] Accessing data from next row? (mysql)

2002-10-14 Thread Snijders, Mark
if you want to access stuff from row 3 while being in row 2.. you first have to put it all into an array.. and then you coul do that.. but i can't comup with something where you need something like that.. a strange idea...? -Original Message- From: Leif K-Brooks [mailto:[EMAIL

RE: [PHP-DB] Duplicates

2002-10-23 Thread Snijders, Mark
select date from table_name where name='test' GROUP BY date -Original Message- From: Chris Grigor [mailto:chris;calibre.co.za] Sent: woensdag 23 oktober 2002 14:04 To: PHP Gen; PHP DB Subject: [PHP-DB] Duplicates Howdi all, How can you list the contents of a table and skip duplicate

RE: [PHP-DB] Am I doing This Right?

2002-11-01 Thread Snijders, Mark
or just do phpinfo(); en check all the vars cause in the latest php versions it could be that you have to use $_POST[.. etc.. ___ Mark Snijders, Developer Atos Origin Groenewoudeseweg 1, Room VN-515 5621 BA Eindhoven, The Netherlands * : [EMAIL

RE: [PHP-DB] Check If Table Exists

2002-11-04 Thread Snijders, Mark
not to make a point but the F = fucking and not fine :-) -Original Message- From: David Robley [mailto:robleyd;paradise.net.nz] Sent: maandag 4 november 2002 9:46 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Check If Table Exists In article [EMAIL PROTECTED], [EMAIL PROTECTED] says...

RE: [PHP-DB] sort by date

2002-11-06 Thread Snijders, Mark
if i get your point: 1 event can have more dates.. and you wanna show for each event just the first date... so you wanna show more from one table as the other one in that case you should try to use the left join !! so check the manual on left join -Original Message- From: Terry

RE: [PHP-DB] sort by date

2002-11-06 Thread Snijders, Mark
why does everybody always gives the answers?? why not a hint, or where to search that they can learn something about it??? -Original Message- From: Marco Tabini [mailto:marcot;inicode.com] Sent: woensdag 6 november 2002 16:08 To: Terry Romine Cc: [EMAIL PROTECTED] Subject: Re:

RE: [PHP-DB] textarea!!

2002-11-08 Thread Snijders, Mark
check out the nl2br() function!! good luck -Original Message- From: Siamak Sadeghianfar [mailto:siamak116;hotmail.com] Sent: vrijdag 8 november 2002 15:31 To: [EMAIL PROTECTED] Subject: [PHP-DB] textarea!! Hi I've written a guestbook in php user writes a message in a texarea and

RE: [PHP-DB] Find out a pic size?

2002-11-11 Thread Snijders, Mark
check this out: http://www.php.net/manual/en/ref.image.php you need de GD limbrary you can check with phpinfo() if you already got it good luck ___ Mark Snijders, Developer Atos Origin Groenewoudeseweg 1, Room VN-515 5621 BA Eindhoven, The Netherlands

RE: [PHP-DB] PHP 4 inserting data in MySQL 3.23

2002-11-13 Thread Snijders, Mark
try before the : if ($submit) this: phpself(); the vars are now declared on a different way in the new phph versions you need to do: if ($_POST[submit]){ and the insert values are also now : echo $_POST[phone]; so check phpinfo(); there are all the vars you need...

RE: [PHP-DB] checking for 0 results?

2002-11-15 Thread Snijders, Mark
and how does $sql now gets in touch with $result Or you can skip a step like: $sql = select * from ietsfuckingfriday; if (mysql_num_rows($result) == 0) { do_something(); } else { do_anotherthing(); } Aaron -Original Message- From: Snijders, Mark

RE: [PHP-DB] using php4 to connect to mysql (newbie question)

2002-11-20 Thread Snijders, Mark
read this http://www.php.net/manual/en/ref.mysql.php and other stuff on http://www.php.net good lukck ___ Mark Snijders, Developer Atos Origin Groenewoudeseweg 1, Room VN-515 5621 BA Eindhoven, The Netherlands * : [EMAIL PROTECTED] *:+31 (0)40 -

RE: [PHP-DB] using php4 to connect to mysql (newbie question)

2002-11-20 Thread Snijders, Mark
]' Subject: RE: [PHP-DB] using php4 to connect to mysql (newbie question) Hi The latest PHP bible is now updated to 4.2 www.troutworks.com -Original Message- From: Snijders, Mark [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 12:18 To: 'mike karthauser'; [EMAIL PROTECTED] Subject: RE: [PHP

RE: [PHP-DB] SQL Guru Question:

2002-11-26 Thread Snijders, Mark
don't think it won't work all in mysql... but what db are we talking about? Well, have you tried it like that? If that doesn't work you could try this: select @calc:=(round(pr_contents * 12)+ round(pr_buildings * 12)), (@calc * .33) as agent, (@calc * .5) as manager from pipeline Regards

RE: [PHP-DB] some data output formatting and grouping question...

2002-12-02 Thread Snijders, Mark
I think you should first make a new datamodel, cause if I see this, it isn't right (just my 2 cents) :-) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Form TextArea Formatting

2002-12-09 Thread Snijders, Mark
hello, check this page for all info: http://www.php.net/manual/en/function.nl2br.php and also check out the links on that page See also htmlspecialchars(), htmlentities() and wordwrap(). hope it helps!! good luck -Original Message- From: Ignatius Reilly [mailto:[EMAIL PROTECTED]]

RE: [PHP-DB] Enlarging tables

2002-12-09 Thread Snijders, Mark
http://www.mysql.com and check 'alter table' with this you can fix it but using phpmyadmin or another program is more handy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Catalog

2002-12-11 Thread Snijders, Mark
jou want to make it yourself even without nowing how to code it or how to set up a database design??? just by looking to other code?? think it will be to hard for a first project.. just my idea... kind regards, Mark -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] php- odbc- access

2002-12-11 Thread Snijders, Mark
don't think it's possible @ once... what I suggest... those people have to make a comma delimited export file, then you make an upload page, where people can upload this file. and you make a script so it will be imported get the point? kind regards ___ Mark

RE: [PHP-DB] Re: flytte bsd harddisk til anden pc

2002-12-12 Thread Snijders, Mark
it's swedish or something.. i don't get it and i'm dutch if the person understands knulla then he's swedish :) ___ Mark Snijders, Developer Atos Origin Groenewoudeseweg 1, Room VN-515 5621 BA Eindhoven, The Netherlands * : [EMAIL PROTECTED] *:+31 (0)40

RE: [PHP-DB] Re: flytte bsd harddisk til anden pc

2002-12-12 Thread Snijders, Mark
PROTECTED]] Sent: donderdag 12 december 2002 14:39 To: Snijders, Mark; 'Radovan Radic'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: flytte bsd harddisk til anden pc I'm pretty sure the .dk on the end of his e-mail address means Denmark. Glad you guys were confused too. I was afraid that last shot

RE: [PHP-DB] Variables de SESSION dentro de funciones PHP

2002-12-13 Thread Snijders, Mark
english please!!! ___ Mark Snijders, Developer Atos Origin Groenewoudeseweg 1, Room VN-515 5621 BA Eindhoven, The Netherlands * : [EMAIL PROTECTED] *:+31 (0)40 - 2785992 (tel) * : +31 (0)40 - 2788729 (fax) The information in this mail is intended

RE: [PHP-DB] Passing selection to next page

2002-12-19 Thread Snijders, Mark
I guess this all is in a form so on the next page it should be in: echo $_POST[department]; or in echo $department depending on the php version -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: donderdag 19 december 2002 12:05 To: [EMAIL PROTECTED] Subject:

RE: [PHP-DB] help me

2003-01-09 Thread Snijders, Mark
when using start_session the code tries to write a file to the tmp dir... think you are working under windows so make in c: a \tmp dir !!! then it should work -Original Message- From: khac duy [mailto:[EMAIL PROTECTED]] Sent: vrijdag 10 januari 2003 1:08 To: [EMAIL PROTECTED]

RE: [PHP-DB] how use random in php

2003-01-09 Thread Snijders, Mark
check www.php.net and search for array... then you will get a list of all the array functions try to find it out yourself first please -mark- -Original Message- From: khac duy [mailto:[EMAIL PROTECTED]] Sent: vrijdag 10 januari 2003 1:15 To: [EMAIL PROTECTED] Subject: [PHP-DB] how use

RE: [PHP-DB] Concatenate two strings

2003-01-15 Thread Snijders, Mark
with a dot $valor=$valor1 . . $valor2 :-) -Original Message- From: Bruno Pereira [mailto:[EMAIL PROTECTED]] Sent: woensdag 15 januari 2003 15:48 Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Concatenate two strings How can i join two strings. My code is something

RE: [PHP-DB] Getting values back out of a URL

2003-01-23 Thread Snijders, Mark
forget that code just do this $parcel_query = SELECT * FROM land01_02_03 WHERE (PelNumber LIKE '$_GET[number]%') AND (OnerName1 LIKE '$_GET[owner]%') ; do this for seeing the url values: print_r($_GET); I am trying to get my values back out of a URL that has been passed from a page

RE: [PHP-DB] Empty form variables

2003-02-18 Thread Snijders, Mark
sometimes people really never use a search :((( but the answer is: php versions 4 use another way of handeling postvars and arrays and if users don't know where the values are, use the function: phpinfo(); !!! and try this: print_r($_POST); thats all i will say -Oorspronkelijk

[PHP-DB] sorting a multimensional array

2003-02-19 Thread Snijders, Mark
hello, i've got the next array: Array ( [testsubnet] = Array ( [2690910720] = 255.255.255.0 ) [GLN-subnetsirangevoorgedelegeerddomein] = Array ( [2886735616] = 255.255.255.0 ) [testsubnet2] = Array (

RE: [PHP-DB] LIMIT problem MSSQL

2003-02-19 Thread Snijders, Mark
$start = 10; $numbers_to_show = 25; $sql = SELECT * FROM bla Limit $start, $numbers_to_show; or just go to mysql.com and use the manual :) -Original Message- From: Noam Giladi [mailto:[EMAIL PROTECTED]] Sent: woensdag 19 februari 2003 16:00 To: [EMAIL PROTECTED] Subject: [PHP-DB] LIMIT

[PHP-DB] mysql to cvs file to excel

2003-02-21 Thread Snijders, Mark
hello, does anybody know if it's possible (without php) to export data from mysql to a cvs file, so i can import it in excel??? so is it possible, and if yes.. how? thanks kinds regards, Mark Snijders -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] Date

2003-02-28 Thread Snijders, Mark
go to mysql.com en look for date -Original Message- From: Jorge Miguel Fonseca Martins [mailto:[EMAIL PROTECTED] Sent: vrijdag 28 februari 2003 16:23 To: [EMAIL PROTECTED] Subject: [PHP-DB] Date How can a make a query that lists all the fields where a datefield as the date of tomorow?

RE: [PHP-DB] Don't Understand

2003-03-12 Thread Snijders, Mark
no there is no other way, and it is pritty easy if you get it.. i've made a special function for it, but got the code @ home but read this: http://www.php.net/manual/nl/function.imagecopyresized.php and especially the user comments.. they are always very usefull goodluck -Original

RE: [PHP-DB] Don't Understand

2003-03-12 Thread Snijders, Mark
that's bull on www.marksnijders.com and www.nederlandmobiel.nl i use those scripts (php and the GD functions ) for automatically changing the file size... -Original Message- From: Dallas Freeman [mailto:[EMAIL PROTECTED] Sent: woensdag 12 maart 2003 12:58 To: 'mike karthauser' Cc:

RE: [PHP-DB] listbox not adding data to mySql?

2003-03-13 Thread Snijders, Mark
put in top of your document : phpinfo(); and see under 'variables' what is in them -Original Message- From: Rich Gray [mailto:[EMAIL PROTECTED] Sent: donderdag 13 maart 2003 10:22 To: Billy; PHP-DB Subject: RE: [PHP-DB] listbox not adding data to mySql? Im having a problem

RE: [PHP-DB] Where have my errors gone?

2003-03-13 Thread Snijders, Mark
I know, it's really anoing some errors are syntax errors which you can't see the way I look them up: put a exit; in the middle of the page... you still see nothing, put the exit; higher in the code.. to that until you see some output again, then you know the syntax error is somewhere below

RE: [PHP-DB] sorting problem...

2003-03-13 Thread Snijders, Mark
guess you can better take a look at the group by function of mysql -Original Message- From: Ignatius Reilly [mailto:[EMAIL PROTECTED] Sent: donderdag 13 maart 2003 15:03 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP-DB] sorting problem... Take a look at the MySQL

RE: [PHP-DB] SELECT * FROM Command

2003-03-19 Thread Snijders, Mark
guess it is hard to answer this with so less information first show us how the table defenition is... how it is build up and then which fields you want to show to the user! then I or others can help you much more!! ___ Mark Snijders, Developer Atos Origin

RE: [PHP-DB] Substring ?

2003-03-20 Thread Snijders, Mark
www.php.net function: substr and you'll see please first search, then ask! -Original Message- From: Dallas Freeman [mailto:[EMAIL PROTECTED] Sent: donderdag 20 maart 2003 9:13 To: [EMAIL PROTECTED] Subject: [PHP-DB] Substring ? I know how to use it with MySQL but how do you use

RE: [PHP-DB] MySQL or Postgres

2003-03-24 Thread Snijders, Mark
hi, Ih ate people being so lazy.. open google and type the words: mysql postgres and you get enough results, here i looked one up for you: http://www.mmlabx.ua.es/mysql-postgres.html http://www.mmlabx.ua.es/mysql-postgres.html ___ Mark Snijders, Developer

RE: [PHP-DB] MySQL or Postgres

2003-03-24 Thread Snijders, Mark
sorry the url I gave was of a weird language.. this one is better: http://www.phpbuilder.com/columns/tim2705.php3 -Original Message- From: Ben Edwards [mailto:[EMAIL PROTECTED] Sent: maandag 24 maart 2003 12:03 To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL or Postgres Could

[PHP-DB] [php] file open

2003-03-24 Thread Snijders, Mark
hello, i'm using the next code: $fp=fopen(WBSMUTA.CSV,r); while (!(feof($fp))) { $data_file=fgets($fp,4096); echo br$data_filebr; } to open a file... but I want to read it from line 3.. and there is a special function for, but can't find it back :( can someone tell me the

RE: [PHP-DB] date to Y-M-D

2003-03-25 Thread Snijders, Mark
ehmmm what kind of dates do you use, maybe dates of birth? when using date of unix timestamp you can't have dates befor 1970 so if those timestamps represents an older date you can't use timestamps! -mark- -Oorspronkelijk bericht- Van: David Rice [mailto:[EMAIL PROTECTED]

RE: [PHP-DB] Generate thumbnails from MySql database

2003-03-27 Thread Snijders, Mark
hi all, cause a lot of people are asking for a thumbnail script: some explenation: this script makes 2 new pics of a uploaded pic, 1 thumbnail and 1 bigger picture (but the bigger one will all be of the same size.. it's better you also see this: if ($site==who-r-u){ this is because the

[PHP-DB] database model

2003-05-28 Thread Snijders, Mark
hello I use mysql can somebody tell me if it's possible to create a database model, like you can do in access... so you can see the relationships between tables (exporting to access and then to it really sucks :((( ) so please another option if possible thanks

RE: [PHP-DB] hotornot functionality

2003-05-29 Thread Snijders, Mark
i would do it totally different if i understand you right.. you start with row number one, show it, give it a rate, then show number 2, and show number 1 as last rated pic!!! then you have the problem of reaching the last record!! but !! i also see another problem: if you do row 1,2,3,4 you

[PHP-DB] array fill/sort question

2003-06-10 Thread Snijders, Mark
hi, I'm working on a ipaddres/subnet programm now i have a talbe with a lot of information about ip-addresses i'm having this query: SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain, location, contact, ccn FROM subnets the subnetaddr field looks like this : 100.20.20.1 and is

RE: [PHP-DB] array fill/sort question

2003-06-11 Thread Snijders, Mark
www.becomingdigital.com - Original Message - From: Snijders, Mark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, 10 June, 2003 08:55 Subject: [PHP-DB] array fill/sort question hi, I'm working on a ipaddres/subnet programm now i have a talbe with a lot of information about ip-addresses i'm having

RE: [PHP-DB] Calculating Time

2003-06-16 Thread Snijders, Mark
check the mktime() function :-) -Original Message- From: Delz [mailto:[EMAIL PROTECTED] Sent: maandag 16 juni 2003 11:21 To: [EMAIL PROTECTED] Subject: [PHP-DB] Calculating Time Hi All, How do I calculate time using php? Let's say I want to know the difference between 12:30PM

RE: [PHP-DB] checking a string for numbers

2003-06-26 Thread Snijders, Mark
you should use preg_match if (preg_match(/\d/,$myVar)){ echo yes it contains a digit; } i believe this works... you should use preg_match and with \d it checks for a digit i'm not sure this works... let me know -Original Message- From: Jamie Saunders [mailto:[EMAIL

RE: [PHP-DB] Re: PHP help

2003-06-30 Thread Snijders, Mark
think you miss something try this : print_r($_POST); cause from a specific php version (above 4) al lthe form vars are in a special array called ($_POST) (when submitted by a form) so you should do: query=INSERT INTO login VALUES ('$_POST[login]'); I also removed a you got one to

RE: [PHP-DB] Problem with select-tag within a php-script

2003-07-02 Thread Snijders, Mark
the select has to be a name and not the id the id has to be within the option value! -Original Message- From: Ruprecht Helms [mailto:[EMAIL PROTECTED] Sent: woensdag 2 juli 2003 15:51 To: [EMAIL PROTECTED] Subject: [PHP-DB] Problem with select-tag within a php-script Hi, I've some

[PHP-DB] [php] printing query output to a printen and or file

2003-07-14 Thread Snijders, Mark
hello i'm busy with generating some overviews out of a mysql database (with php) this are aroudn 8 different overviews and query's. and the output to the screen is very nice. but now i'm also want to give the visiter the option to send the output to a printer of file. but how do I manage

RE: [PHP-DB] Simple field replace...?

2003-08-28 Thread Snijders, Mark
I guess there is no other solution just do it one at a time... it's no problem even if there are 100's. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: donderdag 28 augustus 2003 11:35 To: [EMAIL PROTECTED] Subject: [PHP-DB] Simple field replace...? Hi