Re: [PHP-DB] SELECT where something exists but something else does not

2002-02-21 Thread George Lioumis
Hi! I think I have solved your problem... I have attached an sql file to create the sample DB I created for my test and a PHP file for you to run to see how I have implemented it. First create the tables with the .sql file an then execute the .php file from your browser. Hope these help.

Re: [PHP-DB] SELECT where something exists but something else does not

2002-02-21 Thread George Lioumis
I think I forgot something usefull... - Original Message - From: Beau Lebens [EMAIL PROTECTED] To: PHP DB (E-mail) [EMAIL PROTECTED] Sent: Thursday, February 21, 2002 3:59 AM Subject: [PHP-DB] SELECT where something exists but something else does not Hey guys, I am a little stuck

Re: [PHP-DB] How do I add multiple var to a if clause ?

2002-02-21 Thread George Lioumis
You can use: if ( ($var == 1) or ($var == 2) or ($var == 3)) { ... } - Original Message - From: Dave Carrera [EMAIL PROTECTED] To: php List [EMAIL PROTECTED] Sent: Thursday, February 21, 2002 12:40 PM Subject: [PHP-DB] How do I add multiple var to a if clause ? Hi All

Re: [PHP-DB] Re: [PHP-WIN] why doesnt this work?

2002-02-08 Thread George Lioumis
I forgot somthing ? if (isset($submit) ) // this ) { IF ($submit) // this is line 8 { . } } ? - Original Message - From: George Lioumis [EMAIL PROTECTED] To: chris [EMAIL PROTECTED]; PHP Mailing List [EMAIL PROTECTED] Sent: Friday, February 08, 2002 3

[PHP-DB] Help in tokenizing a string

2002-01-31 Thread George Lioumis
Good day to all. I tried the following code from PHP's manual if (isset($submit)) { if ($submit == Save) { echo $im_fileBR; $tok = strtok($im_file, \\); while ($tok) { echo $tokBR; $tok = strtok (\\); } } } I have the string $im_file =C:\\a_path\\image.jpg and I want to

Fw: [PHP-DB] Drop down list

2002-01-30 Thread George Lioumis
- Original Message - From: George Lioumis To: B.J.Rumsey Sent: Wednesday, January 30, 2002 11:47 AM Subject: Re: [PHP-DB] Drop down list Try the following: ?php $option_block = ; $get_list = select * from table_name; $res = mysql_query($get_list) or die (mysql_error()); while

[PHP-DB] select into array

2002-01-16 Thread George Lioumis
Hello everyone! I have the following table: |name |-- |n_id |n_name |ns_id --- I do a select: SELECT n_name from name and I want to put all selected n_name values into an array (say it names) How can this be done?? Thanx in advance.

[PHP-DB] Insert data selected from drop down list into mySQL table

2002-01-09 Thread George Lioumis
Hello everyone! In my mySQL DB I have the tables: | po_product | and | products| |--| | -| | po_id | | product_id | | product_id | | product_name |

Re: [PHP-DB] How to querry two db in a single statement?

2002-01-04 Thread George Lioumis
Try the following: ?php mysql_connect(firstDB,username,password) or die (Unable to connect to Server); mysql_select_db(DB) or die (Unable to select DB); ---GET THE INFO YOU WANT AND PLACE IT IN AN APPROPRIATE VARIABLES --FOR LATER COMPARISON mysql_connect(secondDB,username,password) or die

[PHP-DB] Pass var from JavaScript to PHP

2001-11-13 Thread George Lioumis
Good day to all! Consider the following code: FORM ... INPUT type=Text name=criteria size=50 BR INPUT type=Button name=Find value=Find /FORM I want to get the text that the user writes into the text field into a php variable to use it in the same page. I want to use this text as a criteria to

Re: [PHP-DB] Re: Pass var from JavaScript to PHP

2001-11-13 Thread George Lioumis
OR post action=?php echo $PHP_SELF? Then in your page have a php tag that checks for the presence of $Find (in your case), e.g. if ($Find) { sql = (SELECT * FROM table WHERE $criteria = value); then the rest... } -torrent George Lioumis [EMAIL PROTECTED] wrote in message

Re: [PHP-DB] https

2001-10-22 Thread George Lioumis
I think that you MUST retype the whole URL. George. - Original Message - From: J-E-N [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 20, 2001 2:22 PM Subject: [PHP-DB] https hello, how can i switch from http to https without typing the whole url? thanks -- PHP

[PHP-DB] Re: [PHP-WIN] released

2001-10-18 Thread George Lioumis
Yes, but mySQL 4.0 is alpha Release and Apache 1.3.22 for Win32 is not as stable as for Unix platforms So, let's wit a bit more! - Original Message - From: suraj [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 18, 2001 10:55 AM Subject: [PHP-WIN] released Hello

Re: [PHP-DB] Question In French.

2001-10-18 Thread George Lioumis
Il faut tu ecrire: if ($colonne[LIV_TYPE_EVT] == 21) { $couleur = yellow; } else if ($colonne[LIV_TYPE_EVT] == 1) { $couleur = 009933; } else { $couleur = FF; } Georges Lioumis. -

[PHP-DB] Re: [PHP-WIN] variables in URL

2001-10-17 Thread George Lioumis
main.php?sectionName=homevariable_2=value...variable_n=value - Original Message - From: Tony Leach [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 17, 2001 5:11 PM Subject: [PHP-WIN] variables in URL How do I construct a URL to pass more than one variable to a php