[PHP-DB] Need Help with 2 MYSQL Table

2015-04-24 Thread Guru
Hi All, Hope everyone is doing well. I need some help regarding a project. I have a huge list of customers in a ledger in a mysql table (Table A). And in another table I have their names and their ID number (Table B). What I want is when I click on a customer name from Table A, I want php to

[PHP-DB] Need help with SQL Query

2012-04-13 Thread Rikin Parekh
Suppose I have a *BOOKS* table like the one given below: ISBN | Book Title | Author Name 1 Jungle bookSam 2 Princess Diary Joe 3 Titanic Sam 4 House Joe 5 Scary Movie Rick

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 att...@gmail.com: 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 =

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

2011-11-10 Thread Guru™
Hi All, I want to update an existing mysql record with another value after calculating it. Below is the code. ?php $connection = mysql_connect(localhost, root, ) or die(Error connecting to database); mysql_select_db(maha, $connection); $result = mysql_query(SELECT * FROM tax, $connection) or

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 issue

[PHP-DB] Need Help with Search Engine

2011-06-28 Thread Guru™
Hi All, I coded a search engine which is pretty good on its own terms. I have functions and conditions for blank entries or any SQL injection. However I have a problem. When a user start search he uses words like in, for, the, at, on etc... For example: Hotels in India or Car for rent etc.. How

[PHP-DB] Need Help with PHP Mails

2011-04-04 Thread Guru™
Hi All, I have this HTML form style type=text/css !-- .style14 {font-size: 24px } .style14 {font-size: 12px} -- /style table width=788 border=0 align=center tr td width=1023form method=post action= table width=648 height=133 border=0 align=center cellpadding=0 cellspacing=0

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

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

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™ nagendra802...@gmail.com wrote: Hi Will, Below is my

[PHP-DB] Need help with an extra backslash

2011-03-01 Thread nagendra prasad
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 remove the extra \ backslash from the result page. Please help me with this. Best, Guru.

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

[PHP-DB] Need Help with database output

2010-08-28 Thread nagendra prasad
Hi All, I have a database and I want to show it in 3 columns Like Col1 Col2 Col3 data1 data2 data3 data4 data5 data5 ... I tired using table but its not working. Please help me. Best, guru.

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.

[PHP-DB] Need help with HTML form errors

2010-07-04 Thread nagendra prasad
Hi All, I have this php form that I have inserted in the result page. form action=index.php method=post table class=bd border=0 cellspacing=1 cellpadding=4 tr

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

[PHP-DB] Need Help in Mysql database

2010-06-30 Thread nagendra prasad
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 it the best solution for my problem or is their any other solution?

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

[PHP-DB] Need Help in setting up a server

2010-06-27 Thread nagendra prasad
Hi All, I need help in setting up a home server. I know the subject line looks like an off topic but trust me its not. What I want is to set up a WAMP server over the intranet. I have a laptop and 2 desktop. I want to set up a desktop like a wamp server locally so that I can able to use or able

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

[PHP-DB] Need Help in error msg

2010-05-18 Thread nagendra prasad
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 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

[PHP-DB] Need help with linking

2010-02-03 Thread nagendra prasad
Hi All, I have created a search engine for MP3 with mysql database. Now I want to connect each search result with its respective info page which will consist with name of the artist, size, year, and so on. Dose anyone knows how to do it? I did created few static pages with all these info. But its

[PHP-DB] Need Help with data sorting

2010-01-31 Thread nagendra prasad
Hi, I have a database of MP3s in mysql and I have created a php search engine. Now I want to sort it in ascending or descending order if user clicks on the title of the table. For example if user want to arrange the table in ascending or descending order by Name, Size, or by any other field.

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 at

[PHP-DB] Need Help

2010-01-28 Thread nagendra prasad
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 dose. What I mean is when I search for a song it will show me some 100 song list but I want 20 songs per page. So, is their any trick to do it? Best, -- Guru Prasad Ubuntu

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 nagendra802...@gmail.comwrote: Hi, I have a database of MP3 and I have designed a PHP-Mysql search engine. I want to break it down in

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

[PHP-DB] Need help with the code

2009-10-02 Thread nagendra prasad
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 username and a 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

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

