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,
> )
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,
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: http://www.
On Thu, Mar 22, 2012 at 7:42 PM, Stuart Dallas 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 (`).
>
> BU
On 2012-03-22, at 8:10 PM, Chris Stinemetz 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/)
> To unsubs
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.
Ser
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
.1, UAE AF 2006 Premium Edition, AF 2012
Plus Edition, Sam440 AOS 4.1.2, Roland DXY-1300 pen plotter, Cutok DC330
cutter/pen plotter
Wanted: RiscOS system, GEOS system (C64/C128), Atari ST, Apple Macintosh
(6502/68k/PPC only)
--- On Tue, 20/3/12, Tom Sparks wrote:
> From: Tom Sparks
> Sub
--- On Tue, 20/3/12, Ashley Sheridan wrote:
From: Ashley Sheridan
Subject: Re: [PHP] mysql list to two-column list
To: "Tom Sparks"
Cc: "php-general"
Received: Tuesday, 20 March, 2012, 10:15 AM
On Mon, 2012-03-19 at 16:09 -0700, Tom Sparks wrote:
--- On
>> 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 c
On Mon, 2012-03-19 at 16:09 -0700, Tom Sparks wrote:
> --- On Tue, 20/3/12, Ashley Sheridan 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
--- On Tue, 20/3/12, Ashley Sheridan 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 the code
>>"
>>
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
On Mon, Mar 5, 2012 at 7:33 AM, 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 are also same PHP
> > 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
On Mon, Feb 27, 2012 at 4:06 AM, 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 are also
> same PHP sc
mysqli - it's what I wanted. thanks
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
To: shahrzad khorrami
On Sat 17 Sep 2011 04:54:13 PM IST, shahrzad khorrami wrote
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
wrote:
> hi all,
> I'm looking for a mysql adapter for create my dal..
> where can I find a good one? and hav
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!?
>[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
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 al
Tim Streater wrote:
> On 11 May 2011 at 19:25, Curtis
Maurand 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
On 11 May 2011 at 19:25, Curtis Maurand 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
On Wed, May 11, 2011 at 2:25 PM, Curtis Maurand 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, "SELECT
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"
wh
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"
wh
> 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
Hi Grega,
Probably you wanna define a primary key, if so, then change from
"uniqueid" to "primary key".
2011/5/6 Curtis Maurand :
>
>
>
> 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 unfa
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), o
On Thu, May 5, 2011 at 10:29, 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 va
Hello Grega,
What do you mean by uniqueid(idlog)?
--
With best regards from Ukraine,
Andre
Skype: Francophile
My blog: http://oire.org/menelion (mostly in Russian)
Twitter: http://twitter.com/m_elensule
Facebook: http://facebook.com/menelion
Original message
From: Greg
BTW, how is the traffic on your site? What's the max connection limit
and timeout set on the MySQL server?
[1] from searching [2] might be the solution to your problem.
Good luck,
Tommy
[1] http://forums.mysql.com/read.php?52,364493,364831#msg-364831
[2] http://www.google.com/search?q=php+SQLST
On Tue, Feb 15, 2011 at 9:57 AM, Matthias Laug wrote:
> 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 '
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> c
> -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
On Mon, Nov 29, 2010 at 14:40, Daniel P. Brown
wrote:
> For your convenience, both have been CC'd on this email.
Actually, PHP-DB (php...@lists.php.net) was accidentally BCC'd.
--
Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting
(866-) 725-4321
http://www.parasane.net/
On Mon, Nov 29, 2010 at 14:35, Don Wieland 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, write to the MySQL
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
On Sun, 21 Nov 2010 11:19:04 -0700
"Ben Miller" wrote:
>
> To help clarify - the 3 tables look something like the following (tableName
> => column,column,column...):
>
> Products => product_id,product_name,product_description... (key =
> product_id)
> Criteria => criteria_id,criteria_title,cri
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 joi
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 jo
On Sat, 20 Nov 2010 13:54:29 -0700
"Ben Miller" 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 have a tables
Since we are just tossing out development environments.
We moved to Aptana in conjunction with TortoiseSVN for a team environment
development timelines dropped.
Personally I do not feel any gui editor makes you a better programmer, maybe
you understand the fundamentals a little less.
Not that
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 for client
Hello Gary,
Actually, what I do here is the following: I create a subdomain called
beta.mysite.com (for me it's http://beta.oire.org/ and
http://beta.gviragon.org/ :-)). There I have a copy of my database and
all of my files. The only difference is the mysql_select_db in the
connect.php file.
Ther
> -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
It's always best practice to have a staging server for testing these sorts of
things.
If in doubt, run it in a transaction, but don't commit it, I.e. roll it back.
That way you'll see if it would run but nothing actually changes.
Thanks,
Ash
http://www.ashleysheridan.co.uk
- Reply message
On Mon, 19 Jul 2010 10:36:40 -0600
"Ashley M. Kirchner" 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 |
> +---+-+-
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 wrote:
> Peter wrote:
>
>> Hi All,
>>
>> I have a table which contain's some dup
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 exe
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 wrote:
> How about this :
>
> CREATE
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 wrote:
> On 19 July 2010 05:44, Peter wrote:
> > Hi All,
> >
> > I have a table
On 19 July 2010 15:01, Richard Quadling wrote:
> On 19 July 2010 05:44, 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
>>
On 19 July 2010 05:44, 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
>
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 FROM
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 List
On Mon, Jul 19, 2010 at 10:44 AM, 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
>
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
>
On Monday 28 June 2010 11:14:53 Andrew Ballard wrote:
> On Mon, Jun 28, 2010 at 10:27 AM, David McGlone 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
On Mon, Jun 28, 2010 at 10:27 AM, David McGlone 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.
I think yo
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 Monday 28 June 2010 09:49:55 Andrew Ballard wrote:
> On Sun, Jun 27, 2010 at 4:08 AM, 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'
> >
On Sun, Jun 27, 2010 at 4:08 AM, 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
no
On Sun, Jun 27, 2010 at 8:29 PM, David McGlone 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 '1'
>
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
>
At 2:12 PM +0300 6/4/10, Tanel Tammik wrote:
Hello,
if there is some webpage content with html tags in database is it possible
to search it without tags?
data : 'you need some styling!'
when i now search for 'you style' i don't want to get any rows! is it
possible?
when i search 'you styling'
On Fri, 2010-06-04 at 15:00 +0300, Tanel Tammik wrote:
> "Ashley Sheridan" wrote in message
> news:1275652880.2217.54.ca...@localhost...
> > On Fri, 2010-06-04 at 14:54 +0300, Tanel Tammik wrote:
> >
> >> "Ashley Sheridan" wrote in message
> >> news:1275652342.2217.51.ca...@localhost...
> >> >
"Ashley Sheridan" wrote in message
news:1275652880.2217.54.ca...@localhost...
> On Fri, 2010-06-04 at 14:54 +0300, Tanel Tammik wrote:
>
>> "Ashley Sheridan" wrote in message
>> news:1275652342.2217.51.ca...@localhost...
>> > On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote:
>> >
>> >> "As
On Fri, 2010-06-04 at 14:54 +0300, Tanel Tammik wrote:
> "Ashley Sheridan" wrote in message
> news:1275652342.2217.51.ca...@localhost...
> > On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote:
> >
> >> "Ashley Sheridan" wrote in message
> >> news:1275651371.2217.46.ca...@localhost...
> >> >
"Ashley Sheridan" wrote in message
news:1275652342.2217.51.ca...@localhost...
> On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote:
>
>> "Ashley Sheridan" wrote in message
>> news:1275651371.2217.46.ca...@localhost...
>> > On Fri, 2010-06-04 at 14:12 +0300, Tanel Tammik wrote:
>> >
>> >> Hel
On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote:
> "Ashley Sheridan" 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
> >> po
"Ashley Sheridan" 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 : 'you need some stylin
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 : 'you need some styling!'
>
> when i now search for 'you style' i don't want to get any rows! is it
> possible?
At 4:20 PM +0430 3/31/10, Parham Doustdar wrote:
Hi there,
Here is a snippet of code... that doesn't work for some reason. Please note
that I have put some
@mysql_query($query) or die(mysql_error());
statements, to see if MySQL gives an error. I receive nothing other than the
file starting to d
On Wed, Mar 31, 2010 at 9:08 AM, Andrew Ballard wrote:
> Nope. All it does is suppress the error message. Just try it:
>
>
> @mysql_connect('localhost', 'baduser', 'badpassword') or die('Could
> not connect');
>
> ?>
>
> Output:
> Could not connect
>
> @mysql_connect('localhost', 'baduser', 'bad
should have put:
> >>
> >> if (mysql_num_rows($result))
> >>
> >> rather than just
> >>
> >> if ($result)
> >>
> >> Thanks!
> >> - Original Message -
> >> From: "Andre Polykanine"
>
t;>
>> if (mysql_num_rows($result))
>>
>> rather than just
>>
>> if ($result)
>>
>> Thanks!
>> ----- Original Message -
>> From: "Andre Polykanine"
>> To: "Parham Doustdar"
>> Cc:
>> Sent: Wednesday,
gt; > - Original Message -
> > From: "Andre Polykanine"
> > To: "Parham Doustdar"
> > Cc:
> > Sent: Wednesday, March 31, 2010 4:41 PM
> > Subject: Re: [PHP] MySQL query not working!
> >
> >
> > > Hell
gt; Thanks!
> - Original Message -
> From: "Andre Polykanine"
> To: "Parham Doustdar"
> Cc:
> Sent: Wednesday, March 31, 2010 4:41 PM
> Subject: Re: [PHP] MySQL query not working!
>
>
> > Hello Parham,
> >
> > Adding to Ash
Hi!
To view error:
you must use mysql_query(). @ before mysql - error supression.
next
you can use the following:
$result=..
if($result){
if(mysql_num_rows($result)){
/* you have record in table */
}else{
/* you haven't */
On Wed, Mar 31, 2010 at 4:11 PM, Andre Polykanine wrote:
> Hel
tween the apostrophes is given.
And, I found out what the problem was; I should have put:
if (mysql_num_rows($result))
rather than just
if ($result)
Thanks!
- Original Message -
From: "Andre Polykanine"
To: "Parham Doustdar"
Cc:
Sent: Wednesday, March 31, 2010
Hello Parham,
Adding to Ash's question, why to use the @ operator before
mysql_query?
--
With best regards from Ukraine,
Andre
Skype: Francophile; Wlm&MSN: arthaelon @ yandex.ru; Jabber: arthaelon @
jabber.org
Yahoo! messenger: andre.polykanine; ICQ: 191749952
Twitter: m_elensule
- Original
On Wed, 2010-03-31 at 16:20 +0430, Parham Doustdar wrote:
> Hi there,
> Here is a snippet of code... that doesn't work for some reason. Please note
> that I have put some
>
> @mysql_query($query) or die(mysql_error());
>
> statements, to see if MySQL gives an error. I receive nothing other than
On Thu, Mar 25, 2010 at 9:19 PM, James Colannino wrote:
> Yeah, the extra select is what I was hoping to avoid :-P The MySQL
> client will return both the number of rows matched and the number of
> rows affected by the query; I was hoping perhaps the PHP API offered a
> way for me to do the same.
Floyd Resler wrote:
> As for as I know, MySQL simply just doesn't report a row as being affected if
> nothing has changed in it. To get the number of matched rows, try doing a
> SELECT query before you do the UPDATE query. I don't know if that will
> produce the results you're looking for, but
On Mar 25, 2010, at 5:10 PM, James Colannino wrote:
> Hey everyone,
>
> I have a question. If I do a mysql query that updates a column in a row
> to the same value, I get 0 rows affected. However, I also get 1 or more
> matched rows. Is there a way that I can return the number of matched
> ro
Hi Don,
i work for the company simplynetworks in germany. I have access to may
programmers with the best quality to the best prices. We work quick and
no dirty ;-)
I am programmer too and my company offer you the best object oriented
software of the market. Some references of my clients in Germ
On Thu, Feb 11, 2010 at 09:49:02PM -0600, Joseph Thayne wrote:
> I was going to write an example as to what should happen instead of what
> actually does when id dawned on me why MySQL works the way it does. One of
> the biggest complaints people have with MySQL is in speed.
The much-vaunted s
e work for you and you can
then focus on other things such as data integrity and general processing
speed?
Joseph
-Original Message-
From: Paul M Foster [mailto:pa...@quillandmouse.com]
Sent: Thursday, February 11, 2010 9:15 PM
To: php-general@lists.php.net
Subject: Re: [PHP] Mysql state
On Fri, Feb 12, 2010 at 09:44:47AM +1030, James McLean wrote:
> On Fri, Feb 12, 2010 at 9:31 AM, Joseph Thayne wrote:
> > As for the backticks, they are required because of MySQL, not because of
> > phpMyAdmin. The issue was not that phpMyAdmin uses backticks, it is that
> > MySQL pretty much re
Yeah, I am a lot more descriptive now. I ran into it quite a bit when I
was first starting out.
James McLean wrote:
On Fri, Feb 12, 2010 at 9:31 AM, Joseph Thayne wrote:
As for the backticks, they are required because of MySQL, not because of
phpMyAdmin. The issue was not that phpMyAdmin
On Fri, Feb 12, 2010 at 9:31 AM, Joseph Thayne wrote:
> As for the backticks, they are required because of MySQL, not because of
> phpMyAdmin. The issue was not that phpMyAdmin uses backticks, it is that
> MySQL pretty much requires them when naming a field the same as an internal
> function to m
On Fri, Feb 12, 2010 at 9:31 AM, Jochem Maas wrote:
> Op 2/11/10 10:51 PM, James McLean schreef:
>> My personal preference these days is to use Curly braces around
>> variables in strings such as this, I always find excessive string
>> concatenation such as is often used when building SQL queries
Op 2/11/10 10:51 PM, James McLean schreef:
> On Fri, Feb 12, 2010 at 8:27 AM, Joseph Thayne wrote:
>>
>> Actually, the syntax is just fine. I personally would prefer it the way you
>> mention, but there actually is nothing wrong with the syntax.
>>
>>> The ,'$date1'"." is not correct syntax, chan
That is a good idea to use the curly braces. I consistently forget
about them, and fell like an idiot every time I am reminded of them.
As for the backticks, they are required because of MySQL, not because of
phpMyAdmin. The issue was not that phpMyAdmin uses backticks, it is
that MySQL pret
On Fri, Feb 12, 2010 at 8:27 AM, Joseph Thayne wrote:
>
> Actually, the syntax is just fine. I personally would prefer it the way you
> mention, but there actually is nothing wrong with the syntax.
>
>> The ,'$date1'"." is not correct syntax, change it to ,'".$date."'
My personal preference thes
Actually, the syntax is just fine. I personally would prefer it the way
you mention, but there actually is nothing wrong with the syntax.
The ,'$date1'"." is not correct syntax, change it to ,'".$date."'
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.ph
Thank you.
You were right on the money, "hour" was the problem and the tick marks
solved it. I spent 3 hours trying to figure out why I never got an error but
there was no insert and php myadmin does add the tick marks automatically.
Probably a good habit to always use the tick marks.
Learn some
Also, in PHP you should NOT put the last semi-colon at the end of your SQL
statement. http://www.php.net/manual/en/function.mysql-query.php
On Feb 11, 2010, at 1:26 PM, Joseph Thayne wrote:
> Try putting tick marks (`) around the field and table names. So your SQL
> query would then look like
1 - 100 of 1780 matches
Mail list logo