[PHP-DB] Using Array with form submission

2004-03-12 Thread Aleks @ USA.net
I have been trying to get this to work and think I must be missing something. I am using Kevin Yank's books and examples as a guide. Here is what I have so far - this does work [as it should since Kevin created it.. 8-) ] I have a form that creates a list of items with a select link that when

[PHP-DB] Using Array with form submission

2004-03-12 Thread Aleks @ USA.net
Sorry for all the dead space in my last post... I cleaned it up some here... === I have been trying to get this to work and think I must be missing something. I am using Kevin Yank's books and examples as a guide. Here is

[PHP-DB] Group inner join results

2004-03-08 Thread Aleks @ USA.net
Hi all, I thought I saw the answer to this question on here but can not find the answer .. So, I am doing an inner join on 2 tables and displaying the result as follows: Code= table cellspacing=2 cellpadding=2 border=0 tr tdfont

RE: [PHP-DB] Re: php-db Digest 8 Mar 2004 20:50:10 -0000 Issue 2294

2004-03-08 Thread Aleks @ USA.net
12:50 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: From: Aleks @ USA.net [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 8 Mar 2004 15:50:01 -0500 To: PHPDatabase List [EMAIL PROTECTED] Subject: Group inner join results Hi all, I thought I saw the answer to this question

RE: [PHP-DB] INSERT into mysql from dynamic drop down

2004-01-07 Thread Aleks @ USA.net
Hello Irin, Not sure where you problem is but here is what I would check first. After you open the page that has the drop down list, view the source and See if the OPTION VALUE= has any value assigned to it. If you are using IE, on the menu bar click on View - Source. Second, if that is fine,

RE: [PHP-DB] table structure question

2003-12-29 Thread Aleks @ USA.net
Hi Kirt, Your tables look ok to me... As for your question, if I were using your example, I would link the field teams.name to players.team_name. For example, I would set another column in the teams table to be auto incrementing. As you add the team information, the team will get a number

RE: [PHP-DB] Re: Display Mysql Result in drop down list

2003-12-23 Thread Aleks @ USA.net
Hi, I am looking at your code and have a question, in your code you have print OPTION VALUE=\$tutor_name\ SELECTED .$row [tutor_name]. /option; Doesn't the SELECTED piece mark everything listed as selected?? When you bring up the page with the drop down list and open the source, what does it

RE: [PHP-DB] Sessions and input form

2003-11-24 Thread Aleks @ USA.net
Dear Jeffrey, Yes that is clear thank you... I have used this technique in the past But wanted to give sessions a try. I did manage to get it working. Seems That typing code at midnight can lead to frustrating and volatile results.. Thanks again for your response... Aleks -Original

RE: [PHP-DB] number_format problem

2003-11-05 Thread Aleks @ USA.net
Great answer... One question though, how would you convert it back to X,xxx.00 format?? Thanks Aleks -Original Message- From: Peter Beckman [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 10:48 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] number_format problem On Wed,

[PHP-DB] Select Value with 's

2003-11-05 Thread Aleks @ USA.net
This is a basic question but I am all messed up and need to be straightened out.. Have a select field called customer that works great except when there is a ' in the customer name. Have tried addslash and stripslashes but I think I might be using them wrong. If I addslash to the select

RE: [PHP-DB] Select Value with 's

2003-11-05 Thread Aleks @ USA.net
)) { echo stripslashes($res-customer).'br'.\n; } hth? _ma # life would be easier if i knew the source code... Von: Aleks @ USA.net [EMAIL PROTECTED] Datum: Wed, 5 Nov 2003 13:12:45 -0500 An: [EMAIL PROTECTED] Betreff: [PHP-DB] Select Value with 's This is a basic question but I am all

RE: [PHP-DB] Select Value with 's

2003-11-05 Thread Aleks @ USA.net
(): supplied argument is not a valid MySQL result -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 1:45 PM To: Aleks @ USA.net; 'ma'; 'PHP-DB' Subject: Re: [PHP-DB] Select Value with 's From: Aleks @ USA.net [EMAIL PROTECTED

RE: [PHP-DB] Select Value with 's

2003-11-05 Thread Aleks @ USA.net
with 's hi think you should use ' when you create the query and in the SQL-statement for comparison: $qry = 'SELECT * FROM customer WHERE customer.customer LIKE '.$FF.''; _ma # life would be easier if i knew the source code... Von: Aleks @ USA.net [EMAIL PROTECTED] Datum: Wed, 5 Nov 2003 13

RE: [PHP-DB] Select Value with 's

2003-11-05 Thread Aleks @ USA.net
it be like this?: $FF = St Mary's Hospital; $info = mysql_query('Select * From customer Where customer.customer LIKE '.$FF.''); _ma # life would be easier if i knew the source code... Von: Aleks @ USA.net [EMAIL PROTECTED] Datum: Wed, 5 Nov 2003 14:01:37 -0500 An: 'ma' [EMAIL PROTECTED

RE: [PHP-DB] Select Value with 's

2003-11-05 Thread Aleks @ USA.net
hm - it would help if you'd send us the code where you generate the query _ma # life would be easier if i knew the source code... Von: Aleks @ USA.net [EMAIL PROTECTED] Datum: Wed, 5 Nov 2003 14:23:06 -0500 An: 'ma' [EMAIL PROTECTED], 'PHP-DB' [EMAIL PROTECTED] Betreff: RE: [PHP

[PHP-DB] inserting date from text file

2003-10-15 Thread Aleks @ USA.net
Hi all, I have a large text file that I am inserting into a mysql db and seem to have a problem with the date format. The data is currently in the mm/dd/ format. The command I am using is INSERT INTO TABLE (QID,REV,DATE) VALUES (619 , 12 , 1/4/2001); I am using phpMyAdmin with the above

RE: [PHP-DB] inserting date from text file

2003-10-15 Thread Aleks @ USA.net
Thanks John for the idea... will use php to extract and reparse the values in the correct order... -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 5:11 PM To: Aleks @ USA.net; [EMAIL PROTECTED] Subject: Re: [PHP-DB] inserting date

[PHP-DB] backing up MySQL

2003-09-10 Thread Aleks @ USA.net
Was wondering what are people using to backup their php with MySQL dbs?? Thanks for your time and input.. Aleks.

RE: [PHP-DB] how to recognize user login name?

2003-09-04 Thread Aleks @ USA.net
I agree with David.. however you can create a membership system using PHP and MySQL. I did following the information in a tutorial posted here.. http://www.phpfreaks.com/tutorials/40/0.php Many useful tutorials here... Hope this helps... Aleks K -Original Message- From: David Smith

[PHP-DB] Error updating db when using a '

2003-08-21 Thread Aleks @ USA.net
I have a strange problem I am adding records into a MySQL db... there is a description column and everything works fine when I add a new record. When I try to edit an existing record it fails if I us an apostrophe ['] in the field. I thought that addslashes would take care of this but it is

RE: [PHP-DB] Error updating db when using a '

2003-08-21 Thread Aleks @ USA.net
Found the problem.. seems that spanning the sql statement with a carriage return messed something up. It works fine now.. Sorry about the return receipt earlier... won't happen again.. Thanks Aleks -Original Message- From: Aleks @ USA.net [mailto:[EMAIL PROTECTED] Sent: Thursday

[PHP-DB] search doc in dB

2003-08-07 Thread Aleks @ USA.net
I have a project were I need to create a search mechanism for a large number of documents. I have already created a dB containing the Doc name, its URL location on the hard drive and a description. The search is being done against the document name. The complaint I am getting is that the users may