2009-10-02 Thread nagendra prasad
OK so here is the form for the below code: html form action='mem_login.php' method='POST' Username: input type='text' name='username'br Password: input type='password' name='password'br input type='submit' value='Log in' /form /html

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: html form action='mem_login.php' method='POST' Username: input type='text' name='username'br Password: input type='password' name='password'br input type='submit' value='Log in'

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 jason.ger...@scl.utah.eduwrote: nagendra prasad wrote: OK so here is the form for the below code: html form action='mem_login.php'

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 pre; var_dump(print_r($_GET)); var_dump(print_r($_POST)); echo /pre; If you are not getting anything in the post try changing the

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 jason.ger...@scl.utah.eduwrote:

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 nagendra802...@gmail.comwrote: 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-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-21 Thread Velen
Kannan viny...@gmail.com Cc: php-db@lists.php.net 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

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

2009-09-21 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

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

2009-09-17 Thread nagendra prasad
Hi All, I need help in PHP file management system. So, I am working on my project in which user will upload a file on the server. I know how to upload a file on server using PHP. But the problem is how to differentiate the different uploaded files with different users. Please help me with this.

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

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

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

2009-09-17 Thread Eric
- Original Message - From: nagendra prasad nagendra802...@gmail.com To: Vinay Kannan viny...@gmail.com Cc: php-db@lists.php.net 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

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,

[PHP-DB] Need help-Send email

2009-09-11 Thread nagendra prasad
Hi All, I want to send my sql database to the user email. But I don't have any Email server or any email domain server. So, is their any way to use my localhost to send emails to the user's email id. If it not possible is their a way that I can use my Gmail to send an email through PHP? Best,

[PHP-DB] Need Help in the below script

2009-09-04 Thread nagendra prasad
Hi all, I am working on my project. I have to create a user regestration page and a login page. I am done with registration page but when I tried to code the login page its not working. Below is the code. Please take a look at script and let me know where am I going wrong. ?php

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

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

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 dmag...@gmail.com wrote: From: chris smith dmag...@gmail.com Subject: Re: [PHP-DB] Need help in solving issues with configuration of php

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

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
...@gmail.com 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: Thursday, March 5, 2009, 3:01 AM niranjan k wrote: Hi Chris, Thanks for the response. 1. I ran php configuration as below

