Re: [PHP] Mysql search html tags excluded

2010-06-04 Thread Ashley Sheridan
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

Re: [PHP] Mysql search html tags excluded

2010-06-04 Thread Tanel Tammik
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

Re: [PHP] Mysql search html tags excluded

2010-06-04 Thread Ashley Sheridan
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

Re: [PHP] Mysql search html tags excluded

2010-06-04 Thread tedd
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

Re: [PHP] PHP MYSQL sorting

2010-04-12 Thread tedd
At 8:16 PM -0400 4/11/10, Ernie Kemp wrote: Simple idea I thought. I need a webpage that displays a drop down list of number with a checkbox on the side that when checked will select the database again only in descending order. Small database with maybe 100 records. The user can click the

[PHP] PHP MYSQL sorting

2010-04-11 Thread Ernie Kemp
Simple idea I thought. I need a webpage that displays a drop down list of number with a checkbox on the side that when checked will select the database again only in descending order. Small database with maybe 100 records. The user can click the submit button when they have located

Re: [PHP] PHP MYSQL sorting

2010-04-11 Thread kranthi
You can use javascript to trigger an onclick function every time a checkbox is selected. The onclick function can make an ajax call to a remote php script which can then make the database query.

Re: [PHP] PHP MYSQL sorting

2010-04-11 Thread Nilesh Govindarajan
On 04/12/10 05:46, Ernie Kemp wrote: Simple idea I thought. I need a webpage that displays a drop down list of number with a checkbox on the side that when checked will select the database again only in descending order. Small database with maybe 100 records. The user can click the submit

[PHP] mysql query returning slowly

