[PHP-DB] editing, deleting records

2004-01-22 Thread Kirk Babb
Here's a part of my code, which is retrieving player records from mysql and displaying them in a table: - if($queryChk3 !== 0){ print(form action='$_SERVER['PHP_SELF']' method='POST' input type='hidden' name='teamID' value='$teamID'

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 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] table structure question

2003-12-29 Thread Kirk Babb
Hi everyone, I would like to set up the following two tables inside a db for a soccer league, but wanted to run their structure by you guys first. Here it is: dbname: soccer_stats tables: teams, players teams -- name | captain | division | paid | pmnt_notes | win | loss | tie | goals_for |

[PHP-DB] Re: Strange bahavior with mysql_fetch_array($result)

2003-11-20 Thread Kirk Babb
Hi Evan, Try something like this instead: $query = mysql_query(SELECT product_id, product_name, purchase_date from MyTable ORDER BY product_id DESC); if(!$query) { echo mysql_errno() . : . mysql_error() . \n; die; } else { //Now, for fun, display the results in a table with the results

[PHP-DB] problem - query inside a function

2003-10-15 Thread Kirk Babb
Hi, I'm having trouble with a query inside a function. I thought I'd written this so that the function would fail if email and zipcode supplied were not in the same row (trying to use those two things to identify the user), but I don't think that is what is happening because I can enter the wrong

[PHP-DB] [SOLVED] Re: problem - query inside a function

2003-10-15 Thread Kirk Babb
Thanks to Karen and Richard for your help! I removed the quotes around 0 in the comparison for mysql_affected_rows. That was definitely important. I then added the echo $sql; statement Richard recommended, and saw the following: (save some time and just look at the end of the string) SELECT *

[PHP-DB] [CLARIFICATION on SOLUTION] Re: problem - query inside a function

2003-10-15 Thread Kirk Babb
Lines 7-11 should actually read as the following and then what I was saying makes sense 7} else { 8 //a bunch of variables declared here so I pulled them out for space 9} 10$this-sendResult(Edit,$varsToEdit); 11 } I had accidentally erased the curly bracket on line 9. This

[PHP-DB] db list problem

2003-10-15 Thread Kirk Babb
I keep getting this message in Italian every time I post to php.db, does anyone else have this problem? when I click on the link provided in the msg, it takes me to some page and asks for my email address so that my email could be sent to the user fsoto. I didn't do it. Can we get rid of this

[PHP-DB] Re: db list problem

2003-10-15 Thread Kirk Babb
Thanks for hijacking my thread - I guess nobody else is having this problem? I don't understand how I can post to php.db and receive notices and autoresponders from Italy (2 different guys now). -Kirk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: db list problem

2003-10-15 Thread Kirk Babb
Ah, I just read Richards note on the same problem. Let's get rid of these guys, please. -Kirk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] bouncing an idea...

2002-07-10 Thread Kirk Babb
I'm a grad student with a university medical research lab, and they have thousands of samples coming through. They want to integrate a web-based tracking system using barcodes and scanners to trace the samples through the different processing points in the lab. And they don't want to pay for a

[PHP-DB] Re: bouncing an idea...

2002-07-10 Thread Kirk Babb
My apologies for these posts, I'm just not sure where to start I'm asking for info more from the standpoint of finding someone who is using php mysql to accept the info from a scanner rather than wanting info about scanners. Thanks! Kirk -- PHP Database Mailing List

[PHP-DB] about MySQL config for PHP on regular user accounts

2002-05-22 Thread Kirk Babb
Good afternoon everyone, I have a site running on Apache 1.3.24, PHP 4.2.0, and MySQL 3.23.49 all done on a W2K box. Whenever I run as regular user instead of admin, my site runs but cannot make any db connections through the PHP scripts. I installed MySQL as a service, but it won't run when I

[PHP-DB] select and sort question

2002-04-27 Thread Kirk Babb
I have a db table which holds news in the following manner: ID (auto-increment), newsdate (DATE), newstitle, and newstext I have been displaying them by ID, and would like instead to sort them by date (descending). Since I'm using Flash I have been doing mysql_fetch_array for each ID query and