;
. " H"
. " I"
. " J"
. " K"
. " L"
. " M"
. " N"
. " O"
. " P"
. " Q"
t expect them to work if you don't understand the
code, though.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Peter Beckman" <[EMAIL PROTECTED]>
To: "Philippe Rousselot" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECT
It's probably an issue with security settings in IE6, not your code.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Marie Osypian" <[EMAIL PROTECTED]>
To: "PHP-DB" <[EMAIL PROTECTED]>
Sent: Thursday, 05 June, 20
Entries from what? Do you have a code example of what you're working with now?
Believe it or not, most of us would rather read through it than guess what
you're trying to accomplish.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "A
;t even know how to refer to my problem. Thanks a lot for all
your help.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
re I think about it, the more it seems like I'll just have to use two
queries. I just didn't want to do so bcs the second query will run at least
four times and it seemed inefficient.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Gürhan
Please post the code you are trying to use so that we can try to find the
problem. Without data, we can't tell you where things went wrong.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Ramesh PAtel " <[EMAIL PROTECTED]>
To: <
AUTO_INCREMENT
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Merlin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 03 June, 2003 17:56
Subject: [PHP-DB] in
Try this. I made some minor syntax changes and added some error reporting.
While it may not fix things, it might help you figure out what's wrong.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Ahmed Abdelaliem" <[EMAIL PROTE
Not that I'm aware of, but why don't you give it a shot.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Jakob Mund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, 07 June, 2003 09:04
Subject: [PHP-DB] P
que (albeit slightly altered) would
work well at storing that information for future use.
Storing this information is *very* important. If users keep seeing the same
images, they won't return.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From
rays)
but the general structure is there.
I know that there have been a few multiple insert questions posted to the list
lately so perhaps this will prove helpful to those who asked. If not, than
perhaps some of you can point out flaws in my design, should there be any.
Thanks for yo
Yes, it does what I want, but perhaps not what I described. My goal was to find
a way to add values to the actual query, which this does nicely. Yours, thank
you very much, is even nicer. :)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Ford,
osCommerce
http://www.oscommerce.com
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Mignon Hunter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, 29 May, 2003 16:47
Subject: [PHP-DB] - Shopping cart software
Searching is good for you, just like exercise. :)
If you check the archives, you'll see a lot of posts recommending you visit the
PHP Classes Repository or the PEAR site. If you're not sure where they are,
refer back to the first line.
Edward Dudlik
Becoming Digital
www.becomingd
Forgive me if I'm overlooking something, but why not just use a class?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Rolf Brusletto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, 30 May, 2003 17:10
Subject
Link is bad.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Jim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 23:24
Subject: [PHP-DB] remote commands thought www
Hey,
Where are some actual example
Check out http://www.php.net/manual/en/ref.url.php
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Ian Fingold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 23:20
Subject: Re: [PHP-DB] query string
olutions fairly complex? I'm
simply trying to avoid using another table since it will contain only four
elements. Thanks.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks to both Heilo and Lisi. These scripts should make things easier.
Is it safe to assume that we are in agreement about the use of an ENUM field for
this application?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "heilo" <[EMAIL P
quot; script to remove all entries in the
temp table more than 7 days old. I think that's a fair time for someone to
confirm their information and it allows easily a scheduled operation.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Boa Const
arate from the
regular menu item categories. Because there are only four specials categories
and they are static, I thought ENUM would work best. Your opinions?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
e.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Ahmed Abdel-Aliem" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 04 May, 2003 20:06
Subject: [PHP-DB] problem
hi again,
i use php/mysql and i have a form to enter data
What's the purpose of your script? You can take a look at the command line
functions in the manual, though I don't know if they work in a Windows
environment.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "carol" <[EMAIL
;sport']='2';
$s_lt='PS';
$t_lt='TP';
}
elseif ($cols['s_acro']=='B')
{
$r_away['sport']='3';
$r_home['sport']='3';
$s_lt='ML';
$t_lt='TM';
}
else
$r_a
print date("m-d-y");
http://us3.php.net/manual/en/function.date.php
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Steve B." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, 04 June, 2003 17:58
Subject: [P
I assume you lack update permissions, which means you probably don't have the
other permissions necessary to change data. Assuming you actually do, you could
use REPLACE or DELETE followed by INSERT.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
help you. So I can attempt to do that, let's see the ASP code
you're trying to convert to PHP.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Steve B." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, 09 June,
This is more of an OS/application program than it is a PHP issue. Besides, we
don't even know which program you're using so we couldn't help if we tried.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "birdto" <[EMAIL PROTE
I can't explain why addslashes() didn't work (incorrect placement in the script,
perhaps), but take a look at htmlspecialchars() and htmlentities(). They're
long shots, but they might help.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From
_array( $result );
$total = $total['Total'];
You had forgotten to pull the data out of your result set. It's a common
mistake. :)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Robert Wanadoo" <[EMAIL PROTECTED]>
To: &
I screwed up my own code. Silly me. It should read:
$query = "SELECT SUM(bedrag) AS Total FROM finance WHERE posneg = 'af'";
$result = mysql_query( $query );
while ( $total = mysql_fetch_array( $result ) )
{
$total = $total['Total'];
}
Edward Dudlik
Becoming D
to 2GB.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Martin Waite" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, 10 June, 2003 07:30
Subject: What is the maximum number of rows per table ?
Hi,
rray for the desired result.
Edward Dudlik
Becoming Digital
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'
ything you would change. I
plan on publishing a list of those that are recommended and it is my belief that
this information would make the list more useful. Thanks a lot for your time,
and if you're on the US East Coast, enjoy the nice weather. We deserve our two
days a month!
Edward Dudlik
Unfortunately, I can't, despite my best efforts, get the data to display unless
it's put inside a loop. If anyone can tell me how to, I'd just for joy.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Ford, Mike [LSS]&quo
I love when things go completely over my head for no apparent reason. I have an
incredible talent for missing the obvious.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Hutchins, Richard" <[EMAIL PROTECTED]>
To: "'
Sorry, Manuel, but you must have missed the first paragraph of my post. I was
hoping to narrow down the 40 classes from the repository to those that are top
quality.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Manuel Lemos" <[EMAIL P
With a rather complex class. There is no built-in function for developing roman
numerals from their arabic counterparts, nor is there anything in the Classes
Repository. Perhaps you can be the first to develop one. :)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original
t the quest must go on! ;)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Manuel Lemos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 10 June, 2003 20:51
Subject: Re: [PHP-DB] Re: Authentication Classes
Hello,
Thanks to everyone who's tried to help me with this. I think I'm on the right
track now.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Manuel Lemos" <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]
Very nice work, Hugh.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Hugh Bothwell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, 11 June, 2003 00:55
Subject: [PHP-DB] Re: Now, how about Roman Numerals?
&q
k.net.
I won't "burn" you this time, but try to make sure your future posts to this
list are actually related to database stuff. Thanks.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Steve B." <[EMAIL PROTECTED]>
To: <
If it works for everyone else but not your boss, guess where the problem is?
His security settings probably have something to do with it.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Dewi Wahyuni" <[EMAIL PROTECTED]>
To: <[EMA
> How can I do paging in PHP?
Search the list archives or use one of the paginating classes in the repository.
This came up just last week.
http://marc.theaimsgroup.com/?l=php-db&w=2&r=1&s=paging&q=b
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Messa
ql "SELECT COUNT(*)" statement below?
Same as above. Store it in a PHP variable and retrieve it later.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "ed anderson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, 12
milar uses.
If your webpage broke because a hyperlink in the database included quotes, you
need to either manually add slashes to the text in the database or re-write your
form processing script to include addslashes() and insert the data again.
Edward Dudlik
Becoming Digital
www.becomingdigita
ing easy but I can't figure out
what it is. The session variable simply isn't being set, as confirmed by
printing its value (and by things not working!). Thanks a lot for any and all
suggestions.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ore, your register_globals setting will have some impact on your
> syntax.
Mike answered that part quite nicely. I just realized that I had
register_globals = On, but that is now changed and I still have the same result.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Messag
ch reduces the URL to its basic format.
> ''.
> ''.
That helped, to a degree. The submit button was key to getting the form to
register (hiding the button) but it's still not registering the session
variable.
Edward Dudlik
Becoming Digital
www.becomingdigital.co
page with
the same query string. Again, I'm sure it's something obvious but I just can't
seem to figure it out. What stupid mistake am I making this time? Thanks
again.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Becoming Digi
only one class, the comments for
which are written in Spanish. I've included a link below for those who are
interested.
http://promoxy.mirrors.phpclasses.org/browse.html/file/3077.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
--
PHP Database Mailing List (http://www.php.ne
unning individual queries or building your multi-value query string.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Creative Solutions New Media" <[EMAIL PROTECTED]>
To: "PHP-DB" <[EMAIL PROTECTED]>
Sent: Tuesday, 17 June, 20
Here's a slight alteration to Peter's code in "case" someone isn't familiar with
switch statements. Ooh, such a bad pun, as if there's any other kind.
da da da
';
}// end while
?>
Edward Dudlik
Becoming Digital
www.becomingdigital.c
it seems
better suited to your level of experience. As they say, if you need to ask...
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "nabil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, 18 June, 2003 10:11
Subject
know quite little
about string manipulation, yet I managed to put that script together for you in
a few minutes. All it took was a glimpse at the manual...
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "nabil" <[EMAIL PROTECTED]>
To: <[
> mysqlmanager (www.ems-hitech.com) is by far the best I've used.
They've changed the name to Navicat now. It really is fantastic software.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Michael Scappa" <[EMAIL PROTE
Sorry, I mistyped. Navicat was previously known as MySQL Studio. Both are very
nice packages.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Becoming Digital" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, 19 Ju
> Any added spyware or so ?
I believe someone sent a few attachments to the list.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, 19 June, 2003 12:35
Subject: [PHP-DB] Fw: p
Nice job. There's a fair bit of room for optimization, but unless your data
sets are very large, it's probably not necessary. However, if you're compulsive
(as I tend to be), you'll optimize every bit of code to the best of your
abilities. And yes, I know I'm crazy. ;
include() or require()
What does this have to do with databases?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Alvaro Rosales R." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, 20 June, 2003 18:01
Subject: [PHP-D
That was actually my primary point of optimization. Unfortunately, I've been
feeling a bit lazy, so I didn't bother going into things. :)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]&
Check out the below:
http://us4.php.net/manual/en/features.persistent-connections.php
http://us4.php.net/manual/en/function.mysql-pconnect.php
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Peter Goggin" <[EMAIL PROTECTED]>
To: &
equivalents of $_POST['clientID'] and $_POST['values'], it's no surprise
that things don't work as expected. Those variables are arrays, not strings.
You need to use implode on both to get the strings needed by the script above.
Edward Dudlik
Becoming Digital
ww
> Im trying to figure out a way to emulate mysql's RAND() function to be
> cross database compatible via php.
> Has anyone done anything similar to this???
How about PHP's rand() function?
http://us2.php.net/manual/en/function.rand.php
Edward Dudlik
Becoming Digital
www.becom
.
Use your table's primary key, assuming there is one. This saves creating what
is otherwise unncessary data, but you'll still face "gaps" if records are
deleted.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/regist
> So, why then not using the GPL for PHP. Soo many people are releasing their
> software under the GPL.
This just begs for the "if everyone jumped off a bridge..." question we've all
heard from our parents on at least one occassion.
Edward Dudlik
Becoming Digital
www.becomi
of
unsetting variables is limited, at least with regards to error control. There
may be memory and/or storage benefits, but I am not aware of any that are
significant.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDX
Search, please.
http://marc.theaimsgroup.com/?l=php-db&w=2&r=1&s=XML+MySQL&q=b
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
From: "Nabil" <[
Here's an excellent tutorial
http://www.ricocheting.com/server
and another tutorial
http://www.hotscripts.com/PHP/Tips_and_Tutorials/Installing_PHP/
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- O
this was a chore to
read.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
From: "ed anderson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednes
We have found the only case when banning someone from the list for foul language
would be completely undesirable.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
From
The internet is a wonderful resource.
http://www.mysql.com/doc/en/SELECT.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
From: "Artoo" <[EMAIL PROTECTED]
uite reasonable, but I'd
like to know what others have used.
I'm sorry for going slightly off-topic, but I'm sure many of you have experience
with this issue. Every shopping cart *does* use a database, after all, and I'm
sure someone else will find this useful, too. Thanks a l
Thanks, Mike. I should have specified that I'm in the States and accordingly
need a US-based gateway.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
From: "mike
_query("SELECT * FROM kcs_patternthreads WHERE
pattern_index='$id'");
while ($threadselectResult = db_fetch($threadselectQuery)) {
echo ''.$threadResults[colour].'';
}
}
?>
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did
Anyone who's been on these lists for a few days is already familiar with CPT John W.
Holmes. He's probably helped each and every one of us more times than we can count,
all without asking for a thing. I think it's time we help him with something.
php|cruise is coming this March. As of now, Jo
emaining fields to your liking. :)
Edward Dudlik
"Those who say it cannot be done
should not interrupt the person doing it."
wishy washy | www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: "Beco
ay, 20 October, 2003 15:32
Subject: Re: [PHP] php|cruise - do unto others...
I certain hope no one takes offense to this, John has been a great asset to
this community and to this list, its not like its a required donation or
anything like that, unlike my sons daycare, pay $200/wk and then "fu
79 matches
Mail list logo