[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
Hi, I installed 64 bit MySQL-5.3.1 and i am in the process of installing php-5.2.8. While configuring php with mysql, getting following issues. Issue: 1. I ran php configuration as below. $./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql=/apps/mysql/mysql It went fine.

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

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
, Niranjan --- On Wed, 3/4/09, chris smith dmag...@gmail.com wrote: From: chris smith dmag...@gmail.com 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 PM 1. I ran

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 SQL

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

2006-07-05 Thread Karl James
Team, 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 MSN.

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,

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

2006-07-03 Thread Mike
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 Linux. Again,

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

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

2005-10-17 Thread Juan Stiller
Hi, i ´ve got a php page that shows records from a database (mysql), basically the php code retrieve info from the database and display it, and with some htm i ´ve made a table to show the recods, i need to add several things to the page, but i´ve no idea how to... A) I need to add a modify

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

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

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 I

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: [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 ON ( g.id =

[PHP-DB] Need help with a tricky query

2005-05-19 Thread Andy Green
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 I alias as

[PHP-DB] Need help with MySQL query

2004-03-05 Thread Mikhail U. Petrov
Hi! I need help with simple mysql query. I have table: program{ program_id, partner_id } partner{ partner_id, parnter_name } how I can get number of distinct partner_id's where program_id in ( bla bla bla)? Best wishes, Mikhail U. Petrov. -- PHP Database Mailing

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_id

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

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

2004-03-05 Thread Mikhail U. Petrov
. Petrov [EMAIL PROTECTED] VD To: [EMAIL PROTECTED] VD Sent: Friday, March 05, 2004 11:38 AM VD Subject: [PHP-DB] Need help with MySQL query Hi! I need help with simple mysql query. I have table: program{ program_id, partner_id } partner{ partner_id, parnter_name

[PHP-DB] Need help replacing one record

2004-01-09 Thread Jeroen Wasteels
Is there a way to change the information in one record of a database, for example the password, without having to open the entire row, delete it, and then add it with $row_data[name] and all and the $newpass as changed password? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

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 replacing one record

2004-01-09 Thread Hutchins, Richard
Writing Administrator Getinge USA 1777 E. Henrietta Rd. Rochester NY 14623 585-272-5072 www.getingeusa.com -Original Message- From: Jeroen Wasteels [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 1:24 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Need help replacing one record

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

[PHP-DB] need help with a query

2003-12-31 Thread Kirk Babb
If (in MySQL) I have to select 'playerID' from the table soccer.players based on lname='smith', fname='john', and dob='1988-12-02' and THEN update soccer.teams 'coachID' equal to the result of the select statement, can I do it all in one query? Or must I let my PHP script execute a select, grab

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

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 comments: q:

[PHP-DB] Need help!!!

2003-12-12 Thread irinchiang
Hi.. Anyone can help me with this script???I kept getting error saying i did not define the variable $tutor_id and whenever I define it as $tutor_id = $_POST ['tutor_id'], I got error saying there was an Undefined index! What was exactly the problem?? Need help desperately , greatly

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

2003-12-12 Thread Griffiths, Daniel
to access this script then they will of course be GET vars. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 December 2003 09:38 To: [EMAIL PROTECTED] Subject: [PHP-DB] Need help!!! Hi.. Anyone can help me with this script???I kept getting error saying i

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

2003-12-12 Thread irinchiang
To: [EMAIL PROTECTED] Subject: [PHP-DB] Need help!!! Hi.. Anyone can help me with this script???I kept getting error saying i did not define the variable $tutor_id and whenever I define it as $tutor_id = $_POST ['tutor_id'], I got error saying there was an Undefined index! What was exactly

[PHP-DB] Need HELP with UPDATE DELETE

2003-12-11 Thread irinchiang
Hi all, Right now I'm trying to do a UPDATE and DELETE queries using the following code below: But i kept getting error Undefined variable: tutor_id in /usr/local/apache/htdocs/tutor/edit.php on line . Didn't I defined my variable $tutor_idI thought I have... Anyone can help???

[PHP-DB] Need help with queries

2003-10-30 Thread Shiloh Madsen
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. AIM: lumerian3 Yahoo: lumerian1 MSN: [EMAIL PROTECTED] ICQ: 76145844

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 want

[PHP-DB] Need help Get/send Variabel to another window

2003-10-10 Thread agus supriatna
Dear all I have two page one as main and secon as child, now I have problem how to send variable/data to main page from child thanks in advance asupna -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2003-10-06 Thread Don Myers
Ok this time I checked the SQL select syntax! So I hope it's not something that easy again (Well actually easy would be nice) The other day I Posted a email question about getting a 37000 sql error but my sql syntax was wrong. Yes I felt stupid but this time I corrected the syntax and I am

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

2003-10-06 Thread Jacob A. van Zanen
Message- From: Don Myers [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 3:23 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Need help with a OpenLink ODBC driver error again Ok this time I checked the SQL select syntax! So I hope it's not something that easy again (Well actually easy would

[PHP-DB] need help with repeated regions

2003-07-27 Thread Alberto
Plz could some one help me how to create an horizontal repeated region in a php page using a mysql database for showing thumbnail without using a expensive plugin such like MXlooper for dreamweaver MX. plz sent me help over mail [EMAIL PROTECTED] thx -- PHP Database Mailing List

[PHP-DB] Need help on query

2003-06-26 Thread Gezeala 'Eyah' Bacuño II
Dear all, I have 2 tables product_customer and product_price product_customer prod_cust_idprod_cust_product_idprod_cust_customer_id 1 1 1 2 2 1 3 3 1 4 1

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

[PHP-DB] need help with foreach()

2003-03-09 Thread David Rice
Okay, i have two arrays, $tips and $staff $tips has a key date (which is the date of the first day of the week, the second result in the array has the key of the second day of the week etc... ) and the value is a floating point decimal. $staff also has a key date and the value is an integer,

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

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

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

[PHP-DB] Need help with php and apache

2003-03-06 Thread Stephen K Knight
I am currently running on a Windows Box the OS is ME I have installed apache 2.0.44 and I have downloaded the newest PHP download for windows. I have read the configuration manual repeatedly for getting the php into the apache httpd.conf doc file. but I still cannot get php to be recognized. Can

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

2003-03-02 Thread David Rice
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 connects to the

  1   2   >