[PHP-DB] New Member

Hi, this is my first post on this list. I've never used PHP, but I'm interested in exploring it, along with MySQL and Apache server software. Very briefly, my main focus is on designing webpages. I've been unemployed for several months and have been using my extra time to learn new computer

[PHP-DB] mysql, php, mp3 - a variable problem

hi, i put a script together to scan a directory and its subdirectories for all mp3 files. the tag informations and path then should be put into a mysql database. i included a script called mphp3.php from http://res.crea-bmb.de/mphp3/ which returns the needed tag info from one file. the script

Re: [PHP-DB] mysql, php, mp3 - a variable problem

Hi, Where do you get $info2 from? I only see $info in this function. .: Allowee function scan_dir($dir) { $info = New mphp3(2); $handle = @opendir($dir); while ($file = @readdir ($handle)) { if (eregi(^\.{1,2}$,$file)) { continue; }

[PHP-DB] ?? php and mysql database question ??

Hello, I have a question, not sure if what I am looking for is available at all or a smaller program of the full sized program I am looking for but thought I'd ask to see if anyone knows of a program or a program they may of created. On my personal Computer I run a Windows OS and on my server

Re: [PHP-DB] ?? php and mysql database question ??

I already have installed a PHP program that I can run/test PHP scripts and thought I'd ask here if anyone knew of a mysql one. (I thought since a PHP program is available on Windows OS maybe a mysql one was too?) There is... http://www.mysql.com/ for more info .: Allowee -- PHP

Re: [PHP-DB] mysql, php, mp3 - a variable problem

hi allowee, sorry, this was not meant to be. $info2 is supposed to be $info. my fault. but that is not the actual problem. Hi, Where do you get $info2 from? I only see $info in this function. .: Allowee function scan_dir($dir) { $info = New mphp3(2); $handle =

Re: [PHP-DB] mysql, php, mp3 - a variable problem

hmmm, maybe this code.. $info-load(/.$dir.$file); if $dir = mp3s and $file = test.mp3 then it will load '/mp3s/test.mp3' you got that directory? I've seen the class and you are hiding the fopen error message, which could be the problem. .: Allowee On Saturday 07 June 2003 11:11, Ole Hornauer

Re: [PHP-DB] mysql, php, mp3 - a variable problem

Hi, Where do you get $info2 from? I only see $info in this function. I guess that the $info-values are formfieldvalues. $info-[db-field] is normaly used within a whileloop for outputing a select-statement. In the case of formfieldvalues you can use $formfieldname. .: Allowee function

Re: [PHP-DB] mysql, php, mp3 - a variable problem

On Saturday 07 June 2003 11:20, Allowee wrote: hmmm, maybe this code.. $info-load(/.$dir.$file); if $dir = mp3s and $file = test.mp3 then it will load '/mp3s/test.mp3' you got that directory? I've seen the class and you are hiding the fopen error message, which could be the problem.

Re: [PHP-DB] mysql, php, mp3 - a variable problem

well, you are right. the dir '/mp3' does not exist. 'mp3' is a subdir from my htdocs dir. so i think the right path should be 'mp3/someartist/somesong', right? i fixed that, but the original problem is still the same :( hmmm, maybe this code.. $info-load(/.$dir.$file); if $dir = mp3s

Re: [PHP-DB] mysql, php, mp3 - a variable problem

moin, sorry, my php-knowledge is not the best. what do you mean with formfieldvalues? i think $info-value is used to get the id3-tag info from the class, right? this worked for me in a more simple way without the recursive scan: ? include(mphp3.php); $info = New mphp3(2);

[PHP-DB] Re: ?? php and mysql database question ??

hi, u can install vmware (not freeware) on your windows machine and then install linux as a virtual machine. it behaves just like a real machine. works fine for me! Hello, I have a question, not sure if what I am looking for is available at all or a smaller program of the full sized

[PHP-DB] What must a (Windows) User do to query Oracle9i with oci8 functions

hi i already found this in this newsgroup: Hi Robert Yes oci8 functions work fine with Oracle9i. that's great :-) but someone said something about Recompiling to use oci8 extension with Oracle9i. So now my question: What tasks are requiered to query Oracle9i DB with the oci8-extension ?

[PHP-DB] Problems with OCIFetchStatement()'s $skip and $return?

Hi, I'm using OCIFetchStatement()'s undocumented parameter $return (http://de.php.net/manual/de/function.ocifetchstatement.php) to limit the number of rows fetched from a result set. Unfortunately, I sometimes get far less rows than expected. Before I further investigate the issue, can anyone

[PHP-DB] incrementing values

Hi there, is there a function in mysql to increment a value inside a field? I am always doing this with php, just thought this might be really usefull?! Thanx, Merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] incrementing values

AUTO_INCREMENT http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Merlin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, 03 June, 2003 17:56 Subject: [PHP-DB] incrementing values Hi there,

[PHP-DB] problem with insert query

hi i am wrote a script to read e-malis from a file and insert it into the tables of database i get error when i write it here is the code can anyone tell me what is wrong? ? $mails=file(mails.txt); $number_of_mails = count($mails); for ($i=0; $i$number_of_mails; $i++){ @ $db =

Re: [PHP-DB] Displaying groups from SELECT

What I did to somewhat solve the problem of over calling mysql was to initiate the query outside the loop (SELECT prod_name query), put the results into an array and then use the array inside the while($cats) loop. For example, $sql=SELECT prod_name, cat_id FROM products;

[PHP-DB] SQL Server connection error.

Hi, I am new to PHP DB code and am currently struggling with the connection to SQL Server 2000. I am using ODBC and have created a System DSN with integrated NT security specifiying which DB etc. I have written the following code and posted it in the htdocs folder for Apache. (We are all

Re: [PHP-DB] problem with insert query

Try this. I made some minor syntax changes and added some error reporting. While it may not fix things, it might help you figure out what's wrong. ? $mails=file(mails.txt); $number_of_mails = count($mails); for ($i=0; $i$number_of_mails; $i++) { $link = @ mysql_connect(localhost) or

[PHP-DB] Possible to store arrays in mySQL without explode()/implode()

is it possible to store an array in mySQL without using implode() / explode(), like this: $stuff['blob'] = string; $stuff['hm'] = G-string; mysql_query(INSERT INTO table VALUES ($stuff)); and if, who must the mysql table be defined ? thx Jakob 'iNstinct' Mund -- PHP Database Mailing List

[PHP-DB] Glitching install script.

I'm still new to php and my syntax is not great. I am getting this notice: Notice: Undefined variable: begin in /home/wwwfulc/public_html/install.php on line 21 When I hit subit it just prints Completed. and doesn't update the database at all. Can anyone help me find my glitch in

Re: [PHP-DB] Possible to store arrays in mySQL withoutexplode()/implode()

Not that I'm aware of, but why don't you give it a shot. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Jakob Mund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 07 June, 2003 09:04 Subject: [PHP-DB] Possible to store arrays in mySQL without

Re: [PHP-DB] problem with insert query

It seems to me that this code will not provide useful information: if ($result) echo mysql_affected_rows(). affected.; If the insert was successful, it will always say 1 affected. Since you are only inserting one row at a time. On Sat, 07 Jun 2003 08:49:15 -0400, Becoming Digital wrote:

RE: [PHP-DB] incrementing values

is there a function in mysql to increment a value inside a field? I am always doing this with php, just thought this might be really usefull?! UPDATE table SET column = column + 1 WHERE ... Like that? ---John W. Holmes... Amazon Wishlist: http://www.amazon.com/o/registry/3BEXC84AB3A5E PHP

Re: [PHP-DB] Possible to store arrays in mySQL without explode()/implode()

On Saturday 07 June 2003 21:04, Jakob Mund wrote: is it possible to store an array in mySQL without using implode() / explode(), like this: $stuff['blob'] = string; $stuff['hm'] = G-string; mysql_query(INSERT INTO table VALUES ($stuff)); serialize() and if, who must the mysql table be

[PHP-DB] Loading database information from a text file

Hi, I have a text file with all my database information from creating databases to setting up tables. I have looked throught the mysql docs on how to load these on from a text file via the mysql prompt. But all I can find is: load data infile filename.txt into table whatever But this is not

Re: [PHP-DB] Displaying groups from SELECT

hey, you can join the two queries and make only one... ? function get_inventory() { $query = SELECT c.cat_id, p.product_name FROM categories as c LEFT JOIN products as p on (c.cat_id = p.cat_id); $result = mysql_query( $query ); if ( mysql_num_rows($query) 0 )

RE: [PHP-DB] Loading database information from a text file

I have a text file with all my database information from creating databases to setting up tables. I have looked throught the mysql docs on how to load these on from a text file via the mysql prompt. But all I can find is: load data infile filename.txt into table whatever But this is

[PHP-DB] Re: ?? php and mysql database question ??

snip hi, u can install vmware (not freeware) on your windows machine and then install linux as a virtual machine. it behaves just like a real machine. works fine for me! /snip Yup I am aware of this but would be much better under Windows itself, saves mucking around than if it is possible.

[PHP-DB] Re: ?? php and mysql database question ??

snip hi, u can install vmware (not freeware) on your windows machine and then install linux as a virtual machine. it behaves just like a real machine. works fine for me! /snip Yup I am aware of this but would be much better under Windows itself, saves mucking around than if it is possible.