[PHP-DB] phpmyadmin download

2002-07-05 Thread Page Works Web Solutions
Hi all, Can someone point me in the direction of where to get a copy of phpmyadmin as a .pkg file? Any help would be greatly appreciated. Shawn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Inserting records across multiple mySQL forms - tracking ID's?

2002-07-05 Thread Jason Wong
On Saturday 06 July 2002 08:18, Matthew Nock wrote: > I want to create a form that will input a number of records, into a number > of different tables. > > The first part of the detail will need to create a new "product" record. > this will create Product ID. the Product ID is required to insert

[PHP-DB] template problem!!!

2002-07-05 Thread its me
i have asimple problem: can i put php code in the site template??-i'm using dreamweaver. and if yes will i save it as php or as .dwt?? thanks guys Rehab M.Shouman

[PHP-DB] Inserting records across multiple mySQL forms - tracking ID's?

2002-07-05 Thread Matthew Nock
I want to create a form that will input a number of records, into a number of different tables. The first part of the detail will need to create a new "product" record. this will create Product ID. the Product ID is required to insert the "features" for this product ID into another table. Is th

RE: [PHP-DB] A real question this time...

2002-07-05 Thread NIPP, SCOTT V (SBCSI)
Perfect. Why was I trying to make this more difficult??? Sometimes the simple solution is definitely the best. -Original Message- From: Shrock, Court [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 1:50 PM To: NIPP, SCOTT V (SBCSI); '[EMAIL PROTECTED]' Subject: RE: [PHP-D

Re: [PHP-DB] A real question this time...

2002-07-05 Thread John Coder
On Fri, 2002-07-05 at 14:43, NIPP, SCOTT V (SBCSI) wrote: > > mysql_select_db($database, $Test); > $query_SA = "SELECT sbcuid FROM contacts_sa"; > $SA = mysql_query($query_SA, $Test) or die(mysql_error()); > $PASS = $SA; I think here is your problem you have the select element name pass just

RE: [PHP-DB] A real question this time...

2002-07-05 Thread Shrock, Court
You are correct that an assignment between two variable is a copy, and that is exactly what is happening, however, you need to know what $SA is originally--it is a resource pointer in ways...it does not hold any data, it is just an internal pointer to where php is storing the data. So, when you d

RE: [PHP-DB] another problem with mySQL server

2002-07-05 Thread NIPP, SCOTT V (SBCSI)
Since you are using phpMyAdmin, I would suggest taking a look at the user table in the mysql database. I would suspect that you do not have the proper permissions in the user table. If this 'admin' user should have full rights to the database, you will need to make sure that you have two

[PHP-DB] A real question this time...

2002-07-05 Thread NIPP, SCOTT V (SBCSI)
This time I have a real question that I need help with. I am not sure why something is not working the way I intend it. This is most likely a mistake in my understanding, but here goes... I have a section of code that populates a dropdown list with the results of a query on a dat

[PHP-DB] another problem with mySQL server

2002-07-05 Thread Damiano Ferrari
Hello everybody, I am having again problems with the mySQL server. I wrote one simple .php page with the following lines: When I call the script, I get this error: Warning: Access denied for user: 'admin@localhost' (Using password: YES) in D:\Inetpub\wwwroot\test.php on line 2 Warning: MySQ

[PHP-DB] repost: still having problem getting data from mysql into backend.csv...

2002-07-05 Thread matthew
hello. we are new to this list and new to php so forgive me if this is a dumb question but we are stuck... we are trying to setup the event calendar script that http://www.php.net uses on their front page. The only problem I'm having is getting the information from the mysql database to the

RE: [PHP-DB] MySQL test database creation...

2002-07-05 Thread Peter Lovatt
hi If the database is not too much data you can export using phpMyAdmin and select 'complete inserts' which generates complete queries. you could also do INSERT INTO db_2.tablename SELECT * FROM db_1.tablename if both databases are on the same server. There may be better answers, but these t

RE: [PHP-DB] MySQL test database creation...

2002-07-05 Thread NIPP, SCOTT V (SBCSI)
Thanks, but I finally stumbled across the answer. Thankfully it was simple enough even for me. In case anyone else had this question also, all you have to do is browse for your dump file in the 'SQL' window of phpMyAdmin and click 'Go'. That's it. -Original Message- From: NIPP,

[PHP-DB] MySQL test database creation...

2002-07-05 Thread NIPP, SCOTT V (SBCSI)
Hey guys... I know that this is not specifically on topic for this group, but I promise this is an easy one. I am developing a web app, and need to create a development copy of the production database. I have created the new database, now I just need to export and import the sc

Re: [PHP-DB] Microsoft Access & PHP

2002-07-05 Thread Maureen
Correction on that, I removed the wrong parentheses: "SELECT ExamPapers.EPaperID, ExamPapers.EPapersText, ExamPapers.[Title of Paper], ExamPapers.Course, ExamPapers.School, ExamPapers.Year, ExamPapers.Jan/Summer], ExamPapers.[Module Code], ExamPapers.Stage, ExamPapers.[Storage Location], ExamP

Re: [PHP-DB] Microsoft Access & PHP

2002-07-05 Thread Maureen
If you are putting this in a web page, I assume you are putting quotes around the select statement. If so, are you escaping the quotes around "Colour and Imaging Institute" by putting \"Colour and Imaging Institute\" instead (or using single quotes instead of double quotes)? If not, that may

[PHP-DB] Re: resizing images comming out of blobs

2002-07-05 Thread Dan Koken
Andy, Yes I do it all the time. In this example, I do this with a window that has buttons across the top of a image representing size from 1 to 10. Depending on the button they select they get a image displayed from small to large. Here is a snip of code that displays the sized images. ---

Re: [PHP-DB] Re: resizing images comming out of blobs

2002-07-05 Thread David Russell
Hi Dan, Forgive me if I have missed something, but this is not actually doing anything to the image. the *same* image is being sent to the client, and it is up to the client browser to resize the image in the size you specify. Therefore, no matter what image size is specified, the same image

Re: [PHP-DB] date problem

2002-07-05 Thread ditoiu cristian
maybe you should try if($date!=="-00-00") {do something} "Dl Neil" <[EMAIL PROTECTED]> wrote in message 0df801c1cb3d$c947e420$c200a8c0@jrbrown">news:0df801c1cb3d$c947e420$c200a8c0@jrbrown... > Rehab, > > > i have an input field in a form that accept date called $date and in > databse i made i