There's no need for it to be a flame war. The mysql extension is officially
not recommended for writing new code, so anyone using it should be informed
of this fact. I think it should consist of more than don't use that, but
at the very least that should cause the questioner to want to know why.
In my database design, I tend to store some variable that is meant to be acting
as a ROLE or TYPE as SMALLINT. For example :
CREATE TABLE `house` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` smallint(11) NOT NULL,
)
And in php, I do
define('HOUSE_SMALL_TYPE',
On Mar 13, 2013, at 10:35 AM, Kevin Peterson wrote:
In my database design, I tend to store some variable that is meant to be
acting as a ROLE or TYPE as SMALLINT. For example :
CREATE TABLE `house` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` smallint(11) NOT NULL,
Am 13.03.13 10:35, schrieb Kevin Peterson:
In my database design, I tend to store some variable that is meant to be
acting as a ROLE or TYPE as SMALLINT. For example :
CREATE TABLE `house` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` smallint(11) NOT NULL,
)
And
Hello all:
I had a few questions.
First, I'm using php-fastcgi with nginx for my primary web server. I was
wondering what sorts of optimizations exist to make this process a lot
faster.
Second, I'm setting up a custom application, and it contains an
authentication module for
Greetings,
I have a site that I am developing and I am looking to partner/
developer with great php/mySQL skills (for share of potential profits)
to assist me in finishing this site. I am looking for someone who can
invest (like myself) their time and skills to complete the site
Hello List,
Is it possible to create a MySQL table with characters such as . and
[] in the column headers? If so would you explain how?
Thank you,
Chris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On 23 Mar 2012, at 00:10, Chris Stinemetz wrote:
Is it possible to create a MySQL table with characters such as . and
[] in the column headers? If so would you explain how?
Try putting the column names in backticks (`).
BUT... whatever the reason why you want to do that, IT'S WRONG.
On 2012-03-22, at 8:10 PM, Chris Stinemetz chrisstinem...@gmail.com wrote:
Hello List,
Is it possible to create a MySQL table with characters such as . and
[] in the column headers? If so would you explain how?
Thank you,
Chris
--
PHP General Mailing List (http://www.php.net/)
On Thu, Mar 22, 2012 at 7:42 PM, Stuart Dallas stu...@3ft9.com wrote:
On 23 Mar 2012, at 00:10, Chris Stinemetz wrote:
Is it possible to create a MySQL table with characters such as . and
[] in the column headers? If so would you explain how?
Try putting the column names in backticks (`).
Leave the past behind. You're moving forward. And - for whatever reason
that they were used originally, you now have the opportunity to rid yourself
of column names that must be a pia to type all the time.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
I have a members list witch I print out once a week,
I would like to make the list into two-column list, but I dont know where to
start looking to change the code?
here is the code
$result = mysql_query(SELECT * FROM customers ORDER BY LastName);
while($row = mysql_fetch_array($result))
{
On Mon, 2012-03-19 at 15:43 -0700, Tom Sparks wrote:
I have a members list witch I print out once a week,
I would like to make the list into two-column list, but I dont know where to
start looking to change the code?
here is the code
$result = mysql_query(SELECT * FROM customers ORDER
--- On Tue, 20/3/12, Ashley Sheridan a...@ashleysheridan.co.uk wrote:
On Mon, 2012-03-19 at 15:43 -0700, Tom Sparks wrote:
I have a members list witch I print out once a week,
I would like to make the list into two-column list, but I dont know where
to start looking to change the code?
here is
On Mon, 2012-03-19 at 16:09 -0700, Tom Sparks wrote:
--- On Tue, 20/3/12, Ashley Sheridan a...@ashleysheridan.co.uk wrote:
On Mon, 2012-03-19 at 15:43 -0700, Tom Sparks wrote:
I have a members list witch I print out once a week,
I would like to make the list into two-column list, but I
my goal is to do something phonebook like
Your reply of 9 words adds no extra information. Rather than have us all
guess what you want, try and tell us specifically what it is that you
want.
Hi Tom
I *think* what want to be asking is, what HTML do I change/add such that my
data coming
--- On Tue, 20/3/12, Ashley Sheridan a...@ashleysheridan.co.uk wrote:
From: Ashley Sheridan a...@ashleysheridan.co.uk
Subject: Re: [PHP] mysql list to two-column list
To: Tom Sparks tom_a_spa...@yahoo.com.au
Cc: php-general php-general@lists.php.net
Received: Tuesday, 20 March, 2012, 10:15 AM
tom_a_spa...@yahoo.com.au
Subject: Re: [PHP] mysql list to two-column list
To: a...@ashleysheridan.co.uk
Cc: php-general php-general@lists.php.net
Received: Tuesday, 20 March, 2012, 10:41 AM
--- On Tue, 20/3/12, Ashley Sheridan
a...@ashleysheridan.co.uk
wrote:
From: Ashley Sheridan
On 19 Mar 2012, at 22:43, Tom Sparks wrote:
I have a members list witch I print out once a week,
I would like to make the list into two-column list, but I dont know where to
start looking to change the code?
here is the code
$result = mysql_query(SELECT * FROM customers ORDER BY
I have a MySQL server A, a server B with PHP 5.3.8 and a server C with
PHP 5.3.3. I'm connecting to the MySQL server on A via TCP from B and C
using an internal network. Server B and C use the same PHP application.
There are also same PHP scripts that get data from the database and then
On Mon, Mar 5, 2012 at 7:33 AM, php-l...@dubistmeinheld.de wrote:
I have a MySQL server A, a server B with PHP 5.3.8 and a server C with
PHP 5.3.3. I'm connecting to the MySQL server on A via TCP from B and C
using an internal network. Server B and C use the same PHP application.
There
Hi,
I have a MySQL server A, a server B with PHP 5.3.8 and a server C with PHP
5.3.3. I'm connecting to the MySQL server on A via TCP from B and C using an
internal network. Server B and C use the same PHP application. There are also
same PHP scripts that get data from the database and then
On Mon, Feb 27, 2012 at 4:06 AM, php-l...@dubistmeinheld.de wrote:
Hi,
I have a MySQL server A, a server B with PHP 5.3.8 and a server C with PHP
5.3.3. I'm connecting to the MySQL server on A via TCP from B and C using an
internal network. Server B and C use the same PHP application. There
Bear with me here. I have a problem with PHP and MySQL that's been stumping
me for a couple of days now. I'm not even sure how to describe it, so I'll
just do my best.
There's a row in our bugs database that looks like every other row in the
table, but when it's pulled from the database and
hi all,
I'm looking for a mysql adapter for create my dal..
where can I find a good one? and have you ever written a dal with a mysql
adapter?
in my dal I want to pass parameters to sql sting, for example like
following:
$db-query($sql, array($name, $family))
thanks,
Shahrzad Khorrami
hi,
If you are building your own dal I guess you would have to build your own
adapter,
simply use mysqli function and wrap them in a class.
On 17 September 2011 12:24, shahrzad khorrami
shahrzad.khorr...@gmail.comwrote:
hi all,
I'm looking for a mysql adapter for create my dal..
where can I
Sorry, I clicked the 'reply' button instead of reply to all.
Original Message
Subject: Re: [PHP] mysql adapter and DAL
Date: Sat, 17 Sep 2011 19:07:48 +0530
From: Nilesh Govindarajan cont...@nileshgr.com
To: shahrzad khorrami shahrzad.khorr...@gmail.com
On Sat 17 Sep 2011 04:54
mysqli - it's what I wanted. thanks
$ime=$_COOKIE['user'];
$dolgF=filesize($filename)
INSERT INTO `friendlyCMS`.`log` (`imepriimek`, `clock`, `action`,
`onfile`, `filesize`) VALUES ( $ime, CURRENT_TIMESTAMP,
'saved',$filename, $dolgF);
What is wrong with this?
PS First column of the log table is idlog primary key autoincrement
not
I think it's not the best place to send it but:
$dolgF is not closed with ; ...and the insert is not in a variable!
(And also I think it's not a good way using COOKIE in PHP because we have
sessions)
So the answer is: the all.. :D -or what's the full part you use for insert
int this source!?
Sean Greenslade wrote:
[MASSIVE
SNIP]
Well, from what I saw while wading through your
code, you allow
unsanitized
variables to be
concatenated to your queries. Big no-no! For ANY
client-generated variable, always sanitize with
mysql_real_escape_string.
In
fact, sanitize all your
[SNIP]
added and else clause.
while ($_parent != 0)
{
if
($num_rows 0)
{
perform some action
}
else
{
$_parent =
0;
}
}
and that solved the
problem.
Thank you, everyone for your help.
Curtis
A small remark:
I think it is good programming practice to
On 11 May 2011 at 19:25, Curtis Maurand cur...@maurand.com wrote:
$_cartTotal=$0.00;
Surely that should be:
$_cartTotal = 0.00;
tim
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Tim Streater wrote:
On 11 May 2011 at 19:25, Curtis
Maurand cur...@maurand.com wrote:
$_cartTotal=$0.00;
Surely that should
be:
$_cartTotal = 0.00;
Good
pickup. I missed that. I didn't write the code, I'm just
trying to figure out what's going on.
Thanks, I'll look at
that. --C
I'm running PHP 5.3.6, Mysql 5.1.51 and Apache 2.2.17
I have
code that does a simple mysql_query(); the query on the commandline
returns an empty set. when run via PHP and the web server, the page
hangs, it never gets to the if (mysql_num_rows($result) 0) {}. and
the queries per second on
Does anyone have any ideas?
Sounds like it's getting caught in a loop. Post the whole script for
best results.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Marc Guay wrote:
Does anyone have any ideas?
Sounds like it's getting caught in a loop. Post the whole script
for
best results.
It looks like the site is
under attack, because I keep seeing the query, SELECT catagory_parent FROM
t_catagories where catagory_ID= .
$_currentCat
where
Marc Guay wrote:
Does anyone have any ideas?
Sounds like it's getting caught in a loop. Post the whole script
for
best results.
It looks like the site is
under attack, because I keep seeing the query, SELECT catagory_parent FROM
t_catagories where catagory_ID= .
$_currentCat
where
On Wed, May 11, 2011 at 2:25 PM, Curtis Maurand cur...@maurand.com wrote:
Marc Guay wrote:
Does anyone have any ideas?
Sounds like it's getting caught in a loop. Post the whole script
for
best results.
It looks like the site is
under attack, because I keep seeing the query,
Hi Grega,
Probably you wanna define a primary key, if so, then change from
uniqueid to primary key.
2011/5/6 Curtis Maurand cur...@maurand.com:
engine=
--C
Grega Leskovšek wrote:
Can smbd please look at this sentence - I got an error and do
not
know how to fix it - I am still very
engine=
--C
Grega Leskov¹ek wrote:
Can smbd please look at this sentence - I got an error and do
not
know how to fix it - I am still very unfamiliar with
MYSQL:
CREATE TABLE log ( idlog int auto_increment
not null, imepriimek
varchar(50), clock timestamp, action
varchar(30),
Can smbd please look at this sentence - I got an error and do not
know how to fix it - I am still very unfamiliar with MYSQL:
CREATE TABLE log ( idlog int auto_increment not null, imepriimek
varchar(50), clock timestamp, action varchar(30), onfile
varchar(100), filesize float(6,2),
: Grega Leskovšek legr...@gmail.com
To: php-general
Date created: , 5:29:44 PM
Subject: [PHP] mysql error
Can smbd please look at this sentence - I got an error and do not
know how to fix it - I am still very unfamiliar with MYSQL:
CREATE TABLE log ( idlog int auto_increment not null
On Thu, May 5, 2011 at 10:29, Grega Leskovšek legr...@gmail.com wrote:
Can smbd please look at this sentence - I got an error and do not
know how to fix it - I am still very unfamiliar with MYSQL:
CREATE TABLE log ( idlog int auto_increment not null, imepriimek
varchar(50), clock
I was previously on PHP 5.1.6 and was using the following code:
$dbr = mysql_unbuffered_query($query, $this-con);
while($row = mysql_fetch_array($dbr, $assoc ? MYSQL_ASSOC : MYSQL_NUM))
$this-result[] = $row;
$this-rows = mysql_num_rows($dbr);
It worked properly. The documentation at
Hi.
I have a table called images with 4 columns - `image_id`, `item_name`,
`image_url`, `image_views`
(Where image_id is UNIQUE and AUTO-INCREMENT).
Sometimes, there might be many items with the same name (but not with the
same url).
I want to make sure that each item name has at most 3 images
On 11-02-16 11:37 AM, דניאל דנון wrote:
Hi.
I have a table called images with 4 columns - `image_id`, `item_name`,
`image_url`, `image_views`
(Where image_id is UNIQUE and AUTO-INCREMENT).
Sometimes, there might be many items with the same name (but not with the
same url).
I want to make
On 11-02-16 11:55 AM, Robert Cummings wrote:
On 11-02-16 11:37 AM, דניאל דנון wrote:
Hi.
I have a table called images with 4 columns - `image_id`, `item_name`,
`image_url`, `image_views`
(Where image_id is UNIQUE and AUTO-INCREMENT).
Sometimes, there might be many items with the same name
Hey there,
I've just migrated to Mysql 5.5 from source and it works like a charm. Still
every now and then (in intervals of approximatly an hour) I get the following
error:
Error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2013]
Lost connection to MySQL server at
Hi all,
I have to perform a mysql query in a table with millions of records.
I've full-text indexed my search field and I'm searching with MATCH AGAINST.
But there is a problem. In this field there are company names that
contain dots, for istance I've PO.SE. srl and I want to find it if
the
-Original Message-
From: Barbara Picci [mailto:barbara.pi...@sardi.it]
Sent: Monday, January 24, 2011 4:51 AM
To: php-general@lists.php.net
Subject: [PHP] Mysql search query ignoring dots
Hi all,
I have to perform a mysql query in a table with millions of records.
I've full
Hi,
Monday, January 24, 2011, 10:50:41 PM, you wrote:
BP Hi all,
BP I have to perform a mysql query in a table with millions of records.
BP I've full-text indexed my search field and I'm searching with MATCH AGAINST.
BP But there is a problem. In this field there are company names that
BP
Hi all,
Is there a list/form to get some help on compiling mySQL queries? I am
executing them via PHP, but do not want to ask for help here if it is
no the appropriate forum. Thanks ;-)
Don
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Mon, Nov 29, 2010 at 14:35, Don Wieland d...@dwdataconcepts.com wrote:
Hi all,
Is there a list/form to get some help on compiling mySQL queries? I am
executing them via PHP, but do not want to ask for help here if it is no the
appropriate forum. Thanks ;-)
Yes.
For MySQL queries,
On Mon, Nov 29, 2010 at 14:40, Daniel P. Brown
daniel.br...@parasane.net wrote:
For your convenience, both have been CC'd on this email.
Actually, PHP-DB (php...@lists.php.net) was accidentally BCC'd.
--
/Daniel P. Brown
Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting
Greetings fellow PHP developers!
I am looking of a relatively simple way to export a whole database into
an Excel file. I have several methods to export tables to Excel files
but unfortunately I have failed to export a whole database!
Can someone be so kind to point me in the right
On Fri, 2010-11-26 at 15:21 +0200, Sotiris Katsaniotis wrote:
Greetings fellow PHP developers!
I am looking of a relatively simple way to export a whole database into
an Excel file. I have several methods to export tables to Excel files
but unfortunately I have failed to export a whole
SELECT * FROM products p LEFT JOIN criteria_values cv ON p.key=cv.key LEFT JOIN
criteria c ON cv.key=c.key WHERE c.value IS NOT NULL
Hard to answer without more detail, but I am guessing the answer will be
something like the above. Your question makes it hard to understand whether c
or cv is
SELECT * FROM products p LEFT JOIN criteria_values cv ON p.key=cv.key LEFT
JOIN criteria c ON cv.key=c.key WHERE c.value IS NOT NULL
Hard to answer without more detail, but I am guessing the answer will be
something like the above. Your question makes it hard to understand whether
c or cv is
Hi,
I'm building a website for a client in which I need to compare their
products, side-by-side, but only include criteria for which all selected
products have a value for that criteria.
In my database (MySQL), I have a tables named products,criteria and
criteria_values
If I have something like
I'm going to jump in and throw in my 2 cents...
Have you used dreamweaver?
I would suggest Dreamweaver to any new programmer beginning php/mysql.
It helped me out tremendously in the beginning. I'm not an advanced programmer
with hand coding classes yet, but I can get any job completed
-Original Message-
From: Ben Miller [mailto:biprel...@gmail.com]
Sent: Saturday, November 20, 2010 3:54 PM
To: 'php-general'
Subject: [PHP] MySQL Query Help
Hi,
I'm building a website for a client in which I need to compare their
products, side-by-side, but only include criteria
On Sat, 20 Nov 2010 13:54:29 -0700
Ben Miller biprel...@gmail.com wrote:
Hi,
I'm building a website for a client in which I need to compare their
products, side-by-side, but only include criteria for which all selected
products have a value for that criteria.
In my database (MySQL), I
: Gary php-gene...@garydjones.name
To: php-general@lists.php.net php-general@lists.php.net
Date: Tuesday, November 16, 2010, 3:35:12 PM
Subject: [PHP] mysql help (sorry, a bit OT)
Is there a way to check the syntax of a query, short of running it? I've
got an insert to do (but of course it's a valid
-
From: Gary php-gene...@garydjones.name
Date: Tue, Nov 16, 2010 13:35
Subject: [PHP] mysql help (sorry, a bit OT)
To: php-general@lists.php.net
Is there a way to check the syntax of a query, short of running it? I've
got an insert to do (but of course it's a valid question for any query
-Original Message-
From: Gary [mailto:php-gene...@garydjones.name]
Sent: Tuesday, November 16, 2010 5:35 AM
To: php-general@lists.php.net
Subject: [PHP] mysql help (sorry, a bit OT)
Is there a way to check the syntax of a query, short of running it? I've
got an
insert to do
Subject: [PHP] Open Source PHP/ mySQL Project Management
Hi,
I don't know if it meets all of the features you enumerated but Mantis
(http://www.mantisbt.org/) is very good, and it is PHP+MySQL (or
Postgres, or MSSQL).
Jonathan
On Thu, Nov 11, 2010 at 7:23 PM, Don Wieland d
Redmine is (I think) one of the best out there. It is written in ruby
and does have all you need + some more.
Cheers!
On Fri, Nov 12, 2010 at 12:23 AM, Don Wieland d...@dwdataconcepts.com wrote:
Hi gang,
I am looking into Project Management apps for my projects. Any suggestions:
I am
Hi gang,
I am looking into Project Management apps for my projects. Any
suggestions:
I am interested in tracking Projects, Milestones, Tickets, Files,
Discussions, Documents, Time Tracking, etc... Also, would like to have
the system have robust email integration Reminders, Email Ticket
d...@dwdataconcepts.com
To: php-general@lists.php.net php-general@lists.php.net
Date: Friday, November 12, 2010, 12:23:11 AM
Subject: [PHP] Open Source PHP/ mySQL Project Management
Hi gang,
I am looking into Project Management apps for my projects. Any
suggestions:
I am interested in tracking
Hi,
I don't know if it meets all of the features you enumerated but Mantis
(http://www.mantisbt.org/) is very good, and it is PHP+MySQL (or
Postgres, or MSSQL).
Jonathan
On Thu, Nov 11, 2010 at 7:23 PM, Don Wieland d...@dwdataconcepts.com wrote:
Hi gang,
I am looking into Project Management
...@gmail.com
To: Don Wieland d...@dwdataconcepts.com
Date: Friday, November 12, 2010, 3:00:32 AM
Subject: [PHP] Open Source PHP/ mySQL Project Management
Hi,
I don't know if it meets all of the features you enumerated but Mantis
(http://www.mantisbt.org/) is very good, and it is PHP+MySQL (or
Postgres
Hi.
I need a protected directory in my server that only the authenticated user
can reach all files in that folder(file type is zip and picture or a web
page, maybe). I save user ID and passwords in mysql database. today I tried
to use htaccess but mod_auth_mysql isn't installed on my server.
I
On Thu, 2010-08-12 at 02:02 +0430, Ali Asghar Toraby Parizy wrote:
Hi.
I need a protected directory in my server that only the authenticated user
can reach all files in that folder(file type is zip and picture or a web
page, maybe). I save user ID and passwords in mysql database. today I
On Mon, 19 Jul 2010 10:36:40 -0600
Ashley M. Kirchner ash...@pcraft.com wrote:
mysql select * from table where id='1';
+---+-+-+---+
| 1 | 123 | 0.0 | C |
| 1 | 234 | 0.1 | D |
| 1 | 345 | 0.0 | D |
| 1 | 456 | 0.1 | C |
| 1 | 567 | 0.1 | G |
Dear all,
I'm a newbie, need your help.
Now I am building a databasea using MySQL and PHP, I want to put two tables
in one searching, the two are in one database.
$query = SELECT SQL_CALC_FOUND_ROWS * FROM table1 WHERE .implode( AND
, $data);
$number = SELECT FOUND_ROWS();
How can I
I am very keen to see a closure to this thread so that I can add to my
snippets.
Let's all know what worked best out of many solutions that have been
proposed.
--Shreyas
On Tue, Jul 20, 2010 at 10:07 AM, Jim Lucas li...@cmsws.com wrote:
Peter wrote:
Hi All,
I have a table which contain's
Use distinct.
SELECT DISTINCT COLUMN1, COLUMN2 FROM ... ...
Shiplu Mokadd.im
My talks, http://talk.cmyweb.net
Follow me, http://twitter.com/shiplu
SUST Programmers, http://groups.google.com/group/p2psust
Innovation distinguishes bet ... ... (ask Steve Jobs the rest)
--
PHP General Mailing
Hi Shiplu,
Thanks for reply.
Distinct function hide the duplicate records while we selecting the
record through the Query
i want to remove the duplicate entries in my table
i need a Delete Query instead of Select Query
shiplu wrote:
Use distinct.
SELECT DISTINCT COLUMN1, COLUMN2
On 19 July 2010 05:44, Peter pet...@egrabber.com wrote:
Hi All,
I have a table which contain's some duplicate rows. I just want to delete
the duplicate records alone
not original records.
Assume my table as look as below
column1 column2
1
a
1
a
2
b
3
c
On 19 July 2010 15:01, Richard Quadling rquadl...@gmail.com wrote:
On 19 July 2010 05:44, Peter pet...@egrabber.com wrote:
Hi All,
I have a table which contain's some duplicate rows. I just want to delete
the duplicate records alone
not original records.
Assume my table as look as below
How about this :
CREATE TEMPORARY TABLE bad_temp1 (id INT,name VARCHAR(20));
INSERT INTO bad_temp1 (id,name) SELECT DISTINCT id,name FROM SAMPLE;
Regards,
Shreyas
On Mon, Jul 19, 2010 at 7:31 PM, Richard Quadling rquadl...@gmail.comwrote:
On 19 July 2010 05:44, Peter pet...@egrabber.com
I may be going at this completely wrong but at the moment I'm
stuck. I have a DB from a client and need to do several searches on
it. This one sentence is important because it's their DB, not mine. So
I can't modify the way the DB was created in the first place, I can only
work with
Just to add more perspective :
You will have a table with DISTINCT values.
Drop the initial table (better take a back-up); copy from the temporary
table which will have only DISTINCT values.
Regards,
Shreyas
On Mon, Jul 19, 2010 at 7:58 PM, Shreyas Agasthya shreya...@gmail.comwrote:
How
Peter wrote:
Hi All,
I have a table which contain's some duplicate rows. I just want to
delete the duplicate records alone
not original records.
Assume my table as look as below
column1 column2
1
a
1
a
2
b
3
c
3
c
i want the above table need to be as below, After
Hi All,
I have a table which contain's some duplicate rows. I just want to
delete the duplicate records alone
not original records.
Assume my table as look as below
column1 column2
1
a
1
a
2
b
3
c
3
c
i want the above table need to be as below,
On Mon, Jul 19, 2010 at 10:14:30AM +0530, Peter wrote:
Hi All,
I have a table which contain's some duplicate rows. I just want to
delete the duplicate records alone
not original records.
Assume my table as look as below
column1 column2
1
a
1
a
2
b
3
c
3
On Mon, Jul 19, 2010 at 10:44 AM, Peter pet...@egrabber.com wrote:
Hi All,
I have a table which contain's some duplicate rows. I just want to delete
the duplicate records alone
not original records.
Assume my table as look as below
column1 column2
1
a
1
a
2
b
On Sun, Jun 27, 2010 at 4:08 AM, Tanel Tammik keevit...@gmail.com wrote:
Hello,
how to select only if value is present?
$query = $db-query(select menus.id, menus.name,
case
when panels.id is not null then '1'
end as hiddenpanel
from . \DB_MENUS . as menus
On Monday 28 June 2010 09:49:55 Andrew Ballard wrote:
On Sun, Jun 27, 2010 at 4:08 AM, Tanel Tammik keevit...@gmail.com wrote:
Hello,
how to select only if value is present?
$query = $db-query(select menus.id, menus.name,
case
when panels.id is not null then '1'
On Sunday 27 June 2010 22:12:41 Brandon Rampersad wrote:
no
At least smack me and give us an explanation. :-)
--
Blessings,
David M.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Mon, Jun 28, 2010 at 10:27 AM, David McGlone da...@dmcentral.net wrote:
Tanel, we both learned something. I didn't fully understand join myself yet,
but I think I do now.
but let me ask this if the join wasn't there would an if statement like I
mentioned have worked?
Blessings,
David M.
On Monday 28 June 2010 11:14:53 Andrew Ballard wrote:
On Mon, Jun 28, 2010 at 10:27 AM, David McGlone da...@dmcentral.net wrote:
Tanel, we both learned something. I didn't fully understand join myself
yet, but I think I do now.
but let me ask this if the join wasn't there would an if
On Sunday 27 June 2010 04:08:24 Tanel Tammik wrote:
Hello,
how to select only if value is present?
$query = $db-query(select menus.id, menus.name,
case
when panels.id is not null then '1'
end as hiddenpanel
from . \DB_MENUS . as menus
left join
no
On Sun, Jun 27, 2010 at 8:29 PM, David McGlone da...@dmcentral.net wrote:
On Sunday 27 June 2010 04:08:24 Tanel Tammik wrote:
Hello,
how to select only if value is present?
$query = $db-query(select menus.id, menus.name,
case
when panels.id is not null then
Hello,
if there is some webpage content with html tags in database is it possible
to search it without tags?
data : 'div style=you need some styling!/div'
when i now search for 'you style' i don't want to get any rows! is it
possible?
when i search 'you styling' i get the row!
Br
Tanel
On Fri, 2010-06-04 at 14:12 +0300, Tanel Tammik wrote:
Hello,
if there is some webpage content with html tags in database is it possible
to search it without tags?
data : 'div style=you need some styling!/div'
when i now search for 'you style' i don't want to get any rows! is it
Ashley Sheridan a...@ashleysheridan.co.uk wrote in message
news:1275651371.2217.46.ca...@localhost...
On Fri, 2010-06-04 at 14:12 +0300, Tanel Tammik wrote:
Hello,
if there is some webpage content with html tags in database is it
possible
to search it without tags?
data : 'div
On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote:
Ashley Sheridan a...@ashleysheridan.co.uk wrote in message
news:1275651371.2217.46.ca...@localhost...
On Fri, 2010-06-04 at 14:12 +0300, Tanel Tammik wrote:
Hello,
if there is some webpage content with html tags in database is it
Ashley Sheridan a...@ashleysheridan.co.uk wrote in message
news:1275652342.2217.51.ca...@localhost...
On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote:
Ashley Sheridan a...@ashleysheridan.co.uk wrote in message
news:1275651371.2217.46.ca...@localhost...
On Fri, 2010-06-04 at 14:12
1 - 100 of 3625 matches
Mail list logo
