[PHP-DB] Join on single table

2005-02-10 Thread Matthew Weier O'Phinney
I have a table which contains the following: id (primary key, auto incrementing) app_id (integer, foreign key) resource_id (integer, foreign key) word score (This is a search index.) I want to find all resource_ids from one app_id that match resource_ids in another app_id by wo

Re: [PHP-DB] Reg Exp to change c:\dir\dir\pic.jpg to dir/pic.jpg - to upload image path

2005-02-10 Thread J R
now if you must have the local path of your file here's a rough code to give you an idea using javascript, then just have it php control it on the server side. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Reg Exp to change c:\dir\dir\pic.jpg to dir/pic.jpg-to upload image path

2005-02-10 Thread Martin Norland
ioannes wrote: OK. Makes sense, since I needed to change the form tag to upload files. Clearly, then it was not uploading the path. Thanks If by local, in your example, you mean it gives you "pic1.jpg" - then I will agree. No browser I've ever seen sends "C:\pics\subdir\pic1.jpg". It will *di

Re: [PHP-DB] Cannot connect to local server

2005-02-10 Thread J. Connolly
Novice, This is rather complicated code. In addition you are making it over complicated by taking constants and just renaming them as other contants. This accomplished nothing. You would be better of just placing the information in the correct place. Otherwise you can make the arguments into

Re: [PHP-DB] Cannot connect to local server

2005-02-10 Thread Novice Learner
Make sure that: localhost is actually "localhost" username is the actual authorized username of the database the password is the actual password you have given for the user the database is the actual database name you have given. I am an absolute beginner and I have a file like this and works pe

Re: [PHP-DB] Reg Exp to change c:\dir\dir\pic.jpg to dir/pic.jpg- to upload image path

2005-02-10 Thread Martin Norland
ioannes wrote: I am trying to upload images - in fact an image path - from a PC. I use the tag: which nicely gives an input textfield and Browse button! This gives me, in the input box, eg: c:\pics\subdir\pic1.jpg a web browser doesn't even give you this information! The input tag does give t

Re: [PHP-DB] Cannot connect to local server

2005-02-10 Thread J. Connolly
have you tied using $link = mysqli_connect("$host","$usernam","$password","$database") I have never used the code you are trying to use. But i am also noob. hope this works jzf Miles Thompson wrote: New version of MySQL, old PHP? possible password encryption mis-match? Check out: http://dev

Re: [PHP-DB] Reg Exp to change c:\dir\dir\pic.jpg to dir/pic.jpg - to upload image path

2005-02-10 Thread Martin Norland
ioannes wrote: I am trying to upload images - in fact an image path - from a PC. I use the tag: which nicely gives an input textfield and Browse button! This gives me, in the input box, eg: c:\pics\subdir\pic1.jpg The relative path on the server is something like: subdir/pics1.jpg thus I need t

RE: [PHP-DB] Is there anything non commercial pdf lib to create PDF file from PHP ?

2005-02-10 Thread Bastien Koert
www.fpdf.org bastien From: santoso berkah <[EMAIL PROTECTED]> To: [email protected] Subject: [PHP-DB] Is there anything non commercial pdf lib to create PDF file from PHP ? Date: Wed, 9 Feb 2005 21:23:20 -0800 (PST) Dear Friends, Is there anything non commercial pdf library (stable release) to

Re: [PHP-DB] Cannot connect to local server

2005-02-10 Thread Miles Thompson
New version of MySQL, old PHP? possible password encryption mis-match? Check out: http://dev.mysql.com/doc/mysql/en/old-client.html Regards - Miles At 06:33 AM 2/10/2005, Denis Gerasimov wrote: Hello, I am trying to connect to MySQL using $mysqli = new mysqli("example.com", "user", "pass",

RE: [PHP-DB] Re: Is there anything non commercial pdf lib to crea te PDF file from PHP ?

2005-02-10 Thread Hutchins, Richard
Or ezPDF http://www.ros.co.nz/pdf/ I've used it and it's easy to use as advertised. Rich -Original Message- From: Stefan Reimers [mailto:[EMAIL PROTECTED] Sent: Thursday, February 10, 2005 5:26 AM To: [email protected] Subject: [PHP-DB] Re: Is there anything non commercial pdf lib to

[PHP-DB] Re: Cannot connect to local server

2005-02-10 Thread Dusty Bin
Denis, try executing the following statement in your mysql client. grant all privileges on db.* to [EMAIL PROTECTED] identified by 'pass'; I didn't check the documentation but it seems that localhost is not in the set {%}. HTH. . . Dusty Denis Gerasimov wrote: Hello, I am trying t

[PHP-DB] Cannot connect to local server

2005-02-10 Thread Denis Gerasimov
Hello, I am trying to connect to MySQL using $mysqli = new mysqli("example.com", "user", "pass", "db"); And access is ALWAYS denied (I played around changing user name/pass/host - didn't help me at all) The thing is that I CAN connect to the db server using this user name and password with my

[PHP-DB] Re: Is there anything non commercial pdf lib to create PDF file from PHP ?

2005-02-10 Thread Stefan Reimers
Try FPDF on http://www.fpdf.org/ Stefan Santoso Berkah wrote: Dear Friends, Is there anything non commercial pdf library (stable release) to create PDF file from PHP except PHPlib.com ? I've browsed this site and it costed Euro 450. Can you help me please ? Best regards, [EMAIL PROTECTED] _