Re: [PHP-DB] Need help with updating existing mysql records with something else

2011-11-12 Thread tamouse mailing lists
2011/11/11 Amit Tandon : > U can "update" the record with following > > === > $result = mysql_query("UPDATE  tax set mwool40_ > totqty = $res", $connection) or die("error > updating database"); Won't this update every row in the table? I think you'd want: $result = mysql_query("UPDATE ta

Re: [PHP-DB] Need help with updating existing mysql records with something else

2011-11-10 Thread Amit Tandon
Dear Guru U can "update" the record with following === $result = mysql_query("UPDATE tax set mwool40_ totqty = $res", $connection) or die("error updating database"); if (mysql_affected_rows($connection) != 1 (/* no of rows that should be updated */) { die("Update problem") ; } The only

Re: [PHP-DB] Need Help with PHP Mails

2011-04-04 Thread Will Lunden
Hi Guru, Glad to hear it's working! Yes the mail function will be able to handle all the fields, it should be as simple as repeating what you've already done for all of the remaining fields - Will On Apr 4, 2011, at 1:09 PM, Guru™ wrote: Hi Will, Below is my final PHP code, and its wo

Re: [PHP-DB] Need Help with PHP Mails

2011-04-04 Thread Guru™
Hi Will, Below is my final PHP code, and its working now. However this is just a small piece of the form that I have created. In my original form I have more then 50 fields and variables. Now I am not sure how to expand this code having all 50 fields. Can the mail function will take that much fiel

Re: [PHP-DB] Need Help with PHP Mails

2011-04-04 Thread Will Lunden
Hi Guru, Have you already made the php script that includes the "mail" function? If there is an error in your php that is preventing the mail function from working properly, I or someone else may be able to help you correct it if you were to send the php you have written so far. -Will 2011/4/4 Gu

Re: [PHP-DB] Need help with an extra backslash

2011-03-01 Thread Design in Motion Webdesign
Try the stripslashes() function. See on http://php.net/manual/en/function.stripslashes.php for details. Best regards. Steven Hi All, I have a list of product in which WIRE MESH 24G X 3/4" is one of them. When I am trying to print the same its coming like WIRE MESH 24G X 3/4\". I want to re

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

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 p

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 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 speed of searching? Is >

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] 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" wrote: On 18 May 2010 09:19, nagendra prasad wrote: > Hi All, > > I am getting t... It means that either the password you're using is wrong or the user doesn't h

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 wrote: > Hi All, > > I am getting this error while tried to run a downloaded script in WAMP: > > [1045] dbconn: mysql_connect: Access denied for user 'root'@'localho

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

2010-05-18 Thread Peter Lind
On 18 May 2010 09:19, nagendra prasad wrote: > Hi All, > > I am getting this error while tried to run a downloaded script in WAMP: > > [1045] dbconn: mysql_connect: Access denied for user 'root'@'localhost' > (using password: YES) > > Dose anyone know what exactly this means. > > Best, > Guru. >

Re: [PHP-DB] Need Help with data sorting

2010-01-31 Thread Amit Tandon
Hello, I a not clear why are u using so many tables, and also div's within the table. Either use tableless (css tables ) or simply use table(preferably one) without divs in it regds amit "The difference between fiction and reality? Fiction has to make sense." On Sun, Jan 31, 2010 a

Re: [PHP-DB] Need Help

2010-01-28 Thread Udhaya Kumar
Hi There This is what you are looking for. http://phpsense.com/php/php-pagination-script.html Regards udhay On Fri, Jan 29, 2010 at 6:01 AM, nagendra prasad wrote: > Hi, > > I have a database of MP3 and I have designed a PHP-Mysql search engine. I > want to break it down in pages like Google do

Re: [PHP-DB] Need help in triggers

2009-10-05 Thread Samuel ROZE
What are you really want to do ? This is an exemple: CREATE FUNCTION myfunction () RETURNS trigger AS $$ BEGIN NEW.update_date = 'now'::date; RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER set_update_date AFTER INSERT ON matable FOR EACH ROW EXECUTE PROCEDURE myfunction();

Re: [PHP-DB] Need help in triggers

2009-10-05 Thread gunawan
Yogendra Kaushik wrote: Hi all's i am working on an application in which we are using PostgreSql as an database, i need to write trigger for my application. Can any one help me how can i write it. i have try to write it, but did not get success. do you using PEAR? to help database?

Re: [PHP-DB] Need help in triggers

2009-10-05 Thread Pavan Keshavamurthy
Read the manual: http://www.postgresql.org/docs/8.1/interactive/sql-createtrigger.html Best _Pavan On Monday 05 October 2009 14:36:47 Yogendra Kaushik wrote: > Hi all's >i am working on an application in which we are using PostgreSql as an > database, i need to write trigger for my applicati

Re: [PHP-DB] Need help with the code

2009-10-02 Thread nagendra prasad
hay so I have solved the issue. The problem was with my login HTML page. Anyways thanks everyone for quick responses :)

