[PHP] PHP/mySQL Developer Partner needed...

2012-07-02 Thread Don Wieland
Greetings, I have a site that I am developing and I am looking to partner/ developer with great php/mySQL skills (for share of potential profits) to assist me in finishing this site. I am looking for someone who can invest (like myself) their time and skills to complete the site in exchang

Re: [PHP] PHP+MySQL question

2011-02-16 Thread Robert Cummings
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

Re: [PHP] PHP+MySQL question

2011-02-16 Thread Robert Cummings
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 su

[PHP] PHP+MySQL question

2011-02-16 Thread דניאל דנון
Hi. I have a table called "images" with 4 columns - `image_id`, `item_name`, `image_url`, `image_views` (Where image_id is UNIQUE and AUTO-INCREMENT). Sometimes, there might be many items with the same name (but not with the same url). I want to make sure that each "item name" has at most 3 ima

[PHP] php - mysql tandem and multi core performance

2010-09-28 Thread Giulio Mastrosanti
Hi all, I have to setup a new dedicated server for my job, it will need to host some mysql databases with php accessing them, for a number of reasons it need to be a Windows server ( 2008 ) the amount of data will not be very great ( the biggest table will contain between 100.000 and 200.000 rows

RE: [PHP] PHP & MYSQL sorting

2010-04-14 Thread Ernie Kemp
Thanks for your thoughts. Ajax is the way to go... Thanks, .../Ernie -Original Message- From: tedd [mailto:tedd.sperl...@gmail.com] Sent: April-12-10 10:18 AM To: Ernie Kemp; 'PHP General List' Subject: Re: [PHP] PHP & MYSQL sorting At 8:16 PM -0400 4/11/10, Ernie Kemp

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 s

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 butt

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.

[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 the

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 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 wor

Re: [PHP] PHP MySQL Insert Statements

2010-03-16 Thread Jan G.B.
2010/3/12 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? > > T

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. M

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 of

Re: [PHP] PHP MySQL Insert Statements

2010-03-11 Thread Bruno Fajardo
2010/3/11 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? Woul

[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 Gene

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 > > wrote: > > > On Wed, 2010-02-24 at 09:18 +, Pete Ford wrote: > > >> sudo ln -s /bin/cat /bin/dog > > >> sudo ln -s /

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 > 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...

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 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 want to exe

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

2010-02-24 Thread Ashley Sheridan
On Wed, 2010-02-24 at 09:18 +, Pete Ford wrote: > On 24/02/10 08:20, shiplu wrote: > > Lots of confusion! > > > > So I tried this, > > > > $ for x in cat dog rabbit rat; do echo -n "$x "; if whatis $x> > > /dev/null; then echo found; else echo not found; fi ; done; > > cat found > > dog not fo

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

2010-02-24 Thread Pete Ford
On 24/02/10 08:20, shiplu wrote: Lots of confusion! So I tried this, $ for x in cat dog rabbit rat; do echo -n "$x "; if whatis $x> /dev/null; then echo found; else echo not found; fi ; done; cat found dog not found rabbit not found rat not found That's easy to fix: sudo ln -s /bin/cat /b

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

2010-02-24 Thread shiplu
Lots of confusion! So I tried this, $ for x in cat dog rabbit rat; do echo -n "$x "; if whatis $x > /dev/null; then echo found; else echo not found; fi ; done; cat found dog not found rabbit not found rat not found -- Shiplu Mokaddim My talks, http://talk.cmyweb.net Follow me, http://twitter.

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

2010-02-23 Thread Jim Lucas
Paul M Foster wrote: 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=102&threadID=310099&messageID=3099392&tag=content;leftCol That guy's partial to JOE. Pffft. Rea

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=102&threadID=310099&messageID=3099392&tag=content;leftCol That guy's partial to JOE. Pffft. Real men use Vim. A

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=102&threadID=310099&m > essageID=3099392&tag=content;leftCol

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=102&threadID=310099&m essageID=3099392&tag=content;leftCol > -Original Message- > From: Richard Quadling [mailto:rquad

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 finish

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 wrote: On 23 February 2010 00:28, Daevid Vincent wrote: -Original Message- From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk] On Mon, 2010-02-22 at 14:39 -0800, Don W

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

2010-02-23 Thread Richard Quadling
On 23 February 2010 00:28, Daevid Vincent 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 t

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 > > com

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

2010-02-22 Thread Ashley Sheridan
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

[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, A

[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:

Re: [PHP] PHP/MySQL Superstars

2009-10-02 Thread tedd
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 http://ancientston

Re: [PHP] PHP/MySQL Superstars

2009-10-01 Thread Robert Cummings
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 w

[PHP] PHP/MySQL Superstars

2009-10-01 Thread Jerome Botbol
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 web 2.0 project which involves a variety of exciting new technologies. You will need at least 2 years proven experience on commercial projects. Relevant experience

Re: [PHP] php/mysql Query Question.

2009-09-16 Thread Jim Lucas
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: shell>mysql -uyourmom -plovesme --html > This now will r

Re: [PHP] php/mysql Query Question.

2009-09-16 Thread Robert Cummings
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: $ddvery"; ?> Not are the results safe but the unlimited possibilites are amazing. Thanks so much for the kick sta

Re: [PHP] php/mysql Query Question.

2009-09-16 Thread admin
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: $ddvery"; ?> Not are the results safe but the unlimited possibilites are amazing. Thanks so much for the kick starter ad...@buskirkgraphics.com wr

Re: [PHP] php/mysql Query Question.

2009-09-15 Thread Robert Cummings
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 Cheers, Rob. -- http://www.interjinn.com Applica

Re: [PHP] php/mysql Query Question.

2009-09-15 Thread Robert Cummings
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: shell>mysql -uyourmom -plovesme --html This now will return all

[PHP] php/mysql Query Question.

2009-09-15 Thread admin
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: shell>mysql -uyourmom -plovesme --html This now will return all results in an html format from all qu

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-15 Thread Govinda
Better late then never! :) I played around with your code tonight and got this working on a test server: $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) {

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-15 Thread Jason Pruim
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";

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-13 Thread Govinda
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

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-12 Thread Zareef Ahmed
On Mon, Jul 13, 2009 at 3:19 AM, Govinda wrote: > On Sat, Jul 11, 2009 at 19:57, Govinda >> 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

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-12 Thread Daniel Brown
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, Govinda wrote: >> On Sat, Jul 11, 2009 at 19:57, Govinda >> wrote: >>> >>> I have been using PEAR's tableInfo() to remind myself about the co

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-12 Thread Govinda
On Sat, Jul 11, 2009 at 19:57, Govinda 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 stuff for mysqli.) Th

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-11 Thread Daniel Brown
On Sat, Jul 11, 2009 at 19:57, Govinda 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 stuff for > mysqli.) Thi

[PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-11 Thread Govinda
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 stuff for mysqli.) I have been looking through the manuals, even tried th

Re: [PHP] PHP MySQL 500 Internal Error

2009-06-19 Thread Shawn Simmons
Sorry about thatI wasn't sure if it went the first time when I didn't see the post sfter a refresh8-) "Daniel Brown" wrote in message news:ab5568160906190558u1a585cedpf73eb5690330d...@mail.gmail.com... On Thu, Jun 18, 2009 at 22:10, Shawn Simmons wrote: Greetings Gurus! Also,

Re: [PHP] PHP MySQL 500 Internal Error

2009-06-19 Thread Daniel Brown
On Thu, Jun 18, 2009 at 22:10, Shawn Simmons 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.br...@parasane.net

RE: [PHP] PHP MySQL 500 Internal Error

2009-06-19 Thread Yuri Yarlei
Yarlei. Programmer PHP, CSS, Java, PostregreSQL; Today PHP, tomorrow Java, after the world. Kyou wa PHP, ashita wa Java, sono ato sekai desu. > To: php-general@lists.php.net > From: elcid...@gmail.com > Date: Thu, 18 Jun 2009 22:10:44 -0400 > Subject: [PHP] PHP MySQL 500 In

Re: [PHP] PHP MySQL 500 Internal Error

2009-06-19 Thread Paul Scott
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 com

[PHP] PHP MySQL 500 Internal Error

2009-06-19 Thread Shawn Simmons
Greetings Gurus! I am attempting to use PHP+MYSQL+APACHE and I have downloaded all the latest verions and installed them on a fresh windows XP install. Got the Apache server up and running, got MySQL up and running and installed PHP. Tested PHP with a script containing phpinfo(). Everythin

Re: [PHP] PHP/MYSQL/ Encrypting Sensetive information

2009-04-17 Thread Philip Thompson
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). http://dev.mysql.com/doc/refman/5.1/en/encryptio

