[PHP-DB] Problem with MySQL and array loop

for the second choice. :) Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

RE: [PHP-DB] Problem with MySQL and array loop

, after all. Isn't it funny, how one can become code-blind regarding one own's code? -Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] parse error

.= ' 358nobr 359pAnswer yes if you want all postings to the list to be sent to 360 a moderator for approval before distribution to the list./p Any help would be greatly appreciated. Thanks! -- Markus Lervik Linux-administrator with a kungfoo grip

[PHP-DB] Problem with buttons

Hello everyone! Does anyone know what the problem might be with the following little php-snippet? print(TR TD COLSPAN=\4\ ALIGN=\CENTER\INPUT TYPE=button VALUE=\Previous page\ onclink=\parent.location='index.php?nav=truego=prev';\/TD); print( TD COLSPAN=\4\ ALIGN=\CENTER\INPUT TYPE=button

Re: [PHP-DB] Sending variables between PHP pages

, $username and $password, so I'd probably still have to somehow register the variables, ie. using session_register, no? -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List

Fwd: Re: [PHP-DB] How to querry two db in a single statement?

Didn't notice that this didn't get cc:d to the list, so here it hoes. -- Forwarded Message -- Subject: Re: [PHP-DB] How to querry two db in a single statement? Date: Fri, 4 Jan 2002 15:58:35 +0200 From: markus|lervik [EMAIL PROTECTED] To: Andy [EMAIL PROTECTED] On Friday 04

Re: [PHP-DB] Formated Results

, which seems to be quite a good book, and we can't forget the classical MySQL by Paul DuBois and Laurie Petrycki (New Riders, ISBN 0735709211) 850 pages. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325

[PHP-DB] Updating table with data from another table in the same database

that would take care of this I wouldn't have to get into that. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

Re: [PHP-DB] Updating table with data from another table in the same database

like a charm! [/snip] =Ok? Very much so! Thanks a million! Now we're (or rather, I'm) a bit wiser again, and I increased the grasp of my kung-foo grip just a bit more!-) Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL

Re: [PHP-DB] PHP/MySQL Library Catalog System

. Not that I know if anyone has got any use of it whatsoever, but... Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] Combining INSERT...SELECT and INSERT INTO

calls from my PHP-code, but I'd like to keep it as simple as possible. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] Replacing * with %

. Yes, I've RTFM, RTMFM, read from my PHP Blackbook to phpbuilder.net and just about everything in between. Pretty soon I'll start bashing away on that Solaris 8 box over there. Markus - frustrated -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library

Re: [PHP-DB] Including a file using php //

in php.ini If the answer to option a is yes, then sorry, Harry, it wont work. -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

Re: [PHP-DB] Combining INSERT...SELECT and INSERT INTO

On Tuesday 15 January 2002 16:04, you wrote: On 1/14/2002 12:54 PM +0200 Markus Lervik wrote: Is there any way to combine INSERT...SELECT and INSERT INTO so one could insert a new row with a few values inserted by hand and others from another table? something like INSERT

[PHP-DB] session_registered variable problem

time, and it suddenly gets the value it had in the beginning. Ideas as to how one would go about solving this little problem? Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709

Re: [PHP-DB] session_registered variable problem

of the code at all at that point. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] session_registered variable problem

: ) It would be just as big a mess with a truckload of concatenations, like $query = SELECT . $tables . FROM uusi_lehtitaulu L, nimet N WHERE (L.nimi_id=N.id . $search . ) LIMIT $start,20; Besides, I have a strange fetisch to do everything the hard way. : ) Cheers, Markus -- Markus Lervik Linux

Re: [PHP-DB] session_registered variable problem

Whack! Doesn't work any more... It's starting to drive me mad. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] session_registered variable problem

. (yes, I use session_register(query), not session_register($query).) I checked the sess_whatever file step by step when testing again just to see exactly what is put in it, but it seems to be a well-behaved little textfile. Make any sense out of the code? Cheers mate, Markus -- Markus Lervik

Re: [PHP-DB] session_registered variable problem

, problem solved, sort of. It suddenly started working. Wicked. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e

Re: [PHP-DB] PHP + SQL Books

each other. Any recommendations would be great. MySQL/PHP Database Applications Jay Greenspan, Brad Bulger MT Books ISBN 0-7645-3537-4 -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP

Re: [PHP-DB] Email Validation

exists, too. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MySQL/PHP date functions

to loop through all dates possible just to find if they are on that particular week.. (my explanation might be a bit confusing, I'm dead tired :) Cheers, markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40

RE: [PHP-DB] MySQL/PHP date functions

the whateverth, right?-) Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] selecting question

Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Parse error (a bit OT)

missing brackets or semicolons... Cheers, Markus 53: if ($prev_week) { 54:while(date(W,mktime(0,0,0,$m,$d,$Y))==$week) { ...blababla... } 67: if ($next_week) { 68:while(date(W,mktime(0,0,0,$m,$d,$Y))==$week) { ...blablabla... } -- Markus Lervik

Re: [PHP-DB] Re: Parse error (a bit OT)

, Markus 53: if ($prev_week) { 54:while(date(W,mktime(0,0,0,$m,$d,$Y))==$week) { ...blababla... } 67: if ($next_week) { 68:while(date(W,mktime(0,0,0,$m,$d,$Y))==$week) { ...blablabla... } -- Markus Lervik Linux-administrator with a kungfoo grip

Re: [PHP-DB] MySQL problem

='$LName')) || die(1); Try this out: $q = mysql_query(SELECT FName, LName FROM user_info WHERE (FName='$FName' LName='$LName'),$db) || die(1); ^^^ It might help. Or it might not :) Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip

Re: [PHP-DB] Tutorial?

)) { echo DISABLED; }? VALUE=whatever If $disabled is set, the button is rendered grayed out, but still visible. -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http

Re: [PHP-DB] Email Validation

stop people from entering a false email address. You could do a DNS-lookup to see if the domain-part of the address really exists, too. -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP

[PHP-DB] PHP date calculations and db (slightly OT)

in a counter for the number of days in the month. However much I ponder this I can't reach a sensible conclusion. It seems that putting the loop just about anywhere would be a performance loss ;) Anyone ever done anything like this? Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo

Re: [PHP-DB] problem with mysql_query

problem with the database connection. Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library, Finland [EMAIL PROTECTED] +358-6-325 3589/+358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] problem with mysql_query

/function.addslashes.php Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library, Finland [EMAIL PROTECTED] +358-6-325 3589/+358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] problem with mysql_query

On Monday 10 Jun 2002 2:37 pm, Markus Lervik wrote: On Monday 10 Jun 2002 2:15 pm, Rene Schoenmakers wrote: Hi, I know what's causing the problem. In $newsText sometimes single quotes are entered. There the error occurs. How can I escape these singel quotes? with $newsText