Re: [PHP-DB] Need help with the code

2009-10-02 Thread Jason Gerfen
Maybe you should google for information regarding the php.ini and error reporting. nagendra prasad wrote: Yes I did but still its not working on my web server however its working fine with my WAMP server locally. On Fri, Oct 2, 2009 at 9:17 PM, Jason Gerfen wrote: nagendra prasad wrote:

Re: [PHP-DB] Need help with the code

2009-10-02 Thread Jason Gerfen
Add this to your script and just copy and paste it back. Seriously, you are not going to get any help if you don't show anyone the output of your problem. echo ""; var_dump(print_r($_GET)); var_dump(print_r($_POST)); echo ""; If you are not getting anything in the post try changing the method

Re: [PHP-DB] Need help with the code

2009-10-02 Thread nagendra prasad
Yes I did but still its not working on my web server however its working fine with my WAMP server locally. On Fri, Oct 2, 2009 at 9:17 PM, Jason Gerfen wrote: > nagendra prasad wrote: > >> OK so here is the form for the below code: >> >> >> >> >>Username: >>Passw

Re: [PHP-DB] Need help with the code

2009-10-02 Thread Jason Gerfen
nagendra prasad wrote: OK so here is the form for the below code: Username: Password: Did you try looking at the $_POST array data? echo var_dump(print_r($_POST)); -- Jason Gerfen Systems Administration/Web app

Re: [PHP-DB] Need help with the code

2009-10-02 Thread nagendra prasad
OK so here is the form for the below code: Username: Password:

Re: [PHP-DB] Need help with the code

2009-10-02 Thread Jason Gerfen
nagendra prasad wrote: Hi All, I need some help with the below code. I have this login code with me and its working fine with my *localhost 'WAMP' *server. But when I tried to run the same script on my web host server its not working. Every time its giving me the same message "*please enter a us

Re: [PHP-DB] Need help in PHP file Management System

2009-09-23 Thread nagendra prasad
Hi Vinay, Eric & Everyone, Sorry, I was down with fever 'malaria' since last Friday. I was hospitalized for 3 days. It will take more 2-3 days for me to start working again on my project. Anyways till now I didn't get anything which will solve my issue. Lets see if anyone comes with something new.

Re: [PHP-DB] Need help in PHP file Management System

2009-09-23 Thread Vinay Kannan
Hi Nagendra, Any progress on the task you were at? On Fri, Sep 18, 2009 at 12:40 AM, nagendra prasad wrote: > Eric, I am new to file or content management. So, if possible can you send > me few scripts or some links from where I can learn more about it? > > > Best, > >

Re: [PHP-DB] Need help in PHP file Management System

2009-09-20 Thread Lester Caine
nagendra prasad wrote: Eric, I am new to file or content management. So, if possible can you send me few scripts or some links from where I can learn more about it? Have a look at bitweaver ... http://bitweaver.org What this does is creates a set of directories for storage, and under that one

Re: [PHP-DB] Need help in PHP file Management System

2009-09-20 Thread Velen
;Vinay Kannan" Cc: Sent: Thursday, September 17, 2009 10:16 PM Subject: Re: [PHP-DB] Need help in PHP file Management System Thanks Vinay, I think you are right. I thought about it but then server will have to manage huge set of folders. I also thought that what if we give a unique ID for eac

