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
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
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.
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
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
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
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
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
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.
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
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
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
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
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]
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
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
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
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
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 finished soon.
Candidate must have good english
-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
At 4:29 PM -0400 10/1/09, Robert Cummings wrote:
I'm a superstar... send me a check for $500,000 and I'll fly on over.
Or did you completely misuse the word superstar?
Cheers,
Rob.
Rob:
Well, in my book you are a superstar.
Cheers,
tedd
--
---
http://sperling.com
I'm a superstar... send me a check for $500,000 and I'll fly on over.
Or did you completely misuse the word superstar?
Cheers,
Rob.
Jerome Botbol wrote:
Hi All,
We require a PHP / MySQL superstar to work in-house at our offices near
Edgware, London for 3 months on a ground breaking new
I tend to do this robert,
while looking at your example i thought to myself since i am trying to mimick a
shell command why not run one.
Result:
?
$db = 'db';
$host = 'host';
$user = 'user';
$pass = 'pass';
$query = select * from $db.my_table;
$ddvery = shell_exec(mysql -u$user -p$pass --html
ad...@buskirkgraphics.com wrote:
I tend to do this robert,
while looking at your example i thought to myself since i am trying to mimick a
shell command why not run one.
Result:
?
$db = 'db';
$host = 'host';
$user = 'user';
$pass = 'pass';
$query = select * from $db.my_table;
$ddvery =
ad...@buskirkgraphics.com wrote:
Before most of you go on a rampage of how to please read below...
As most of you already know when using MySQL from the shell you can write
your queries in html format in an out file.
Example: shellmysql -uyourmom -plovesme --html
This now will return
ad...@buskirkgraphics.com wrote:
Before most of you go on a rampage of how to please read below...
As most of you already know when using MySQL from the shell you can write your
queries in html format in an out file.
Example: shellmysql -uyourmom -plovesme --html
This now will return all
ad...@buskirkgraphics.com wrote:
Would you mind giving me an example of this that i can stick right into a blank
php file and run.
I get what you are saying but i cant seem to make that even echo out the data.
php 5.2 mysql 5.1.3 Apache 2.2
?php
$db = 'db';
$host = 'host';
$user =
On Jul 13, 2009, at 10:03 AM, Govinda wrote:
I have this code:
$db_billing=mysqli_connect(localhost,metheuser,mypass,billing);
if (mysqli_connect_error()) { die(Can't connect: .
mysqli_connect_error()); }
mysqli
//$dbname = 'billing';
$sql = SHOW TABLES;
Better late then never! :)
I played around with your code tonight and got this working on a
test server:
?PHP
$db_billing = mysql_connect($DBHOST, $DBUSER, $DBPASS) or die(Could
not connect: .mysql_error());
$db_selected = mysql_select_db($DB, $db_billing);
if(!$db_selected)
I have this code:
$db_billing=mysqli_connect(localhost,metheuser,mypass,billing);
if (mysqli_connect_error()) { die(Can't connect: .
mysqli_connect_error()); }
mysqli
//$dbname = 'billing';
$sql = SHOW TABLES;
$result = mysql_query($sql); // line 53
On Sat, Jul 11, 2009 at 19:57, Govindagovinda.webdnat...@gmail.com
wrote:
I have been using PEAR's tableInfo() to remind myself about the
columns in
the table.. but now I want to see as much data as possible about
the table
and its contents *without* using PEAR. (I.e. just using built in
Top-posting.
This would be an excellent question for Prune (CC'd) to field,
based on the error message.
Prune?
On Sun, Jul 12, 2009 at 17:49, Govindagovinda.webdnat...@gmail.com wrote:
On Sat, Jul 11, 2009 at 19:57, Govindagovinda.webdnat...@gmail.com
wrote:
I have been using
On Mon, Jul 13, 2009 at 3:19 AM, Govinda govinda.webdnat...@gmail.comwrote:
On Sat, Jul 11, 2009 at 19:57, Govindagovinda.webdnat...@gmail.com
wrote:
I have been using PEAR's tableInfo() to remind myself about the columns
in
the table.. but now I want to see as much data as possible about
On Sat, Jul 11, 2009 at 19:57, Govindagovinda.webdnat...@gmail.com wrote:
I have been using PEAR's tableInfo() to remind myself about the columns in
the table.. but now I want to see as much data as possible about the table
and its contents *without* using PEAR. (I.e. just using built in
On Thu, 2009-06-18 at 22:10 -0400, Shawn Simmons wrote:
Wrote a small script to connect to the MySql database. Tried to run the
script (http://localhost/dbscript.php) and I get a 500 Internal Server
error. I have been up and down the web for two days looking for a solution
and I am
Check the mysql user permissions, then check the root directory permissions, if
you use some .htacess file, check this to.
This error occurs when you have, permissions errors, server is not working
well, .htacess errors and other things, try acess your script to with
http://127.0.0.1
Yuri
On Thu, Jun 18, 2009 at 22:10, Shawn Simmonselcid...@gmail.com wrote:
Greetings Gurus!
Also, please keep new threads on the list limited to one at a
time, except in extenuating circumstances. And as a developer, there
certainly are and will be more of those circumstances. ;-P
--
/Daniel
Sorry about thatI wasn't sure if it went the first time when I didn't
see the post sfter a refresh8-)
Daniel Brown danbr...@php.net wrote in message
news:ab5568160906190558u1a585cedpf73eb5690330d...@mail.gmail.com...
On Thu, Jun 18, 2009 at 22:10, Shawn Simmonselcid...@gmail.com
At 10:00 AM -0400 4/17/09, Russell Jones wrote:
We are looking at a project where we will potentially need to store
sensetive information in a few fields of a MySQL table. Any recommendations
on where to look for best practices in doing this? for encrypting the data,
etc.? We will need to be
If its by a user-basis, something that can be a bit risky but possible - You
can encrypt it, password is hashed on database, and the key to the other
data is the un-encrypted password..
On Fri, Apr 17, 2009 at 5:00 PM, Russell Jones rjon...@gmail.com wrote:
We are looking at a project where we
MySQLs own Function AES_(EN|DE)CRYPT is pretty cool for this case.
--
Stefan Langwald
2009/4/17 דניאל דנון danondan...@gmail.com:
If its by a user-basis, something that can be a bit risky but possible - You
can encrypt it, password is hashed on database, and the key to the other
data is the
On Fri, Apr 17, 2009 at 10:15 AM, דניאל דנון danondan...@gmail.com wrote:
If its by a user-basis, something that can be a bit risky but possible -
You
can encrypt it, password is hashed on database, and the key to the other
data is the un-encrypted password..
On Fri, Apr 17, 2009 at 5:00
On Apr 17, 2009, at 10:17 AM, Stefan Langwald wrote:
MySQLs own Function AES_(EN|DE)CRYPT is pretty cool for this case.
--
Stefan Langwald
We use MySQL's AES_(EN|DE)CRYPT. It's fast, easy to use and uses 128
bit encryption (optionally 256).
This isn't PHP but mysql question.
You didn't mention that the table itslef is created or not. If not, then it
is probably a mysql error,
maybe your installation of mysql doesn't support INNODB.
SanTa
- Original Message -
From: abdulazeez alugo defati...@hotmail.com
To:
abdulazeez alugo wrote:
Hi guys,
Please can anyone tell me what I'm doing wrong with the code below? It
keep returning unsuccessful.
Why don't you print out mysql_error() ? It'll tell you right away.
/Per
--
Per Jessen, Zürich (20.1°C)
--
PHP General Mailing List
From: p...@computer.org
Date: Tue, 7 Apr 2009 15:18:35 +0200
To: php-general@lists.php.net
Subject: Re: [PHP] PHP-MYSQL Question
abdulazeez alugo wrote:
Hi guys,
Please can anyone tell me what I'm doing wrong with the code below? It
keep returning unsuccessful.
Why
Rob Gould wrote:
Can anyone here recommend an ISP that will let me have a dedicated
server (not shared), and also allow me to adjust the ft_min_word_len
mySQL parameter? I was originally thinking Dreamhost PS, but I
recently found out that they do not allow changes to mySQL
environmental
Hi,
Can anyone here recommend an ISP that will let me have a dedicated
server (not shared), and also allow me to adjust the ft_min_word_len
mySQL parameter? I was originally thinking Dreamhost PS, but I
recently found out that they do not allow changes to mySQL
environmental variables. I
Sebastian Muszytowski wrote:
Hello :)
I have some troubles with php and mysql. I have a normal MySQL Query
and this returns X 3 rows.
Now i want to get the last 3 inserted values. For Example i've inserted
A, B, C, D, E
I want to get the last inserted values, e.g. E D C (in reversed
I have some troubles with php and mysql. I have a normal MySQL Query
and this returns X 3 rows.
Now i want to get the last 3 inserted values. For Example i've inserted
A, B, C, D, E
I want to get the last inserted values, e.g. E D C (in reversed order)
So how to do this? I already searched
Thijs Lensselink schrieb:
Sebastian Muszytowski wrote:
Hello :)
I have some troubles with php and mysql. I have a normal MySQL Query
and this returns X 3 rows.
Now i want to get the last 3 inserted values. For Example i've inserted
A, B, C, D, E
I want to get the last inserted values,
On Mon, Mar 30, 2009 at 7:55 AM, Sebastian Muszytowski
s.muszytow...@googlemail.com wrote:
Thijs Lensselink schrieb:
Sebastian Muszytowski wrote:
Hello :)
I have some troubles with php and mysql. I have a normal MySQL Query
and this returns X 3 rows.
Now i want to get the last 3
haliphax schrieb:
[..cut...]
Except when your primary key value rolls over, or fills a gap between
two other rows that was left when a row was deleted/moved/etc... there
has got to be a better way than grabbing rows in descending order
based on the auto_increment value.
Are you doing the
Date: Mon, 30 Mar 2009 14:55:08 +0200
From: s.muszytow...@googlemail.com
To: p...@addmissions.nl
CC: php-general@lists.php.net
Subject: Re: [PHP] PHP + MySQL - Load last inserts
Thijs Lensselink schrieb:
Sebastian Muszytowski wrote:
Hello :)
I have some troubles with php
On Mon, Mar 30, 2009 at 9:13 AM, Sebastian Muszytowski
s.muszytow...@googlemail.com wrote:
haliphax schrieb:
[..cut...]
Except when your primary key value rolls over, or fills a gap between
two other rows that was left when a row was deleted/moved/etc... there
has got to be a better way
haliphax wrote:
On Mon, Mar 30, 2009 at 9:13 AM, Sebastian Muszytowski
s.muszytow...@googlemail.com wrote:
haliphax schrieb:
[..cut...]
Except when your primary key value rolls over, or fills a gap between
two other rows that was left when a row was deleted/moved/etc... there
has got to be a
On Mon, Mar 30, 2009 at 5:10 PM, Chris dmag...@gmail.com wrote:
haliphax wrote:
On Mon, Mar 30, 2009 at 9:13 AM, Sebastian Muszytowski
s.muszytow...@googlemail.com wrote:
haliphax schrieb:
[..cut...]
Except when your primary key value rolls over, or fills a gap between
two other rows
The physical order of the rows changed (as you can see) but it does not
re-use the id's that were deleted.
Ordering by the id will get you the last bunch inserted.
If you're using innodb you'll have to be aware it's transaction specific, if
you're using myisam it will be system wide.
I'll
From: Dirk
Thilo Klein wrote:
Dear readers,
I am new to relational DB but not to MySQL PHP in general. I
created a RDB using Struggling with the program's
complexity I managed to create a set of databases being
interconnected
via (foreign) keys.
What I want to know is how to
Bob McConnell wrote:
From: Dirk
Thilo Klein wrote:
Dear readers,
I am new to relational DB but not to MySQL PHP in general. I
created a RDB using Struggling with the program's
complexity I managed to create a set of databases being
interconnected
via (foreign) keys.
What I want
Thilo Klein wrote:
Dear readers,
I am new to relational DB but not to MySQL PHP in general. I
created a RDB using Struggling with the program's
complexity I managed to create a set of databases being interconnected
via (foreign) keys.
What I want to know is how to use this database
On Tue, Mar 10, 2009 at 05:44:31AM +0100, Thilo Klein wrote:
Dear readers,
I am new to relational DB but not to MySQL PHP in general. I
created a RDB using Powerdesigner. Struggling with the program's
complexity I managed to create a set of databases being interconnected
via (foreign)
Thilo Klein wrote:
Dear readers,
I am new to relational DB but not to MySQL PHP in general. I
created a RDB using Powerdesigner. Struggling with the program's
complexity I managed to create a set of databases being interconnected
via (foreign) keys.
What I want to know is how to use
Hello, you have to do :
$dwsl = mysql_query('UPDATE database SET Field=Field+1 WHERE
Criteria=\'Criteria\''); From: ad...@buskirkgraphics.com To:
php-general@lists.php.net Date: Mon, 29 Dec 2008 12:05:37 -0500 Subject:
[PHP] Php mysql update Okay maybe i have just forgot. I am trying to
Wouldn't it be:
mysql_query(UPDATE database set Field = Field+1 WHERE
Criteria='Criteria');
Note: no '' around +1, = operator
John Corry
ad...@buskirkgraphics.com wrote:
Okay maybe i have just forgot.
I am trying to update the database and do a +1 to a int field without pulling
the data and
Sorry about that it hit me right after i sent the email.
Thank You so much for you reply
Hello, you have to do :
$dwsl = mysql_query('UPDATE database SET Field=Field+1 WHERE
Criteria=\'Criteria\''); From: ad...@buskirkgraphics.com To:
php-general@lists.php.net Date: Mon, 29 Dec 2008 12:05:37
On Fri, 2008-10-24 at 00:18 -0400, Rob Gould wrote:
Question about mySQL and PHP, when using the mySQL ORDER BY method...
Basically I've got data coming from the database where a wine
producer-name is a word like:
Château Bahans Haut-Brion
or
La Chapelle
See http://dev.mysql.com/doc/refman/5.0/en/savepoints.html
The situation might not come up but it can't hurt to have it already
built in just in case.
This doesn't appear deal with *nested transactions.* It appears that it
will use a single transaction and you can just save up to a
On May 22, 2008, at 7:25 PM, Chris wrote:
Philip Thompson wrote:
Hi all.
I'm currently working on a project that's in its beta stage. Due to
time
restraints, we were unable to build in transactions from the
beginning.
Well, we're getting to the point where we can now put in
Philip Thompson wrote:
Hi all.
I'm currently working on a project that's in its beta stage. Due to time
restraints, we were unable to build in transactions from the beginning.
Well, we're getting to the point where we can now put in transactions.
Basically, I'm curious to find out your
Nameless,
I see someone mentioned the setTimeout(function, milliseconds) function for
JavaScript. I would also like to point out that you can use
setInterval(function, milliseconds) in order to have an event repeat at a set
interval. For instance, let's say you had a page laid out like so:
Todd
I want to thank you. You sent me thinking in the right direction to resolving
this issue. I now have successfully created a live Pika Card status GUI using
PHP, MYSQL, AJAX.
The key word in what you said was unique function. I was not thinking to write
a function. I was looking for the
Hi:
The following could be taken from MySQL just as well:
http://webbytedd.com/b/timed-php/
Cheers,
tedd
--
---
http://sperling.com http://ancientstones.com http://earthstones.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Check out jQuery.
http://jquery.com
On May 20, 2008, at 1:24 PM, [EMAIL PROTECTED] wrote:
Okay before i pull more hair out...
I am trying to use php to pull mysql data and refresh the mysql data
every say 5 seconds for like a live display of the database without
the screen reloading.
I
[EMAIL PROTECTED] wrote:
Okay before i pull more hair out...
I am trying to use php to pull mysql data and refresh the mysql data
every say 5 seconds for like a live display of the database without
the screen reloading.
I want the data to refresh but not the screen. Ajax seems to hate me
Ok. I apologize for the mix. When I'm mailing someone, I simply don't get
Google into mind. :)
Thanks,
Rahul
On Sun, May 11, 2008 at 12:53 AM, Nathan Nobbe [EMAIL PROTECTED]
wrote:
On Sun, May 11, 2008 at 1:46 AM, Rahul P [EMAIL PROTECTED] wrote:
Ok I removed mysql using yum remove mysql.
On Sun, May 11, 2008 at 1:59 AM, Rahul P [EMAIL PROTECTED] wrote:
Ok. I apologize for the mix. When I'm mailing someone, I simply don't get
Google into mind. :)
no problem, if it were emerge id be much more capable of helping ;)
-nathan
Rahul P wrote:
Ok I removed mysql using yum remove mysql. But is there a special way to
tell yum to install that version of mysql?
On Sun, May 11, 2008 at 12:44 AM, Rahul P [EMAIL PROTECTED] wrote:
On Sun, May 11, 2008 at 12:42 AM, Nathan Nobbe [EMAIL PROTECTED]
wrote:
On Sun, May 11, 2008
On Sun, May 11, 2008 at 12:30 AM, Rahul [EMAIL PROTECTED] wrote:
I am using Fedora Core 4. As I was unable to use PHP or MySQL together, I
uninstalled both of them and installed again using the following commands:
yum install mysql
And then
apt-get install php php-devel php-gd php-imap
Thanks a lot for your reply.
I have tried using
$host = localhost;
$db = dbname;
$table_main = tablename;
$dbusername = root;
$dbpass = passhere;
mysql_connect($host, $dbusername, $dbpass) or die(mysql_error());
and
$host = mycomputer.webaddress.com;
$db = dbname;
$table_main = tablename;
On Sun, May 11, 2008 at 12:42 AM, Rahul [EMAIL PROTECTED] wrote:
Thanks a lot for your reply.
I have tried using
$host = localhost;
$db = dbname;
$table_main = tablename;
$dbusername = root;
$dbpass = passhere;
mysql_connect($host, $dbusername, $dbpass) or die(mysql_error());
and
I have recorded both the errors by changing the variable:
$host = mycomputer.webaddress.com
PHP Warning: mysql_connect(): Lost connection to MySQL server during
query in /export/home/rpo219/may/conf_global.php on line 18
Lost connection to MySQL server during query
$host = localhost
PHP
On Sun, May 11, 2008 at 1:05 AM, Rahul [EMAIL PROTECTED] wrote:
I have recorded both the errors by changing the variable:
$host = mycomputer.webaddress.com
PHP Warning: mysql_connect(): Lost connection to MySQL server during query
in /export/home/rpo219/may/conf_global.php on line 18
Lost
Thanks. I just stopped mysql and when I try to start it again it throws
another set of errors:
chown: changing ownership of `/home-public/mysql6': Operation not permitted
So I guess something is messed up completely. I wish I installed it better.
Now the installing is messed up I guess with all
On Sun, May 11, 2008 at 1:22 AM, Rahul P [EMAIL PROTECTED] wrote:
Thanks. I just stopped mysql and when I try to start it again it throws
another set of errors:
chown: changing ownership of `/home-public/mysql6': Operation not permitted
So I guess something is messed up completely. I wish I
Oh... This is the fourth time I'm doing that except that this time yum
installed mysql6 instead of older versions... I don't see any way out other
than reinstalling the OS itself... There are so many dependency failures
I'm spending more time troubleshooting than actually coding something :)
On Sun, May 11, 2008 at 1:29 AM, Rahul P [EMAIL PROTECTED] wrote:
Oh... This is the fourth time I'm doing that except that this time yum
installed mysql6 instead of older versions... I don't see any way out other
than reinstalling the OS itself... There are so many dependency failures
I'm
On Sun, May 11, 2008 at 12:42 AM, Nathan Nobbe [EMAIL PROTECTED]
wrote:
On Sun, May 11, 2008 at 1:29 AM, Rahul P [EMAIL PROTECTED] wrote:
Oh... This is the fourth time I'm doing that except that this time yum
installed mysql6 instead of older versions... I don't see any way out other
than
Ok I removed mysql using yum remove mysql. But is there a special way to
tell yum to install that version of mysql?
On Sun, May 11, 2008 at 12:44 AM, Rahul P [EMAIL PROTECTED] wrote:
On Sun, May 11, 2008 at 12:42 AM, Nathan Nobbe [EMAIL PROTECTED]
wrote:
On Sun, May 11, 2008 at 1:29 AM,
On Sun, May 11, 2008 at 1:46 AM, Rahul P [EMAIL PROTECTED] wrote:
Ok I removed mysql using yum remove mysql. But is there a special way to
tell yum to install that version of mysql?
ahh, this is where google comes in for sure. it looks like you could
download an older rpm, like from mysql
Insert is for a new row
Alter or Update is for an exsisting row
/*I'm trying to insert values from an array into MySQL DB but the insert
begins at the last record in the table and not at first record in the table.
I have added the cellSuffixes column after I already populated 30 records in
Thanks :-)
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Insert is for a new row
Alter or Update is for an exsisting row
/*I'm trying to insert values from an array into MySQL DB but the insert
begins at the last record in the table and not at first record in the
table.
On Sat, February 16, 2008 5:22 pm, Rob Gould wrote:
I've got a PHP script that inserts 00012345678 into a record in a
mySQL database (it's a barcode). Things work ok unless the number has
preceding zeros, and then the zeros get cut off and all I get is
12345678.
I have the mySQL database
On Feb 16, 2008 6:22 PM, Rob Gould [EMAIL PROTECTED] wrote:
I've got a PHP script that inserts 00012345678 into a record in a mySQL
database (it's a barcode). Things work ok unless the number has preceding
zeros, and then the zeros get cut off and all I get is 12345678.
I have the mySQL
Daniel Brown wrote:
On Feb 16, 2008 6:22 PM, Rob Gould [EMAIL PROTECTED] wrote:
I've got a PHP script that inserts 00012345678 into a record in a mySQL database (it's
a barcode). Things work ok unless the number has preceding zeros, and then the zeros get cut off
and all I get is 12345678.
char(14) is a better data type
bastien
Date: Sat, 16 Feb 2008 15:22:17 -0800
From: [EMAIL PROTECTED]
To: php-general@lists.php.net
Subject: [PHP] PHP/mySQL dropping zeros after inserting number into record
I've got a PHP script that inserts
Rob Gould [EMAIL PROTECTED] writes:
I've got a PHP script that inserts 00012345678 into a record in a
mySQL database (it's a barcode). Things work ok unless the number has
preceding zeros, and then the zeros get cut off and all I get is
12345678.
I have the mySQL database fieldtype set to
list
Subject: Re: [PHP] PHP/mySQL question about groups
On Feb 7, 2008 1:20 AM, Warren Vail [EMAIL PROTECTED] wrote:
I did some looking into performance issues many years ago at company
that
developed and marketed another database server, comparing the query plan
to
the actual code
On Feb 7, 2008 1:20 AM, Warren Vail [EMAIL PROTECTED] wrote:
I did some looking into performance issues many years ago at company that
developed and marketed another database server, comparing the query plan to
the actual code, and a query plan usually shows the processes that consume
the
1 - 100 of 520 matches
Mail list logo
