SV: [PHP-DB] I am new to PHP

2004-04-15 Thread Henrik Hornemann
Hi, I would guess your problem is in the third file: mysql_query( UPDATE books SET isbn='$ud_isbn' ,title='$ud_title', author='$ud_author',edition='$ud_edition',course_id='$ud_course_id',quan tity = '$ud_quantity', stack_no = '$ud_stack_no' WHERE isbn='$ud_id'); The WHERE clause

Re: [PHP-DB] quotations in value field

2004-04-15 Thread Mikael Grön
On Apr 14, 2004, at 15:33, Ford, Mike [LSS] wrote: On 14 April 2004 15:21, Mikael Grön wrote: Well, I guess a combination of htmlspecialchars and some other function to convert it back, before it gets sent of in the _plain text mails_. You don't need to convert it back -- that happens

[PHP-DB] New To PHP

2004-04-15 Thread Tom Cloyes
I ma trying to learn PHP and am having difficulty with understanding it. Is there a good PHP creator that will create PHP which will let me specify what all I need to have done so that I can go back and try to figure out just how it all fits together? Thanks, Tom KI8IZ

RE: [PHP-DB] New To PHP

2004-04-15 Thread Galbreath, Mark A
I found Lerdorf and Tatroe's Programming PHP (O'Reilly 2002) extremely helpful in understanding the why of PHP. Mark -Original Message- From: Tom Cloyes [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 7:54 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] New To PHP I ma trying to

Re: [PHP-DB] New To PHP

2004-04-15 Thread Mikael Grön
What I did to learn PHP was to surf to http://www.hotscripts.com/ and look at other peoples code. Writing it yourself looking at the hotscript codes also helps you understand the logic of it. Mike On Apr 15, 2004, at 12:53, Tom Cloyes wrote: I ma trying to learn PHP and am having difficulty

RE: [PHP-DB] New To PHP

2004-04-15 Thread Tom Cloyes
Mark, Thanks for responding. I have read the books: PHP4 A Beginners Guide by McCarty from Osborne Mastering PHP 4.1 by Allen and Hornberger from Sybex and have poked around in PHP Cookbook by Sklar and Trachtenberg from O'Reilly Also have read books on MySQL, and am left scratching my head.

RE: [PHP-DB] New To PHP