2010-04-06 Thread David Murphy
This is from our application I enabled profile in mysql to determine why an update took 20seconds. As you can see MySQL reported no where near that amount of duration took place. Is there any way I can dig into php and determine why mysql client libs are so slow (this is not using mysqlnd

[PHP] MySQL query not working!

2010-03-31 Thread Parham Doustdar
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 download. This is supposed to be a file download

Re: [PHP] MySQL query not working!

2010-03-31 Thread Ashley Sheridan
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

Re: [PHP] MySQL query not working!

2010-03-31 Thread Andre Polykanine
message - From: Parham Doustdar parha...@gmail.com To: php-general@lists.php.net php-general@lists.php.net Date: Wednesday, March 31, 2010, 2:50:07 PM Subject: [PHP] MySQL query not working! Hi there, Here is a snippet of code... that doesn't work for some reason. Please note that I have put

Re: [PHP] MySQL query not working!

2010-03-31 Thread Parham Doustdar
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

Re: [PHP] MySQL query not working!

2010-03-31 Thread Alexey Bovanenko
- Original message - From: Parham Doustdar parha...@gmail.com To: php-general@lists.php.net php-general@lists.php.net Date: Wednesday, March 31, 2010, 2:50:07 PM Subject: [PHP] MySQL query not working! Hi there, Here is a snippet of code... that doesn't work for some reason. Please

Re[2]: [PHP] MySQL query not working!

2010-03-31 Thread Andre Polykanine
@ yandex.ru; Jabber: arthaelon @ jabber.org Yahoo! messenger: andre.polykanine; ICQ: 191749952 Twitter: m_elensule - Original message - From: Parham Doustdar parha...@gmail.com To: Andre Polykanine an...@oire.org Date: Wednesday, March 31, 2010, 3:20:54 PM Subject: [PHP] MySQL query

Re: [PHP] MySQL query not working!

2010-03-31 Thread Ashley Sheridan
...@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

Re: [PHP] MySQL query not working!

2010-03-31 Thread Midhun Girish
, 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

Re: [PHP] MySQL query not working!

2010-03-31 Thread Andrew Ballard
- 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

Re: [PHP] MySQL query not working!

2010-03-31 Thread Midhun Girish
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

Re: [PHP] MySQL query not working!

2010-03-31 Thread Andrew Ballard
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',

Re: [PHP] MySQL query not working!

2010-03-31 Thread tedd
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

[PHP] MySQL: Return Number of Matched Rows

2010-03-25 Thread James Colannino
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, rather than the number of rows affected? I'm trying to get

Re: [PHP] MySQL: Return Number of Matched Rows

2010-03-25 Thread Floyd Resler
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,

Re: [PHP] MySQL: Return Number of Matched Rows

2010-03-25 Thread James Colannino
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

Re: [PHP] MySQL: Return Number of Matched Rows

2010-03-25 Thread Yousif Masoud
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

Re: [PHP] PHP MySQL Insert Statements

2010-03-16 Thread Jan G.B.
2010/3/12 Martine Osias webi...@gmail.com Hi, My insert statements on this web page don't execute. The select statements do work. This tells me that the database connection is working. The username and password are the administrator's. What else could prevent the insert statements from

Re: [PHP] PHP MySQL Insert Statements

2010-03-16 Thread Ryan Sun
Always make sure your dynamic sql string in php code are as expected var_dump($sql) before query On Thu, Mar 11, 2010 at 10:13 PM, Martine Osias webi...@gmail.com wrote: Hi, My insert statements on this web page don't execute. The select statements do work. This tells me that the database

[PHP] PHP MySQL Insert Statements

2010-03-11 Thread Martine Osias
Hi, My insert statements on this web page don't execute. The select statements do work. This tells me that the database connection is working. The username and password are the administrator's. What else could prevent the insert statements from executing? Thank you. Martine -- PHP

Re: [PHP] PHP MySQL Insert Statements

2010-03-11 Thread Bruno Fajardo
2010/3/11 Martine Osias webi...@gmail.com: Hi, My insert statements on this web page don't execute. The select statements do work. This tells me that the database connection is working. The username and password are the administrator's. What else could prevent the insert statements from

Re: [PHP] PHP MySQL Insert Statements

2010-03-11 Thread Stephen
Martine Osias wrote: My insert statements on this web page don't execute. The select statements do work. This tells me that the database connection is working. The username and password are the administrator's. What else could prevent the insert statements from executing? Most likely syntax

Re: [PHP] PHP MySQL Insert Statements

2010-03-11 Thread Kevin Kinsey
Martine Osias wrote: Hi, My insert statements on this web page don't execute. The select statements do work. This tells me that the database connection is working. The username and password are the administrator's. What else could prevent the insert statements from executing? Thank you.

Re: [PHP] PHP / mySQL Project... Real men use 'cat'

2010-02-24 Thread Andrew Ballard
On Wed, Feb 24, 2010 at 5:12 AM, Ashley Sheridan a...@ashleysheridan.co.uk wrote: On Wed, 2010-02-24 at 09:18 +, Pete Ford wrote: sudo ln -s /bin/cat /bin/dog sudo ln -s /bin/cat /bin/rabbit sudo ln -s /bin/cat /bin/rat Sorted... But now they're in /bin, surely at some point you'll

Re: [PHP] PHP / mySQL Project... Real men use 'cat'

2010-02-24 Thread Ashley Sheridan
On Wed, 2010-02-24 at 09:22 -0500, Andrew Ballard wrote: On Wed, Feb 24, 2010 at 5:12 AM, Ashley Sheridan a...@ashleysheridan.co.uk wrote: On Wed, 2010-02-24 at 09:18 +, Pete Ford wrote: sudo ln -s /bin/cat /bin/dog sudo ln -s /bin/cat /bin/rabbit sudo ln -s /bin/cat /bin/rat

Re: [PHP] PHP / mySQL Project... Real men use 'cat'

2010-02-24 Thread Ashley Sheridan
On Wed, 2010-02-24 at 14:24 +, Ashley Sheridan wrote: On Wed, 2010-02-24 at 09:22 -0500, Andrew Ballard wrote: On Wed, Feb 24, 2010 at 5:12 AM, Ashley Sheridan a...@ashleysheridan.co.uk wrote: On Wed, 2010-02-24 at 09:18 +, Pete Ford wrote: sudo ln -s /bin/cat /bin/dog

Re: [PHP] PHP / mySQL Project... Real men use 'cat'

2010-02-23 Thread Richard Quadling
On 23 February 2010 00:28, Daevid Vincent dae...@daevid.com wrote: -Original Message- From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk] On Mon, 2010-02-22 at 14:39 -0800, Don Wieland wrote: I am needing assistance IMMEDIATELY in finishing up a project (the developer went in

Re: [PHP] PHP / mySQL Project... Real men use 'cat'

2010-02-23 Thread Phpster
Depends on what you do with them! Bastien Sent from my iPod On Feb 23, 2010, at 6:42 AM, Richard Quadling rquadl...@googlemail.com wrote: On 23 February 2010 00:28, Daevid Vincent dae...@daevid.com wrote: -Original Message- From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk]

