Re: [PHP-DB] PHP application hosted on a dektop ubuntu(localhost) vs A .NET software installed on Windows

2010-08-06 Thread maarten
Hello, without further information, it is not really possible to give any kind of indication that a web app can replace the original app. We do not know what the original app is supposed to do, how it works, ... Having said that, I think most apps would be possible to transform to some web app.

Re: [PHP-DB] PHP application hosted on a dektop ubuntu(localhost) vs A .NET software installed on Windows

2010-08-06 Thread Vinay Kannan
Thanks for your reply Maarten, Its a hotel management application for a hotel.. Thanks, Vinay On Fri, Aug 6, 2010 at 1:03 PM, maarten maarten.fo...@edchq.com wrote: Hello, without further information, it is not really possible to give any kind of indication that a web app can replace the

Re: [PHP-DB] PHP application hosted on a dektop ubuntu(localhost) vs A .NET software installed on Windows

2010-08-06 Thread Vinay Kannan
Actually there is no customer registrations happening, its just a resturant and there wouldnt be any registrations and stuff, its a valid point of hosting it on a webserver and building it like any web app, but then internet connection might also be a problem in that area, and if the internet

Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-04 Thread Simcha Younger
paul_s_john...@mnb.uscourts.gov wrote: THE INPUT: $sql_insert_registration = sprintf(INSERT INTO Registrations ( Class_ID, prid, Registrant, Company, Phone, Email ) VALUES ( $_POST[Class_ID], $_POST[prid], '%s',. You

RE: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-04 Thread Ford, Mike
-Original Message- From: Simcha Younger [mailto:sim...@syounger.com] Sent: 04 August 2010 08:19 paul_s_john...@mnb.uscourts.gov wrote: THE INPUT: $sql_insert_registration = sprintf(INSERT INTO Registrations ( Class_ID, prid, Registrant,

Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread Peter Lind
On 3 August 2010 15:04, paul_s_john...@mnb.uscourts.gov wrote: Yes, I may have mixed up the input and output from different iterations of running it. Let me try posting this again although it may not be an issue. Once again if I enter two sequential apostrophes in the name (O''Brien) the

Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread Chris
On 03/08/10 23:04, paul_s_john...@mnb.uscourts.gov wrote: Yes, I may have mixed up the input and output from different iterations of running it. Let me try posting this again although it may not be an issue. Once again if I enter two sequential apostrophes in the name (O''Brien) the INSERT

Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread Karl DeSaulniers
On Aug 3, 2010, at 8:08 AM, Peter Lind wrote: On 3 August 2010 15:04, paul_s_john...@mnb.uscourts.gov wrote: Yes, I may have mixed up the input and output from different iterations of running it. Let me try posting this again although it may not be an issue. Once again if I enter two

Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread Karl DeSaulniers
On Aug 3, 2010, at 5:44 PM, Chris wrote: On 03/08/10 23:04, paul_s_john...@mnb.uscourts.gov wrote: Yes, I may have mixed up the input and output from different iterations of running it. Let me try posting this again although it may not be an issue. Once again if I enter two sequential

Re: [PHP-DB] Stuck in apostrophe hell

2010-08-02 Thread Peter Lind
On 2 August 2010 22:30, paul_s_john...@mnb.uscourts.gov wrote: Before I send the following SQL to MySQL from PHP I print it to screen. PHP chokes on it, but I can paste the exact same query from the screen directly to MySQL and it works just fine. For example: Here's the relevant PHP code:

Re: [PHP-DB] Stuck in apostrophe hell

2010-08-02 Thread Niel Archer
Before I send the following SQL to MySQL from PHP I print it to screen. PHP chokes on it, but I can paste the exact same query from the screen directly to MySQL and it works just fine. For example: Here's the relevant PHP code: ==

Re: [PHP-DB] Stuck in apostrophe hell

2010-08-02 Thread Bret Hughes
I would turn on query logging and see what exactly is making it to mysql. Niel Archer wrote: Before I send the following SQL to MySQL from PHP I print it to screen. PHP chokes on it, but I can paste the exact same query from the screen directly to MySQL and it works just fine. For example:

Re: [PHP-DB] Stuck in apostrophe hell

2010-08-02 Thread Philip Thompson
On Aug 2, 2010, at 4:42 PM, Bret Hughes wrote: I would turn on query logging and see what exactly is making it to mysql. Niel Archer wrote: Before I send the following SQL to MySQL from PHP I print it to screen. PHP chokes on it, but I can paste the exact same query from the screen

Re: [PHP-DB] input statement in php

2010-07-27 Thread Richard Quadling
On 26 July 2010 15:38, Bavithra R bavithr...@gmail.com wrote: hi friends.. Is there any equivalent statement in php  for scanf or cin in c or c++? That is without using html and creating forms. WOW. Completely surprised by the two responses that were given. ?php while ($userinfo =

RE: [PHP-DB] input statement in php

2010-07-26 Thread HallMarc Websites
hi friends.. Is there any equivalent statement in php for scanf or cin in c or c++? That is without using html and creating forms. Thanks in advance regards --Bavithra.R No, there are no equivalents in PHP. __ Information from ESET Smart Security, version of virus signature

RE: [PHP-DB] input statement in php

2010-07-26 Thread Daevid Vincent
-Original Message- From: Bavithra R [mailto:bavithr...@gmail.com] Sent: Monday, July 26, 2010 7:39 AM To: php-db@lists.php.net Subject: [PHP-DB] input statement in php hi friends.. Is there any equivalent statement in php for scanf or cin in c or c++? That is without

Re: [PHP-DB] RE: [phpXperts] No Warping in results [1 Attachment]

2010-07-23 Thread Artur Ejsmont
I guess the html/css is wrong. If you print all links in new TD elements or as nonbreakable test it will look like this. If you just use divs floating left instead then links will fill the space and wrap around. Also getting rid of it all together and simple list of a tags with some space between

Re: [PHP-DB] NULL to 0

2010-07-18 Thread Ron Piggott
Thanks, Ron -- -Original Message- From: Andrés G. Montañez andresmonta...@gmail.com To: ron.pigg...@actsministries.org Cc: php-db@lists.php.net Subject: Re: [PHP-DB] NULL to 0 Date: Sat, 17 Jul 2010 23:20:20 -0300 SELECT IFNULL(SUM(`my_Bible_trivia_knowledge_questions_answered

Re: [PHP-DB] Re: LEFT JOIN query help

2010-07-18 Thread Kesavan Rengarajan
Change 'NOT LIKE' to 'NOT IN' in the outer query. Sent from my iPhone On 19/07/2010, at 4:15 AM, Ron Piggott ron.pigg...@actsministries.org wrote: I am still working on this query and wondering if I should be taking a different approach --- to use a sub query to figure out which questions

Re: [PHP-DB] Re: LEFT JOIN query help

2010-07-18 Thread Ron Piggott
: [PHP-DB] Re: LEFT JOIN query help Date: Mon, 19 Jul 2010 08:21:00 +1000 Change 'NOT LIKE' to 'NOT IN' in the outer query. Sent from my iPhone On 19/07/2010, at 4:15 AM, Ron Piggott ron.pigg...@actsministries.org wrote: I am still working on this query and wondering if I should be taking

Re: [PHP-DB] NULL to 0

2010-07-17 Thread Andrés G . Montañez
SELECT IFNULL(SUM(`my_Bible_trivia_knowledge_questions_answered`.`score`), 0) AS total_score, IFNULL(`my_Bible_trivia_knowledge_profile`.`questions_answered`, 0) AS questions_answered In these cases you must use the IFNULL function, for testing the value. -- Andrés G. Montañez Zend Certified

Re: [PHP-DB] calling a page for each row

2010-07-15 Thread Chris
On 16/07/10 09:38, listread wrote: We need to load a page which performs some tasks specific to each record, including writing some results to another table. I have tried to place a page loading script within the while loop that creates the table, but it seems to only load the page on the last

Re: [PHP-DB] calling a page for each row

2010-07-15 Thread Chris
On 16/07/10 09:51, listread wrote: On 7/15/2010 6:42 PM, Chris wrote: On 16/07/10 09:38, listread wrote: We need to load a page which performs some tasks specific to each record, including writing some results to another table. I have tried to place a page loading script within the while loop

Re: [PHP-DB] calling a page for each row

2010-07-15 Thread listread
On 7/15/2010 8:03 PM, Chris wrote: On 16/07/10 09:51, listread wrote: On 7/15/2010 6:42 PM, Chris wrote: On 16/07/10 09:38, listread wrote: We need to load a page which performs some tasks specific to each record, including writing some results to another table. I have tried to place a page

Re: [PHP-DB] Broken query

2010-07-11 Thread Patrick Price
How is the last mailing date variable set? Have you tried printing out the queries that are run when it is run manually and when it is run as a cron to find any differences? -patrick On Jul 11, 2010 8:23 AM, Ron Piggott ron.pigg...@actsministries.org wrote: I am trying to write a query to

Re: [PHP-DB] Broken query

2010-07-11 Thread Niel Archer
I am trying to write a query to select a trivia question, but I don't want the trivia question category to be the same two days in a row so I added a second SELECT syntax to find out what category was used yesterday. This works when I test it live, but doesn't work when it is part of a cron

Re: [PHP-DB] imagettftext

2010-07-11 Thread Karl DeSaulniers
Nevermind. found it on my own. On Jul 9, 2010, at 8:13 PM, Karl DeSaulniers wrote: Is there a way to get the width and height of text created with imagettftext? Karl DeSaulniers Design Drumm http://designdrumm.com Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database

Re: [PHP-DB] Need help with HTML form errors

2010-07-05 Thread Jesus
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/04/2010 02:55 PM, Jesus wrote: On 07/04/2010 03:30 AM, nagendra prasad wrote: Hi All, I have this php form that I have inserted in the result page.

Re: [PHP-DB] Need help with HTML form errors

2010-07-04 Thread Kesavan Rengarajan
Hi, Those are notices not warnings(meaning they can be ignored sometimes, search for error_reporting in the PHP manual). In your example, if you do not wish ignore the notices, then initialize the different variables to some value. Sent from my iPhone On 04/07/2010, at 6:30 PM, nagendra

Re: [PHP-DB] Image linking help in PHP

2010-07-04 Thread nagendra prasad
Thanks Jason, However will this work if each time let say a variable called $mp_url will change. I hope you know what I meant. The MP3 link will not be constant, but the image file link could be constant. I already linked the MP3 link with its own name (Text ) and its working but now I want to

Re: [PHP-DB] Image linking help in PHP

2010-07-04 Thread Vinay Kannan
So basically you want to be able to associate an image with an Mp3, and the path to the mp3 is stored in the DB, right ? If above is the case, why dont you upload the image to an image folder, and save the path to the image in the DB too along with mp3 path details, I think this should work !

Re: [PHP-DB] Need help with HTML form errors

2010-07-04 Thread Jesus
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/04/2010 03:30 AM, nagendra prasad wrote: Hi All, I have this php form that I have inserted in the result page. form action=index.php

Re: [PHP-DB] Image linking help in PHP

2010-07-04 Thread Karl DeSaulniers
+1 This is the way to do it IMO. Has worked for me. Karl On Jul 4, 2010, at 1:26 PM, Vinay Kannan wrote: So basically you want to be able to associate an image with an Mp3, and the path to the mp3 is stored in the DB, right ? If above is the case, why dont you upload the image to an image

Re: [PHP-DB] RE: [PHP-WIN] Re: Need Help in setting up a server

2010-06-30 Thread Chaitanya Yanamadala
u can do one more thing, u need to get a public ip or a static ip from ur ISP, this will make sure that u have a constant ip on ur machine so that it can be accessed from anywhere.. Chaitanya On Wed, Jun 30, 2010 at 2:10 AM, Warren Vail war...@vailtech.net wrote: The IP you cited Is the IP

Re: [PHP-DB] RE: [PHP-WIN] Re: Need Help in setting up a server

2010-06-30 Thread 3dgtech
Well, there are two more things to do. 1. If you have a router you will have to forward the ports for the webserver (80, etc) to the correct internal ip. - depending on your security needs consider putting your webserver into the fm 2. There are multiple services out there that offer dynamic

Re: [PHP-DB] Need Help in Mysql database

2010-06-30 Thread Bastien Koert
On Wed, Jun 30, 2010 at 10:52 AM, nagendra prasad nagendra802...@gmail.com wrote: Hi All, I have a huge set of MP3 database. My problem is that when I try to search in my database its getting very slow. I was wondering if I split that database into 2 or more tables. Will this improve the

Re: [PHP-DB] Email validation

2010-06-29 Thread Richard Quadling
On 28 June 2010 15:42, gmail agbo...@gmail.com wrote: Hello to you all! I'm facing a problem with a scrip that can validate a form witch accept only as input email address. I have seen many scripts on the net and  were very interesting but I'm not able to implement those scripts on my need.

Re: [PHP-DB] PHP ERP Applications Need Suggestions????

2010-06-28 Thread Adriano Rodrigo Guerreiro Laranjeira
Hello! You should look at same good stable ERP's PHP based, and start your new project from one of them. By example: * BlueErp * Dolibarr * GNU Enterprise * WebERP Cheers, Adriano Laranjeira. On Mon, 28 Jun 2010 17:17:26 +0530 Mohamed Hashim nmdhas...@gmail.com wrote: *Hello everyone,*

RE: [PHP-DB] Re: [PHP-WIN] Need Help in setting up a server

2010-06-28 Thread Systems
The only thing to remember is that the firewall settings on the wamp / xampp machine have to be set to allow incoming connections. Then you can reach the server by IP. I would share the htdocs folder of the server (and map it on the other workstations) , so you can make changes to the working web

RE: [PHP-DB] table html with PHP

2010-06-15 Thread Systems
I assume you're looking for something like: table tr ?php $i = 0; while(array) { echo td$varible[0]/td; $i++; If ($i1) { $i=0; echo '/trtr'; } } ? /tr /table -Original Message- From: Emiliano

Re: [PHP-DB] table html with PHP

2010-06-15 Thread Emiliano Boragina
sorry... why $i = 0 again? 2010/6/15 Systems syst...@3dgtech.com I assume you're looking for something like: table tr ?php $i = 0; while(array) { echo td$varible[0]/td; $i++; If ($i1) { $i=0; echo '/trtr'; }

Re: [PHP-DB] table html with PHP

2010-06-15 Thread Emiliano Boragina
sorry again... thanks for your answer... 2010/6/15 Emiliano Boragina emiliano.borag...@gmail.com sorry... why $i = 0 again? 2010/6/15 Systems syst...@3dgtech.com I assume you're looking for something like: table tr ?php $i = 0; while(array) { echo

Re: [PHP-DB] table html with PHP

2010-06-15 Thread Emiliano Boragina
thank youu... work... I understand why the $i = 0 again... thanks thanks thanks 2010/6/15 Systems syst...@3dgtech.com I assume you're looking for something like: table tr ?php $i = 0; while(array) { echo td$varible[0]/td; $i++; If ($i1)

RE: [PHP-DB] table html with PHP

2010-06-15 Thread Systems
: php-db@lists.php.net Subject: Re: [PHP-DB] table html with PHP thank youu... work... I understand why the $i = 0 again... thanks thanks thanks 2010/6/15 Systems syst...@3dgtech.com I assume you're looking for something like: table tr ?php $i = 0; while(array) { echo

Re: [PHP-DB] Need Help in error msg

2010-06-14 Thread Bavithra R
hi.. Try to change the root password by System-administration-users and groups. Unlock the key and double click the root.Change the root password and try downloading again.I hope this works. --Bavithra

Re: [PHP-DB] ie multi tab label share one cookie?

2010-06-09 Thread Bastien Koert
On Wed, Jun 9, 2010 at 10:28 PM, win.a win@gmail.com wrote: It's known  that the IE browser  share on session in the same APP How about cookie ,the same ?or use its own? Thanks in advacne! All you best What we are struggling for ? The life or the life ? --

Re: [PHP-DB] anyone has experience with pgslq Cybercluster 2 ?

2010-06-01 Thread Chris
On 02/06/10 04:34, Artur Ejsmont wrote: Hi there i just noticed announcement of cybercluster 2 release for postgres. http://www.cybertec.at/en/postgresql_news they say its open source but did not find downloads on their site ; ) Anyone has experinece with it? i loved postgres and used to work

Re: [PHP-DB] upload images

2010-05-31 Thread 3dgtech
It could work, but be careful using timestamp or the php equivalent - microtime since this is reliant on gettimeofday(). If naming conventions don't mandate a sterilized format I woul still recommend using a confirmed new variable. Just my two cents :-) Eli On May 30, 2010, at 10:04 PM,

Re: [PHP-DB] upload images

2010-05-31 Thread Karl DeSaulniers
You are probably right. The use of the $i and say photo_.$i..jpg would work better. and change.. :) Karl On May 31, 2010, at 2:27 AM, 3dgtech wrote: It could work, but be careful using timestamp or the php equivalent - microtime since this is reliant on gettimeofday(). If naming

Re: [PHP-DB] upload images

2010-05-31 Thread Karl DeSaulniers
Good to hear. Karl Sent from losPhone On May 31, 2010, at 2:41 PM, Emiliano Boragina emiliano.borag...@gmail.com wrote: Thanks a lot... this last solution is the best for me... thanks a lot to all!!! 2010/5/31 Karl DeSaulniers k...@designdrumm.com You are probably right. The use of the

Re: [PHP-DB] upload images

2010-05-30 Thread Karl DeSaulniers
Try this Try assigning time() to a variable then add that to the rename. EG: if ($_FILES['foto']['type'] == image/jpeg || $_FILES['foto']['type'] == image/pjpeg){ //nombre de la imagen $timestamp = time(); //movemos la

Re: [PHP-DB] upload images

2010-05-30 Thread 3dgtech
The problem with time() is that fast servers are too fast! (you will have processed multiple files before time() changes.) Add the $i from the for loop in multiple images to the end of your filename. On May 30, 2010, at 4:33 PM, Karl DeSaulniers k...@designdrumm.com wrote: Try this Try

Re: [PHP-DB] Fatal error: Class 'Mail' not found in

2010-05-29 Thread Nilesh Govindarajan
On Sat, May 29, 2010 at 7:23 PM, win.a win@gmail.com wrote: Excuse me to trouble ,in my little application there's a mail function which i revoked the pear package require 'mail.php' when i test the app ,it show me Fatal error: Class 'Mail' not found ,i checked the mail.php no Class Mail?

RE: [PHP-DB] File Downloads

2010-05-28 Thread Adam Schroeder
Hi Karl -- You can store the file contents outside of the web tree and use PHP to read the contents. This allows you to place access control restrictions in the PHP script. This post talks about doing something similar with images. Obviously, if you have a music track... you'll need to

Re: [PHP-DB] File Downloads

2010-05-28 Thread Karl DeSaulniers
On May 28, 2010, at 4:18 PM, Adam Schroeder wrote: Hi Karl -- You can store the file contents outside of the web tree and use PHP to read the contents. This allows you to place access control restrictions in the PHP script. This post talks about doing something similar with images.

Re: [PHP-DB] File Downloads

2010-05-28 Thread Karl DeSaulniers
On May 28, 2010, at 4:33 PM, Karl DeSaulniers wrote: On May 28, 2010, at 4:18 PM, Adam Schroeder wrote: Hi Karl -- You can store the file contents outside of the web tree and use PHP to read the contents. This allows you to place access control restrictions in the PHP script. This

RE: [PHP-DB] File Downloads

2010-05-28 Thread Adam Schroeder
... but depending on the importance of the content -- it should be good. Adam -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 2:36 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] File Downloads On May 28, 2010, at 4:33 PM, Karl DeSaulniers

Re: [PHP-DB] Sqlite inserts inside a PDO fetch loop

2010-05-28 Thread Phpster
Can't you do a limit in the extract SQL and mark the records extracted so that you don't end up extraxting the same ones? Bastien Sent from my iPod On May 28, 2010, at 5:49 PM, Brandon version...@gmail.com wrote: Hello, I have a situation where I am trying to create an index of words

Re: [PHP-DB] File Downloads

2010-05-28 Thread Karl DeSaulniers
On May 28, 2010, at 4:49 PM, Michael Stowe wrote: For that you would probably need to setup a databased system in which (best scenario) they would need to register prior to downloading or (not so secure) capture their IP address and prevent that IP from downloading it again (example

Re: [PHP-DB] File Downloads

2010-05-28 Thread Karl DeSaulniers
logging) Is there any reason not to log them in by personalized means? (such as email/username) -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 6:39 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] File Downloads On May 28, 2010, at 4:49 PM

Re: [PHP-DB] File Downloads

2010-05-28 Thread Karl DeSaulniers
logging) Is there any reason not to log them in by personalized means? (such as email/username) -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 6:39 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] File Downloads On May 28, 2010, at 4

RE: [PHP-DB] File Downloads

2010-05-28 Thread Systems
is 150 or username Is logged in join table (so the 150 first authenticated users can retrieve the file more than once...) Good luck Eli -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 7:40 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] File

Re: [PHP-DB] File Downloads

2010-05-28 Thread Karl DeSaulniers
the file more than once...) Good luck Eli -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 7:40 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] File Downloads This is for a small project of limited edition audio or pictures or scripts

Re: [PHP-DB] Need Simple PHP mysql search engine script

2010-05-24 Thread nagendra prasad
Hi Chaitanya, I have used the below script but its not meeting my requirements. What I need is that I have a database in which their are names which I wanted to use as keywords. I want to search with only one variable called Names. the other stuff will come along with it. Please help me if

Re: [PHP-DB] Need Simple PHP mysql search engine script

2010-05-24 Thread Chris
On 24/05/10 16:01, nagendra prasad wrote: Hi Chaitanya, I have used the below script but its not meeting my requirements. What I need is that I have a database in which their are names which I wanted to use as keywords. I want to search with only one variable called Names. the other stuff will

Re: [PHP-DB] PHP / iODBC / PostGreSQL: running into a deadlock

2010-05-24 Thread Chris
To try to solve this issue, I grabed the sources for PHP (5.3.2) and libiodbc (3.52.7). When ran under GDB, I can observe the following: odbc_exec() [PHP code] calls SQLAllocStmt() [libiodbc code], which calls some internal function that tries to call SQLAllocStmt(), in some indirect recursive

Re: [PHP-DB] Call two class object failed

2010-05-23 Thread Chris
On 24/05/10 11:55, win.a wrote: Hi my friend,i wrote two classed on is user,the other is db .The user have a property which from the db class object . When i writing my application have both class object invoked at the same time ,just like $user_a = new user($para); $db_a = new db() Then the

Re: [PHP-DB] Need Simple PHP mysql search engine script

2010-05-23 Thread Chaitanya Yanamadala
most of the users use this for the search engine.. http://www.sphider.eu/ Chaitanya A man can get discouraged many times but he is not a failure until he stops trying... The difference between 'involvement' and 'commitment' is like an eggs-and-ham breakfast: the chicken was 'involved' - the

Re: [PHP-DB] Need Help in error msg

2010-05-18 Thread Chaitanya Yanamadala
it means the root user password which u are using is the wrong one.. Chaitanya On Tue, May 18, 2010 at 12:49 PM, nagendra prasad nagendra802...@gmail.comwrote: Hi All, I am getting this error while tried to run a downloaded script in WAMP: [1045] dbconn: mysql_connect: Access denied for

Re: [PHP-DB] Need Help in error msg

2010-05-18 Thread Artur Ejsmont
May also be granted rights to login from '%' which will resolve to any host name except localhost. On 18 May 2010 08:24, Peter Lind peter.e.l...@gmail.com wrote: On 18 May 2010 09:19, nagendra prasad nagendra802...@gmail.com wrote: Hi All, I am getting t... It means that either the password

Re: [PHP-DB] MySQL: Creating a database with

2010-05-18 Thread Artur Ejsmont
You probably miss the mysql extension or have different one than you are calling. Please call ?php php_info(); ? in script to see what extensions are loaded. if there is some other module supporting mysql just use different way to run sql. otherwise you need to look into php.ini and see if

Re: [PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Niel Archer
Is there a different syntax to the mysql delete statement when the WHERE clause points only to half of the primary key? The structure is as follows: CREATE TABLE IF NOT EXISTS ` table1` ( `id1` int(10) unsigned NOT NULL, `id2` int(10) unsigned NOT NULL, PRIMARY KEY (`id1`,`id2`),

Re: [PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Niel Archer
Is there a different syntax to the mysql delete statement when the WHERE clause points only to half of the primary key? The structure is as follows: CREATE TABLE IF NOT EXISTS ` table1` ( `id1` int(10) unsigned NOT NULL, `id2` int(10) unsigned NOT NULL, PRIMARY KEY

Re: [PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Bastien Koert
On Tue, May 18, 2010 at 2:51 PM, Niel Archer n...@chance.now wrote: Is there a different syntax to the mysql delete statement when the WHERE clause points only to half of the primary key? The structure is as follows: CREATE TABLE IF NOT EXISTS ` table1` (   `id1` int(10) unsigned NOT

Re: [PHP-DB] deleting rows with composite primary key

2010-05-18 Thread Niel Archer
On Tue, May 18, 2010 at 2:51 PM, Niel Archer n...@chance.now wrote: Is there a different syntax to the mysql delete statement when the WHERE clause points only to half of the primary key? The structure is as follows: CREATE TABLE IF NOT EXISTS ` table1` (   `id1` int(10)

Re: [PHP-DB] Help with mysql data sorting using php

2010-05-17 Thread nagendra prasad
DB is like more then 500MB and it will grow day by day :) On Mon, May 17, 2010 at 12:46 PM, Artur Ejsmont ejsmont.ar...@gmail.comwrote: If the DB is very small use tablesorter plugin of jquery. Otherwise custumizable query method. On 17 May 2010 07:56, nagendra prasad

Re: [PHP-DB] Help with mysql data sorting using php

2010-05-17 Thread Artur Ejsmont
Hehe. Then a method: ) just make a query builder method like 'findSongs' with all the params ( optional or mandatory ) like page, limit, sortby, filters etc. then inside build SQL based on args. Just be careful - SQL injection is your enemy here. From app pass all the args from get/ post and

Re: [PHP-DB] Help with mysql data sorting using php

2010-05-17 Thread nagendra prasad
Hi Artur, I am a beginner to this stuff. So, If you or anyone can give me some example codes or may be some links for my reference that would be a great help. Best, Guru. On Mon, May 17, 2010 at 12:57 PM, Artur Ejsmont ejsmont.ar...@gmail.comwrote: Hehe. Then a method: ) just make a query

Re: [PHP-DB] Help with mysql data sorting using php

2010-05-17 Thread kesavan trichy rengarajan
take a look at this: http://datatables.net/examples/data_sources/server_side.html On Mon, May 17, 2010 at 5:30 PM, nagendra prasad nagendra802...@gmail.comwrote: Hi Artur, I am a beginner to this stuff. So, If you or anyone can give me some example codes or may be some links for my

Re: [PHP-DB] form help

2010-05-15 Thread Chaitanya Yanamadala
yes i realize that so this the reason i asked for the ajax.. so can u help me with that Chaitanya On Sat, May 15, 2010 at 4:32 PM, lists-php replies-lists-b3z1-...@listmail.innovate.net wrote: PHP is server-side, so the only way (strictly within php) to get a second drop-down to change

Re: [PHP-DB] Session start

2010-05-14 Thread Peter Lind
On 14 May 2010 18:47, Barry Zimmerman barryzi...@googlemail.com wrote: I have a problem with my system, not sure how I can fix this one. A user has a log in page and takes them to different pages, now each of these pages has a check to make sure they are logged in with the following code:

Re: [PHP-DB] Session start

2010-05-14 Thread Luiz Alberto
Barry, Did you try to use setcookie with expiry date in the past? You could use setcookie before header function of the following manner. session_start(); if (!(isset($_SESSION['username']) $_SESSION['username'] != '')) { setcookie(session,session id, 1); header (Location: login.html); } Best

Re: [PHP-DB] Session start

2010-05-14 Thread Artur Ejsmont
id also suggest to revisit the entire login script that you have attached, its a bit overly complicated. Keep amount of if statements to the minimum and you will not get lost. Try to keep it simple. Session is not a problem for you, just make a very simple set of rules when user is logging in,

Re: [PHP-DB] Session start

2010-05-14 Thread Dustin Simpson
Barry, session_start(); will not wipe clean the user's session so there is something else going on. Does the login.html authentication script correctly set $_SESSION['username'] ? Also, it has been my experience that code like isset($_SESSION['username']) is better if you replace

Re: [PHP-DB] Major Cookie Problem

2010-05-13 Thread Barry Zimmerman
Its only happening in safari with the cookie not being set. It must be my cookie string that is the problem. I just cannot find anything on the issue. My other major issue is the fact that the session is being set when the post has not even been declared, its just setting the session?

Re: [PHP-DB] Major Cookie Problem

2010-05-13 Thread Chaitanya Yanamadala
On 5/13/10, Barry Zimmerman barryzi...@googlemail.com wrote: Its only happening in safari with the cookie not being set. It must be my cookie string that is the problem. I just cannot find anything on the issue. My other major issue is the fact that the session is being set when the post has

Re: [PHP-DB] Major Cookie Problem

2010-05-13 Thread Richard Quadling
On 13 May 2010 12:32, Barry Zimmerman barryzi...@googlemail.com wrote: setcookie('peg', 'YES', 'time()+190', '', 0); Can you try removing the quotes from around the expire parameter. setcookie('peg', 'YES', time()+190, '', 0); Richard -- - Richard Quadling Standing on the shoulders of

Re: [PHP-DB] PDO + The Role of PHP + SQLite - Am I missing something?

2010-05-11 Thread Niel Archer
Hi List, It seems that I'm a little confused (and thus frustrated) with PDO in general, and especially when it comes to PECL php_sqlite3. I understand that PDO is a data-access abstraction layer, and as one, is really good. However, the way I see it, is that PDO should just be an added

Re: [PHP-DB] Extending my login - not sure how to add my code block in

2010-05-11 Thread Bastien Koert
On Tue, May 11, 2010 at 12:26 PM, Barry Zimmerman barryzi...@googlemail.com wrote: I have a login script that is great and I want to expand on this but not sure where to place my new code I have written, I have placed it where I thought but keep getting errors for else and others when

Re: [PHP-DB]how to handle exception in php

2010-05-08 Thread Bavithra R
hi friends... Thanks for your suggestions..but i could not get the exact rank list properly.. My code is as below.. $sql2=SELECT * FROM rank; $result=mysql_query($sql2,$con); $num=mysql_num_rows($result); for($i=0;$i$num;$i++) { $f1=mysql_result($result,$i,regno);

Re: [PHP-DB] MySQL Wildcard

2010-05-07 Thread Onur Yerlikaya
function getOptGrps($ID=null){ if ($ID == All) { $ID = %; // % = MySQL multi character wildcard } $extraClause = ; if(!is_null($ID)) { $extraClause = WHERE OptGrpID LIKE '$ID' ; } $q = SELECT * FROM .OPT_GRPS_TABLE.$extraClause; $result =

Re: [PHP-DB] MySQL Wildcard

2010-05-07 Thread Karl DeSaulniers
On May 7, 2010, at 4:16 AM, Onur Yerlikaya wrote: function getOptGrps($ID=null){ if ($ID == All) { $ID = %; // % = MySQL multi character wildcard } $extraClause = ; if(!is_null($ID)) { $extraClause = WHERE OptGrpID LIKE '$ID' ; } $q = SELECT

Re: [PHP-DB] MySQL Wildcard

2010-05-07 Thread Onur Yerlikaya
so sorry function getOptGrps($ID=null){ $extraClause = ; if($ID != All) { $extraClause = WHERE OptGrpID LIKE '$ID' ; } $q = SELECT * FROM .OPT_GRPS_TABLE.$extraClause; $result = $this-query($q); /* Error occurred, return given name by default */

Re: [PHP-DB] how to upgrade php in linux

2010-05-05 Thread Chaitanya Yanamadala
I apologize guys for being rude.. i know that u guys are helping me out, but i was in a typical awkward position searching for the same things made me a little restless. coming to the point i have posted the question to the centos list as well as suggested by dan.. but still now i could not able

Re: [PHP-DB] how to upgrade php in linux

2010-05-04 Thread Chaitanya Yanamadala
hai bavitra i have read the article from this site http://www.web-tech-india.com/articles/php/compiling_php_apache/ but actually the thing is it is not working for me.. it is giving me some error like this checking for gcc ---no checking for cc--no configure: error: no acceptable cc found in

Re: [PHP-DB] how to upgrade php in linux

2010-05-04 Thread Kesavan Rengarajan
As someone else mentioned in the list, try the remi repository. If you still want to compile from source, then this is what you do to search for packages: yum search packagename So you would be doing: yum search gcc and then install the missing package before compiling php. You may have to

Re: [PHP-DB] Updating MySQL Database after install

2010-05-04 Thread kesavan trichy rengarajan
You need to use the ALTER statement. doc: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html http://dev.mysql.com/doc/refman/5.1/en/alter-table.htmlexample: http://www.1keydata.com/sql/sql-foreign-key.html On Wed, May 5, 2010 at 8:21 AM, Karl DeSaulniers k...@designdrumm.comwrote: Hi, I

Re: [PHP-DB] how to upgrade php in linux

2010-05-04 Thread Chaitanya Yanamadala
hai dan thank you for your suggestion regarding the google thing.. thank god u said me that or else i could have never known that google will get me all the results. dude i just asked this question thinking that some one would help me find the solution not for fun. regarding the thing of compiling

Re: [PHP-DB] how to upgrade php in linux

2010-05-04 Thread Chris
On 05/05/10 15:02, Chaitanya Yanamadala wrote: hai dan thank you for your suggestion regarding the google thing.. thank god u said me that or else i could have never known that google will get me all the results. dude i just asked this question thinking that some one would help me find the

Re: [PHP-DB] how to upgrade php in linux

2010-05-03 Thread David McGlone
On Monday 03 May 2010 07:02:35 Chaitanya Yanamadala wrote: Hai i have installed php in the cent os 5.4. the one which is installed is 5.1.6 now what i want to do is upgrade it to latest one 5.3.2, as i am new to linux environment it is quite hard for me to configure that, can any one guide

<    8   9   10   11   12   13   14   15   16   17   >