Re: [PHP-DB] Need help in PHP file Management System

2009-09-17 Thread nagendra prasad
Eric, I am new to file or content management. So, if possible can you send me few scripts or some links from where I can learn more about it? Best,

Re: [PHP-DB] Need help in PHP file Management System

2009-09-17 Thread Eric
- Original Message - From: "nagendra prasad" To: "Vinay Kannan" Cc: Sent: Friday, September 18, 2009 2:16 AM Subject: Re: [PHP-DB] Need help in PHP file Management System > Thanks Vinay, > > I think you are right. I thought about it but then server will

Re: [PHP-DB] Need help in PHP file Management System

2009-09-17 Thread nagendra prasad
Thanks Vinay, I think you are right. I thought about it but then server will have to manage huge set of folders. I also thought that what if we give a unique ID for each file for each user. So, when user wants to access his file the code should first checks if the unique ID and the username is mat

Re: [PHP-DB] Need help in PHP file Management System

2009-09-17 Thread Vinay Kannan
I would think, since you already have different users, so most probably you would be getting them registered, so maybe at the time of the registration, you could create folders for each user, and the files they upload would be on to the folders with their username, the folder securities on the serv

Re: [PHP-DB] Need Help in the below script

2009-09-04 Thread nagendra prasad
Hay Patrick, Thanks so much. Its really working. You have saved my life. Best,

Re: [PHP-DB] Need Help in the below script

2009-09-04 Thread Patrick Price
It appears that you had a missing bracket or two and you had misspelled 'WHERE' in the query. In your code you were checking if the username and password were correct outside of the while loop. Even though it can be uncommon, if you have multiple users with the same username then you would only b

Re: [PHP-DB] Need help in solving issues with configuration of php-5.2.8 with mysql-5.3.1

2009-03-05 Thread Chris
niranjan k wrote: Hi Chris, Thanks for your response. Is there any way to find out which files are in 32 bit or 64 bit? If you're on a packaged system (redhat based inc. fedora, centos, rhel or debian based inc. ubuntu) you might be able to use rpm or dpkg or whatever your system provides.

Re: [PHP-DB] Need help in solving issues with configuration of php-5.2.8 with mysql-5.3.1

2009-03-05 Thread niranjan k
Hi Chris, Thanks for your response. Is there any way to find out which files are in 32 bit or 64 bit? Regards, Niranjan --- On Thu, 3/5/09, chris smith wrote: From: chris smith Subject: Re: [PHP-DB] Need help in solving issues with configuration of php-5.2.8 with mysql-5.3.1 To: niranjan_

Re: [PHP-DB] Need help in solving issues with configuration of php-5.2.8 with mysql-5.3.1

2009-03-05 Thread chris smith
> Do you mean i am using 32bit PHP libraries? If so could you please let me > know where to download 64bit PHP libraries. I tried over the net but i > couldn't get it. No, I meant this: ld: fatal: file /usr/local/mysql/lib/libmysqlclient.so: wrong ELF class: ELFCLASS64 ld: fatal: file ext/libxml

Re: [PHP-DB] Need help in solving issues with configuration of php-5.2.8 with mysql-5.3.1

2009-03-04 Thread niranjan k
Hi Chris, Thanks for your response. Do you mean i am using 32bit PHP libraries? If so could you please let me know where to download 64bit PHP libraries. I tried over the net but i couldn't get it. Regards, Niranjan --- On Thu, 3/5/09, Chris wrote: From: Chris Subject: Re: [PHP-DB]

Re: [PHP-DB] Need help in solving issues with configuration of php-5.2.8 with mysql-5.3.1

2009-03-04 Thread Chris
niranjan k wrote: Hi Chris, Thanks for the response. 1. I ran php configuration as below. $./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql=/apps/mysql/mysql It went fine. Chris > Are you sure? Yes it went fine. 2. While running make, i got following relink error. l

Re: [PHP-DB] Need help in solving issues with configuration of php-5.2.8 with mysql-5.3.1

2009-03-03 Thread niranjan k
ql which points to /apps/mysql/mysql Regards, Niranjan --- On Wed, 3/4/09, chris smith wrote: From: chris smith Subject: Re: [PHP-DB] Need help in solving issues with configuration of php-5.2.8 with mysql-5.3.1 To: niranjan_...@yahoo.com Cc: php-db@lists.php.net Date: Wednesday, March 4, 2009, 12:16

