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
your claims agent
> as soon as possible.
> Congratulations again from all our staff and thank
> you for being part of our promotions program.
>
> Sincerely,
> Clark Wood
> THE PROMOTIONS MANAGER, SUNSWEETWIN PROMO LOTTERY,THE
> NETHERLANDS.
> NB. Any breach of confidentia
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 y
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
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
rude, 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]
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]
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 PROTECT
gt; SET emailfwd='$emailfwd',
> > mformat='$mformat',
> > filter_code='$filter_code'";
I mean, the line breaks in the second example won't cause the query to bomb,
will they? I agree
$sql .= "filter_code='$filter_code'";
if($FUNC=='USERPOST')
$sql .= ", unote='$unote'";
$sql .= "WHERE user_id='$user_id'";
$result = mysql_query($sql) or die('mysql error #'.mysq
FYI, you should keep your connection.txt as connection.php so we can't all
read the database password and host and put what we want in it. :)
Regards,
Matt.
-Original Message-
From: Philippe Rousselot [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 4:18 PM
To: [EMAIL PROTECTED]
Su
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
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.trilogyint
w you 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 Kille
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.trilogyint
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
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
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?
I would guess something is wrong with the services that are running on your
machine, maybe MySQL isn't on the same machine as your PHP? ... Also, are
you running this on a Windows machine or UNIX?
Matt.
-Original Message-
From: JordanW [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27,
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
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 Administrato
Well, I just assumed he was using PHP since this is a PHP list ... :)
Otherwise, he'd have to use SELECT count() FROM ...
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecom
Try mysql_num_rows() ...
http://www.php.net/manual/en/function.mysql-num-rows.php for the
documentation.
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce
Oh I see ... you need to use the http://www.trilogyintl.com/ecommerce/
---
-Original Message-
From: Sabina Alejandr Schneider [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 11:54 AM
To: Matthew Moldvan
Subject: Re: [PHP-DB] Examine button
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
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
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
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
Sounds like maybe he/she wants to print a directory listing and save it in a
database ... ? As good of a guess as I could figure ... =P
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce
;,
echoing 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 em
Basically all it does is start 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
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/ecom
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
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.trilo
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/ecom
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 Administrato
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
I would say generate the product id you want to show in your new window,
then for your "?" link, or whatever it may be, include that in the
parameters passed in the URL (aka http://www.trilogyintl.com/ecommerce/
---
-Original Message-
From: José Luis [ma
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 Administ
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 of
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
,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce/
---
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 9
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
45 matches
Mail list logo