2004-04-15 Thread Galbreath, Mark A
Nice resource! Thanks for sharing! Mark -Original Message- From: Mikael Grön [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 9:00 AM To: Tom Cloyes; [EMAIL PROTECTED] Subject: Re: [PHP-DB] New To PHP What I did to learn PHP was to surf to http://www.hotscripts.com/ and look

Re: [PHP-DB] New To PHP

2004-04-15 Thread Tom Cloyes
Lisi, Thank you for your reply, and I've bookmarked both sites as well as downloaded a few scripts that look promising. I've also found another creator that may just be what I'm looking for - dbquiksite - http://www.dbqwiksite.com/. Thanks again, T At 03:20 PM 4/15/04 +0200, [EMAIL

[PHP-DB] Re: PHP OO Problem

2004-04-15 Thread Andre Matos
Thanks Justin, I found the problem. I am using the OOP with sessions. The idea is use um object and put it into the session and change it when is necessary. However, instead of change the information in the object and then change the object that is in the session, it is adding more information in

Re: [PHP-DB] Re: PHP OO Problem

2004-04-15 Thread Chris Boget
Is there any way to destroy the object in PHP? http://us2.php.net/manual/en/function.unset.php Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] finding data

2004-04-15 Thread Hull, Douglas D
I am trying to find data, or if not found set a variable to Err. myvalue being a variable in my database and $zchar being my value to find. The following result is never 1 even if no values were found, so the result is always 2. If the finding value does exist in my database this does find

[PHP-DB] Re: finding data

2004-04-15 Thread pete M
the way I would do this is with count() $row = mysql_fetch_assoc(SELECT count(*) as c FROM bivalues WHERE myvalue = '$zchar') if ($row['c'] 0) { echo 'result 2 - found it' }else{ echo 'NOT found' } hope it helps Pete Douglas D Hull wrote: I am trying to find data, or if not

Re: [PHP-DB] Re: finding data

2004-04-15 Thread Mikael Grön
The way I would do it: $result = mysql_query(select * from bivalues WHERE myvalue - '$zchar'); if (mysql_num_rows($result) { echo Result 2 - found it; } else { echo Not found; } This leaves you with the option to start processing the data as soon as error checking is over. Using

[PHP-DB] FPDF Help

2004-04-15 Thread Nathan Mealey
Anyone who is familiar with using FPDF to generate PDFs, I'd really appreciate some suggestions here: I am using the following code, virtually identical to that used in the FPDF tutorial examples. But I keep getting a parse error for the first line containing the variable $this. In the

[PHP-DB] Problems switching from MySQL 3.23 - 4.0

2004-04-15 Thread ergeorge
Hi, I have a page that grabs some data from a MySQL 3.23.58 database on a RedHat 9 box. I'm trying to migrate the db to a Suse box running MySQL 4.0.15. When I connect to the MySQL 4.0 DB, I get strange results. For example, there's a certain query that just returns the number of records in one

[PHP-DB] Date SELECT with IF

2004-04-15 Thread Shaun
Hi, Is it possible to have a clause in a mysql SELECT statement? I would the query to display the date except where it equals the default 000-00-00 to display n/a or something similar. For example SELECT DATE_FORMAT(B.Booking_End_Date, \%Y-%m-%d\) AS 'Booking End Date' FROM Bookings (IF

Re: [PHP-DB] Date SELECT with IF

2004-04-15 Thread Ignatius Reilly
SELECT IF( B.Booking_End_Date != -00-00, DATE_FORMAT( B.Booking_End_Date, %Y-%m-%d ), N/A ) AS Booking_End_Date FROM Bookings AS B, etc. HTH Ignatius _ - Original Message - From: Shaun [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

Re: [PHP-DB] Date SELECT with IF

2004-04-15 Thread Marcjon Louwersheimer
try the WHERE clause. SELECT name, address, phone, date FROM usertable WHERE date = '-00-00' And please, look at the mysql documentation, or at least the tutorial. -- Marcjon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Hi I am new to PHP

2004-04-15 Thread andy amol
I have posted my problem at No: 33892 of this mailing list. I have received 1 reply. No: 33897 My exact problem with second file is as follows: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource on line 15 Can you help me to solve problem, any help would be

[PHP-DB] Re: Hi I am new to PHP

2004-04-15 Thread Shaun
It means there is a problem with your query, if you send the query back to the group someone may be able to help. Andy Amol [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I have posted my problem at No: 33892 of this mailing list. I have received 1 reply. No: 33897 My exact

[PHP-DB] lamer noob question

2004-04-15 Thread Dan Bowkley
So I'm building this website; the first I've tried to build using a mostly dynamic structure. What I've done is create a mysql table, with two fields: id and page_val. The idea is you call the page like http://www.someplace.com/page.php?id=404 and it'll spit back (in this case) the infamous

[PHP-DB] Re: lamer noob question

2004-04-15 Thread Justin Patrin
Dan Bowkley wrote: So I'm building this website; the first I've tried to build using a mostly dynamic structure. What I've done is create a mysql table, with two fields: id and page_val. The idea is you call the page like http://www.someplace.com/page.php?id=404 and it'll spit back (in this

[PHP-DB] Hi I am new to PHP

2004-04-15 Thread andy amol
Hi, I have a problem with the second file. I am not able to update the data from the php program. Any help on that would be appreciated. Any modification which would be reduce the code like directly using the Update command would be appreciated. thanks in advance. My exact problem with

Re: [PHP-DB] Hi I am new to PHP

2004-04-15 Thread George Patterson
On Thu, 15 Apr 2004 14:58:09 -0700 (PDT) andy amol [EMAIL PROTECTED] wrote: Hi, I have a problem with the second file. I am not able to update the data from the php program. Any help on that would be appreciated. Any modification which would be reduce the code like directly using the

[PHP-DB] Re: Hi I am new to PHP

2004-04-15 Thread David Robley
[EMAIL PROTECTED] (Andy Amol) wrote in news:[EMAIL PROTECTED]: I have posted my problem at No: 33892 of this mailing list. I have received 1 reply. No: 33897 My exact problem with second file is as follows: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result

[PHP-DB] Link to do query

2004-04-15 Thread JeRRy
Hi, I have a Tipster Website that lists a Tipster Ladder. So it shows their name and their current score. What I want to do is make their name clickable and upon clicking the name it loads that persons profile which is fetched from the mysql db. Now which would be the best way to do this? I