Re: [PHP] PHP/MYSQL/ Encrypting Sensetive information

2009-04-17 Thread Bastien Koert
On Fri, Apr 17, 2009 at 10:15 AM, דניאל דנון 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 PM, Russell Jones

Re: [PHP] PHP/MYSQL/ Encrypting Sensetive information

2009-04-17 Thread Stefan Langwald
MySQLs own Function AES_(EN|DE)CRYPT is pretty cool for this case. -- Stefan Langwald 2009/4/17 דניאל דנון : > 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 passw

Re: [PHP] PHP/MYSQL/ Encrypting Sensetive information

2009-04-17 Thread דניאל דנון
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 wrote: > We are looking at a project where we will potentially

Re: [PHP] PHP/MYSQL/ Encrypting Sensetive information

2009-04-17 Thread tedd
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 able

[PHP] PHP/MYSQL/ Encrypting Sensetive information

2009-04-17 Thread Russell Jones
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 able to decrypt the data as well, although this can pr

RE: [PHP] PHP-MYSQL Question

2009-04-07 Thread abdulazeez alugo
> 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 doin

Re: [PHP] PHP-MYSQL Question

2009-04-07 Thread Per Jessen
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 (http://www

Re: [PHP] PHP-MYSQL Question

2009-04-07 Thread HostWare Kft.
: Tuesday, April 07, 2009 3:05 PM Subject: [PHP] PHP-MYSQL Question Hi guys, Please can anyone tell me what I'm doing wrong with the code below? It keep returning unsuccessful. $result=mysql_query("CREATE TABLE table2(table2_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,

[PHP] PHP-MYSQL Question

2009-04-07 Thread abdulazeez alugo
Hi guys, Please can anyone tell me what I'm doing wrong with the code below? It keep returning unsuccessful. $result=mysql_query("CREATE TABLE table2(table2_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, table1_id INT NOT NULL, name VARCHAR(100) NOT NULL, s

Re: [PHP] PHP/MySQL ISP recommendation that lets one edit ft_min_word_len variable?

2009-04-04 Thread Richard Heyes
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.

Re: [PHP] PHP/MySQL ISP recommendation that lets one edit ft_min_word_len variable?

2009-04-04 Thread Michael A. Peters
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 variabl

[PHP] PHP/MySQL ISP recommendation that lets one edit ft_min_word_len variable?

2009-04-04 Thread Rob Gould
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 really need

Re: [PHP] PHP + MySQL - Load last inserts

2009-03-30 Thread Chris
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 ha

Re: [PHP] PHP + MySQL - Load last inserts

2009-03-30 Thread haliphax
On Mon, Mar 30, 2009 at 5:10 PM, Chris wrote: > haliphax wrote: >> >> On Mon, Mar 30, 2009 at 9:13 AM, Sebastian Muszytowski >> wrote: >>> >>> haliphax schrieb: > > [..cut...] Except when your primary key value rolls over, or fills a gap between two other rows that was left

Re: [PHP] PHP + MySQL - Load last inserts

2009-03-30 Thread Chris
haliphax wrote: On Mon, Mar 30, 2009 at 9:13 AM, Sebastian Muszytowski 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 than grabbing rows

Re: [PHP] PHP + MySQL - Load last inserts

2009-03-30 Thread haliphax
On Mon, Mar 30, 2009 at 9:13 AM, Sebastian Muszytowski 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 than grabbing row

RE: [PHP] PHP + MySQL - Load last inserts

2009-03-30 Thread abdulazeez alugo
> 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: > > &g

Re: [PHP] PHP + MySQL - Load last inserts

2009-03-30 Thread Sebastian Muszytowski
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 inser

Re: [PHP] PHP + MySQL - Load last inserts

2009-03-30 Thread haliphax
On Mon, Mar 30, 2009 at 7:55 AM, Sebastian Muszytowski 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 inserted

Re: [PHP] PHP + MySQL - Load last inserts

2009-03-30 Thread Sebastian Muszytowski
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, e

Re: [PHP] PHP + MySQL - Load last inserts

2009-03-30 Thread Marc
>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

Re: [PHP] PHP + MySQL - Load last inserts

2009-03-30 Thread Thijs Lensselink
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

[PHP] PHP + MySQL - Load last inserts

2009-03-30 Thread Sebastian Muszytowski
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 order) So how to do this? I alread

