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

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

[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. > I want to append the $mwool40_totqty value with the calculated one "$res". Let say initially the value of $mwool40_totqty is 50. and after calculation its value became 40, then t

[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

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

[PHP-DB] Need Help with PHP Mails

2011-04-04 Thread Guru™
Hi All, I have this HTML form Your Name Contact Numbers (please specify STD code) Email

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

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

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

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

[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.    All Fields "> "> "> "> ***

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 >

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

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

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

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

[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

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

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

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

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

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

[PHP-DB] Need help in triggers

2009-10-05 Thread Yogendra Kaushik
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. -- Regard's Yogendra kaushik

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

[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*" w

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

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

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

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

[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. -- Guru Prasad U

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

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

[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. http://ww

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

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

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 ph

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

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

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

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

2004-03-05 Thread Mikhail U. Petrov
> From: "Mikhail U. 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: &g

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 h

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:

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

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

2004-01-09 Thread Hutchins, Richard
CIW Professional Sr. Technical 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] &

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 rep

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

[PHP-DB] Need help retreiving one record

2004-01-06 Thread Jeroen Wasteels
I'm studying PHP now woth this manual, but it's rather fuzzy on how to show data on screen obtained from a database, or how to assign a value of one record of the database to a variable I can use in my script. Concrete, this is the case: I would like to be able to assign to the variable $TruePassw

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

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

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
'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 hyperlinks to access this script then they will of course be GET vars. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECT

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

2003-12-12 Thread Griffiths, Daniel
rray OR the GET array, and if your using hyperlinks 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 t

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

[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_id"I thought I have... Anyone can help??? Tha

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

[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

[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

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

2003-10-06 Thread Jacob A. van Zanen
ginal 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

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

[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 (http://www.php

[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

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

  1   2   >