Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Jochem Maas
Dan Joseph schreef: On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta <[EMAIL PROTECTED]>wrote: ... $i[servername] Try: $i['servername'] notice the ' and ' around the name. I've heard you can do w/o those, but I've had issues in the past where it didn't work. ITs also good practice to us

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Vinny Gullotta
That was it!!! Thank you all so much for your help!!! =D ""Dan Joseph"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] On Wed, Sep 17, 2008 at 4:30 PM, Vinny Gullotta <[EMAIL PROTECTED]>wrote: If by key you mean the column in the database, it's called: servername "Micah Gerste

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Micah Gersten
I meant key in the array that was returned by MySQL. I answered you in my other post. The array was numerically index based instead of column based. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote: > If by key you mean the column in the

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Dan Joseph
On Wed, Sep 17, 2008 at 4:30 PM, Vinny Gullotta <[EMAIL PROTECTED]>wrote: > If by key you mean the column in the database, it's called: servername > > "Micah Gersten" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > What is the key for the server name? That's what you need when

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Micah Gersten
That's your problem, you need to use mysql_fetch_assoc instead of mysql_fetch_row. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote: > var_dump looks like this: > > array(2) { [0]=> string(9) "wehost006" [1]=> string(2) "72" } array(2) > {

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Vinny Gullotta
If by key you mean the column in the database, it's called: servername "Micah Gersten" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] What is the key for the server name? That's what you need when you output it. Thank you, Micah Gersten onShore Networks Internal Developer http://

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Vinny Gullotta
var_dump looks like this: array(2) { [0]=> string(9) "wehost006" [1]=> string(2) "72" } array(2) { [0]=> string(8) "H7848-49" [1]=> string(2) "71" } array(2) { [0]=> string(7) "H7853-2" [1]=> string(2) "70" } array(2) { [0]=> string(7) "H7842-2" [1]=> string(2) "64" } array(2) { [0]=> string(9

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Dan Joseph
On Wed, Sep 17, 2008 at 4:21 PM, Vinny Gullotta <[EMAIL PROTECTED]>wrote: > var_dump($i); looks messy, but I can see the server names in there and they > are the correct names. > > > "Micah Gersten" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Do var_dump($i) in the loop to s

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Micah Gersten
What is the key for the server name? That's what you need when you output it. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote: > var_dump($i); looks messy, but I can see the server names in there and > they are the correct names. > > > "

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Vinny Gullotta
var_dump($i); looks messy, but I can see the server names in there and they are the correct names. "Micah Gersten" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Do var_dump($i) in the loop to see if you're getting the data you want. Thank you, Micah Gersten onShore Networks Int

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Vinny Gullotta
""Dan Joseph"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta <[EMAIL PROTECTED]>wrote: What I want to do is find the top 10 servers where the column steps = iisreset. The following code works great except that the page is not displa

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Micah Gersten
Do var_dump($i) in the loop to see if you're getting the data you want. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote: > Still no luck displaying the stupid servername. Any other things I can > try? > > > "Micah Gersten" <[EMAIL PROTECT

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Dan Joseph
On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta <[EMAIL PROTECTED]>wrote: > What I want to do is find the top 10 servers where the column steps = > iisreset. The following code works great except that the page is not > displaying the servername in the 'Server Name' column of my results (nothing >

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Vinny Gullotta
Still no luck displaying the stupid servername. Any other things I can try? "Micah Gersten" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] You'll want to change your Order By statement to 'ORDER BY CountSteps DESC'. Thank you, Micah Gersten onShore Networks Internal Developer ht

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Micah Gersten
You'll want to change your Order By statement to 'ORDER BY CountSteps DESC'. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote: > echo $query; > > yields > > SELECT servername, COUNT(steps) as CountSteps FROM monitoring WHERE > steps = 'IIS

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Vinny Gullotta
""Dan Joseph"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] On Wed, Sep 17, 2008 at 2:30 PM, Vinny Gullotta <[EMAIL PROTECTED]>wrote: ""Dan Joseph"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta <[EMAIL PROTECTED]

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Dan Joseph
On Wed, Sep 17, 2008 at 2:30 PM, Vinny Gullotta <[EMAIL PROTECTED]>wrote: > ""Dan Joseph"" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta <[EMAIL PROTECTED] >> >wrote: >> >> What I want to do is find the top 10 servers where the

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Vinny Gullotta
""Dan Joseph"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta <[EMAIL PROTECTED]>wrote: What I want to do is find the top 10 servers where the column steps = iisreset. The following code works great except that the page is not displa

Re: [PHP] PHP and MySQL SELECT COUNT (*)

2008-09-17 Thread Dan Joseph
On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta <[EMAIL PROTECTED]>wrote: > What I want to do is find the top 10 servers where the column steps = > iisreset. The following code works great except that the page is not > displaying the servername in the 'Server Name' column of my results (nothing >

Re: [PHP] php and mysql date mapping question

2006-10-10 Thread Jochem Maas
Dave Goodchild wrote: > Hi all, I am in the process of creating a national events directory where > people can enter their events (car boot sales, evening classes etc) and > specify whether those events are one-ff events or repeating (daily, weekly > etc) affairs and people can search for those eve

Re: [PHP] PHP and mySQL dates

2006-09-15 Thread Richard Lynch
On Wed, September 13, 2006 5:56 am, Dave Goodchild wrote: > Hi all. I am building an online events registry and have mapped out > all the > dates between Oct 1 2006 and Dec 31 2030, stored in the database as > timestamps incremented by 86400 to give daily slots. I have output the > values using the

Re: [PHP] PHP and mySQL dates

2006-09-13 Thread Dave Goodchild
Good luck with that. > -- http://www.web-buddha.co.uk http://www.projectkarma.co.uk -- http://www.web-buddha.co.uk http://www.projectkarma.co.uk

RE: [PHP] PHP and mySQL dates

2006-09-13 Thread Peter Lauri
No problem, now I will go and make my girlfriend happy :) -Original Message- From: Dave Goodchild [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 13, 2006 6:27 PM To: Peter Lauri Cc: PHP General Subject: Re: [PHP] PHP and mySQL dates Thanks. I have been so up close and personal

Re: [PHP] PHP and mySQL dates

2006-09-13 Thread Dave Goodchild
Thanks. I have been so up close and personal with this that I can't see the wood for the trees. Of course, so obvious. Thank you - you have made me very happy. -- http://www.web-buddha.co.uk http://www.projectkarma.co.uk

RE: [PHP] PHP and mySQL dates

2006-09-13 Thread Peter Lauri
[snip] Hi all. I am building an online events registry and have mapped out all the dates between Oct 1 2006 and Dec 31 2030, stored in the database as timestamps incremented by 86400 to give daily slots. [/snip] I do not really understand the purpose of mapping all dates between Oct 1 2006 and De

Re: [PHP] PHP and mySQL getting smashed...

2006-05-18 Thread Richard Lynch
On Wed, May 17, 2006 6:55 am, Russell Jones wrote: > I have a site that is getting 30K+ traffic daily and it is smashing > mySQL - > any ideas on what to do to make the mysql connections more efficient, > or > anything in general. No bandwidth issue here, just the server getting > killed. It depen

Re: [PHP] PHP and mySQL getting smashed...

2006-05-17 Thread Jochem Maas
Jay Blanchard wrote: [snip] I have a site that is getting 30K+ traffic daily and it is smashing mySQL - any ideas on what to do to make the mysql connections more efficient, or anything in general. No bandwidth issue here, just the server getting killed. [/snip] Without seeing any code or table

Re: [PHP] PHP and mySQL getting smashed...

2006-05-17 Thread Alister Bulman
On 17/05/06, Dave Goodchild <[EMAIL PROTECTED]> wrote: I have a site that is getting 30K+ traffic daily and it is smashing mySQL - > any ideas on what to do to make the mysql connections more efficient, or > anything in general. No bandwidth issue here, just the server getting > killed. > > ...I

RE: [PHP] PHP and mySQL getting smashed...

2006-05-17 Thread Jay Blanchard
[snip] I have a site that is getting 30K+ traffic daily and it is smashing mySQL - any ideas on what to do to make the mysql connections more efficient, or anything in general. No bandwidth issue here, just the server getting killed. [/snip] Without seeing any code or table information my bet woul

Re: [PHP] PHP and mySQL getting smashed...

2006-05-17 Thread Angelo Zanetti
perhaps post some code so we can look at how you doing your queries... HTH Angelo Zanetti Z Logic www.zlogic.co.za [c] +27 72 441 3355 [t] +27 21 469 1052 [f] +27 86 681 5885 Dave Goodchild wrote: I have a site that is getting 30K+ traffic daily and it is smashing mySQL - any ideas on what t

Re: [PHP] PHP and mySQL getting smashed...

2006-05-17 Thread Dave Goodchild
I have a site that is getting 30K+ traffic daily and it is smashing mySQL - any ideas on what to do to make the mysql connections more efficient, or anything in general. No bandwidth issue here, just the server getting killed. ...I may be wrong but using persistent connections (mysql_pconnect) m

Re: [PHP] PHP and MySQL and resouce limits

2005-07-21 Thread Richard Lynch
On Wed, July 20, 2005 5:22 pm, John Hinton said: > I don't get it... I have been upping my memory limit for PHP. 32megs > now... and am making calls to a database on a different server. I see > the loads run up on the other server as it cruches the numbers.. and PHP > is in the process of creating

Re: [PHP] PHP and MySQL and resouce limits

2005-07-20 Thread Matt Darby
John Hinton wrote: I don't get it... I have been upping my memory limit for PHP. 32megs now... and am making calls to a database on a different server. I see the loads run up on the other server as it cruches the numbers.. and PHP is in the process of creating a single little page with about

RE: [PHP] php and mysql help

2004-04-17 Thread David Robley
Friday, April 16, 2004 12:41 PM > To: Jay Blanchard > Subject: RE: [PHP] php and mysql help > > > Please remove my address from any future correspondence about PHP. > Jay, you are confusing persons at a university with persons who may have a Clue [TM] David (also recipient

RE: [PHP] php and mysql help

2004-04-16 Thread Jay Blanchard
Why are you sending this to me? You're at Stanford, you can probably figure out the unsubscribe link and stuff -Original Message- From: David A. Stevens [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 12:41 PM To: Jay Blanchard Subject: RE: [PHP] php and mysql help Please r

RE: [PHP] php and mysql help

2004-04-14 Thread Jay Blanchard
[snip] Hello i need help with mysql_create_db i found the solution once but cant remember what it was if someone could tell me the proper way to create a database with php and mysql i would be greatly thankfull. Thank you. [/snip] http://www.php.net/mysql_create_db You're welcome. -- PHP General

Re: [PHP] php and mysql help

2004-04-14 Thread Curt Zirzow
* Thus wrote webmaster ([EMAIL PROTECTED]): > Hello i need help with mysql_create_db i found the solution once but cant remember > what it was if someone could tell me the proper way to create a database with php > and mysql i would be greatly thankfull. You just need to issue a create database

Re: [PHP] PHP and MySQL date

2003-12-15 Thread Website Managers.net
If you need to store both date and time, there are several ways to accomplish this. MySQL has built-in date/timestamp options, but those long strings would need to be converted for be human readable. The option I use most is telling PHP what format I want to use and entering it into the databas

RE: [PHP] PHP and MySQL problem, please help

2003-11-18 Thread Jay Blanchard
[snip] A query in mysql become with STATE set to STATISTICS and all queries after this query are LOCKED.What is the decision please. [/snip] The decision is to ask for a better description if possible, along with some of the suspected code. -- PHP General Mailing List (http://www.php.net/) To un

Re: [PHP] PHP and MYSQL don't shake hands

2003-09-18 Thread CPT John W. Holmes
From: "Frank Tudor" <[EMAIL PROTECTED]> > The problem I am having is that when I try to pass values to the > database the php fails. > > I think I have singled it down to the connection string but I am > not sure. [snip] > function db_connect() { >global $dbhost, $dbusername, $dbuserpassword,

Re: [PHP] PHP and Mysql Limit

2003-07-02 Thread ed
On Wed, 2 Jul 2003, Jeff Harris wrote: > Then, once you've done it enough times, $start = $count = 178. > [code] > while ($start <= $count) { > // when $start = $count = 178, you won't retrive any data > [/code] The recordset would not alway contain an even number of records resulting in 10 re

Re: [PHP] PHP and Mysql Limit

2003-07-02 Thread ed
Yes, the next page of results would start at #18. The page number only increments by 1. Ed On Wed, 2 Jul 2003, Chris Sherwood wrote: > It looks like your adding 10 to 8 thus getting 18... of course I maybe > looking at this wrong > > - Original Message - > From: <[EMAIL PROTECTED]> > T

Re: [PHP] PHP and Mysql Limit

2003-07-02 Thread Jeff Harris
|- Original Message - |From: <[EMAIL PROTECTED]> |To: <[EMAIL PROTECTED]> |Sent: Wednesday, July 02, 2003 9:23 AM |Subject: [PHP] PHP and Mysql Limit | | |> |> I've created a script that reads a sorted mysql query and outputs specific |> results into text files defined by the start and limi

Re: [PHP] PHP and Mysql Limit

2003-07-02 Thread Chris Sherwood
It looks like your adding 10 to 8 thus getting 18... of course I maybe looking at this wrong - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 02, 2003 9:23 AM Subject: [PHP] PHP and Mysql Limit > > I've created a script that reads a sorted mysq

RE: [PHP] PHP and MYSQL record locking

2003-06-04 Thread John W. Holmes
> We have a multi-user database we use for telemarketing. It is used across > the internet. All the pages are PHP, I am trying to lock or keep other > users > from accessing the same record, so that they do not call the same lead. > For > example, the user selects a zip code to work from and then a

Re: [PHP] PHP and MySQL Full Text Search Problem

2003-03-13 Thread Ray Hunter
Since you are using fulltext search it is going to look for the exact spelling of what you pass in. If you wanted to get matches with Chris then you will want to modify your query by using LIKE. In version 4.0.1 of mysql you can do fulltext search in boolean mode. http://www.mysql.com/doc/en/Ful

RE: [PHP] php and mysql

2003-02-20 Thread Kelly Protsko
I'm not sure what you mean by cut the records at 1/4, if you mean only bringing back 1/4 of the rows you could use the LIMIT clause in your sql statement and give it a number of rows you want brought back. To sort alphabetically just use the order by command in SQL So your query would look like

Re: [PHP] php and mysql

2003-02-20 Thread David Otton
On Thu, 20 Feb 2003 17:44:51 +, you wrote: >When using a php script to pull recorda from a db how can I cut the records >at 1/4 of the total and arrange them alaphabetically according to a certain >field? Thanks in advance. http://www.mysql.com/doc/en/SELECT.html LIMIT and ORDER BY. This

Re: [PHP] PHP and MySQL bug

2003-01-04 Thread Michael J. Pawlowsky
I cant give you a solution, and I''m running on Linux. But I have pages were I do 6-7 queries on one page always using the same connection. Never had a problem with that. Mike *** REPLY SEPARATOR *** >I'm using PHP and MySQL to make my programs. But I think I discovered a bug >

RE: [PHP] PHP and MySQL queries

2002-12-19 Thread Rich Gray
Does it work if you put quotes around the array keys as follows... echo $line['idn']; echo $line['total']; echo $line['idp']; echo $line['position']; echo $line['points']; Rich -Original Message- From: Beauford.2002 [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 20:28 To: PHP General

RE: [PHP] PHP and MySQL queries

2002-12-18 Thread John W. Holmes
So print out $query before you execute it and see what you're actually sending to MySQL. You're apparently sending a valid query, but it's not matching any rows... ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -O

Re: [PHP] PHP and MySQL

2002-12-11 Thread Jason Wong
On Thursday 12 December 2002 09:22, BABA Yoshihiko wrote: > Jason Wong wrote: > > Not sure why you're escaping the single quote. It's unnecessary -- and I > > suspect you mis-escaped $select as well. Any you can use this format, > > which IMHO, is a lot easier on the eyes: > > > > $sql = "INSERT IN

Re: [PHP] PHP and MySQL

2002-12-11 Thread BABA Yoshihiko
Jason Wong wrote: Not sure why you're escaping the single quote. It's unnecessary -- and I suspect you mis-escaped $select as well. Any you can use this format, which IMHO, is a lot easier on the eyes: $sql = "INSERT INTO `guest` SET `title` = '$title', `fir

Re: [PHP] PHP and MySQL

2002-12-11 Thread Pushpinder Singh Garcha
Thanks Jason...that werked fine for me.. --pS On Wednesday, December 11, 2002, at 03:50 PM, Jason Wong wrote: On Thursday 12 December 2002 04:30, Pushpinder Singh Garcha wrote: Hello, I am using PHP to create forms and then am entering the user input into a MySQL DB In the first query I am

Re: [PHP] PHP and MySQL

2002-12-11 Thread Jason Wong
On Thursday 12 December 2002 04:30, Pushpinder Singh Garcha wrote: > Hello, > > I am using PHP to create forms and then am entering the user input into > a MySQL DB > In the first query I am trying to select the values that the user > entered on the form > > THIS DOES NOT WERK gives error unab

Re: [PHP] PHP and MySQL

2002-12-11 Thread Kevin Stone
Numerous syntax errors produce your invalid query... 1) If you use double quotes to enclose the string, "INSERT..., then you do not have to delimit your single quotes. 2) You accidently delimit a variable at VALUES ('\$select 3) The SQL command its self does not need to end with a semi-colon. Fix

Re: [PHP] PHP and MySQL

2002-12-11 Thread Stephen
My guess is you don't have register_globals on. Replace each variable with $_POST['field_name'] or $_GET['field_name'] depending on what your form's method is. You could also turn register_globals on but that is a security risk I've heard. - Original Message - From: "Pushpinder Singh Garc

RE: [PHP] PHP and MySQL sorting using COUNT

2002-11-13 Thread Steve Edberg
Actually, using your original query and referring to $row['count(*)'] would work too. However, when using calculated fields I always use a column alias as Rich recommends - it makes things a lot clearer. -steve At 1:54 PM + 11/13/02, "Rich Gray" <[EMAIL PROTECTED]> wrote: try '... ,count

Re: [PHP] PHP and MySQL sorting using COUNT

2002-11-13 Thread @ Edwin
Hello, <[EMAIL PROTECTED]> wrote: > > I'm sorting records using COUNT with the following mysql command > > $result = mysql_query ("SELECT company_name, agent_name, count(*) FROM > $cur_listings GROUP BY company_name, agent_name"); > > Running this in MySQL does exactly what I need it to do but

Re: [PHP] PHP and MySQL

2002-08-02 Thread Jason Wong
On Saturday 03 August 2002 04:13, Erich Kolb wrote: > Is there any way to speed up MySQL queries? 1) Use a faster computer 2) Read the mysql manual 3) Ask on the mysql list 4) Ask google -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web D

RE: [PHP] PHP and MySQL

2002-08-02 Thread Shane
-Original Message- here any way to speed up MySQL queries? -- Sure, ask for only the data you need. or halt your query when you have what you need. HTH -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] PHP and MySQL

2002-05-17 Thread Craig Vincent
> You do realise, you have just pasted your database connection details to > the world?! I gonna have to write an article on how to communicate > securely over the internet. (not just with PHP, but with the data you > communicate in the messages as well!!) Well not quite, she did post her usernam

Re: [PHP] PHP and MySQL

2002-05-17 Thread Dan Hardiker
Hi, [..] > $user = "OMMITTED"; > $pass = "OMMITTED"; > $db = "Book Store1"; > $local = "OMMITED"; > $link = mysql_connect( "$local", $user, $pass ); [..] You do realise, you have just pasted your database connection details to the world?! I gonna have to write an article on how to communicat

Re: [PHP] PHP and MySQL

2002-05-16 Thread Miguel Cruz
On Thu, 16 May 2002, City Colleges of Chicago - Mannheim wrote: > > 1 > 2 > 3 > 4 > 5 > 6 > 7 > 8 > 9 > 10 > This wasn't your question, but... $i"; ?> miguel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] PHP and MySQL

2002-05-16 Thread Craig Vincent
Missed a spot =) > if( $booktitle AND "quantity" ){ I'm not certain if this if statement is accurate. I've never used a statement like this but from the looks of it the AND "quantity" part would always be true (assuming it parses it). This could be adding to your problem as well. I think you

RE: [PHP] PHP and MySQL

2002-05-16 Thread Craig Vincent
> mysql_select_db( $db, $link ) > > or die ( "Couldn't open the $db: ".mysql_error() ); > > > if ($submit){ > > if( $booktitle AND "quantity" ){ > > $sql = "UPDATE Book2 SET stock ='$stock-quantity' WHERE > booktitle='$booktitle' AND quantity=quantity"; > > } Easy enough =) You're not running t

RE: [PHP] PHP and mySQL

2002-05-14 Thread J Smith
Actually, "elseif" and "else if" are both valid. J Craig Vincent wrote: > > }else if(!$submit){ > > > Acthough you didn't show 75 lines of code my guess would be your problem > lies here. The else and the if shouldn't have a space between them. > > } elseif(!$submit){ > > See how that w

RE: [PHP] PHP and mySQL

2002-05-14 Thread Craig Vincent
> You are missing a " before $booktitle. > old:booktitle=$booktitle AND quantity=quantity"; > new:booktitle="$booktitle AND quantity=quantity"; So you're saying $sql = "UPDATE Book2 SET stock ='$stock-quantity' WHERE booktitle="$booktitle AND quantity=quantity"; is the correct SQL statement? M

RE: [PHP] PHP and mySQL

2002-05-14 Thread Craig Vincent
}else if(!$submit){ Acthough you didn't show 75 lines of code my guess would be your problem lies here. The else and the if shouldn't have a space between them. } elseif(!$submit){ See how that works for you =) Also your SQL is faulty $sql = "UPDATE Book2 SET stock ='$stoc