Re: [PHP] PHP / mySQL Project...

2010-02-23 Thread tedd
At 11:46 PM + 2/22/10, Ashley Sheridan wrote: On Mon, 2010-02-22 at 14:39 -0800, Don Wieland wrote: Hello, I am needing assistance IMMEDIATELY in finishing up a project (the developer went in to have shoulder surgery and will be out of commission for 3 weeks) and I need this

RE: [PHP] PHP / mySQL Project... Real men use 'cat'

2010-02-23 Thread Daevid Vincent
Am I the only Linux/Unix guy here? Do you guys not know what 'cat' is? :-\ http://en.wikipedia.org/wiki/Cat_(Unix) http://techrepublic.com.com/5208-12846-0.html?forumID=102threadID=310099m essageID=3099392tag=content;leftCol -Original Message- From: Richard Quadling

RE: [PHP] PHP / mySQL Project... Real men use 'cat'

2010-02-23 Thread Ashley Sheridan
On Tue, 2010-02-23 at 15:06 -0800, Daevid Vincent wrote: Am I the only Linux/Unix guy here? Do you guys not know what 'cat' is? :-\ http://en.wikipedia.org/wiki/Cat_(Unix) http://techrepublic.com.com/5208-12846-0.html?forumID=102threadID=310099m essageID=3099392tag=content;leftCol

Re: [PHP] PHP / mySQL Project... Real men use 'cat'

2010-02-23 Thread Paul M Foster
On Tue, Feb 23, 2010 at 11:05:14PM +, Ashley Sheridan wrote: On Tue, 2010-02-23 at 15:06 -0800, Daevid Vincent wrote: http://techrepublic.com.com/5208-12846-0.html?forumID=102threadID=310099messageID=3099392tag=content;leftCol That guy's partial to JOE. Pffft. Real men use Vim. And

[PHP] PHP / mySQL Project...

2010-02-22 Thread Don Wieland
Hello, I am needing assistance IMMEDIATELY in finishing up a project (the developer went in to have shoulder surgery and will be out of commission for 3 weeks) and I need this finished soon. Candidate must have good english skills, a solid knowledge of HTML, CSS, PHP, mySQL, Javascript

[PHP] Re: PHP / mySQL Project...

2010-02-22 Thread Carlos Medina
weeks) and I need this finished soon. Candidate must have good english skills, a solid knowledge of HTML, CSS, PHP, mySQL, Javascript, AJAX, and JQuery. Developer may work remotely. Please contact me via email, PRIVATELY, with your skills and sample of online project you have done. Also

Re: [PHP] PHP / mySQL Project...

2010-02-22 Thread Ashley Sheridan
, a solid knowledge of HTML, CSS, PHP, mySQL, Javascript, AJAX, and JQuery. Developer may work remotely. Please contact me via email, PRIVATELY, with your skills and sample of online project you have done. Also, this will be an hourly job - so what Hourly Rate you expect to get paid

RE: [PHP] PHP / mySQL Project... Real men use 'cat'

