Re: [PHP-DB] Relational database

2002-03-22 Thread Andrey Hristov
Otidi tuk : http://www.php.net/unsub.php i vig kak se pravi Unsubscribe Andrey - Original Message - From: Stefan [EMAIL PROTECTED] To: 'Andrey Hristov' [EMAIL PROTECTED]; 'Ron' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, March 22, 2002 10:37 AM Subject: RE: [PHP-DB]

Re: [PHP-DB] Relational database

2002-03-22 Thread Cirstoiu Aurel Sorin
test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] insert into javascript php

2002-03-22 Thread its me
script c=document.forms[0].category.options[document.forms[0].category.selectedIndex].text ?php $x=c; ? /script but the php doesn't understand this c variable Rehab M.Shouman

Re: [PHP-DB] insert into javascript php

2002-03-22 Thread Marius Ursache
its me a écrit : script c=document.forms[0].category.options[document.forms[0].category.selectedIndex].text ?php $x=c; ? /script but the php doesn't understand this c variable Rehab M.Shouman maybe is $x = $c ? you can access that option from php $HTTP_POST_VARS[name]

[PHP-DB] Forms

2002-03-22 Thread Ron
I know this is suppose to be databases, but the most knowledgeable people seem to be in here. This is the first time that I have tried to conquer a form in PHP(which I obviously am not doing) so that I can have a total PHP script page and move away from HTML. Here is my code as followed by my

Re: [PHP-DB] Forms

2002-03-22 Thread Ron
(((Point taken))) no harm intended Parse error: parse error in C:\**\*\tt.php on line 53 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Forms

2002-03-22 Thread Ron
Line 53 is the line that is commented out Ron [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... (((Point taken))) no harm intended Parse error: parse error in C:\**\*\tt.php on line 53 -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] PHP and HTML problems

2002-03-22 Thread Keiran Wynyard
Is it possible for you to post a link for it, so that I do not have to try and make it work as it stands at the moment? I am more an HTML wiz than a PHP guru, and I think I may have had a similar problem in the past that I solved, so I will try to help Keiran -Original Message- From:

[PHP-DB] RE: Forms

2002-03-22 Thread Keiran Wynyard
maybe try escaping the characters in the last line, or using ' instead...? Keiran -Original Message- From: Ron [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 1:05 PM To: [EMAIL PROTECTED] Subject: Forms I know this is suppose to be databases, but the most knowledgeable

[PHP-DB] Re: insert into javascript php

2002-03-22 Thread Adam Royle
PHP cannot recognise javascript variables because javascript is interpreted via the browser, and not the server (which php is). for php to use javascript variables, you must post the variable to another page using either a form or querystring. Adam script

RE: [PHP-DB] Forms

2002-03-22 Thread Rick Emery
First: cross-posting to multiple lists...not nice. Most PHP folks are on both lists. Second: your first sentence seems to indicate that unknowledgeable people inhabit the PHP list, vice the PHP-DB list. H GRIN Third: what error do you get when you get the parsing error? -Original

[PHP-DB] Creating a good search engine

2002-03-22 Thread Mike de Libero
Hi Guys, I need to create a search engine that catalogs data from about 4 separate tables, and then of course is searchable from use input. I'm having a brain fart on how I should go about doing this. This is what I think I should do so far tell me if I'm right or at least going in the

Re: [PHP-DB] Creating a good search engine

2002-03-22 Thread olinux
I would recommend going with a table of keywords like you said, you may want ot structure like this: [ words_id | article_id | word ] You can tie the article id to the other tables getting an efficient multiple word search working is a bit of a task. This is very helpful:

[PHP-DB] calculations based on checkbox value

2002-03-22 Thread jas
Ok here is my problem, currently I have a form that calculates the number of words in a given textarea. Now what I need to accomplish is using a checkbox to subtract a value based on said checkbox. I have looked for a tutorial on such an item and did not find one so I am asking if anyone out

RE: [PHP-DB] calculations based on checkbox value

