To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
On 16 December 2004 06:00, neil wrote:
Hi
I am needing to convert a d/m/y date such as 30/11/2004 into the
format that mysql can use ie. 2004-11-20
If I try the following:
This not be what you need, but I think there are some squiggle brackets
missing.
The curly brackets aren't the problem as they're not needed for just
one statement.
Examples at:
http://www.php.net/manual/en/language.control-structures.php#control-structures.if
anna
--
PHP Database Mailing
Hey guys,
I am working on an internal db and i have a script[below] which does some
searching for me, now i am no expert in php but atleast i can always read up,
i want to add some kind of pagination because just incase i search for
somethign in particular i dont want it to display 100
have a look at the PEAR Pager class.
very useful.
_
- Original Message -
From: David Ziggy Lubowa [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 16 December 2004 23:38
Subject: [PHP-DB] Pagination
Hey guys,
I am working on an internal db and i have a
Hi you all,
here is how I am doing in a veery big class of mine.. Course that
uses class's specific terms, but it's very easy to understand.
=
/*
* Fetch paginated results
To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
On 16 December 2004 12:51, Vincent KONIECZEK wrote:
Hi there,
I was testing PHP 4.3.10RC2 with a well-tested web application when I
saw it failed badly.
After a little
Hi there,
I was testing PHP 4.3.10RC2 with a well-tested web application when I
saw it failed badly.
After a little debug, I have found that the problem comes from this SQL
query:
SELECT CONCAT(num) AS k FROM user WHERE uid LIKE '%%'
where user is a table with num as the PK and uid as a
for inserts , yes, it does
for lots of update, deletes it might be worth to periodically drop and
rebuild the indeces
bastien
From: Yemi Obembe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql Index table
Date: Thu, 16 Dec 2004 04:59:40 -0800 (PST)
just want to know if mysql
I've got some strange mysql behavior, wondered if anyone encountered it.
I have a database with some float(4,3) fields.
I have a version of this running on mysql 4.0[.23], and another running
on mysql 4.1[.7].
When I insert, for example, 12 into it - the 4.0 version stores '12.00'
- but the 4.1
-Original Message-
From: Mark Benson [mailto:[EMAIL PROTECTED]
The following SQL statement returns an error. What is wrong with it?
The error is stated as being near 'ON DUPLICATE KEY
UPDATE foo_no='$data[1]', alt_no='$data[2]', descript='$data[3]', pr'
INSERT INTO `foobar2` SET
Thanks, no luck tho...
Here's the code:
if($_SESSION[VIEW] == private)
if (($odbc_conn = odbc_connect(D3_ACTIVE,,)) === false)
die(ODBC connect call failed);
and the result:
Warning: odbc_connect(): SQL error: [Raining Data][ODBC D3 Driver]Logon
failed. Check D3 connection parameters and
Try heading over to www.phpfreaks.com, they have a couple of
tutorials/examples on how to achieve this.
HTH
Graham.
On Thu, 16 Dec 2004 14:38:29 -0800, David Ziggy Lubowa
[EMAIL PROTECTED] wrote:
Hey guys,
I am working on an internal db and i have a script[below] which does some
On Friday 17 December 2004 10:33, Chris Payne wrote:
Im having to send an email with looped results, but Im having problems.
I can send an email no problem, and this code works OUTSIDE of the string,
but not inside, can anyone see what is going wrong?
Please explain what you are doing. A
Hi there,
Well basically I have a list of items and their prices etc . which have
to be sent via email, so I need to store the data in a string. I THOUGHT I
could execute the loop with all the elements (Such as table rows etc ...)
inside a string, but I was wrong, so how can I store the data
On Fri, 17 Dec 2004 13:54, Chris Payne wrote:
Hi there,
Well basically I have a list of items and their prices etc . which
have
to be sent via email, so I need to store the data in a string. I THOUGHT
I could execute the loop with all the elements (Such as table rows etc
...) inside
On Friday 17 December 2004 11:24, Chris Payne wrote:
Please do not top post.
Well basically I have a list of items and their prices etc . which have
to be sent via email, so I need to store the data in a string. I THOUGHT I
could execute the loop with all the elements (Such as table rows
Dear All,
I am using php and mysql the last two years, and I still cannot find the way
to update a field on mysql from php that containts the single quotes ( ` and
' )
Examples
Here is an example of my index.php file. I have to type something on
Comments field
$myquery=INSERT INTO `$table` (`comments`) VALUES ('$mycomments');
$mycomments = addslashes($mycomments);
$myquery = INSERT INTO $table (comments) VALUES ('$mycomments');
See:
http://www.php.net/addslashes
Hope it solves the problem.
nadim attari
--
PHP Database Mailing List
just want to know if mysql automatically update an index table if new datas are
inserted into the original table. for example, if i insert a row of data to a
table I'have already created an index table for, would mysql add the row to the
table?
-
A passion
The following SQL statement returns an error. What is wrong with it? The error
is stated as being near 'ON DUPLICATE KEY UPDATE foo_no='$data[1]',
alt_no='$data[2]', descript='$data[3]', pr'
INSERT INTO `foobar2` SET part_no='$data[0]', foo_no='$data[1]',
alt_no='$data[2]',
Hi list,
and yes I am a newcomer to this list but not to the realm of lamp's deve,
any who I would like to know if any one has any good resources for making a web
page display at 800x600 fix res, no matter what the display is set to in their
machine, I'm moving to php5, just a simple
On Thursday, December 16, 2004, at 05:21PM, Norland, Martin [EMAIL PROTECTED]
wrote:
INSERT INTO `foobar2` SET part_no='$data[0]', foo_no='$data[1]',
alt_no='$data[2]', descript='$data[3]', price='$data[4]',
unit_sale='$data[5]', unit_issue='$data[6]', weight='$data[7]',
brand='$data[8]',
-Original Message-
From: Mark Benson [mailto:[EMAIL PROTECTED]
If I try that it returns:
You have an error in your SQL syntax near 'ON DUPLICATE KEY UPDATE' at
line 1
so I guess something doesn't work there. I also tried it with and
without the line ending and it didn't work either
for displays bigger than 8x6 you can use a div to border the page. for
displays with res smaller, you're s.o.l. you cannot force the browser to a
smaller res.
bastien
From: Kevin Russell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] html display
Date: Thu, 16 Dec 2004 11:02:15
for displays bigger than 8x6 you can use a div to border the page. for
displays with res smaller, you're s.o.l. you cannot force the browser to a
smaller res.
bastien
that's ok, I want it to display 8x6 if you have your display set to that, or if
you have it set to a higher resolution I want
sorry but this has nothing to do with:
1. DBs
2. PHP
3. LAMP
what your talking about is rather trivial clientside (browser) content
styling. making a page display at a fixed width can be done in any
number of ways, the oldest way would be to use a simple table set at the
correct width and place
26 matches
Mail list logo
