[PHP-DB] creatlang

2002-02-28 Thread W McCloud
when we try to createlang pltclu tams we get this error: Error: load of file /usr/lib/pgsql/pltcl.so failed: /usr/lib/pgsql/pltcl.so: undefined symbol: tcl_createslave Running RH 7.2, php, postgresql that came with RH7.2 Can someone help please -- PHP Database Mailing List (http://www.php.

Re: [PHP-DB] I'm really stuck!

2002-02-28 Thread William Fong
$query="SELECT id FROM wt_users WHERE uid=($session['uid'])"; Always print your queries if they do not work. I don't know if { } will mess anything up since I've never used them. Your doublequotes in your array will end your statement at [. if( isset( $id ) ) { <-- use isset (http://www.ph

Re: [PHP-DB] I'm really stuck!

2002-02-28 Thread Billy S Halsey
Hi Jennifer. Change {$session["uid"]} to {$session['uid']} --> double quotes to single quotes. It's inside a set of single quotes already, so you have to use double quotes. /bsh/ Jennifer Downey wrote: >Hi all, > >I'm really stuck and I'm not asking anyone to re-write this just show me what

Re: [PHP-DB] I'm really stuck!

2002-02-28 Thread Bas Jobsen
if($id) { $id = $pet; you first check for $id and then set it? > while(list($pet)= > mysql_fetch_row($ret)) > print("your pet id is $pet"); > > So if $pet will print the id from the wt_users (has a value of 3) and I > assign $id = $pet (id also has a value of 3 in image_data) why doesn't it >

[PHP-DB] I'm really stuck!

2002-02-28 Thread Jennifer Downey
Hi all, I'm really stuck and I'm not asking anyone to re-write this just show me what is wrong, or explain why it wont work. It just seems logical that this should work. The first query will print the pet id in the browser. $query="SELECT id FROM wt_users WHERE uid={$session["uid"]}"; $ret =

[PHP-DB] Time table was updated?

2002-02-28 Thread Bob Holm
Is there a function available to find out what time a table in a mySQL database was updated? If you can help please mail me at [EMAIL PROTECTED] Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Grouped sql output

2002-02-28 Thread rudi
Hi, Sorry for the delay. I'm still about to test the code. Been busy with Perl and ColdFusion. It's on my list of things to do still. I'll be sure to post my code and result as soon as I can Won't be today though. I know there is at least one problem ( the $thiszip in the if block. ) Thanks Rudi.

Re: [PHP-DB] Re: ORDER BY question

2002-02-28 Thread DL Neil
Hi Chris, Did you get a useable answer to this? > Using PHP and MySQL, how can I do an ORDER BY where city = $city? What > happens is this, I have a search engine which works nicely, but I want to > bring up the closest matches to the search first at the top, how can I do > this? > > Say you ent

Re: [PHP-DB] Grouped sql output

2002-02-28 Thread DL Neil
Hi Rudi, > What do you think ? There are some problems. > I'll test it tomorrow at work. > I'll let you know how she goes. How did you get on? Regards, =dn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] accessing system cmds w/ PHP

2002-02-28 Thread William Fong
NOT a good idea. You would have to run Apache as root (or whatever that SUID stuff is all about). I've been able to manage keeping all the users 'virtual' and not needing to hand out shell accounts. -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 8

Re: [PHP-DB] accessing system cmds w/ PHP

2002-02-28 Thread William Fong
Just remember you will be running those commands as the web server, which usually have limited access rights. -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] - Original Message - From

Re: [PHP-DB] accessing system cmds w/ PHP

2002-02-28 Thread Kevin Traas
Beau, you're such a l33t h4x0r ;-) - Original Message - From: "Beau Lebens" <[EMAIL PROTECTED]> To: "'Jeremiah Jester'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 27, 2002 5:33 PM Subject: RE: [PHP-DB] accessing system cmds w/ PHP > JJ, > I seem to recall m

[PHP-DB] Re: why won't session_start() work?

2002-02-28 Thread jas
Not to mention that you are registering two different variables... try combining the two by putting a coma between them. i.e. session_register('signor','username'); HTH Jas "Jas" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED].; > Ryan, > Do you have anything else between your .

Re: [PHP-DB] Looping through two arrays

2002-02-28 Thread Aron Pilhofer
Jason, you rock! Works perfectly, thanks! aron "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED].; > On Friday 01 March 2002 01:00, Aron Pilhofer wrote: > > [snip] > > Try: > > > Any help is greatly appreciated. Here's the code: > > > > while ($row_new = mysql_fetch_row($r

[PHP-DB] Re: why won't session_start() work?

2002-02-28 Thread jas
Ryan, Do you have anything else between your . Need more code to determine why. Jas "Ryan Snow" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED].; > > when I do: > session_start(); > session_register('signor'); > session_register('username'); > > > I g

Re: [PHP-DB] Join tables

2002-02-28 Thread Aron Pilhofer
Microsoft Access: light-duty relational database with a world-class (in my opinion) GUI interface, but I don't think it's going to help you in this case. > > > id in image_data has the same value as id in wt_users do you mean uid in wt_users? So, $id=session ID? I might set that ahead of time ju

Re: [PHP-DB] Looping through two arrays

2002-02-28 Thread Jason Wong
On Friday 01 March 2002 01:00, Aron Pilhofer wrote: [snip] Try: > Any help is greatly appreciated. Here's the code: > > while ($row_new = mysql_fetch_row($res_master)) > { mysql_data_seek($res_new, 0); > while ($row_old = mysql_fetch_row($res_new)) > { >e

[PHP-DB] Looping through two arrays

2002-02-28 Thread Aron Pilhofer
This one seems like it should be easy, but I can't get anything to work. I have two tables. I want to pull a first name and last name from each table, a master table and a new table. Then, I want to list them in a specific way: I want to list the first name of the master table, then list all the n

[PHP-DB] Re: Sorting the result

2002-02-28 Thread Aron Pilhofer
Not sure I totally understand the question, but I think the answer is no because your count isn't part of the database, nor is it part of the query. You're asking MySQL to sort a field that doesn't exist, in other words. The only way around that is to have MySQL calculate the number of occurances

Re: [PHP-DB] Question about setting up multiple relations

2002-02-28 Thread Paul Burney
on 2/28/02 2:21 AM, Monty at [EMAIL PROTECTED] appended the following bits to my mbox: > I have an Image table in a MySQL database that will be used to store the > location of all images used on my site. Some images will relate to an > Article table (article.id) and some images may relate to a Me

RE: [PHP-DB] Keeping autoincrement ID 2 digits. Possible?

2002-02-28 Thread Cal Evans
Not within the construct of auto_increment. You could , however write your own Serial Assigned Key (SAK) routine in PHP to enforce these business rules. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Andy [mailto:[EMAIL PROTE

[PHP-DB] Keeping autoincrement ID 2 digits. Possible?

2002-02-28 Thread Andy
Hi there, I am wondering if it would be possible to have a autoincrement field which is only 2 digits long. The idea is, that as soon as 99 is reached the next value will be a free one withing 0-99. E.g. A forum has not more than 99 different forums. So lets say we will keep the ID 2 digits. Fo

[PHP-DB] Re: errorr log

2002-02-28 Thread Phillip Oertel
Erwien Samantha Y wrote: does you webserver (apache?) and/or php have the rights needed to write to the /tmp directory? if not you have to chmod the permissions for the /tmp dir. an maybe better idea would be to make directory /tmp/php directory and chown that to wwwrun. but you should double-

Re: [PHP-DB] Join tables

2002-02-28 Thread Jennifer Downey
Ok thanks for that info, but I guess I am ignorant to what MS Access is. Please enlighten me. Thanks Jennifer Downey "Marius Ursache" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED].; > the best tool for building "join" queries is MS Access . > > make a db same as that you use in m

Re: [PHP-DB] Join tables

2002-02-28 Thread Marius Ursache
the best tool for building "join" queries is MS Access . make a db same as that you use in mysql and build the query with access. then copy/paste queries from there. to build queries in access is very simple . drag/drop and other visual ways. Jennifer Downey a écrit : > Hi all, > > Ok first

[PHP-DB] Join tables

2002-02-28 Thread Jennifer Downey
Hi all, Ok first I have figured out my question on storing an image path. my question now is on joining data from two tables. wt_users has two fields (cols) called uid and pid, uid refers to the user pid refers to the users pet image_data has a field called id which refers to the image path

Re: [PHP-DB] Sorting the result

2002-02-28 Thread Kristjan Kanarik
On Wed, 27 Feb 2002, William Fong wrote: > $article_query = mysql_query("select article_name, article_text from > articles where article_name LIKE '%$q%' ORDER BY $q_count DESC ") or die > (mysql_error()); > > Put the ORDER BY $q_count DESC in your SQL statement and that will make > MySQL do th