Re: [PHP] PHP and mySQL

2002-05-14 Thread webmaster
t;[EMAIL PROTECTED]> Sent: Tuesday, May 14, 2002 8:51 PM Subject: Re: [PHP] PHP and mySQL > On Tuesday 14 May 2002 18:38, City Colleges of Chicago - Mannheim wrote: > > I am getting a parse error on line 75. I am trying to say: > > > > if there is a booktitle and a quantity c

Re: [PHP] PHP and mySQL

2002-05-14 Thread Jason Wong
On Tuesday 14 May 2002 18:38, City Colleges of Chicago - Mannheim wrote: > I am getting a parse error on line 75. I am trying to say: > > if there is a booktitle and a quantity chosen, then go to that booktitle > and adjust the quantity in the database. if ($booktitle AND $quantity) { ... > $u

Re: [PHP] PHP and mySQL...

2002-04-05 Thread Miguel Cruz
On Fri, 5 Apr 2002, Anthony Ritter wrote: > Any idea what the cost is for the ISP to install mySQL on their end so that > I can utilize my database that I've set up on localhost? MySQL is free for that sort of usage, so it only costs their time. If they've done it before, it takes about 5 minute

Re: [PHP] PHP and mySQL...

2002-04-05 Thread Anthony Ritter
Cyberskydive wrote in message: > Since you didnt make it clear, do you even have MySql and php on your > server? Are you looking to just move your data or looking to get php & mysql > installed on the server as well? (SERVER = production site, not localhost) ... Yes. I have

Re: [PHP] PHP and mySQL...

2002-04-05 Thread cyberskydive
Since you didnt make it clear, do you even have MySql and php on your server? Are you looking to just move your data or looking to get php & mysql installed on the server as well? (SERVER = production site, not localhost) if you just wanna move data, like everyone else said phpmyadmin rocks, but

Re: [PHP] PHP and mySQL...

2002-04-04 Thread Miguel Cruz
On Thu, 4 Apr 2002, Anthony Ritter wrote: > Sorry if my original question was confusing. > > This is what I would like to accomplish: > > I am currently developing a database on my website using mysql which is on > my harddrive. > I have installed Apache as well and I am using PHP. > > My datab

Re: [PHP] PHP and mySQL...

2002-04-04 Thread Justin French
check out phpMyAdmin, as per my last post on the issue to you. Justin French on 05/04/02 1:25 PM, Anthony Ritter ([EMAIL PROTECTED]) wrote: > Sorry if my original question was confusing. > > This is what I would like to accomplish: > > I am currently developing a database on my website using

Re: [PHP] PHP and mySQL...

2002-04-04 Thread Anthony Ritter
Sorry if my original question was confusing. This is what I would like to accomplish: I am currently developing a database on my website using mysql which is on my harddrive. I have installed Apache as well and I am using PHP. My database is functioning fine on localhost. I would like to find

Re: [PHP] PHP and mySQL...

2002-04-04 Thread Justin French
You should install something like phpMyAdmin, which is a web based admin tool for MySQL... among it's MANY awesome features (create & modify tables and databases, perform queries, all in a GUI way), it has the ability to save dumps of the database or table structure, and/or the database/table data

Re: [PHP] PHP and mySQL...

2002-04-04 Thread heinisch
At 04.04.2002 18:39, you wrote: >Using MS Windows 98, Apache, PHP and mySQL. > >I've installed Apache on my hard drive to test a database driven website >using PHP and mySQL. > >Could somebody lead me through the steps if I want to continue using the >mySQL database and PHP when the site goes liv

Re: [PHP] PHP and MYSQL Security`

2002-01-27 Thread Alan McFarlane
If you know you are running on an apache server, you could try using a simple .htaccess file in a (say) etc directory which contains any or all files you wish to secure. ie: /index.php /etc/config.php /etc/.htaccess --index.php --etc/config.php $config['db_host']="sql"; $confi

Re: [PHP] PHP and MYSQL Security`

2002-01-27 Thread Brian Clark
* Miles Thompson ([EMAIL PROTECTED]) [Jan 27. 2002 19:55]: Hi Miles, [...] > $hostname = "12.34.56.78"; > $user = "username"; > $password = "password"; > $dbname = "database"; > and change your connection string as follows: > include 'params.inc'; > //maybe some other stuff her >

[PHP] [PHP-DB] Re: [PHP] PHP and MYSQL Security`

2002-01-27 Thread Paul DuBois
At 16:59 -0800 1/27/02, Fred wrote: >If this file has a .php extension remote users will not have access to the >variables because the file is parsed by php and they never see the actual >file contents when requesting the document via the web. If you are >concerned with users on localhost having

Re: [PHP] PHP and MYSQL Security`

2002-01-27 Thread Fred
If this file has a .php extension remote users will not have access to the variables because the file is parsed by php and they never see the actual file contents when requesting the document via the web. If you are concerned with users on localhost having access to the file, simply give it the c

Re: [PHP] PHP and mySQL

2002-01-17 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * On 17-01-02 at 21:57 * Morten Nielsen said - --with-mysql. But I can't figure out what that means. That looks like a Unix(ish) command? > Hi, > > I try to use mySQL through PHP, but I can't get it to work. > Both PHP and mySQL is installe

Re: [PHP] PHP and MySQL auth?

2001-08-28 Thread B. van Ouwerkerk
>Case 2. Without any form of auth, I read the text file and do >mysql_connect($the_db_host,$the_db_username,$the_db_pass); > mysql_select_db($the_db_name); > mysql_query("select * from table"); > >and the server response is: >Error 2002: Can't connect to local MySQL server through

Re: [PHP] PHP and MySQL Insert ID

2001-08-01 Thread John Monfort
Many thanks, Daniel! I trully appreciate it. -john __John Monfort_ _+---+_ P E P I E D E S I G N S www.pepiedesigns.com "The world is waiting, are you ready?" -+___+- On Wed, 1 Aug 2001

Re: [PHP] PHP and MySQL Insert ID

2001-08-01 Thread Daniel Rezny
Hello John, Wednesday, August 01, 2001, 11:06:06 AM, you wrote: JM> In an environment where it's possible to have multiple JM> users register at the same time (relatively speaking), how can I be sure JM> that the 'last ID' is indeed the 'intended' last user's ID? JM> Ex. JM>Say tha

Re: [PHP] PHP and MySQL insert problem

2001-04-02 Thread Richard Lynch
Perhaps http://php.net/FAQ.php#4.4 is the answer. -- Visit the Zend Store at http://www.zend.com/store/ Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm - Original Message - From: "Pinwang Chao" <[EMAIL PRO

Re: [PHP] PHP and MySQL query

2001-03-09 Thread Yasuo Ohgaki
Read RFC2396 for URI format. You are escaping query string as HTML where do you don't have to. When you deal with query string, you should escape as URL. Read PHP manual for rawurlencode()/rawurldecode() for URL encode/decode. Regards, Yasuo Ohgaki - Original Message - From: "Jim Ray" <

Re: [PHP] PHP and MySQL ....dynamic query?

2001-03-09 Thread Richard Lynch
>You can see my problem here. I want to be able to write parts of my sql statement based upon >user input, and then execute it all at once. How do I tie all of my $qual variables in so >that this will read/execute it properly? $where = ' where 1=1 '; if ($dig == '1'){ $where .= " and track