RE: [PHP-DB] How to pass multiple checkbox values thru form??

2002-08-31 Thread victor
e_name = $row["picture_name"]; echo $db_ID; echo ''; echo $db_picture_name; echo ''; echo $ID; echo ''; echo $picture_name; echo ''; echo $result; } so many echoes because I'm trying to figure out what works and what doesn't. - Victor > ww

[PHP-DB] newest entry in db

2002-08-31 Thread Victor
How can I use php to get the newest entry from mysql database? Ie, if I make a timestamp and then I want to retrieve the last timestamp I made how do I go about doing it? Any php or mysql documentation? - Victor > www.argilent.

[PHP-DB] why do i get this error please tell me?

2002-08-31 Thread Victor
end repeat You have an error in your SQL syntax near 'order=1 WHERE ID='2'' at line 2 - Victor > www.argilent.com __ Post your ad for free now! http://personals.yahoo.ca -- PHP Database Mailin

[PHP-DB] RE: [PHP] why do i get this error please tell me?

2002-08-31 Thread victor
Yep, figured it just now, thanks anyway, ahhh.. You'd thing they put reserved names right besides the damn mysql command in the manual. Alas it shall not be so. - Victor > www.argilent.com -Original Message- From: Chris Knipe [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 31

RE: [PHP-DB] RE: [PHP] why do i get this error please tell me?

2002-08-31 Thread victor
I meant besides the UPDATE or SELECT or any filed that those words might interfere with... - Victor > www.argilent.com -Original Message- From: Mark Charette [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 31, 2002 2:18 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB]

[PHP-DB] RE: [PHP] help, array values echoed as Array on loop!

2002-09-02 Thread victor
Ok, if I change $ID_arr[] to $ID_arr I think it gives me what I want. - Victor > www.argilent.com -Original Message- From: Victor [mailto:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 3:39 PM To: 'PHP' Subject: [PHP] help, array values echoed as Array on loop! I ha

RE: [PHP-DB] RE: [PHP] help, array values echoed as Array on loop!

2002-09-02 Thread victor
Ok, wrong mailing list! - Victor > www.argilent.com -Original Message- From: victor [mailto:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 3:46 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] RE: [PHP] help, array values echoed as Array on loop! Ok, if I change $ID_arr[] to $ID_ar

[PHP-DB] some data output formatting and grouping question...

2002-12-01 Thread Victor
I just have a fucking mental block; I cannot at all conceive the necessary syntax to or even the theoretical algorithm that I need, to do the following: Consider the following table: U | X | Y --|---|-- me|001|0a me|002|0a me|003|0a me|002|0b me|003|0b me|004|0b ..|...|.. then the code says: S

Re: [PHP-DB] sql: LIKE

2001-01-10 Thread Victor Foitzik
if you mean something like "SELECT * FROM THETABLE WHERE subject LIKE '%foo%' ORDER BY hitcount ASC" yes it is ... ;-) >Hi there. Is there a way to sort results of a '.. WHERE subject LIKE %foo%' >query by HITS in order to use it for a search engine? -- PHP Database Mailing List (http://www.ph

Re: [PHP-DB] Problem with oci8

2001-01-12 Thread Victor Foitzik
libclnsh) refer to http://www.php.net/manual/ref.oci8.php or ask me if you like --Victor > Hi, > > I'm trying to run php4 with support to oci8 (Oracle 8.1.6 - Linux) and >apache aborts. > > I read in the FAQ that if MySql libs are linked with pthread, pthread >should be

Re: AW: [PHP-DB] Oracle Persistant Connections

2001-02-04 Thread Victor Foitzik
uld be a PHP CGI-Script running _permanently_ performing periodically select/insert's ? And, this sounds very funny, another way is to run the insert/select part in Apache, returning data to the calling application via HTTP. This _might_ still be faster than calling PHP as a CGI hun

Re: [PHP-DB] newbie question

