I'm not completely sure of the implementation details, but look into the
BLOB data type.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BLO
B
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http
with more
than one value for each row returned. ie, $array[$i] could be anything from
the table name to its size to its whatever ...
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce
lol ... sorry but that was just funny
:-D
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce/
---
-Original Message-
From: Jason Wong [mailto
I would recommend phpBB ... very useful and best of all, FREE! :)
http://www.phpBB.com
-Original Message-
From: Boaz Yahav [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 20, 2002 12:02 PM
To: Chris Payne; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Theory help needed
why not use one
Your company does PHP development, and you don't know how? Hmm ... I would
say pick up a PHP book from Half.com or invest in hiring a good Script
Programmer/Database Developer for your project (me, hehe).
Regards,
Matthew Moldvan
---
System Administrator
Sounds more like an SQL question than PHP, but try the following:
SELECT * FROM table WHERE date LIKE '2002-12%';
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce
I think the easiest way to do this would be to use the JavaScript
onClose(); to load the PHP logout page ... that works whether they simply
leave the page or whether they close the browser also.
Regards,
Matthew Moldvan
---
System Administrator
Trilogy
Which solution did you end up using? Just curious, I wasn't sure if mine was
correct ...
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce
I guess for consistencies sake you can use SELECT * FROM table WHERE date
LIKE '2003-01%' also ... just a thought. :-)
Anyway, glad to help out.
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com
for a very reasonable price ...
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce/
---
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL
Don't mean to nitpick, but from what I read onUnload works both when
navigating away and when closing ...
:)
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce
the Apache server and allow it to
interface with MySQL through configured parameters.
Like I said, I haven't played with it too much, because my web host does
support PHP and MySQL, but when I recently had a lapse in internet service,
I tinkered with it a tiny bit.
Regards,
Matthew Moldvan
RESULT[x].
hope this helps.
Matthew Moldvan.
System Administrator,
Trilogy International.
-Original Message-
From: Info@Best-IT [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 11:34 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Retreive email address from MySQL DB
I have
What does your SQL look like? I would say make sure you use UNIQUE if that
doesn't mess up your implementation ... also, some code snippets would help
if you need assistance.
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
authentication).
Now, if PHP can connect to the types of databases your system would need to
use is a different story ... you would probably have to ask the vendor about
that.
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http
Why not direct your energy to an existing project? No sense in reinventing
the wheel ... http://phprpg.org/. BTW, they are using MySQL, and it is open
source.
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http
Out of curiosity, what was the solution? It's always good to learn from
someone else's mistakes ... :)
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce
Oh I see ... you need to use the input type=file HTML tag within a form
that points to a PHP Script. Now depending on what you want to do with the
file, that will have to be done by your PHP code.
www.google.com, search for: HTML input tag file
Regards,
Matthew Moldvan
Well, I just assumed he was using PHP since this is a PHP list ... :)
Otherwise, he'd have to use SELECT count(something) FROM ...
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce
Choose the database from the list on the left, then do a dump of the
database by selecting Structure and Data. Then, create the new database
and use the INSERT that was generated by your dump.
Regards,
Matthew Moldvan
---
System Administrator
Trilogy
Did you forget to attach the class?
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
Work: (313) 593-7993 x 116
Cell: (734) 658-0997
http://www.trilogyintl.com/ecommerce
Correct me if I'm wrong, but something like:
if(($string=fgets($socket,128)) == hello)
echo 'success!';
should work. In C or C++ you would use strcmp, but luckily PHP doesn't have
that drawback.
Out of curiosity, what are you working on?
Regards,
Matthew Moldvan
I would say using a 'tinyint' as either a 1 or 0 would be the same ... thats
basically all a boolean TRUE or FALSE is, anyway.
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce
Actually this is incorrect also and will only result in another parse error
... you have (), which is fine, but then {)}, which doesn't make any sense
to the parser.
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http
Have you looked into the exec() function? Maybe exec(lpr something or
other) may work, though I haven't tried it myself ...
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce
) ... that
should get you started, at least. :)
Good luck, and for curiosities sake let me know how the project turns out.
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce
implemented it.
Thanks,
Matthew Moldvan.
System Administrator,
Trilogy International, Inc.
http://www.trilogyintl.com/
-Original Message-
From: Nicholas Fitzgerald [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 7:58 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: Real Killer App
I am assuming English isn't your first language.
Yes, fuck is definitely swearing, cursing, or whatever else you would like
to call it. And yes, it is considered rude in our culture. :D
So there. :)
Matthew Moldvan.
System Administrator
Trilogy International, Inc.
http://www.trilogyintl.com
That makes sense ... guess I shouldn't respond to questions so late at night
and with any bit of alcohol. :P
S.: did you find a workaround?
Regards,
Matt.
x116
-Original Message-
From: Leif K-Brooks [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 2:47 AM
To: Matthew Moldvan
Cc: S
')
$sql .= , unote='$unote';
$sql .= WHERE user_id='$user_id';
$result = mysql_query($sql) or die('mysql error #'.mysql_errno.':
'mysql_error());
}
Try that ... also look into www.php.net under string manipulation for other
options.
Regards,
Matthew Moldvan
System Administrator
example won't cause the query to bomb,
will they? I agree that using the $sql .= is cleaner, but the other way
isn't wrong, is it?
Rich
-Original Message-
From: Matthew Moldvan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 11:33 AM
To: 'Susan Ator'; '[EMAIL PROTECTED]'
Subject: RE
Have you tried the built in Oracle functions in PHP?
http://us3.php.net/oracle
oracle_logon() may be useful here ...
Let me know if it works out for you.
Regards,
Matt.
-Original Message-
From: Y Al Hinai [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 8:03 PM
To: [EMAIL
The function mysql_query() expects a string, so you have to put select ...
in quote for it to be considered one string, instead of 4.
Have fun,
Matt.
-Original Message-
From: Jorge L. [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 10:26 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
Yes, but it can be complicated ... you have to install MySQL (www.mysql.com)
and PHP (www.php.net) and web server software, such as Apache
(www.apache.org).
I recently setup a test server on Windows XP with little trouble ...
Good luck!
Regards,
Matthew Moldvan
System Administrator
Trilogy
, but I recommend picking up a good book on database
theory. :)
Regards,
Matthew Moldvan
System Administrator
Trilogy International, Inc.
-Original Message-
From: Sparky Kopetzky [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 05, 2003 12:20 PM
To: PHP DB Group
Subject: [PHP-DB] Very
Because you forgot a $ before $sql in the second?
Regards,
Matthew Moldvan
System Administrator
Trilogy International, Inc.
-Original Message-
From: Patrik Fomin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 4:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] silly problem
Well, it looks like your previous response was correct, but $a%$b in this
case returns 4, not the 0.8 as intended ... fmod($a, $b) (I have php 4.1.2,
so I can't test fmod()) will probably return 0.8 though.
As a side note, this message seems a little off-topic ... though it is PHP,
it has nothing
There's probably a better way to do this, but to retrieve only the 0.8 from
24/5 try this:
($a/$b)-floor($a/$b)
Regards,
Matt.
-Original Message-
From: Alain Barthélemy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 5:05 AM
To: php-db
Subject: [PHP-DB] % operator
Hello,
If
of confidentiality on the part of
the winners will result to disqualification.
SORRY FOR THE LATE INFORMATION THANKS
CLARK WOOD
--
Matthew Moldvan [EMAIL PROTECTED]
Trilogy International, Inc.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
I would say try single quotes instead of double quotes ... let me know if
that works ...
Regards,
Matt.
- Original Message -
From: Sean Smitz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 17, 2003 4:32 PM
Subject: [PHP-DB] MySQL Query not working via PHP
I have a
40 matches
Mail list logo
