[PHP-DB] Retrieve data from a table, edit/add it and enter it in a new table

2004-06-11 Thread Justin
Hi, I am trying to do the following: Retrieve some information from a table, edit it by appending some further information to it (a few more fields) and then enter the new data record into a new table, and delete the old data in the original table. Sounds confusing I know. The code is below

[PHP-DB] Re: PHP/MySQL learning project

2004-06-11 Thread Alexey Kupershtokh
Hi. In trying to learn PHP and MySQL, I'm trying to create a web-based database application that will keep track of my movies. I have five tables (shown in the graphic). I'm trying to be able to display the results of the tables with one movie title, all of the actors associated with it,

[PHP-DB] PHP and DBA (db3)

2004-06-11 Thread Dietmar Hilke
Hello! Trying to bring that code to work on win32. --- h1dba_perf_test.php/h1 ?php $handlers = dba_handlers(true); print pre; print_r($handlers); print /pre; $dbtype = db3; $dbfile = C:/dbfile; $nrecs = 100; echo using datafile: $dbfile.$dbtypebr\n; $id = dba_open($dbfile...$dbtype, c, $dbtype);

[PHP-DB] GROUP_CONCAT query

2004-06-11 Thread I.A. Gray
Hi all, I sometimes find the MYSQL manual very difficult to understand- perhaps I am alone in this. I am wanting to do the following, and I think I need to use GROUP_CONCAT in my query. I have a table of webstats for my site with columns for IP, Hostname, referer website etc and I want to show

[PHP-DB] diplicate entries

2004-06-11 Thread Bobo Wieland
Hi! What is the best way to check if a record allready exists in a msql-db from php in the case of when the same form is submited twice beacuse of the refresh-button? Should I allways check the db for the same entry, or is there some esier way to prevent the user from submiting a form more then

[PHP-DB] Re: diplicate entries

2004-06-11 Thread Torsten Roehr
Bobo Wieland [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi! What is the best way to check if a record allready exists in a msql-db from php in the case of when the same form is submited twice beacuse of the refresh-button? Should I allways check the db for the same entry, or

[PHP-DB] mysql results, arrays, and for loops

2004-06-11 Thread Philip Thompson
Hi all! I am using a select statement to obtain all the dates whenever someone submitted a problem in a database. Well, I want to get the result (which could be multiple dates) and then print that in a table format with some other information on a webpage. So I want to use a FOR loops and go

[PHP-DB] Re: mysql results, arrays, and for loops

2004-06-11 Thread Torsten Roehr
Philip Thompson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi all! I am using a select statement to obtain all the dates whenever someone submitted a problem in a database. Well, I want to get the result (which could be multiple dates) and then print that in a table format

[PHP-DB] Re: PHP/MySQL learning project

2004-06-11 Thread Justin Patrin
Alexey Kupershtokh wrote: Hi. In trying to learn PHP and MySQL, I'm trying to create a web-based database application that will keep track of my movies. I have five tables (shown in the graphic). I'm trying to be able to display the results of the tables with one movie title, all of the actors

Re: [PHP-DB] Re: mysql results, arrays, and for loops

2004-06-11 Thread Philip Thompson
Yes, thanks to all that assisted. I got it working like a charm! ~Philip On Jun 11, 2004, at 9:30 AM, Torsten Roehr wrote: Philip Thompson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi all! I am using a select statement to obtain all the dates whenever someone submitted a problem in

[PHP-DB] MySQL persistent connections

2004-06-11 Thread Radek Zajkowski
Hey there PHP fiends, I have a bit of cookie here. We're designing a PHP based app that uses MySQL as the data storage. Scalability is an issue, we want to be able to handle up to 1 people utilizing the system (not at once of course). Question is, should I be connecting and disconnecting

[PHP-DB] Re: PHP/MySQL learning project

2004-06-11 Thread news.php.net
So given the same database diagram (MovieMain, Actors, Genre, then a table named MovieActor to allow multiple actors to be associated with a movie, and MovieGenre to allow multiple genre's to be associated with a movie), can you steer me in the right direction on writnig the PHP to display all

[PHP-DB] Re: GROUP_CONCAT query

2004-06-11 Thread Rui Cunha
i presume you want something like: select ip,hostname,referer,count(*) from table group by ip,hostname,referer; note: all fields in the select clause that are not affected by any aggregate function must appear in the group by clause; I.A. Gray writes: Hi all, I sometimes find the MYSQL

[PHP-DB] Re: mysql results, arrays, and for loops

2004-06-11 Thread Rui Cunha
hope this code will help you TABLE WIDTH=100% HEIGHT=100% ?php $db = mysql_connect ('localhost') or die ($MYSQL_NO_CON); mysql_select_db ('database_name',$db) or die ($MYSQL_NO_BD); $query = SELECT * FROM table or die ($MYSQL_NO_QUERY); $result =

RE: [PHP-DB] Re: Anyone using MSQL Server with PHP?

2004-06-11 Thread Miguel Guirao
Thanks a lot Hans for your great explanation about this type of passwords, salted passwords. I will google for that term, time-memory Tradeoff. Thanks one more time!! Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: Hans Lellelid [mailto:[EMAIL PROTECTED]

Re: [PHP-DB] PHP and DBA (db3)

2004-06-11 Thread Marcjon
I assume you're using windows XP or 2000 or server 2003 and are using NTFS. When you get a Permission dinied in e:\data\dhidata\meddictool2 it means the server doesn't have permission to access the folder. You need to go into the folder's properties to change that. I'm not sure how your specific

[PHP-DB] multidim help for a newbie

2004-06-11 Thread grahama
Hi :) I am creating an XML file out of a mysql query with nested arrays. Currently I can get 1 element and 1 child with a properly formatted XML file with the below script . My question: is, How do I add 3 to 4 more child elements to the below 'playlist' array ? Currently ,I have one parent