[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

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

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

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

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,

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

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

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

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: ? $db = 'db'; $host = 'host'; $user = 'user'; $pass = 'pass'; $query = select * from $db.my_table; $ddvery = shell_exec(mysql -u$user -p$pass --html

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: ? $db = 'db'; $host = 'host'; $user = 'user'; $pass = 'pass'; $query = select * from $db.my_table; $ddvery =

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: shellmysql -uyourmom -plovesme --html This now will return

[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: shellmysql -uyourmom -plovesme --html This now will return all results in an html format from all

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: shellmysql -uyourmom -plovesme --html This now will return all

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 ?php $db = 'db'; $host = 'host'; $user =

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-15 Thread Govinda
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)

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

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, Govindagovinda.webdnat...@gmail.com wrote: On Sat, Jul 11, 2009 at 19:57, Govindagovinda.webdnat...@gmail.com wrote: I have been using

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

[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

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

2009-07-11 Thread Daniel Brown
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

[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().

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

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 Internal Error Greetings

Re: [PHP] PHP MySQL 500 Internal Error

2009-06-19 Thread Daniel Brown
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

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 danbr...@php.net wrote in message news:ab5568160906190558u1a585cedpf73eb5690330d...@mail.gmail.com... On Thu, Jun 18, 2009 at 22:10, Shawn Simmonselcid...@gmail.com

[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

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

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 rjon...@gmail.com wrote: We are looking at a project where we

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 דניאל דנון 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

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

2009-04-17 Thread Bastien Koert
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

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

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

Re: [PHP] PHP-MYSQL Question

2009-04-07 Thread HostWare Kft.
@lists.php.net Sent: 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

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

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 doing wrong with the code below? It keep returning unsuccessful. Why

[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

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

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

[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

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 reversed

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 searched

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,

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

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

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

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: Hello :) I have some troubles with php

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

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

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

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

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

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

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 to know is how to

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

[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

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

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 (foreign)

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

[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

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 Okay maybe i have just forgot. I am trying

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 and

RE: [PHP] Php mysql update

2008-12-29 Thread admin
-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. Someone refresh me on this please. I think it is something like. $dwsl = mysql_query(UPDATE

[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 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 La Chapelle

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 to a

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

[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

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

RE: [PHP] php mysql live feed

2008-05-21 Thread Boyd, Todd M.
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 mysql data every say 5 seconds for like a live display of the database without

RE: [PHP] php mysql live feed

2008-05-21 Thread admin
: [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 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

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

[PHP] php mysql live feed

2008-05-20 Thread admin
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 because everything i have

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

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

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-11 Thread Rahul P
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.

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-11 Thread Nathan Nobbe
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

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-11 Thread Shawn McKenzie
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

[PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someone help me out please?

2008-05-10 Thread Rahul
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 php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc curl

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someone help me out please?

2008-05-10 Thread Nathan Nobbe
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

  1   2   3   4   5   6   7   8   >