Re: [PHP-DB] Need help in solving issues with configuration of php-5.2.8 with mysql-5.3.1

2009-03-03 Thread chris smith
> 1. I ran php configuration as below. > > $./configure --with-apxs2=/usr/local/apache2/bin/apxs > --with-mysql=/apps/mysql/mysql > > It went fine. Are you sure? > 2. While running make, i got following relink error. > > ld: fatal: file /usr/local/mysql/lib/libmysqlclient.so: wrong ELF class: > E

Re: [PHP-DB] need help on setting up tables for db (NFL Football)

2006-07-05 Thread Stut
Karl James wrote: Team, Heh! I was wondering if anybody can help me or guide me On what tables to make. I want to do all the data entry I just do not know what to do. It's for a fantasy football League. Here is my project! Let me know if anyone can help me directly, through Email, AIM, or

Re: [PHP-DB] Need Help Compiling PHP5 With MS SQL Support

2006-07-05 Thread Riemer Palstra
On Mon, Jul 03, 2006 at 11:14:48AM -0400, Mike wrote: > I am new to Linux and have NEVER compiled PHP. I have PHP 5 and need > to compile it with MS SQL support. Per PHP docs, I installed FreeTDS > and tested it and it works. Now I need to (re)compile PHP to get the > support I need to access MS SQ

Re: [PHP-DB] Need Help Compiling PHP5 With MS SQL Support

2006-07-03 Thread Chris
Mike wrote: I am new to Linux and have NEVER compiled PHP. I have PHP 5 and need to compile it with MS SQL support. Per PHP docs, I installed FreeTDS and tested it and it works. Now I need to (re)compile PHP to get the support I need to access MS SQL databases. I am on a Ubuntu 6.06 version of Li

RE: [PHP-DB] Need help with delete and modify functions on a form.