2010-02-22 Thread Daevid Vincent
-Original Message- From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk] On Mon, 2010-02-22 at 14:39 -0800, Don Wieland wrote: I am needing assistance IMMEDIATELY in finishing up a project (the developer went in to have shoulder surgery and will be out of commission

[PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread james stojan
I'm at my wits end trying to make this mysql statement insert work in PHP. I'm not getting any errors from PHP or mysql but the insert fails (nothing is inserted) error reporting is on and is reporting other errors. When I echo out the query and manually paste it into PHP myAdmin the query inserts

Re: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread Joseph Thayne
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

Re: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread Kim Madsen
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

Re: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread Mari Masuda
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:

Re: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread james stojan
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

Re: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread Joseph Thayne
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:

Re: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread James McLean
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

Re: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread Joseph Thayne
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

Re: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread Jochem Maas
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

Re: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread James McLean
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

Re: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread James McLean
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

Re: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread Joseph Thayne
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

Re: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread Paul M Foster
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

RE: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread Joseph Thayne
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

Re: [PHP] Mysql statement works in phpmyadmin but not in php page

2010-02-11 Thread Paul M Foster
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

[PHP] Question on XML/XSL/PHP/MySQL

2010-01-27 Thread Ryan Park
Hypothetically say that I have MySQL with petabytes of data. I want to use XSL as my template language. But in order to use XSL, I need to make XML filled with petabytes of data. This does not sound elaborate way to use XSL/XML; I would rather use PHP/MySQL/Smarty. Is there a way around

Re: [PHP] Question on XML/XSL/PHP/MySQL

2010-01-27 Thread Ashley Sheridan
rather use PHP/MySQL/Smarty. Is there a way around this so that I can use XSL instead of Smarty? I'm not really sure what you want to achieve here, as all of those languages do quite different things! And I wouldn't ever recommend having a single XML file with petabytes of data, that's just

Re: [PHP] Question on XML/XSL/PHP/MySQL

2010-01-27 Thread Ryan Park
PHP/MySQL/Smarty. Is there a way around this so that I can use XSL instead of Smarty? I'm not really sure what you want to achieve here, as all of those languages do quite different things! And I wouldn't ever recommend having a single XML file with petabytes of data, that's just asking

Re: [PHP] Question on XML/XSL/PHP/MySQL

2010-01-27 Thread Ashley Sheridan
. This does not sound elaborate way to use XSL/XML; I would rather use PHP/MySQL/Smarty. Is there a way around this so that I can use XSL instead of Smarty? I'm not really sure what you want to achieve here, as all of those languages do quite different things! And I wouldn't ever

Re: [PHP] Question on XML/XSL/PHP/MySQL

2010-01-27 Thread Jay Ess
Ryan Park wrote: Hypothetically say that I have MySQL with petabytes of data. I want to use XSL as my template language. But in order to use XSL, I need to make XML filled with petabytes of data. This does not sound elaborate way to use XSL/XML; I would rather use PHP/MySQL/Smarty

Re: [PHP] Question on XML/XSL/PHP/MySQL

2010-01-27 Thread tedd
elaborate way to use XSL/XML; I would rather use PHP/MySQL/Smarty. Is there a way around this so that I can use XSL instead of Smarty? I'm not really sure what you want to achieve here, as all of those languages do quite different things! And I wouldn't ever recommend having a single XML file

[PHP] Re: Question on XML/XSL/PHP/MySQL

2010-01-27 Thread Nathan Rixham
Ryan Park wrote: Hypothetically say that I have MySQL with petabytes of data. I want to use XSL as my template language. But in order to use XSL, I need to make XML filled with petabytes of data. This does not sound elaborate way to use XSL/XML; I would rather use PHP/MySQL/Smarty

[PHP] MySQL ID -- what happens when you run out of range?

2010-01-25 Thread Parham Doustdar
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 ID's that have been deleted, or... what? Thanks! -- PHP General Mailing List (http://www.php.net/) To

Re: [PHP] MySQL ID -- what happens when you run out of range?

2010-01-25 Thread Joseph Thayne
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

Re: [PHP] MySQL ID -- what happens when you run out of range?

2010-01-25 Thread Robert Cummings
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 ID's that have been deleted, or... what? Thanks! Ask Slashdot... I believe they hit

Re: [PHP] MySQL ID -- what happens when you run out of range?

2010-01-25 Thread Camilo Sperberg
On Mon, Jan 25, 2010 at 17:15, Parham Doustdar parha...@gmail.com 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 ID's that have been deleted, or...

Re: [PHP] MySQL ID -- what happens when you run out of range?

2010-01-25 Thread Ryan Sun
For such a large data set, they would split into several sub tables, otherwise the performance will be horrible On Mon, Jan 25, 2010 at 3:39 PM, Robert Cummings rob...@interjinn.comwrote: Parham Doustdar wrote: Hello there, A friend called me today and was wondering what happens if the ID

Re: [PHP] MySQL ID -- what happens when you run out of range?

2010-01-25 Thread Joseph Thayne
That is incorrect. What will happen is as follows: 1. The value will be incremented by 1 causing the value to be greater than the maximum integer allowed. 2. MySQL will see this as a problem and truncate it to the closest value. 3. MySQL will then try and insert the new row with the

Re: [PHP] MySQL ID -- what happens when you run out of range?

2010-01-25 Thread Camilo Sperberg
On Mon, Jan 25, 2010 at 18:51, Joseph Thayne webad...@thaynefam.org wrote: That is incorrect. What will happen is as follows: 1. The value will be incremented by 1 causing the value to be greater than the maximum integer allowed. 2. MySQL will see this as a problem and truncate it to the

Re: [PHP] MySQL ID -- what happens when you run out of range?

2010-01-25 Thread Shawn McKenzie
Joseph Thayne wrote: That is incorrect. What will happen is as follows: 1. The value will be incremented by 1 causing the value to be greater than the maximum integer allowed. 2. MySQL will see this as a problem and truncate it to the closest value. 3. MySQL will then try and insert

Re: [PHP] MySQL ID -- what happens when you run out of range?

2010-01-25 Thread Michael A. Peters
Shawn McKenzie wrote: Joseph Thayne wrote: That is incorrect. What will happen is as follows: 1. The value will be incremented by 1 causing the value to be greater than the maximum integer allowed. 2. MySQL will see this as a problem and truncate it to the closest value. 3. MySQL will then

Re: [PHP] MySQL ID -- what happens when you run out of range?

2010-01-25 Thread APseudoUtopia
On Mon, Jan 25, 2010 at 10:00 PM, Michael A. Peters mpet...@mac.com wrote: Shawn McKenzie wrote: Joseph Thayne wrote: That is incorrect.  What will happen is as follows: 1.  The value will be incremented by 1 causing the value to be greater than the maximum integer allowed. 2.  MySQL will

Re: [PHP] MySQL Increment/Decrement

2009-12-29 Thread muzy
Hello Ben, I had the same question yesterday (but with SQLite) and there are at least 2 solutions. The first was already mentioned: UPDATE table SET value = value + 1 WHERE foo = bar; The second solution which also works is: UPDATE table SET value = (SELECT value FROM table WHERE foo =

Re: [PHP] MySQL Increment/Decrement

2009-12-29 Thread Phpster
On Dec 29, 2009, at 3:10 AM, muzy p...@muzybot.de wrote: Hello Ben, I had the same question yesterday (but with SQLite) and there are at least 2 solutions. The first was already mentioned: UPDATE table SET value = value + 1 WHERE foo = bar; The second solution which also works is:

[PHP] MySQL Increment/Decrement

2009-12-28 Thread Ben Miller
I hope this isn't a bone-head question - Is there a MySQL query that will increment/decrement the value in an integer column with a single query - in other words, I don't have to run a SELECT query to get the value, add/subtract to/from the value, and then run an UPDATE query to store the new

Re: [PHP] MySQL Increment/Decrement

2009-12-28 Thread Robert Cummings
Ben Miller wrote: I hope this isn't a bone-head question - Is there a MySQL query that will increment/decrement the value in an integer column with a single query - in other words, I don't have to run a SELECT query to get the value, add/subtract to/from the value, and then run an UPDATE query

Re: [PHP] MySQL Increment/Decrement

2009-12-28 Thread Bipper Goes!
UPDATE SQLTABLE SET count = (count+1) WHERE PromoID=1 Is this valid for your issue? I have no way of testing or toying On Mon, Dec 28, 2009 at 8:54 PM, Ben Miller b...@tottd.com wrote: I hope this isn't a bone-head question - Is there a MySQL query that will increment/decrement the value in

Re: [PHP] MySQL Increment/Decrement

2009-12-28 Thread Eric Lee
Ben It seems that you can just update the column with a update query like this, update table set field = field + 1 where some condition This might be the thing you need. Eric On 12/29/09, Ben Miller b...@tottd.com wrote: I hope this isn't a bone-head question - Is there a MySQL query

Re: [PHP] MySQL Appeal from Monty

2009-12-16 Thread Philip Thompson
On Dec 15, 2009, at 6:03 AM, Ashley Sheridan wrote: On Tue, 2009-12-15 at 02:53 +, Joseph Masoud wrote: On 14 Dec 2009, at 22:01, Ashley Sheridan a...@ashleysheridan.co.uk wrote: On Mon, 2009-12-14 at 15:59 -0600, Philip Thompson wrote: On Dec 14, 2009, at 12:51 AM, Lester

Re: [PHP] MySQL Appeal from Monty

2009-12-16 Thread Yousif Masoud
On Wed, Dec 16, 2009 at 3:14 PM, Philip Thompson philthath...@gmail.comwrote: On Dec 15, 2009, at 6:03 AM, Ashley Sheridan wrote: On Tue, 2009-12-15 at 02:53 +, Joseph Masoud wrote: On 14 Dec 2009, at 22:01, Ashley Sheridan a...@ashleysheridan.co.uk wrote: On Mon, 2009-12-14 at

Re: [PHP] MySQL Appeal from Monty

2009-12-16 Thread Philip Thompson
On Dec 16, 2009, at 1:48 PM, Yousif Masoud wrote: On Wed, Dec 16, 2009 at 3:14 PM, Philip Thompson philthath...@gmail.com wrote: On Dec 15, 2009, at 6:03 AM, Ashley Sheridan wrote: On Tue, 2009-12-15 at 02:53 +, Joseph Masoud wrote: On 14 Dec 2009, at 22:01, Ashley Sheridan

Re: [PHP] MySQL Appeal from Monty

2009-12-15 Thread Ashley Sheridan
On Tue, 2009-12-15 at 02:53 +, Joseph Masoud wrote: On 14 Dec 2009, at 22:01, Ashley Sheridan a...@ashleysheridan.co.uk wrote: On Mon, 2009-12-14 at 15:59 -0600, Philip Thompson wrote: On Dec 14, 2009, at 12:51 AM, Lester Caine wrote: Lenin wrote: You might also like this:

Re: [PHP] MySQL Appeal from Monty

2009-12-15 Thread Paul M Foster
On Tue, Dec 15, 2009 at 12:03:23PM +, Ashley Sheridan wrote: snip I've always been led to believe that you go with MySQL if you want speed, Oracle if you want data integrity. I know they both handle each one admirably, but Oracle is known more for guarding the data against mishaps and

Re: [PHP] MySQL Appeal from Monty

2009-12-14 Thread Philip Thompson
On Dec 14, 2009, at 12:51 AM, Lester Caine wrote: Lenin wrote: You might also like this: Come on Monty - Lukas Smith http://bit.ly/5lmwwD I've been watching some of this debate with interest, but I'll stay with a database that has none of the baggage that MySQL has always had, and IS

Re: [PHP] MySQL Appeal from Monty

2009-12-14 Thread Ashley Sheridan
On Mon, 2009-12-14 at 15:59 -0600, Philip Thompson wrote: On Dec 14, 2009, at 12:51 AM, Lester Caine wrote: Lenin wrote: You might also like this: Come on Monty - Lukas Smith http://bit.ly/5lmwwD I've been watching some of this debate with interest, but I'll stay with a database

Re: [PHP] MySQL Appeal from Monty

2009-12-14 Thread Joseph Masoud
On 14 Dec 2009, at 22:01, Ashley Sheridan a...@ashleysheridan.co.uk wrote: On Mon, 2009-12-14 at 15:59 -0600, Philip Thompson wrote: On Dec 14, 2009, at 12:51 AM, Lester Caine wrote: Lenin wrote: You might also like this: Come on Monty - Lukas Smith http://bit.ly/5lmwwD I've been

Re: [PHP] MySQL Appeal from Monty

2009-12-14 Thread Lester Caine
Philip Thompson wrote: On Dec 14, 2009, at 12:51 AM, Lester Caine wrote: Lenin wrote: You might also like this: Come on Monty - Lukas Smith http://bit.ly/5lmwwD I've been watching some of this debate with interest, but I'll stay with a database that has none of the baggage that MySQL has

[PHP] MySQL Appeal from Monty

2009-12-13 Thread richard
Hi, You might have already seen this, however if you haven't this may interest you: http://monty-says.blogspot.com/2009/12/help-saving-mysql.html -- Richard Heyes HTML5 canvas graphing: RGraph - www.rgraph.net (updated 12th December - now with IE support!) Lots of PHP and Javascript code -

Re: [PHP] MySQL Appeal from Monty

2009-12-13 Thread metastable
rich...@rgraph.net wrote: Hi, You might have already seen this, however if you haven't this may interest you: http://monty-says.blogspot.com/2009/12/help-saving-mysql.html Sent my appeal to comp-merger-regis...@ec.europa.eu and I would suggest everyone on this list does the same. The

Re: [PHP] MySQL Appeal from Monty

2009-12-13 Thread Lenin
You might also like this: Come on Monty - Lukas Smith http://bit.ly/5lmwwD

Re: [PHP] MySQL Appeal from Monty

2009-12-13 Thread Lester Caine
Lenin wrote: You might also like this: Come on Monty - Lukas Smith http://bit.ly/5lmwwD I've been watching some of this debate with interest, but I'll stay with a database that has none of the baggage that MySQL has always had, and IS currently replacing Oracle in many large sites :) --

[PHP] Re: [php] [mysql] select and subselect

2009-11-17 Thread David Robley
Allen McCabe wrote: I have a page on my site where I can optionaly filter by certain fields (order by filesize or file category), but I am implementing a shopping cart type of idea where users can submit an order. As administrators, my coworkers and I need to be able to filter orders by

[PHP] Re: [php] [mysql] select and subselect

2009-11-17 Thread Nisse Engström
On Mon, 16 Nov 2009 14:21:41 -0800, Allen McCabe wrote: I have an order table that keeps track of the order_id, the date, the status, etc. I also have an order_lineitem table that is the contents of the order. This has a one-to-many structure (without foreign keys because it is mysql).

[PHP] [php] [mysql] select and subselect

2009-11-16 Thread Allen McCabe
I have a page on my site where I can optionaly filter by certain fields (order by filesize or file category), but I am implementing a shopping cart type of idea where users can submit an order. As administrators, my coworkers and I need to be able to filter orders by their contents. For example:

[PHP] mysql resoc iterator

2009-10-31 Thread viraj
can somebody point me to a good article or a piece of code on implementing an iterator for a mysql result resource? actually this is for an oracle statement handle, all i want is to fetch the results as it is from a multi dimensional array. so i can use it in a for each with keys

[PHP] RE: PHP/MySQL Superstars

2009-10-02 Thread Jerome Botbol
Thanks Manuel your input is greatly appreciated. Jerome -Original Message- From: Manuel Lemos [mailto:mle...@acm.org] Sent: 01 October 2009 20:46 To: Jerome Botbol Cc: php-general@lists.php.net Subject: Re: PHP/MySQL Superstars Hello, on 10/01/2009 10:09 AM Jerome Botbol said

<    1   2   3   4   5   6   7   8   9   10   >