2001-02-04 Thread Victor Foitzik
search engine robots do _not_ index pages ending in .php and .php3 due to their dynamic nature (please correct me or give me a hint how to change this). We had to change the extensions to .html to avoid being not indexed by search engines. Hope this helps Victor -- PHP Database Mailing List (h

Re: [PHP-DB] .htpasswd?

2001-02-04 Thread Victor Foitzik
e user and the group file according to your needs. Another way to do this directly with MySQL is to use the apache auth_mysql module which allows you to store authentication data in a MySQL DB. See http://mysql.com/downloads/contrib.html and http://httpd.apache.org/docs/misc/FAQ-G.html for mor

Re[2]: [PHP-DB] Display data begin with "A"

2001-04-08 Thread Victor Foitzik
Hi, if you're using MySQL, the simpliest method is using RLIKE SELECT stuff FROM table WHERE stuff RLIKE '^[0-9]+'; see http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/R/e/Regexp.html for more info HTH Victor > Okay it's working n

Re: [PHP-DB] Does anyone know, or is it even possible

2001-04-11 Thread Victor Foitzik
Hi Brian, this really depends on what kind of user authentication you are using by now. Apache is capable of doing authentication by many methods, not only static .htaccess files, but also via MySQL, PAM or other. You should speicify what kind of system you are using ... HTH Victor > O

Re[2]: [PHP-DB] OCI_DEFAULT

2001-04-19 Thread Victor Foitzik
ions were 4.0.3pl and 4.0.4pl1 both on FreeBSD and Debian ... Hope somebody knows about ... Victor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-19 Thread Victor Foitzik
$varname) { if (!empty($$varname)) { // do funky stuff here } } HTH Victor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-19 Thread Victor Foitzik
Hello JD, on 19.04.2001 you wrote: > if (!empty($Price)) > { > if(empty($whereclause)) > { > $whereclause.="Price$Price"; > } > els

Re: [PHP-DB] Fatal error: undefined function mysql_connect()

2001-04-19 Thread Victor Foitzik
Hello franky, on 13.04.2001 you wrote: > I'm trying to connect to mySQL DB by Web page > and > when I use mysql_connect() > this append: > Fatal error: Call to unsupported or undefined function mysql_connect() > thanks! are you really sure your php has mysql support compiled in (yes, it is po

Re: [PHP-DB] Secure database connectivity?

2001-04-19 Thread Victor Foitzik
Hello Stuart, on 19.04.2001 you wrote: > Hi people, > I'm setting up a database to collect email addresses on my web site, but I > want to avoid using the insecure connection method: > mysql_connect("host", "user", "pass") > as this obviously displays my username and password to anyone who wan

[PHP-DB] ODBC connection under Win32 + Apache + SQL Server

2001-09-11 Thread Victor Espina
r: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I test the DSN with VFP using: SQLStringConnect("dsn=MQIS;usr=sa;pwd=;") and it works pretty fine. ¿What could be the problem here? TIA Victor -- == Victor Esp

[PHP-DB] Passing parameters to a PHP file.

2001-09-12 Thread Victor Espina
I want to call a PHP file with some parameters. I tried this sintax: HREF=MyPage.PHP?Var1=Value1 But i don't seem to be receiving any value for Var1. I tested it with: print "Var1: $Var1"; and the output is "Var1:" What i'm missing here? -- ======

Re: [PHP-DB] Passing parameters to a PHP file.

2001-09-13 Thread Victor Espina
Thanks Leo, i solved the problem using $HTTP_GET_VARS[]. -- == Victor Espina Caracas, Venezuela http://mitrompo.com/vespina [EMAIL PROTECTED] (Quite el 'nospam' para responder) (Remove 'nospam' to reply) "Leo G. Divinagracia III" <[E

[PHP-DB] List

2001-12-14 Thread Victor Bogdan C.
list

[PHP-DB] Win200 --> RH 7.0 MyODBC Error

2001-05-04 Thread Victor Bogdan C.
Can anyone help me please with this error? "ODBC -- call failed. [TCX][MyODBC]Host 'mask.cosmorom.com' is not allowed to connect to this MySQL server (#1130)" More details: 1) mask.cosmorom.com - stands for all computers on our network (10.250.1.*) 2) The computer trying to access the MySQL se