Re: [PHP] IBM's Learning PHP Part 1 tutorial.

2005-07-06 Thread Marek Kilimajer
Richard Davey wrote: Hello André, Wednesday, July 6, 2005, 3:25:37 PM, you wrote: AM> Depending on the sittuation, IMHO, COUNT(*) wouldn't be the way to AM> go. If you need the user's id or somesuch, you have to run an AM> additional query to get the info. But they're returning absolutely noth

Re: [PHP] IBM's Learning PHP Part 1 tutorial.

2005-07-06 Thread Angelo Zanetti
have to agree with Richard here, its wasting resources bringing back * from the database. Its one of those fundamentals. Only do a select * from... where you actually need all the info. Bill, try read the manual to see how the |mysql_query() returns info. SOmeone has posted the link in this threa

Re: [PHP] IBM's Learning PHP Part 1 tutorial.

2005-07-06 Thread André Medeiros
On Wed, 2005-07-06 at 14:12 +0100, Richard Davey wrote: > Hello Bill, > > Wednesday, July 6, 2005, 3:36:09 AM, you wrote: > > BM> I'm working my way through IBM's PHP tutorial. Generally good ... > BM> but I'm stuck at an error point and have no idea what's going > BM> wrong. Before adding a new

Re: [PHP] IBM's Learning PHP Part 1 tutorial.

2005-07-06 Thread John Nichel
Bill McEachran wrote: Newbie question. I'm working my way through IBM's PHP tutorial. Generally good ... but I'm stuck at an error point and have no idea what's going wrong. Before adding a new row to the mysql database (already opened) we do a query to see if a particular record already exis

Re: [PHP] IBM's Learning PHP Part 1 tutorial.

2005-07-06 Thread Richard Davey
Hello Bill, Wednesday, July 6, 2005, 3:36:09 AM, you wrote: BM> I'm working my way through IBM's PHP tutorial. Generally good ... BM> but I'm stuck at an error point and have no idea what's going BM> wrong. Before adding a new row to the mysql database (already BM> opened) we do a query to see if

RE: [PHP] IBM's Learning PHP Part 1 tutorial.

2005-07-06 Thread Jay Blanchard
[snip] We then test, using if, to see if $resultT is true or false. If it's false we are then supposed to enter a new record. Problem: it's never false. It always evaluates true. What am I doing wrong? TIA /* build query to see if the record is entered already */ $sqlT = "select * f

Re: [PHP] IBM's Learning PHP Part 1 tutorial.

2005-07-06 Thread André Medeiros
On Tue, 2005-07-05 at 22:36 -0400, Bill McEachran wrote: > Newbie question. > > I'm working my way through IBM's PHP tutorial. Generally good ... but > I'm stuck at an error point and have no idea what's going wrong. > Before adding a new row to the mysql database (already opened) we do a > que