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
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
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
. 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
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
))
> {
> > 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
> >
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
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
;) || 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
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 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))=
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
") 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
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
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
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
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
?>
TYPE=button
VALUE="Edellinen sivu"
onclick="parent.location='page.php?nav=true&go=prev';">
=
($nr_pages-1)) { echo "DISABLED"; }?> TYPE=button
VALUE="Seuraava sivu
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
$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
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
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
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
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
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
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
$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
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
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 / +
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
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
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
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
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
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:
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
= " 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
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
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
39 matches
Mail list logo