[PHP-DB] Re: Parse error

2003-03-21 Thread Michiel van Heusden
it might be a previous include() or require() or other command inserting external PHP-code is causing your problem.. but posting some code would help indeed.. grace michiel [EMAIL PROTECTED] [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I am having a problem with a parse error.

RE: [PHP-DB] Re: deleting records using a checkbox

2003-03-21 Thread Ford, Mike [LSS]
-Original Message- From: Paul Burney [mailto:[EMAIL PROTECTED] Sent: 20 March 2003 15:22 on 3/20/03 1:45 AM, olinux at [EMAIL PROTECTED] appended the following bits to my mbox: [ and ] are illegal characters. #javascript I'm coming into this a bit late, so I'm not sure

[PHP-DB] Printing anchor link in results

2003-03-21 Thread Achieve IT
Hello, I am new to PHP and am wondering how to print a variable an external link. In the example below, the 'web_pro' variable has the format, www.mycompany.com . How can I make this a clickable link? echo \ntr\n\ttd bgcolor=\silver\ . bWeb: /b . $arr['web_pro'] .

RE: [PHP-DB] Printing anchor link in results

2003-03-21 Thread Hutchins, Richard
It's basic HTML: echo \ntr\n\ttd bgcolor=\silver\ . bWeb: /ba href=\www.mycompany.com\. //changed this line $arr['web_pro']. /a/td //changed this line td bgcolor=\silver\ . /td \n/tr; Hope that's what you were looking for. Rich

RE: [PHP-DB] problem connecting w/ODBC

2003-03-21 Thread Beverly Steiner
Problem fixed! Thank you to David who pointed out that I had my variables switched in the in the odbc_exec and odbc_cursor lines. For ODBC, the connection variable comes first (the opposite of MySQL). Bev -- Beverly Steiner [EMAIL PROTECTED] -Original Message-

[PHP-DB] Password Authentication

2003-03-21 Thread trlists
I am trying to build password authentication into a database front end for a MySQL DB. I find the php docs on this point quite confusing so I have a lot of questions. I can use a one-way hash to do this if that's the best way, as I don't need to retrieve the password. However if I could do

RE: [PHP-DB] Display results on html page

2003-03-21 Thread Michelle Whelan
John, I don't think I'm understanding what you are saying. Anyhow, I actually got the html to display. John Mailing list, I am having a problem with my query working. It was working, then I must have edited something in it. I don't remember exactly what because it was very late at night.

[PHP-DB] Help with this query

2003-03-21 Thread shaun
Hi, I have the following tables in my database: CREATE TABLE WMS_Allocations ( Allocation_ID int(11) DEFAULT '' NOT NULL auto_increment, Project_ID int(11) DEFAULT '0' NOT NULL , User_ID int(11) DEFAULT '0' NOT NULL , PRIMARY KEY (Allocation_ID), ); CREATE TABLE WMS_Projects (

[PHP-DB] Storing images and text retrieved from mysql-db, into a table

2003-03-21 Thread gert vonck
hello, i'm not very good with php and mysql, so this can look like a silly easy question. I have a mysql database named 'oh'. there are 20 tables under it. Now, i want to store 1 image and some text (8 to be exact) in a table. I want to have 1 table with 3 column, and the first two are divided

[PHP-DB] Retrieve the field name itself instead of the info of the field name

2003-03-21 Thread gert vonck
hello everyone, this is my code to retrieve info from my mysql db. This works perfect, but what i also want is a column before this column. In the first column, i want to see the field names from my table. So instead of selecting the info of the field names uitbater,straatnaam,... , I want to

[PHP-DB] Normalize ...relationships

2003-03-21 Thread Russell Griechen
a table 'hound' contains ownerID, breederID. These both are to be normalized in a separate table as in: CREATE TABLE sportsmen ( sportsmenID bigint (10)notnull autoincrement, Question: How? based on a sportsman can be a owner, breeder, hunter, President, Senator, Governor etc; CREATE TABLE

Re: [PHP-DB] Retrieve the field name itself instead of the info of the field name

2003-03-21 Thread Mark
Uwe mysql_fetch_array() to get a row into an associative array, or use mysql_field_name() --- gert vonck [EMAIL PROTECTED] wrote: hello everyone, this is my code to retrieve info from my mysql db. This works perfect, but what i also want is a column before this column. In the first

[PHP-DB] Re: Normalize ...relationships

2003-03-21 Thread l0t3k
Russell, how about creating a mapping , or adding a role field to the sportsmen table, where role is owner, etc. it all depends on whether a sportsman can be multiple things (owner, hunter, etc) at the same time. if so you need a mapping table. for example CREATE table sportsmen_role_map

[PHP-DB] Cross-Table

2003-03-21 Thread Blain
Does anyone have some experience with cross-tables? Thanks for help Blain -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mail() function

2003-03-21 Thread Rick Dahl
I can't get it to work. I get the echo to show up but never receive a email. if($blankpostage) { $to = Rick Dahl [EMAIL PROTECTED]; $subject = Online B+P Request; $body = Show ID = . $id; mail($to, $subject, $body); echo sadflkjaflkasdj; } What am I doing wrong? Rick

Re: [PHP-DB] mail() function

2003-03-21 Thread Jason Wong
On Saturday 22 March 2003 16:38, Rick Dahl wrote: I can't get it to work. I get the echo to show up but never receive a email. if($blankpostage) { $to = Rick Dahl [EMAIL PROTECTED]; $subject = Online B+P Request; $body = Show ID = . $id; mail($to, $subject, $body); echo

Re: [PHP-DB] mail() function

2003-03-21 Thread Rick Dahl
I think the fact that I don't have a mailserver would do it. Unless the PHP home edition 2 bundle has a mailserver, I don't have one. Where can I get one of those? Can I get it for free? Rick - Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday,

Re: [PHP-DB] mail() function

2003-03-21 Thread Jason Wong
On Saturday 22 March 2003 16:53, Rick Dahl wrote: I think the fact that I don't have a mailserver would do it. Unless the PHP home edition 2 bundle has a mailserver, I don't have one. Where can I get one of those? Can I get it for free? I think having a mailserver would be a tremendous help

[PHP-DB] Fwd: FW: Prayer Wheel

2003-03-21 Thread Mike Delorme
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED],