Re: [PHP-DB] More help with mysql

2003-02-18 Thread Max 'AMiGo' Gashkov
Possible error in SQL statement. Are you sure that SOME_TABLE exists? EM Hi all EM I have successfully managed to connect to the mysql database, using the EM following code: EM mysql_connect('localhost','php','***') || die (Unable to connect to EM MySQL server.); EM $db =

Re: [PHP-DB] More help with mysql

2003-02-18 Thread Corne' Cornelius
Yo Evan, Have you got an '@' in front of the mysql_query() to supress errors ? Evan Morris wrote: Hi all I have successfully managed to connect to the mysql database, using the following code: mysql_connect('localhost','php','***') || die (Unable to connect to MySQL server.); $db =

Re: [PHP-DB] More help with mysql

2003-02-18 Thread Evan Morris
- Original Message - From: Max 'AMiGo' Gashkov [EMAIL PROTECTED] To: Evan Morris [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 10:13 AM Subject: Re: [PHP-DB] More help with mysql Possible error in SQL statement. Are you sure that SOME_TABLE exists? Yes. I

Re: [PHP-DB] More help with mysql

2003-02-18 Thread Evan Morris
Since I'm new to PHP, this concept is new to me. What does the @ do and where do you put it? - Original Message - From: Corne' Cornelius [EMAIL PROTECTED] To: Evan Morris [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 10:19 AM Subject: Re: [PHP-DB] More help with

Re[2]: [PHP-DB] More help with mysql

2003-02-18 Thread Max 'AMiGo' Gashkov
Try listing of fields by name, not as '*', and put SOME_TABLE in qoutes ('). EM - Original Message - EM From: Max 'AMiGo' Gashkov [EMAIL PROTECTED] EM To: Evan Morris [EMAIL PROTECTED] EM Cc: [EMAIL PROTECTED] EM Sent: Tuesday, February 18, 2003 10:13 AM EM Subject: Re: [PHP-DB] More help

[PHP-DB]

2003-02-18 Thread nikos
GlacierHi List I run mysql 3,23.. in a RH 7.2 Linux web server.=20 Sudenly mysql crash and non of my db's runnig. Mysqld (re) starts [OK].=20 The message in my browser is that mysql.sock file is missing Does knows why? What is this file? Thanx

Re: [PHP-DB] More help with mysql -- solved (bizarre)

2003-02-18 Thread Evan Morris
If I remove the '|| die' part from the mysql_query() statement, it works fine. This is bizarre, but there it is. ie, if I have: $result = mysql_query(SELECT * FROM SOME_TABLE); it works. If I have: $result = mysql_query(SELECT * FROM SOME_TABLE) || die (Unable to execute SQL query); it

Re[2]: [PHP-DB] More help with mysql -- solved (bizarre)

2003-02-18 Thread Max 'AMiGo' Gashkov
OK, now I see 8) $result after your operations contains not SQL result, it's value is 1 (logical TRUE) -- result of logical operation mysql_query(SELECT * FROM SOME_TABLE) || die( If you want to exit after error try this construction: if(!mysql_query(SELECT * FROM SOME_TABLE)) {

RE: Re[2]: [PHP-DB] More help with mysql -- solved (bizarre)

2003-02-18 Thread Clarkson, Nick
I believe if you put OR instead of || it will work OK as originally posted.. ie mysql_query(SELECT * FROM SOME_TABLE) OR die( Nick -Original Message- From: Max 'AMiGo' Gashkov [mailto:[EMAIL PROTECTED]] Sent: 18 February 2003 08:42 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]

[PHP-DB] Multiple select box using mysql

2003-02-18 Thread Jason End
I writing a software catalog that features experts, who a people especially skilled in a piece of software. My db, has a software table and an experts table. I need to have a page that generates 2 multiple select boxes, each on with the data from each table. From there one will be able to choose

Re: [PHP-DB] Multiple select box using mysql

2003-02-18 Thread Corne' Cornelius
You have to give the Mutli select box a name as an array. eg: SELECT NAME=experts[] MULTIPLE SIZE=5 OPTION VALUE=key1val1/OPTION /SELECT then in PHP, you can access $experts as an array. while (list ($key, $val) = each($experts)) { print $key = $valBR\n; } Jason End wrote: I writing a

[PHP-DB] Session variables when global variables switched off

2003-02-18 Thread Baumgartner Jeffrey
I am making a section on a web site which requires that visitors log-in. Log-in, password, etc are in an MySQL table. I am using (via a web host) PHP 4.2.2 with global variables turned off. Until now, I have worked with a different host in which global variables were switched on. The way it works

[PHP-DB] Session variables when global variables switched off [Sorry, first message accidentally fired off to quickly ]

2003-02-18 Thread Baumgartner Jeffrey
[sorry for the incomplete posting of a couple moments ago. I hit ctl something or other and outlook fired off the e-mail against my wishes!] I am making a section on a web site which requires that visitors log-in. Log-in, password, etc are in an MySQL table. I am using (via a web host) PHP 4.2.2

RE: [PHP-DB] Session variables when global variables switched off [Sorry, first message accidentally fired off to quickly ]

2003-02-18 Thread Rich Gray
Hi Jeff Don't use session_register() just use the $_SESSION superglobal as you would use any other array. So does this work? ? //index.php session_start(); // Login stuff done OK $_SESSION['verified'] = true; ? ? // Other pages needing a valid login session_start(); if

Re: [PHP-DB]

2003-02-18 Thread Doug Thompson
Nikos: The mysql.sock file is created by mysqld when it is running. The error you report is very common and you will find troubleshooting tips at: http://www.mysql.com/doc/en/Can_not_connect_to_server.html Doug On Tue, 18 Feb 2003 10:18:42 +0200, nikos wrote: GlacierHi List I run mysql 3,23..

[PHP-DB] Preserving form field values between pages/tags

2003-02-18 Thread news
Hi, I'm building a form page that has 3 tags for different types of fields (i.e. Personal details, location details, other). I want to preserve the values of the filled in fields as the user moves from section/tag to section/tag. I've tried making each tag a separate page and use the URL to pass

RE: [PHP-DB] Session variables when global variables switched off [Sorry, firs t message accidentally fired off to quickly ]

2003-02-18 Thread Clarkson, Nick
Try changing your code to if ($_SESSION['verified'] != yes){ I think that's the problem Nick -Original Message- From: Baumgartner Jeffrey [mailto:[EMAIL PROTECTED]] Sent: 18 February 2003 11:20 To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Session variables when global variables

[PHP-DB] Empty form variables

2003-02-18 Thread Diego Pedrosa
Hi all: I've installed apache for win98 and php 4.2 (also for win98) and they are working fine but I'm having problems with the form variables. When I submit a form the variables are empty!!! If anyone knows of issues in php-apache-win configuration please let me know. Thanks.

RE: [PHP-DB] Empty form variables

2003-02-18 Thread Snijders, Mark
sometimes people really never use a search :((( but the answer is: php versions 4 use another way of handeling postvars and arrays and if users don't know where the values are, use the function: phpinfo(); !!! and try this: print_r($_POST); thats all i will say -Oorspronkelijk

[PHP-DB] displaying query results

2003-02-18 Thread Sam Folk-Williams
Hi, I have a query that returns a list of staff members and which department they are in. There's one table for departments, which is joined to the table for staff members. Using the typical methods, I am currently displaying the results in the form of Deparment Name: Staff Name for each staff

RE: [PHP-DB] Preserving form field values between pages/tags

2003-02-18 Thread Clarkson, Nick
Here's an example to get you started - created 2 files as below, 1.html and 2.php The important bit is value=?php echo $_POST['username'];? Nick FILE : 1.html html form action=2.php method=post input type=text name=username size=40 maxlength=256 input type=submit value=submit /form /html

RE: [PHP-DB] More help with mysql -- solved (bizarre)

2003-02-18 Thread Ford, Mike [LSS]
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 18 February 2003 08:26 If I remove the '|| die' part from the mysql_query() statement, it works fine. This is bizarre, but there it is. ie, if I have: $result = mysql_query(SELECT * FROM SOME_TABLE);

[PHP-DB] Submitted information not being displayed

2003-02-18 Thread Bruce Sommer
I'm attempting to takke information submitted from a web page through a POST action, insert it into a MySQL database and upon success display the information in a table for the submitter to see. For some reason empty fields are inserted into the database and the data doesn't show up in the

[PHP-DB] Re: PHP and Oracle

2003-02-18 Thread Philippe Saladin
A new guest to the list needs your hlep!!. I am about to start working on a project in which im going to use Oralce with PHP4. I am new to PHP. I am looking for a good book about working with PHP4 and Oracle to help me pick up the basics as well as get the depth that i am looking for. To

[PHP-DB] Help with ADDUSER from linux

2003-02-18 Thread Bruno Pereira
How can i create a new user, with linux, apache and php? Like this, in a form i ask for the username and password, than somehow use the 'adduser' username password confirm password. Can someone help me? Cumprimentos Bruno Pereira [EMAIL PROTECTED] -- PHP Database Mailing List

[PHP-DB] Finding a record using phpMyAdmin

2003-02-18 Thread Shantanu Oak
Hi, I want to find a record. But I don't know in which column should I expect it. I want to search for it in all the columns. I don't see such a facility in the phpMyAdmin's Select Table screen. Can anyone guide me? __ Thanks Shantanu Oak Learn HTML and Java at

[PHP-DB] Issue with this particular SQL query construction

2003-02-18 Thread Jonathan Chum
I have two tables. Table_1 contact_id (INT 5) Table_2 contact_id (INT 5) type (enum '1','2') data (TEXT) In table_2, there is a possible of two records that can be associated to an entry in table in the form of the record type can be an either 1 or 2. There will always be a type 1, but not

Re: [PHP-DB] Preserving form field values between pages/tags

2003-02-18 Thread Mark
possibly use sessions? --- news [EMAIL PROTECTED] wrote: Hi, I'm building a form page that has 3 tags for different types of fields (i.e. Personal details, location details, other). I want to preserve the values of the filled in fields as the user moves from section/tag to section/tag.

Re: [PHP-DB] Preserving form field values between pages/tags

2003-02-18 Thread Chris Boget
Does anyone have a more practical/useful way of preserving field values from page-to-page... or hiding fields as a user clicks on each tag? You can make it all one very, very large form and use DHTML to show or hide the appropriate fields. Chris -- PHP Database Mailing List

[PHP-DB] string manipulation

2003-02-18 Thread Martin Dziura
Hello everyone, this is my first post, so please bare with me. I am very new to php and i am currently working on modifying existing php e-commerce site. so my question is as follow and its more of a general question but it involves a db so i thought i would ask here i have a mysql db, in one

Re: [PHP-DB] Help with ADDUSER from linux

2003-02-18 Thread Squirrel User
adduser script is written in perl. You can easily disect it. Quoting Bruno Pereira [EMAIL PROTECTED]: How can i create a new user, with linux, apache and php? Like this, in a form i ask for the username and password, than somehow use the 'adduser' username password confirm password. Can

[PHP-DB] Re: string manipulation

2003-02-18 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Martin Dziura) writes: is there some sort of parsing call i can evoke to extract the url? Beginning with the http and ending with the first white space? $str = foobarbazhttp://www.foo.bar/;; preg_match(/(http:\/\/\S+)/, $str, $match); $match[1] should contain the url part of

[PHP-DB] problem in PHP with ADODB connection, Microsoft JET Database

2003-02-18 Thread pei_world
when I try to connection to the access file using Microsoft Jet Engine. it come up with following error! can anyone help me? $result = $conn-Execute($query) error line I check the table is exists,and the query should be correct. --

[PHP-DB] Site Help

2003-02-18 Thread Mike Delorme
Hello! My name is Mike and I have no clue what I am doing. I have basic skills in PHP, but for some reson I cant bring them together to make the web program that I need. I would like to make a product site. When a client searches for product 6, the program goes to sites listed in an array,

[PHP-DB] multiple checkbox selection for search form

2003-02-18 Thread Earl Clare
hey guys, I need some assistance here... I am toying with a search form that will allow the user to select 3 options from a set of checkboxes to search by (eg.) [[ Select any 3 type ]] [ ] option1 [ ] option2 [ ] option3 [ ] option4 [ ] option5 [ ] option6 [ ] option7 [ ] option8 [