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
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:
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
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
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
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
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),
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:
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
-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
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
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
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
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
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
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
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.
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
-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 (but
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 |
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
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
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
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
On Fri, 2010-06-04 at 14:54 +0300, Tanel Tammik wrote:
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
Ashley Sheridan a...@ashleysheridan.co.uk wrote in message
news:1275652880.2217.54.ca...@localhost...
On Fri, 2010-06-04 at 14:54 +0300, Tanel Tammik wrote:
Ashley Sheridan a...@ashleysheridan.co.uk wrote in message
news:1275652342.2217.51.ca...@localhost...
On Fri, 2010-06-04 at 14:44
On Fri, 2010-06-04 at 15:00 +0300, Tanel Tammik wrote:
Ashley Sheridan a...@ashleysheridan.co.uk wrote in message
news:1275652880.2217.54.ca...@localhost...
On Fri, 2010-06-04 at 14:54 +0300, Tanel Tammik wrote:
Ashley Sheridan a...@ashleysheridan.co.uk wrote in message
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 : '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
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 the
Hello Parham,
Adding to Ash's question, why to use the @ operator before
mysql_query?
--
With best regards from Ukraine,
Andre
Skype: Francophile; WlmMSN: arthaelon @ yandex.ru; Jabber: arthaelon @
jabber.org
Yahoo! messenger: andre.polykanine; ICQ: 191749952
Twitter: m_elensule
- Original
Subject: Re: [PHP] MySQL query not working!
Hello Parham,
Adding to Ash's question, why to use the @ operator before
mysql_query?
--
With best regards from Ukraine,
Andre
Skype: Francophile; WlmMSN: arthaelon @ yandex.ru; Jabber: arthaelon @
jabber.org
Yahoo! messenger: andre.polykanine; ICQ
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
...@gmail.com
Cc: php-general@lists.php.net
Sent: Wednesday, March 31, 2010 4:41 PM
Subject: Re: [PHP] MySQL query not working!
Hello Parham,
Adding to Ash's question, why to use the @ operator before
mysql_query?
--
With best regards from Ukraine,
Andre
Skype: Francophile; WlmMSN
, 2010 4:41 PM
Subject: Re: [PHP] MySQL query not working!
Hello Parham,
Adding to Ash's question, why to use the @ operator before
mysql_query?
--
With best regards from Ukraine,
Andre
Skype: Francophile; WlmMSN: arthaelon @ yandex.ru; Jabber: arthaelon
@
jabber.org
-
From: Andre Polykanine an...@oire.org
To: Parham Doustdar parha...@gmail.com
Cc: php-general@lists.php.net
Sent: Wednesday, March 31, 2010 4:41 PM
Subject: Re: [PHP] MySQL query not working!
Hello Parham,
Adding to Ash's question, why to use the @ operator before
mysql_query
an...@oire.org
To: Parham Doustdar parha...@gmail.com
Cc: php-general@lists.php.net
Sent: Wednesday, March 31, 2010 4:41 PM
Subject: Re: [PHP] MySQL query not working!
Hello Parham,
Adding to Ash's question, why to use the @ operator before
mysql_query?
--
With best
On Wed, Mar 31, 2010 at 9:08 AM, Andrew Ballard aball...@gmail.com wrote:
Nope. All it does is suppress the error message. Just try it:
?php
@mysql_connect('localhost', 'baduser', 'badpassword') or die('Could
not connect');
?
Output:
Could not connect
?php
@mysql_connect('localhost',
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
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
rows,
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 it
On Thu, Mar 25, 2010 at 9:19 PM, James Colannino ja...@colannino.orgwrote:
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
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
Try putting tick marks (`) around the field and table names. So your
SQL query would then look like:
INSERT INTO `history` (`v_id`, `hour`, `visits`, `date`) VALUES (45, 0,
59, '2010 01 27');
This is a good practice to get into. The problem is that MySQL allows
you to create tables and
james stojan wrote on 11/02/2010 22:21:
$query=INSERT INTO upload_history (v_id,hour,visits,date) VALUES
(.$v_id.,.$hour.,.$visits.,'$date1'.);;
The ,'$date1'. is not correct syntax, change it to ,'.$date.'
--
Kind regards
Kim Emax - masterminds.dk
--
PHP General Mailing List
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:
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
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:
On Fri, Feb 12, 2010 at 8:27 AM, Joseph Thayne webad...@thaynefam.org 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
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
Op 2/11/10 10:51 PM, James McLean schreef:
On Fri, Feb 12, 2010 at 8:27 AM, Joseph Thayne webad...@thaynefam.org 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
On Fri, Feb 12, 2010 at 9:31 AM, Jochem Maas joc...@iamjochem.com 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
On Fri, Feb 12, 2010 at 9:31 AM, Joseph Thayne webad...@thaynefam.org 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
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 webad...@thaynefam.org wrote:
As for the backticks, they are required because of MySQL, not because of
phpMyAdmin. The issue
On Fri, Feb 12, 2010 at 09:44:47AM +1030, James McLean wrote:
On Fri, Feb 12, 2010 at 9:31 AM, Joseph Thayne webad...@thaynefam.org 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
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 statement works
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
It will continue to use the max number which of course will cause an error.
Joseph
Parham Doustdar wrote:
Hello there,
A friend called me today and was wondering what happens if the ID colomn of
an MYSQL database, set to autoinc reaches the int limit. Will it return and
begin choosing the
1 - 100 of 1710 matches
Mail list logo