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
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
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
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
, 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
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
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]
')
$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
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
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
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
) ... 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
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
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
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
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
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
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
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
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
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
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
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
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
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
40 matches
Mail list logo