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 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.
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
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:
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
|
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
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
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 *
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
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
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:
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
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
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
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
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
16 matches
Mail list logo