Re: [PHP-DB] strange link problem to a database item

2002-01-19 Thread chip
On Friday 18 January 2002 09:39 pm, Chris Lott banged out on the keys: In my code I have the following line: printf(td align=\center\a href=\%s\ img src=\.xvpics/%s\/a/td\n, $row[name], $row[name]); When I view this web page I get I get, in- konqueror - all thumb images are fine

Re: [PHP-DB] strange link problem to a database item

2002-01-19 Thread Jason Wong
On Saturday 19 January 2002 16:06, chip wrote: On Friday 18 January 2002 09:39 pm, Chris Lott banged out on the keys: In my code I have the following line: printf(td align=\center\a href=\%s\ img src=\.xvpics/%s\/a/td\n, $row[name], $row[name]); When I view this web page I get

[PHP-DB] Breaking up an array

2002-01-19 Thread Troy A. Delagardelle
I am trying to break this array up so that I can display each one of these varibles independantly. What PHP function will allow me to to this?? Or what other way can I achieve this?? Thx Troy +--+---+-+-+-+ | username | Total | average |

[PHP-DB] PHP Mysql on Win32 platform

2002-01-19 Thread Joni Järvinen
Hey. I have apache, php and mysql installed on Win32 platform. Everything works great but when I try to connect to mysql database with PHP, I get the following error: Warning: Access denied for user: 'ODBC@localhost' (Using password: YES) in c:\dev\msgv2\index.php on line 15. The line 15

Re: [PHP-DB] php/msql

2002-01-19 Thread DL Neil
Hi Mike while ($row = mysql_fetch_array($result)) { echo trtd.$row[0]./td\n; echo td.$row[1]./td\n; $formatted=sprintf($%s,$row[2]); echo td $formatted /td/trbr; } I get an error in the last line where I want to put $formatted into the last cell of a table if I // echo $formatted

[PHP-DB] distinct - how to do

2002-01-19 Thread Barry Rumsey
I have the following query: $query = SELECT * FROM xp_topics, xp_stories WHERE xp_topics.topicid = xp_stories.topicid AND xp_topics.artistname='Faith Hill' ORDER BY topictext DESC LIMIT 0,20; It returns the lot but a lot of doubles. I want to put a DISTINCT call the query, but if I put it

[PHP-DB] MySQL database

2002-01-19 Thread Morten Nielsen
Hi, Could anybody explain to me how I should make a table with usernames and passwords. I want to make a site, where users can sign up and enter some values, which is stored in a different table. How do I grant the necessary acces to the tables, so users can enter values into them? Please help,

Re: [PHP-DB] distinct - how to do

2002-01-19 Thread Paul DuBois
At 2:28 +1300 1/20/02, Barry Rumsey wrote: I have the following query: $query = SELECT * FROM xp_topics, xp_stories WHERE xp_topics.topicid = xp_stories.topicid AND xp_topics.artistname='Faith Hill' ORDER BY topictext DESC LIMIT 0,20; It returns the lot but a lot of doubles. I want to put a

Re: [PHP-DB] strange link problem to a database item

2002-01-19 Thread Steven Cayford
On 2002.01.18 23:00:16 -0600 chip wrote: On Friday 18 January 2002 08:09 pm, Steven Cayford banged out on the keys: Hello again. On 2002.01.18 18:48:36 -0600 chip wrote: In my code I have the following line: printf(td align=\center\a href=\%s\ img src=\.xvpics/%s\/a/td\n,

Re: [PHP-DB] Variable search help still needed - sorry :-(

2002-01-19 Thread Chris Payne
Hi there, I made some of the changes you said below, and when I check the query I get this: The query is SELECT distinct description, email, url, country, category, type, rating from search6 WHERE description LIKE '%word%'AND category = 'Automotive' AND country = 'Austria' AND type = 'Car

Re: [PHP-DB] distinct - how to do

2002-01-19 Thread Miles Thompson
Barry, Change -- xp_topics.topicid = xp_stories.topicid to--- xp_stories.topicid = xp_topics.topicid and see what your results are. Your primary selection is on xp_topics. Then add DISTINCT following your SELECT. That should do the trick - Miles At 02:28 AM 1/20/2002 +1300, Barry

Re: [PHP-DB] MySQL database

2002-01-19 Thread Miles Thompson
Morten, What's your level of knowledge of both databases and PHP? Please have a look at the Introductory Tutorial (Link at the top left of www.php.net). At the end of that tutorial, which is admittedly rudimentary, there are links to more advanced ones, including ones specifically for user

Re: [PHP-DB] MySQL database

2002-01-19 Thread Miles Thompson
As Brian Clark just pointed out on php-general, in response to another issue ... http://www.faqts.com/knowledge_base/index.phtml/fid/51/ Some very specific refernces. You'll find what you need there. Miles At 06:08 PM 1/19/2002 +0100, Morten Nielsen wrote: Hi, Could anybody explain to me how

Re: [PHP-DB] Variable search help still needed - sorry :-(

2002-01-19 Thread Jason Wong
On Sat, 19 Jan 2002, Chris Payne wrote: Hi there, I made some of the changes you said below, and when I check the query I get this: The query is SELECT distinct description, email, url, country, category, type, rating from search6 WHERE description LIKE '%word%'AND category =

[PHP-DB] Password help plz

2002-01-19 Thread Shelly Wilds
hi guys, i'm new to php/mysql :), so plz bare with me a bit. i'm trying to figure out how to retrieve password un crypted to browser. // $result = mysql_query(SELECT * FROM auth WHERE username='$valid_user',$db); $myrow =

[PHP-DB] load data infile problem

2002-01-19 Thread rop30999
I have a called file cats.txt which count data that were solitary of a DB Access. I need to export these data for a table 'cats' inside of a DB done in MySql. In MySql I can execute this procedure in the following way: Load data local infile gatos.txt into table gatos fields terminated by ','

Re: [PHP-DB] Password help plz

2002-01-19 Thread Miles Thompson
Shelly, Retrieve a decrypted password for display? Can't do it, MySQL's password() function is one way. Check this page of the MySQL docs: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html You can display the password as encrypted by that function. PHP doesn't have a password()

Re: [PHP-DB] load data infile problem

2002-01-19 Thread Miles Thompson
You running Windows or *nix? File permissions will play a part in this, but use PHP's exec() function to execute MySQL's load data infile. The manual has a number of well annotated examples. The big problem may be that you'll be executing the command as whatever user the web server is running