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
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
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
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
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
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
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
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
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
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]
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
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
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
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
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
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
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
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
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
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:
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?
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:
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
(
$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
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
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
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
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]
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
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:
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
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
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
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:
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
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
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
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
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 -
]'
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
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
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...
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
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
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
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:
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...
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
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
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
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
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
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:
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
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
55 matches
Mail list logo