2002-03-22 Thread matt stewart
can you post some code, and an exmaple of an input, the current output, and what the desired output would be? -Original Message- From: jas [mailto:[EMAIL PROTECTED]] Sent: 22 March 2002 04:57 To: [EMAIL PROTECTED] Subject: [PHP-DB] calculations based on checkbox value Ok here is my

[PHP-DB] marking DB entries...

2002-03-22 Thread Ljungan
Im making an adressbook using PHP and mySQL. I want each user to have access only to his/hers adressinputs. Now Im wondering how I gonna solve this, ofcourse its very easy just to create a table for each user but then the hole idea of database loose its purpose =). How can I mark each input so

RE: [PHP-DB] marking DB entries...

2002-03-22 Thread Rick Emery
store and validate a username and password with each user's info -Original Message- From: Ljungan [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 11:07 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] marking DB entries... Im making an adressbook using PHP and mySQL. I want each user

RE: [PHP-DB] marking DB entries...

2002-03-22 Thread Rick Emery
well...what the bloody hell are you looking for from us? -Original Message- From: Ljungan [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 11:29 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] marking DB entries... well that wasn't very helpful... I have two tables already, users

[PHP-DB] Multiple SELECT querys

2002-03-22 Thread Morten Nielsen
Hi, I make a SELECT in a mySQL database. It returns a variable, which contains 10 values. I then need to make another SELECT in a new database where I have to use the previous 10 values in the WHERE sentence. How can I do this? Regards, Morten -- PHP Database Mailing List

Re: [PHP-DB] help php4.0.6Oracle9i !

2002-03-22 Thread Rafael Schleuss
ORA-12154: TNS:could not resolve service name Cause: The service name specified is not defined correctly in the TNSNAMES.ORA file. Action: Make the following checks and correct the error: - Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system

RE: [PHP-DB] Multiple SELECT querys

2002-03-22 Thread Rick Emery
$query = SELECT myvalue FROM mytable WHERE some_condition; $result = mysql_query($query) or die(Error: .mysql_error()); $srch = ; while( list($myvalue) = mysql_fetch_array($result) { $srch .= $myvalue, ; } $srch = substr($srch, 0, -2); $query = SELECT * FROM other_table WHERE this_val

RE: [PHP-DB] Selecting Alphabetically

2002-03-22 Thread Robert V. Zwink
In MySQL you can also do this: SELECT * FROM artists WHERE LEFT(title, 1) = 'A' AND LEFT(title, 1) = 'H' ORDER BY title This will return a range of all artists whose title begins with A thru H. Treat the letters like numbers. Robert V. Zwink http://www.zwink.net/daid.php -Original

Re: [PHP-DB] urgent guys

2002-03-22 Thread maxwello
and in javascript when i say for example alert(category) it gives me undefined doesn't javascript see variables passed with the url??? Nope. You'll have to parse the URL and search for your variables. Take a look at using the location.search property. Maxwell -- PHP Database Mailing

[PHP-DB] Remote Connection to Mysql

2002-03-22 Thread Marcus Rigby
Hi all, I know there are plenty of remote connection posts herebut none have helped me solve my problem. I have 2 win98 machines on a novell network, both have static IP addresses, and both machines can ping each other. One machine is running a webserver and the other the Mysql server, and

Re: [PHP-DB] marking DB entries...

2002-03-22 Thread Adam Royle
I have done an address book in php, although I kept the username/password in with the rest of their details. If you wanted to keep it all in two tables, then go ahead. You really should have an ID field in every table, whether you use it or not, and most of the times, you'll find you will use

[PHP-DB] Re: urgent guys

2002-03-22 Thread Adam Royle
You cannot use javascript variables in php, nor php variables in javascript, unless you write the variable to the page (for php - javascript) or post to a new page with querystring or form (javascript - php). php - javascript: script language=JavaScript var jsVariable = ?= $phpVariable ?;

Re: [PHP-DB] marking DB entries...

2002-03-22 Thread Frank Flynn
OK so you have 2 tables one for users login and one for the addresses a user may store and retrieve. Your users will login, you will validate their name and password combination and have either a userID or the name is fine too (an integer ID is smaller to store and possibly more efficient). Now