Re: [PHP-DB] parse error

= " checked"; > 355 } > 356 > 357$message .= ' > 358>no > 359Answer "yes" if you want all postings to the list to be > sent to > 360 a moderator for approval before distribution to the > list. > > Any h

[PHP-DB] Problem with buttons

Hello everyone! Does anyone know what the problem might be with the following little php-snippet? print(" "); print(" "); The next button works perfectly, but for some strange reason nothing happens when one hits the previous button. *sigh* I don't want to be coding today.. I want to be at

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

about it. 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 commands, e-mail:

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

s the page, and therefore also forgets $host, $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

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&quo

Re: [PHP-DB] Formated Results

Kofler (Apress, ISBN 1893115577), 659 pages, 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 - Re

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

but if someone has got a query 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 (htt

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

while back, but then I forgot it :-) One tends to forget things after working for 11-12 hours/day three days in a row... : ) I did just that now, and it works like a charm! [/snip] > =Ok? Very much so! Thanks a million! Now we're (or rather, I'm) a bit wiser again, and I increase

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

our storage, i'll release it under GPL, most probably on the http://lib.vaasa.fi server. 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 / +

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

got it to work, though. Is this even possible? The other option would be to use three(?) mysql_query 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 PROTEC

Re: [PHP-DB] LIMIT and get_num_rows

$query=ereg_replace($what,$with,$query); } } $result=mysql_query($query,$database) print_table(); //processes the query If you got any questions regarding my code, please do drop me a mail. Cheers, Markus --- -- Markus Lervik Linux-admi

[PHP-DB] What is REG_BADRPT, and why do I get it?

ereg("?",$search_id)) { ereg_replace("?","_",$search_id); } and two similar lines of code below them, yet PHP doesn't complain about them. Anyone have any ideas as to what's causing the warning? Cheers, Markus -- Markus Lervik Linux-administrator with a kung

[PHP-DB] Replacing * with %

yes, I also tried $search_name=ereg_replace(blablabla); What a surprise. It didn't work. 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 - frustrate

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

s on Windows." or b) You've compiled PHP with the option --disable-url-fopen-wrapper or set allow_url_fopen to off 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 [EMA

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? somethin

[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

20 -> LIMIT 40,20 that doesn't work. Strange thing is, that it worked about a week ago. : \ I can't really recall changing that part of the code at all at that point. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library

Re: [PHP-DB] session_registered variable problem

$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-administrator with a kungfoo grip Vaasa City Library - Regional Library [E

Re: [PHP-DB] session_registered variable problem

2 <- yup, it's incrementing, all right... nr_pages: 230 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 670

Re: [PHP-DB] session_registered variable problem

?> TYPE=button VALUE="Edellinen sivu" onclick="parent.location='page.php?nav=true&go=prev';"> = ($nr_pages-1)) { echo "DISABLED"; }?> TYPE=button VALUE="Seuraava sivu

Re: [PHP-DB] session_registered variable problem

he full code so we can all revel in this madness! Well, 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 -- PH

Re: [PHP-DB] PHP + SQL Books

oks, but > they usually don't help each other. > > Any recommendations would be great. MySQL/PHP Database Applications Jay Greenspan, Brad Bulger M&T Books ISBN 0-7645-3537-4 -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAI

Re: [PHP-DB] Email Validation

o see if the domain-part of the address really 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

really don't want 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 PROTE

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

") gives 8, add one, and we have monday 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

ilt AS C WHERE (A.id != B.id AND B.building_id = C.building_id)\G *** 1. row *** id: 2 name: bar price: 200 1 row in set (0.00 sec) mysql> Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Reg

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

re doesn't seem to be any 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))=

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

hile(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 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] MySQL problem

;) || die(mysql_error()); > > > $q = mysql_query("SELECT FName, LName FROM user_info WHERE (FName='$FName' && > LName='$LName')") || die(1); Try this out: $q = mysql_query("SELECT FName, LName FROM user_info WHERE (FName='$FName&#

Re: [PHP-DB] Tutorial?

abled 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://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] how to make multiple in a coloum in mysql DB

ple or total in coulum "Total" > otomatically, if me input score in coulom total. > please help me... > (i am sorry my english) INSERT INTO table VALUES("john", "78", "90", scoreA+scoreB); Cheers, Markus -- Markus Lervik Linux-administrator with a k

Re: [PHP-DB] Email Validation

)) > { > > echo "$email doesn't seem to be a valid e-mail address!"; > > } > > > > would do the job. Of course, that doesn't stop people from entering a > false > > email address. You could do a DNS-lookup to see if the domain-part of > >

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

r problem is that I really don't have a clue as to where I'd smack 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 do

Re: [PHP-DB] problem with mysql_query

. mysql_error(); die(); } and see what you get. There's probably some 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

Re: [PHP-DB] problem with mysql_query

ww.php.net/manual/en/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 t

[PHP-DB] Multi-table update question

there's a minimum of four or five SELECTs and four or five INSERTs. I'm positive some of you have similar problems. How do you go about solving it? Cheers, Markus Lervik -- Markus Lervik | A Microsoft Certified Systems Linux-administrator

[PHP-DB] Problem with MySQL and array loop

app working too. What is it I'm missing, or am I just stupid? I opt 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

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

cond alternative was right, 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 67