Re: [PHP-DB] PHP mail() question?

2003-04-02 Thread rolf vreijdenberger
function htmlemailheaders($from="somename<[EMAIL PROTECTED]>",$CC="",$BCC=""){ //three arguments, last two optional // http://www.mindspring.com/~mgrand/mime.html voor mime specificaties $mailheaders = NULL;//initi $mailheaders .= "From: $from\r\n";//waarde van eerste argument van de functie $ma

[PHP-DB] Re: Date format in MySQL

2003-02-03 Thread rolf vreijdenberger
the function you need is DATE_FORMAT() select event, DATE_FORMAT(my_time,'%d-%m-%Y) as mytime From mytable; mytime will be in the form dd-mm-, the %d specifier will give you the prefferred output -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.ne

[PHP-DB] Re: select only where 2 things are true

2002-12-13 Thread rolf vreijdenberger
SELECT jouw_id FROM A AS A1, A AS A2 WHERE A1.merkid=1 AND A2.merk_id=2 AND A1.jouw_id=A2.jouw_id this is a self join! thanks to vincent @ www.yapf.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] select only where 2 things are true

2002-12-11 Thread rolf vreijdenberger
A your_id brand_id B brand_id description A is filled with this data 1-1, 1-2, 2-2, 3-1, 3-2 how to get the your_id's with description of the brand where there are more brand_id's to a your_id with the next query i can get the data out with a where clause, but I want to select only the combo's

[PHP-DB] multiple table inserts at the same time

2002-12-07 Thread rolf vreijdenberger
hi there, I have multiple tables in my mysql db. Users register, and after submitting there are multiple tables that need inserts. What is the best way to do this? speedwise, efficiencywise, codewise? (pseudo code) A) $sql[]='insert1'; $sql[]='insert2'; $sql[]='insert3'; foreach($sql as

Re: [PHP-DB] calling function on submit instead of going to a new script

2002-12-06 Thread rolf vreijdenberger
or use javascript, this really keeps you on the same page -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] need help with "SHOW Colums"

2002-10-31 Thread rolf vreijdenberger
$table="user"; > > $query = " SHOW COLUMNS FROM $user "; > > > > $result = mysql_query ( $query ) or die( mysql_error () ); > > > > while ( $row = mysql_fetch_array ($result) ){ > > > > $x = 0 ;// i don't know what you're trying to do here, but it's wrong!! It keeps resetting$x to zero and does n

[PHP-DB] Re: Newbie-Question: What's that @?

2002-10-31 Thread rolf vreijdenberger
tion basis with the @ or for the whole script with error_reporting() function. -- Rolf Vreijdenberger De Pannekoek en De Kale Maystraat 6 2593 VW Den Haag T: 06-24245719 E: [EMAIL PROTECTED] W: www.depannekoekendekale.nl "Marcus Fleige" <[EMAIL PROTECTED]> schreef in bericht news:

[PHP-DB] checking data from a flash movie at my domain for an insert

2002-10-23 Thread rolf vreijdenberger
;s an I'll-make-it-annoying-but-not-impossible kind of thing. The reason I'm asking is because flash movies can be decompioled so the algorithm for encrypting can be decoded easily. thanks -- Rolf Vreijdenberger De Pannekoek en De Kale Maystraat 6 2593 VW Den Haag T: 06-24245719 E: [EMA

[PHP-DB] Re: f

2002-10-18 Thread rolf vreijdenberger
sorry about the message, I accidently sent it -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] f

2002-10-18 Thread rolf vreijdenberger
f -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php