)) {
alert('Please enter an integer for ...');
}
}
- Jon L.
On Mon, May 12, 2008 at 11:47 AM, YVES SUCAET [EMAIL PROTECTED] wrote:
Nope, it's not. The problem was formulated as Integer detection. not
numerical detection in general. isNaN will return positive for e.g.
floating
point values
());
while ($row = mysql_fetch_array($result))
{
echo Program is in While loop;
$g_name = $row[gig];
$vname = $row[venue];
$genre = $row[genre];
echo(Gig Name: .$g_name);
}
- Jon L.
On Tue, Apr 29, 2008 at 1:27 PM, Nasreen Laghari [EMAIL PROTECTED]
wrote:
Hi,
Why my
.
- Jon L.
On Thu, Apr 3, 2008 at 6:57 PM, Nasreen Laghari [EMAIL PROTECTED]
wrote:
Hi,
I'm trying to put limit of data fetch as well as dynamic navigation. Below
is the try which I did but something is going wrong as $screen value is not
increasing so when I click on NEXt button it refreshes
(This isn't a solution, per se...just a suggestion.)
I don't know how they compare; I've never personally used the ODBC
functions...
But, you may give the MSSQL functions a try:
http://php.net/mssql
- Jon L.
On Mon, Mar 31, 2008 at 3:27 PM, cfs [EMAIL PROTECTED] wrote:
I'm using PHP
Here's the manual: http://php.net/language.types.resource
Also: http://php.net/resource
An entire list of all possible resource types and respective functions.
Read up, man.
- Jon L.
On Mon, Mar 31, 2008 at 1:39 PM, Richard Dunne [EMAIL PROTECTED]
wrote:
When I did a search on resource(5
What I get for not refreshing. ;)
Sorry, man. Didn't know you already gave the links.
- Jon L.
On Mon, Mar 31, 2008 at 1:56 PM, Andrés G. Montañez
[EMAIL PROTECTED] wrote:
The ID of the resource changes on every new resource.
There is no co-relation between resources and resources id
;
$nums = string_to_array(preg_replace(/[^0-9]+/, , $nums));
- Jon L.
On Wed, Mar 26, 2008 at 1:35 PM, Richard Dunne [EMAIL PROTECTED]
wrote:
Using this extract from
http://ie.php.net/manual/en/control-structures.foreach.php
Amaroq
09-Mar-2008 06:40
Even if an array has only one value
it, as Matt suggested, using IN: WHERE variable IN (1, 2)
Did that help any?
- Jon L.
On Mon, Mar 10, 2008 at 3:40 PM, Neil Smith [MVP, Digital media]
[EMAIL PROTECTED] wrote:
At 19:34 09/03/2008, you wrote:
From: Ron Piggott [EMAIL PROTECTED]
Date: Sun, 09 Mar 2008 15:34:05 -0400
Message-Id
, if you use IN, the listing_type tests will already be grouped.
WHERE name LIKE ABC AND listing_type IN (1, 2)
- Jon L.
On Mon, Mar 10, 2008 at 4:02 PM, Jon L. [EMAIL PROTECTED] wrote:
Now I've spoon fed you
Damn, Neil...you're a d-bag.
Next time you go to offer help, it may assist you
[Correction]
Change:
Also, reversing the order should work (since grouping is left-to-right):
To:
Also, reversing the order should work (since AND/OR/etc. are read
left-to-right):
- Jon L.
On Mon, Mar 10, 2008 at 4:18 PM, Jon L. [EMAIL PROTECTED] wrote:
As much as I hate admitting
should check out the following page on adding users:
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
And read up on the following commands:
CREATE USER: http://dev.mysql.com/doc/refman/5.0/en/create-user.html
GRANT: http://dev.mysql.com/doc/refman/5.0/en/grant.html
- Jon L.
On Sat, Mar 8
`
Status: b:1; (1)
Error : '' (0)
Closing connection
Status: b:1; (1)
Error : '' ()
- Jon L.
On Sat, Mar 8, 2008 at 5:53 PM, Manysh [EMAIL PROTECTED] wrote:
Thanks for your input, Jon. Few more observations...
Yes, I have PHP+Apache+MySQL installed for private use
You can try adding a quick test to the ON statement...
SELECT * FROM TableA
INNER JOIN TableB
ON TableA.record_id = TableB.record_id
AND TableB.timestamp = MAX(TableB.timestamp)
Now, I haven't tested it.
I can only say the theory of it is accurate.
- Jon L.
On Thu, Mar 6, 2008 at 12:46
Does anyone has any detailed installation tips? I am on Solaris 10, using
the /usr/sfw/bin/gcc (3.4.3)
I am getting link errors against the php-cli
disabling the php-cli, the link errors come against the apache binaries, all
of the sybase stuff is undefined
Help!
this project, however educational it has been), You seem
to be using sanity check in a technical sense. What exactly would
that be, when it's at home, and what would it look like?
Thanks all for the good advice!
Jon
On Aug 22, 2005, at 4:22 PM, mike burnard wrote:
I certainly agree
[addentry] = Add Entry from the submit button. Is that what's
screwing it up?
Any clues would be much appreciated.
Jon
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
list to ensure the data elements are placed into the correct
columns
Bastien
I'm not sure what any of this means, but it didn't turn out to be
necessary.
Jon
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
? Apologies if these questions are naive,
but I am a rank tyro in these matters.
Jon
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
, but not answered.
Any help for a tyro?
Jon
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Thu, 24 Feb 2005 02:37:01 -0800 (PST), Gael Lams [EMAIL PROTECTED] wrote:
Hi all
I use the classic following rows to connect to a mysql
database. I always put $passsword in clear in the php
connection file and I wonder whether there is a way to
have it in md5 so that someone reading the
To quote the Mighty Gerard Samuel [EMAIL PROTECTED]:
Julian Madle wrote:
I obviously have no control of which ISP and end-user may
choose, although our product will specify that Linux, PHP4, and MySQL4 (or
higher) are installed. The manual says that these are built-in on version
4.0 and
.
Thanks,
Jon
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Sorry for another newbie question, I'm learning.
In Sybase I can do:
select COMM_REGIONID , count(1) from COMM_REGIONID where PHYSICAL_ID is
null
select COMM_TKGRP , count(1) from COMM_TKGRP where PHYSICAL_ID is null
I get parsing errors when putting it in this:
$result = sybase_query(select
.
From: Jon Davis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] selecting a constant or label in php
Date: Wed, 03 Dec 2003 09:39:33 -0600
Sorry for another newbie question, I'm learning.
In Sybase I can do:
select COMM_REGIONID , count(1) from COMM_REGIONID where PHYSICAL_ID is
null
Hello PHP gurus,
I have just started to learn PHP, since I have inherited some previous PHP
scripts that I must maintain.
My question is this: I have to write a script that gets data from a view in
Oracle. I then need to insert that data into a Sybase database. Can this
be done? This will
the
mysql_fetch_array() function; don't assign what you won't use.
--
Jon Kriek
http://phpfreaks.com
Ignatius Reilly [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
mysql_fetch_array( $result )
_
- Original Message -
From: Devon [EMAIL PROTECTED]
To: [EMAIL PROTECTED
Chris, we think along the same lines - posted a similar concern seconds
before you.
--
Jon Kriek
http://phpfreaks.com
Chris Boget [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
mysql_fetch_array( $result )
Actually, for an associative array (which the OP had made reference
(1) additional overhead
(2) bad script-logic
--
Jon Kriek
http://phpfreaks.com
Richard Hutchins [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Chris (Jon Kriek too, I guess),
Curious as to why you say you avoid mysql_fetch_array() like the plague. I
use it frequently and am
Easier is not always right or good script-logic
Would it be easier for you to type:
mysql_fetch_array($result, MYSQL_ASSOC) {
It's easier for me to just always use mysql_fetch_array instead of
figuring out whether I want mysql_fetch_row, mysql_fetch_assoc, or both.
David T-G [EMAIL PROTECTED]
Trust me, I was not shooting anyone down, I would rather quit programming
then do that - seriously.
--
Jon Kriek
http://phpfreaks.com
David T-G [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
That is your personal opinion to which you are entitled to, but again
shooting someone down is just not the case in this situation.
No, but IMNSHO he shot a rather rude hole in Ignatius.
David T-G [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
--
PHP Database Mailing List
30% increase is more than I was expecting, but nonetheless I was correct.
--
Jon Kriek
http://phpfreaks.com
Peter Beckman [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Mysql_fetch_assoc() is faster -- use it.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
Perhaps if you would stop sending your posts at attachments ;)
Dude, your quoting *really* needs some help
--
Jon Kriek
http://phpfreaks.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ORA-01036: illegal variable name/number
Make sure that the variable being bound is in the sql statement.
--
Jon Kriek
http://phpfreaks.com
Roger Spears [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello,
I've been working on this all day. I'm trying to insert some text
less readable
I disagree, but that is ok, that is allowed =)
--
Jon Kriek
http://phpfreaks.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I concur, assign the superglobal array to a variable ...
$Name = strip_slashes($_POST['elementName']);
$sql=INSERT INTO $table SET Name='$Name'];
... and then use that opportunity to run additional checks on the content.
--
Jon Kriek
http://phpfreaks.com
--
PHP Database Mailing List (http
Actually, I meant to suggest addslashes() and mysql_espace_string()
--
Jon Kriek
http://phpfreaks.com
Jon Kriek [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I concur, assign the superglobal array to a variable ...
$Name = strip_slashes($_POST['elementName']);
$sql=INSERT
[EMAIL PROTECTED] wrote:
Hello all I have a helpdesk application that was written in php and I
would like to create a script that will e-mail the systems staff how many
open helpdesk tickets they have. There are 10 users and I can wrtie a
script no problem to do a count and then e-mail that
Aaron Wolski wrote:
Here's some functions I use in my development which save on connect and
query calls for me.
aaron: i do more or less the same thing. allow me to criticize your
functions in one very important respect: you do not check the return
value of your calls! i would suggest that
fred jones wrote:
Okay the weird part is that everything seems kosher,
(no errors, the output from the select statement
prints out the data I entered), the only problem being
when I look in the database (via a webadmin or
bringing up the data in another form) it's not there!
In another words I'm
Does anyone know if PHP 4 on the Red Hat distro is only available on RHL8 or better?
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http://www.mmtnetworks.com.au
I don't know the key to success, but the key to failure
is trying to please everybody. -Bill
of this also.
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http://www.mmtnetworks.com.au
I don't know the key to success, but the key to failure
is trying to please everybody. -Bill Cosby
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
-4.2.2-8.0.5
libpng12.so.0 is needed by php-4.2.2-8.0.5
libstdc++.so.5 is needed by php-4.2.2-8.0.5
All of these are available in RHL8.0
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http://www.mmtnetworks.com.au
I don't know the key
Looking for a php/mysql tutorial on how to handle mathamatical
functions.
--
Jon Miller [EMAIL PROTECTED]
MMT Networks Pty Ltd
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
=HmPhne value= size=32/td
/tr
tr valign=baseline
td nowrap align=rightnbsp;/td
tdinput type=submit value=Insert Record/td
/tr
/table
input type=hidden name=CustID value=
input type=hidden name=MM_insert value=form1
/form
pnbsp;/p
/body
/html
Jon L. Miller, MCNE
as for as creating the form, just when try to run it I get the
message. I should mentioned I just copied the file created to the linux location
where the files are supposed to be.
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http://www.mmtnetworks.com.au
I don't know
not the schweeet low level access that ISAPI provides, but I don't think the
ISAPI php lib is stable enough yet to use in critical apps - most have
better running php as CGI.
just my 2 sense of it.
cheers,
jon-david
RingTFM, but any help would
be greatly appreciated.
TIA!
jon-david
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
enough to discover. currently RingTFM...
as per usual, all help is greatly appreciated.
cheers,
jon-david
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lutz Bruckner
Sent: Tuesday, March 26, 2002 1:34 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Newbie
Yes,
Do a join on the two tables and only pull the book data from the first
record.
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key
- Original Message -
From: George Pitcher [EMAIL
to MSSQL Server?
See above answer. Also you have any TCP/IP overhead to add on.
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key
--
PHP Database Mailing List (http://www.php.net
Hi Faye
Maybe I shouldn't be trying to send that many emails at a time. I am on
apache using mysql and php...
--
put the line
set_time_limit(0);
at the top of your PHP script
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key
it's better to do something like
0,10,20,30,40,50 * * * * /usr/bin/php -q
/home/you/yourscript.php /dev/null
or even
*/10 * * * * /home/you/yourscript.php /dev/null
with the first line of you php script being
#!/path/to/php -q
--
PHP Database Mailing List (http://www.php.net/)
Sorry the second elseif statement should have ended with : not ;
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key
- Original Message -
From: Jon Farmer [EMAIL PROTECTED]
To: [EMAIL PROTECTED
You want to use --with-pgsql=/usr/local/pgsql - but change this path to
point to where you installed PostgreSQL. If you compiled pgsql yourself and
didn't specify a path, the path I gave you there is the default I believe
and should work.
--Jon
At 07:16 AM 12/11/2001 -0500, Michael Hanna
size.
You cant do this with PHP. You need to use a client side script (javascript)
to determine the screen res and then pass that pack to PHP either through
the query string or a form post.
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP
if it's forget it, no way...
If this was a transaction then you can rollback if not then forget it
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key
- Original Message -
--
PHP
No this will not do what the original poster requested
it will be something like the following
select * from table where email regexp
^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}$;
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob
I would suggest changing COUNT(*) to COUNT(properties.PropertyID)
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key
- Original Message -
From: Martin E. Koss [EMAIL PROTECTED
javascript command to update the header telling the user what domain it is
checking at the moment.
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key
--
PHP Database Mailing List (http
.
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
please review my script
I have already had it said that the script is fine, please check. IF
it is then I have a set up proiblem which I would also like help to
solve. BUT mysql outside of apache works fine.
I started with an already set up apache so I don't know if mysql was
installed in
Is it possible to migrate data into a table in MS Excel to MySQL?
Export to csv from excel and the mysqlimport command is your friend
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key
Use a Select Distinct. query. See www.mysql.com/doc for more info
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send blank email to [EMAIL PROTECTED]
- Original Message -
From: Chris Payne
To: [EMAIL PROTECTED
- Original Message -
Polite: Well its easier to post and get a reply rather then me going and
serching fo it.;)
Easier for who?
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send blank email to [EMAIL
You need to capitalize the 'L' in Location (HTTP headers are
case-sensitive).
Wrong... you can use
header(location: index.php);
just fine...
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send blank email to [EMAIL
to a move_uploaded_file(path1,path2); command
which is fine...for uploading. But, once a file is uploaded I can't
figure out a way to move or delete it as it is no longer considered an
uploaded file and hence move_uploaded_file() fails. Does anyone know
a way around this?
Thanks.
-Jon Mormino
--
PHP
The only way i could think of doing this is to loop through $result and
assign the rows you want to keep to a new array.
--
Jon Farmer տլ
Systems Programmer, Entanet www.enta.net
Tel +44 (0)1952 428969 Mob +44 (0)7968 524175
PGP Key available, send blank email to [EMAIL PROTECTED
See
http://www.php.net/manual/en/ref.array.php
You will need a multi-dimensional array if your resultset has more than one
field
Regards
Jon
--
Jon Farmer տլ
Systems Programmer, Entanet www.enta.net
Tel +44 (0)1952 428969 Mob +44 (0)7968 524175
PGP Key available, send blank email to [EMAIL
Hello,
We desperately need someone who is knowledgeable in PHP 3 and 4, and MySQL
databases
for a quick job that might take 1-2 hours.
We have a small site that needs its code fixed. The code is PHP based
and is on the Gamespy servers. The code is already done for the most part,
but just
NO! This will return the first 20 characters from the field not the first 20
words. To do that you need to use a regexp in the SQL or explode the result
in php and use the first 20 elements of the array!
Regards
Jon Farmer
Systems Programmer
Entanet International Ltd www.enta.net
Tel 01952
in the ini file that allows permission for this?
No. It's because the user account that the webserver is running under has no
permissions to create a new directory there. You need to chown or chmod to
correct this.
Regards
Jon
Jon Farmer
Systems Programmer
Entanet International Ltd www.enta.net
Tel
Thank You,
Jon Yaggie
www.design-monster.com
And they were singing . . .
'100 little bugs in the code
100 bugs in the code
fix one bug, compile it again
101 little bugs in the code
as i know only IE supports using return to submit. I have had this problem
before and never solved
the script in
case you want to check it out.. Any ideas anyone?
Thanks
Jon
Jon Farmer
Systems Programmer
Entanet International Ltd www.enta.net
Tel 01952 428969
Mob 07968 524175
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
putting a few other mysql function in the conditional. maybe i am on the
wrong path . . would one of the cariable functions like isset() or soemthing check
this?
Thank You,
Jon Yaggie
www.design-monster.com
And they were singing . . .
'100 little bugs in the code
100 bugs
if(mysql_fetch_array($result))
{
$mysql_data_seek($result, 0);
while . . . . .
- Original Message -
From: olinux [EMAIL PROTECTED]
To: Jon Yaggie [EMAIL PROTECTED]; php-db
[EMAIL PROTECTED]
Sent: Monday, August 06, 2001 12:19 AM
Subject: RE: [PHP-DB] checking for results
are the
implications of switching our server to a win32-based server? Will we
have problems with PHP on windows when all of our scripts were
programmed for unix?
MS-SQL is not an option. Stay with a UNIX-based system.
snip
Hope this helps,
Jon Valvatne
Viventus AS
--
PHP Database Mailing List (http
ng forward to is query caching,
which is a great feature for web applications.
Jon Valvatne
Can someone outline the differences between the two? I am partial to MySQL
from experience but want to get a good view of why one is better than the
other.
Also, I've heard that you will lose data
What about:
$sql = "SELECT something FROM table";
$result = mysql_query($sql) or die ("Query failed!");
do_something(); //the query has succeeded if we get to this line
HTH
Jon
-Original Message-
From: Jordan Elver [mailto:[EMAIL PROTECTED]]
Sent: 29 March 2001 12
loop, the first row disappears. When the while loop starts, the
internal pointer points to the second row.
So just remove the first mysql_fetch_row() call, and it should work fine.
Jon Valvatne
On Mon, 26 Mar 2001, Bob Stone wrote:
Dear PHP Helpers,
I have an array created by an mysql
Any idea how to extract table names for a database in informix - like the
sql for mysql SHOW TABLES;
??
J
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators,
easier to implement than the solution described below. Search
for FULLTEXT in the MySQL manual.
Jon Valvatne
On Wed, 14 Mar 2001, Ron Brogden wrote:
At 05:05 PM 3/14/2001 +, you wrote:
I'm putting together a db with articles in it. Would it be better to have two
tables with the main text
http://www.phpwizard.net/
At 03:51 PM 3/12/2001 -0800, Hector Banda wrote:
Hi all,
I saw a posting Last week about somebody talking about an interface to
administer mysql written in php.
Can somebody point me to the link?
Thanks,
From my Apache config:
LoadModule php4_module d:/php/sapi/php4apache.dll
AddType application/x-httpd-php .php .php4
I have 1.3.14 running on NT4, but this should work for you too. Change the
path in the first line to point to wherever your dll is.
HTH
Jon
| -Original Message-
| From
84 matches
Mail list logo
