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] PHP and MSSQL

2003-12-31 Thread mayo
yes, it's possible. I'm learning php myself. (I'm a CF junkie.) I got this script from somewhere. I have the info on a backup CD at home. I'll post it if you're having problems with the script below. (I did a google for: ODBC connection mySQL, or something similar to that.) The script below is wh

Re: [PHP-DB] EMERGENCY!!

2003-12-31 Thread Martin Marques
El Mié 31 Dic 2003 16:25, escribió: > He surelly has problems with his DB server. > Does the script die? I am outputting mysql_error() nothing is showing up. > > Hows the mysql logs? I don't know where these are. > > is there some kind of high load on the DB server? I am the only one on it right

Re: [PHP-DB] EMERGENCY!!

2003-12-31 Thread Martin Marques
El Mié 31 Dic 2003 15:28, Dennis Cole escribió: > I think that it has more to do with the type of fields he is putting it > into: > > -- > I am trying to build a web site for our inventory. I have a mysql DB > that I Connect to. The following code is what I use. The array products > wont go p-past

RE: [PHP-DB] EMERGENCY!!

2003-12-31 Thread Dennis Cole
I think that it has more to do with the type of fields he is putting it into: -- I am trying to build a web site for our inventory. I have a mysql DB that I Connect to. The following code is what I use. The array products wont go p-past the 61st ish product, when there are hundreds for it to deal

Re: [PHP-DB] EMERGENCY!!

2003-12-31 Thread Martin Marques
You throw code to the list with no information about what errors or warnings you got. Why do you say it doesn't work? What happens when you run the script? El Mié 31 Dic 2003 12:46, John Greco escribió: > I am trying to build a web site for our inventory. I have a mysql DB that i > connect to. >

[PHP-DB] Re: Subject: Categories and Items query

2003-12-31 Thread Ali Van Doren
Neil, Just wanted to let you know that your advice worked like a charm! Thanks so much! Ali Neil Smth wrote: At 01:11 31/12/2003 +, you wrote: To: [EMAIL PROTECTED] Message-ID: <[EMAIL PROTECTED]> Date: Tue, 30 Dec 2003 12:30:06 -0500 From: Ali Van Doren <[EMAIL PROTECTED]> MIME-Version: 1.

[PHP-DB] Code Problem.... EMERGENCY!!

2003-12-31 Thread John Greco
I am trying to build a web site for our inventory. I have a mysql DB that I Connect to. The following code is what I use. The array products wont go past the 61st ish product, when there are hundreds for it to deal with. I tried this first: $sql5 = "select * from product where whseNum = '".$whseN

[PHP-DB] EMERGENCY!!

2003-12-31 Thread John Greco
I am trying to build a web site for our inventory. I have a mysql DB that i connect to. The following code is what I use. The array products wont go past I tried this first: $sql5 = "select * from product where whseNum = '".$whseNumber."' order by prodNum"; $result5 = mysql_query($sql5, $conn) or

[PHP-DB] Editing mysql records in "Grids"

2003-12-31 Thread Shantanu Oak
Hi, I am trying to install a script to manage small MySQL tables, that I found here... http://www.weberdev.com/get_example.php3?count=3763 1. Instead of Delete button next to each record I will like to have a check box before each record. 2. Instead of Update button next to each record I will like

[PHP-DB] Subject: Categories and Items query

2003-12-31 Thread Neil Smth
At 01:11 31/12/2003 +, you wrote: To: [EMAIL PROTECTED] Message-ID: <[EMAIL PROTECTED]> Date: Tue, 30 Dec 2003 12:30:06 -0500 From: Ali Van Doren <[EMAIL PROTECTED]> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Subject: Categories a

[PHP-DB] PHP and MSSQL

2003-12-31 Thread DragonEye WebDesign
hi, I have been learning PHP and MySQL from a book that I have bought. I am really pleased with the way these 2 systems work, but I was wondering if MSSQL wouldn't be easier to use, more specifically I was wondering wether I could make an Access Database and connect it to my php website using MSSQ