2005-10-17 Thread Juan Stiller
--- Bastien Koert <[EMAIL PROTECTED]> escribió: > something like this example > (http://www.weberdev.com/get_example-4085.html)? > > Bastien > Thanks Bastien, that would do the job, ill study it to adapt it to my needs. Another thing, i have some flash buttons, (im ussing dreamweaver), so on

RE: [PHP-DB] Need help with delete and modify functions on a form.

2005-10-17 Thread Bastien Koert
something like this example (http://www.weberdev.com/get_example-4085.html)? Bastien From: Juan Stiller <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] Need help with delete and modify functions on a form. Date: Mon, 17 Oct 2005 13:04:51 -0300 (ART) Hi, i ´ve got a php page that

RE: [PHP-DB] Need help with a tricky query

2005-05-20 Thread Murray @ PlanetThoughtful
> > SELECT g. * , concat( ref.fname, ' ', ref.lname ) AS ref, concat( > > ar1.fname, ' ', ar1.lname ) AS ar1, concat( ar2.fname, ' ', ar2.lname > ) > > AS ar2, concat( fourth.fname, ' ', fourth.lname ) AS fourth > > FROM ( ( ( ( ( ( ( ( games g > > RIGHT OUTER JOIN games_referees ref_ass O

Re: [PHP-DB] Need help with a tricky query

2005-05-20 Thread Brent Baisley
First, your design could be better. You are storing the same data (referee) in multiple columns. More on that later. I think the problem with your query is that you are using RIGHT OUTER JOINS when you can and should be using LEFT JOINS. You want to make sure you are always keeping the games re

RE: [PHP-DB] Need help with a tricky query

2005-05-20 Thread Murray @ PlanetThoughtful
> I'm trying to write a query that pulls details on a game record, as well > as > the officials assigned to the game (up to 4 officials may be assigned to > each game, but that's not always the case). > > Game details are in the games table, and assignments are in the > games_referees table (which

Re: [PHP-DB] Need help with MySQL query

2004-03-05 Thread Viorel Dragomir
> > - Original Message - > From: "Mikhail U. Petrov" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, March 05, 2004 11:38 AM > Subject: [PHP-DB] Need help with MySQL query > > > > Hi! > > I need help with simple mysql query. > > I have table: > > program{ > > p

Re: [PHP-DB] Need help with MySQL query

2004-03-05 Thread Viorel Dragomir
- Original Message - From: "Mikhail U. Petrov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 05, 2004 11:38 AM Subject: [PHP-DB] Need help with MySQL query > Hi! > I need help with simple mysql query. > I have table: > program{ > program_id, > partner_i

RE: [PHP-DB] Need help replacing one record

2004-01-09 Thread Hutchins, Richard
If I understand your question correctly, an UPDATE query should be all you need. UPDATE tablename SET columname='value' WHERE someid='somenum'; I'm assuming you don't have the MySQL doc. Check mysql.com for the docs for your version of the server. Rich Hutchins, CIW Professional Sr. Technical Wr

RE: [PHP-DB] Need help replacing one record

2004-01-09 Thread Humberto Silva
$result=mysql_query("UPDATE tablename SET userpwd='$newpass' WHERE username='$name'"); -Original Message- From: Jeroen Wasteels [mailto:[EMAIL PROTECTED] Sent: sexta-feira, 9 de Janeiro de 2004 18:24 To: [EMAIL PROTECTED] Subject: [PHP-DB] Need help replacing one record Is there a way

Re: [PHP-DB] need help with a query

2004-01-02 Thread Kirk Babb
> RE c1: I do not know how I was going to record the records of one team vs > another in a specific series. That is a very good point and I don't have an > answer. I realize this is getting more OT, but if anyone has a nice table structure for handling team v. team series stats I'd like to hear i

Re: [PHP-DB] need help with a query

2003-12-31 Thread Kirk Babb
"Mihail Bota" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I do not think it is going to work, you may want to stick with the PHP > script. MySQL says that is going to enable subqueries from version 4.1 and > the most recent release is 4.0.16 or 4.0.17. > > A question and 2 commen

Re: [PHP-DB] need help with a query

2003-12-31 Thread Mihail Bota
I do not think it is going to work, you may want to stick with the PHP script. MySQL says that is going to enable subqueries from version 4.1 and the most recent release is 4.0.16 or 4.0.17. A question and 2 comments: q: the teams are fixed within league? c1: it is not clear how you record the goa

RE: [PHP-DB] Need help!!!

2003-12-12 Thread Griffiths, Daniel
mber 2003 10:02 To: Griffiths, Daniel Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Need help!!! Yes I'm using a hyperlink to access this page (see below) echo "Modify"; and so I defined my variable "$tutor_id" as $tutor_id = $_GET['tutor_id']; but i still g

RE: [PHP-DB] Need help!!!

2003-12-12 Thread irinchiang
Yes I'm using a hyperlink to access this page (see below) echo "Modify"; and so I defined my variable "$tutor_id" as $tutor_id = $_GET['tutor_id']; but i still got the error: "Undefined index: tutor_id in /usr/local/apache/htdocs/tutor/edit.php " WHat could be the problem?;(

RE: [PHP-DB] Need help!!!

2003-12-12 Thread Griffiths, Daniel
how are you getting the $tutor_id var?, in your script you are using "$action = $_GET["action"];" so you will need to define $tutor_id like $tutor_id = $_GET['tutor_id'], or just use $_GET['tutor_id']. a form can only put variables in the POST array OR the GET array, and if your using hyperlink

Re: [PHP-DB] Need help with queries

2003-10-30 Thread Filip de Waard
On Fri, 2003-10-31 at 01:23, Shiloh Madsen wrote: > I need some help with some join queries im working on and was wondering if > someone might be able to give me some help with them. Kinda lookiin for more > real time discussion, so if you feel like givin me some help, hit me on IM. Hi, If you wa

RE: [PHP-DB] Need help with a OpenLink ODBC driver error again

2003-10-06 Thread Jacob A. van Zanen
Hi Does the query return data when executed not through a browser but directly on the database? If yes, how much time does it take to return the data. I believe default time out for apache is 30 seconds. So maybe it's a webserver setting that needs to be increased. Jack -Original Messag

Re: Fwd: Re: [PHP-DB] need help with foreach()

2003-03-10 Thread Jason Wong
On Monday 10 March 2003 17:56, David Rice wrote: > Here is the complete function I am using. > I returned, for testing i commented out the foreach loop and returned > $staff, then $tips both arrays returned NULL when i did a > var_dump(pointvalue($startdate)); I haven't been following this thr

Fwd: Re: [PHP-DB] need help with foreach()

2003-03-10 Thread David Rice
Here is the complete function I am using. I returned, for testing i commented out the foreach loop and returned $staff, then $tips both arrays returned NULL when i did a var_dump(pointvalue($startdate)); can anyone see how this could be solved? Cheers, dave =

Re: [PHP-DB] need help with foreach()

2003-03-09 Thread Jason Wong
On Monday 10 March 2003 08:10, David Rice wrote: > Hey thank's for the ideas but neither of them work, doh... > > Okay fredrik I know your idea won't work cos list only works with > numericaly indexed arrays, both the arrays that i am using are indexed by > date. (it produces a parse error when ru

Re: [PHP-DB] need help with foreach()

2003-03-09 Thread Fredrik de Vibe
[EMAIL PROTECTED] (David Rice) writes: > Hey thank's for the ideas but neither of them work, doh... > Okay fredrik I know your idea won't work cos list only works with > numericaly indexed arrays, both the arrays that i am using are indexed > by date. You really had me wondering there for a momen

Re: [PHP-DB] need help with foreach()

2003-03-09 Thread David Rice
Hey thank's for the ideas but neither of them work, doh... Okay fredrik I know your idea won't work cos list only works with numericaly indexed arrays, both the arrays that i am using are indexed by date. (it produces a parse error when run) = while(list($d, $t) = each($tips)

Re: [PHP-DB] need help with fetching a result using a function

2003-03-02 Thread Koleszár Tibor
Ahh, thats true. I thought its wokring in mysql. put a * after the select Tibor - Original Message - From: "John W. Holmes" <[EMAIL PROTECTED]> To: "'David Rice'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, March 02, 2003 5:28

RE: [PHP-DB] need help with fetching a result using a function

2003-03-02 Thread John W. Holmes
> I am trying to write a few functions for a project i need to do for > school, > this function should return all the inactive, or active users (1 or 0 > staffstatusid) as an array for creating a drop down menu. > > Now when i perform the following code (yes it is included in a script that > conne

Re: [PHP-DB] need help with fetching a result using a function

2003-03-02 Thread Koleszár Tibor
lt;[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, March 02, 2003 4:59 PM Subject: Re: [PHP-DB] need help with fetching a result using a function > > You haven't thorougly read my message, about 4/5 lines down i have said > "(yes

Re: [PHP-DB] need help with fetching a result using a function

2003-03-02 Thread David Rice
mation. I have tested it with other queries that work... and there is no problem, i am definately connected to the database From: Koleszár Tibor <[EMAIL PROTECTED]> To: "David Rice" <[EMAIL PROTECTED]> Subject: Re: [PHP-DB] need help with fetching a result using a function

RE: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread Peter Lovatt
Hi Probably a missing ; ?> "> -Original Message- From: Ignatius Reilly [mailto:[EMAIL PROTECTED]] Sent: 23 January 2003 22:00 To: David Rice; [EMAIL PROTECTED] Subject: Re: [PHP-DB] need help spotting this php parse error Dunno. I also re

Re: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread Ignatius Reilly
Dunno. I also remember once having a parse error, but it was on line 35. Cheers Ignatius - Original Message - From: "David Rice" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 8:53 PM Subject: [PHP-DB] need help s

RE: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread Mark
gt; It Does have a closing Brace, just check my second email it > contains the > FULL code.. i missed the last few lines copying it the first time > somehow. > > > >From: "Andreas Sheriff" <[EMAIL PROTECTED]> > >To: "David Rice" <[EMAIL PR

RE: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread Hutchins, Richard
> From: David Rice [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 23, 2003 3:11 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] need help spotting this php parse error > > > > > > It Does have a closing Brace, just check my second email

RE: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread David Rice
It Does have a closing Brace, just check my second email it contains the FULL code.. i missed the last few lines copying it the first time somehow. From: "Andreas Sheriff" <[EMAIL PROTECTED]> To: "David Rice" <[EMAIL PROTECTED]> Subject: RE: [PHP-DB] need he

Re: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread heilo
You forgot to close the { of the first if-statement. "> David Rice <[EMAIL PROTECTED]> [EMAIL PROTECTED] 20:53 Uhr: > When i run this script it tells me that I have a parse error on line 34? I

Re: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread Addison Ellis
you might try pulling the semi colon out before while. i put it in red. i think,that's probably it. addison When i run this script it tells me that I have a parse error on line 34? I really can't see it anyhelp (please!) would be much appreciated Cheers, Dave session_start(); if(!$HTTP_C

RE: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread Hutchins, Richard
Tell us specifically what the parse error is reporting to you and specifically what line is line 34. > -Original Message- > From: David Rice [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 23, 2003 2:53 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] need help spotting this php parse e

Re: [PHP-DB] Need Help

2002-11-16 Thread Peter Beckman
A few suggestions. $show["Time"] doesn't exist; replace the 5 lines after your "while" with this: $sms_time=$show["sms_time"]; $smsc=$show["smsc"]; $org_sms=$show["org_sms"]; $dest_sms=$show["dest_sms"]; $msg_content=$show["msg_content"]; Also, so save you som

RE: [PHP-DB] need help with SHOW COLUMNS

2002-11-05 Thread Josh Johnson
I think you may want to loop over $row=mysql_fetch_array($result), each row should have the name of the field, and some additional info about it (I just ran a SHOW COLUMNS query on my log tables in my last post, that should give you an idea of what the output is), try executing the query in the mys

Re: [PHP-DB] need help with "SHOW Colums"

2002-10-31 Thread rolf vreijdenberger
$table="user"; > > $query = " SHOW COLUMNS FROM $user "; > > > > $result = mysql_query ( $query ) or die( mysql_error () ); > > > > while ( $row = mysql_fetch_array ($result) ){ > > > > $x = 0 ;// i don't know what you're trying to do here, but it's wrong!! It keeps resetting$x to zero and does n

Re: [PHP-DB] need help with "SHOW Colums"

2002-10-31 Thread 1LT John W. Holmes
So show us the code that you tried with. This code doesn't do us any good because it's not causing the error. ---John Holmes... - Original Message - From: "David Rice" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 31, 2002 11:31 AM Subject: [PHP-DB] need help with "S

Re: [PHP-DB] need help

2002-10-08 Thread 1LT John W. Holmes
Remove all of the @ for one, so you can see if there are any errors. You're using $rs as two different variables, also. Check mysql_error() after your query to see if an error is returned. ---John Holmes... - Original Message - From: "Frederick Belfon" <[EMAIL PROTECTED]> To: <[EMAIL PRO

Re: [PHP-DB] Need help with time calculation for a tracking system - it DOES involve DB work :)

2002-10-05 Thread Jason Wong
On Saturday 05 October 2002 03:45, Aaron Wolski wrote: > Anyway.. everything as far as entering the time values, etc is working > correctly except the calculation is NOT working as it should!!! > $timeValue = date("g:i:s", $timeDifference); > When I echo everything out to the browser this is wh

Re: [PHP-DB] Need help urgent!!

2002-09-26 Thread Dan Brunner
Check your register_globals value in your PHP.INI!! Dan On Thursday, September 26, 2002, at 11:48 AM, [EMAIL PROTECTED] wrote: > I'm using PHP4.2.2 Win with MySQL 3.2.52 Win and PHP doesn't pass vars > from > 1 php to the other how i fix it? > > Thanks > > > > -- > PHP Database Mailing List

Re: [PHP-DB] Need help urgent!!

2002-09-26 Thread Pierre-Alain Joye
On Thu, 26 Sep 2002 19:48:31 +0300 "Thomas \"omega\" Henning" <[EMAIL PROTECTED]> wrote: > I'm using PHP4.2.2 Win with MySQL 3.2.52 Win and PHP doesn't pass vars from > 1 php to the other how i fix it? Read the documentation, register_globals is SET to off by default. http://www.php.net/manual/e

RE: [PHP-DB] Need help urgent!!

2002-09-26 Thread Hutchins, Richard
What's you register_globals set to? > -Original Message- > From: Thomas "omega" Henning [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 26, 2002 12:49 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Need help urgent!! > > > I'm using PHP4.2.2 Win with MySQL 3.2.52 Win and PHP does

RE: [PHP-DB] Need help urgent!!

2002-09-26 Thread Ryan Jameson (USA)
Do you mean passing vars between forms, between functions, or between includes? <>< Ryan -Original Message- From: Thomas "omega" Henning [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 10:49 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Need help urgent!! I'm using PHP4.2.2

Re: [PHP-DB] Need help getting record number off insert

2002-09-11 Thread Miles Thompson
Check the DataFlex docs and see if it has a function that returns this information, or if the ODBC driver has such a function. Record numbers are dangerously useless in most database operations - they get re-used and changed when records are deleted or repair/compress functions are executed. I

Re: [PHP-DB] need help on improving performance on this querry

2002-05-07 Thread andy
thank you! I did not know this command. Its 0.16s instead of 1.6! Andy <[EMAIL PROTECTED]> schrieb im Newsbeitrag 043c01c1f5f2$47f5b3e0$[EMAIL PROTECTED]">news:043c01c1f5f2$47f5b3e0$[EMAIL PROTECTED]... > SELECT DISTINCT L.* > from data.languages L, data2.user U > WHERE L.id IN (U.language_1,

Re: [PHP-DB] need help on improving performance on this querry

2002-05-07 Thread szii
SELECT DISTINCT L.* from data.languages L, data2.user U WHERE L.id IN (U.language_1, U.language_2, U.language_3) order by name; I believe the IN clause is a shade faster than multiple ORs, but I'm not 100% sure. 'Luck -Szii - Original Message - From: "andy" <[EMAIL PROTECTED]> To: <

RE: [PHP-DB] Need Help with returning new id's

2002-03-19 Thread Gurhan Ozen
Hi, Did you copy and paste your code?IF yes, I have noticed a problem on the code you posted.. Y The line: $run_query = ($maxid,$db_connect); will fail as you didn't put the function name in. Rewrite it as: $run_query = mysql_query($maxid,$db_connect); Gurhan -Original Message- Fro

RE: [PHP-DB] Need Help with returning new id's

2002-03-19 Thread Rick Emery
first, it helps if you show us your REAL code. The query statement you showed below would obviously not work (it's missing the "mysql_query" part. Second, when executing mysql_query() ALWAYS include the "or die(mysql_error())" part to aid diagnostics. Third, your query could not possibly work at

RE: [PHP-DB] need help guys

2002-03-14 Thread Tony James
hi Rehab Because your submitted text on the url contains an '&' anthing after this character will be parsed as a new variable. Instead of location.href="additems.php?category="+c try location.href="additems.php?category="+escape(c) this will encode the '&' aswell as spaces to pre

RE: [PHP-DB] need help guys

2002-03-14 Thread Richard Black
Can you send us the full script?? Why can't you just do a submit??? The problem is the ampersand (&) in the middle. This is a place marker which marks the start of the next variable in the query string. If you absolutely *HAVE* to submit the data this way, you'll need to convert it to the escape

RE: [PHP-DB] need help guys

2002-03-14 Thread matt stewart
you can't pass a literal "&" in a url - it makes it think that it's the next variable. -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: 14 March 2002 11:21 To: [EMAIL PROTECTED] Subject: [PHP-DB] need help guys i have this Antiques & Arts then i pass this to next page:

RE: [PHP-DB] Need help (displaying select data from an array)

2002-02-13 Thread Rick Emery
session_start() does not take a parameter. Use: session_start(); session_register($clothes); -Original Message- From: Renaldo De Silva [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 8:16 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Need help (displaying select data from an

RE: [PHP-DB] Need Help Please

2002-01-03 Thread Rick Emery
Kelvin, As I asked before: WHAT DATABASE ENGINE ARE YOU USING? -Original Message- From: Kelvn Yip [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 11:39 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Need Help Please I have deleted all the info. from the Table by mistaken. Now,

  1   2   >