Re: [PHP] [PHP & MySQL] Introduction to using relational databases

2009-03-10 Thread Chris
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 t

RE: [PHP] [PHP & MySQL] Introduction to using relational databases

2009-03-10 Thread Bob McConnell
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 t

Re: [PHP] [PHP & MySQL] Introduction to using relational databases

2009-03-09 Thread Dirk
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

Re: [PHP] [PHP & MySQL] Introduction to using relational databases

2009-03-09 Thread Paul M Foster
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 (fore

Re: [PHP] [PHP & MySQL] Introduction to using relational databases

2009-03-09 Thread 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 use this database

[PHP] [PHP & MySQL] Introduction to using relational databases

2009-03-09 Thread Thilo Klein
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 this database via p

RE: [PHP] Php mysql update

2008-12-29 Thread admin
; 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 update the database and do a +1 to a int field without pulling the data and adding 1 to it and sticking it back in.> &

Re: [PHP] Php mysql update

2008-12-29 Thread John Corry
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

RE: [PHP] Php mysql update

2008-12-29 Thread Gautier Di Folco
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

2008-12-29 Thread admin
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 adding 1 to it and sticking it back in. Someone refresh me on this please. I think it is something like. $dwsl = mysql_query("UPDATE database set Field='+1' WHERE Criteria='Cr

Re: [PHP] PHP/mySQL question using ORDER BY with logic

2008-10-23 Thread Robert Cummings
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 > > L

[PHP] PHP/mySQL question using ORDER BY with logic

2008-10-23 Thread Rob Gould
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 de La Mission Haut-Brion or Le Clarence de

Re: [PHP] PHP + MySQL transactions

2008-05-25 Thread Chris
>> 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

Re: [PHP] PHP + MySQL transactions

2008-05-23 Thread Philip Thompson
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 transactions.

Re: [PHP] PHP + MySQL transactions

2008-05-22 Thread Chris
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

[PHP] PHP + MySQL transactions

2008-05-22 Thread Philip Thompson
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 opinion on the best way t

RE: [PHP] php mysql live feed

2008-05-21 Thread tedd
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

RE: [PHP] php mysql live feed

2008-05-21 Thread admin
sed instead of "innerHTML", as well. I would recommend using innerHTML only if you will be populating the div with HTML code, however. Hope this helps, Todd Boyd Web Programmer > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday,

RE: [PHP] php mysql live feed

2008-05-21 Thread Boyd, Todd M.
essage- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 20, 2008 3:25 PM > To: php-general@lists.php.net > Subject: [PHP] php mysql live feed > > Okay before i pull more hair out... > > I am trying to use php to pull mysql data and refresh the mys

Re: [PHP] php mysql live feed

2008-05-20 Thread Richard Heyes
[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 becaus

Re: [PHP] php mysql live feed

2008-05-20 Thread Kyle Browning
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

  1   2   3   4   5   6   7   8   >