Re: [PHP-DB] Sorting the result

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 the

[PHP-DB] Join tables

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] Join tables

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 mysql and

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

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 Eg A forum has not more than 99 different forums So lets say we will keep the ID 2 digits Forums

[PHP-DB] Re: errorr log

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

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

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

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

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

[PHP-DB] Re: Sorting the result

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

[PHP-DB] Looping through two arrays

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

Re: [PHP-DB] Looping through two arrays

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)) {

Re: [PHP-DB] Join tables

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 just

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

Ryan, Do you have anything else between your ?php and ?. 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

Re: [PHP-DB] Looping through two arrays

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($res_master))

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

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 ?php and

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

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 most people

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

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 -

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

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 #:

Re: [PHP-DB] Grouped sql output

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] Re: ORDER BY question

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 enter

Re: [PHP-DB] Grouped sql output

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

[PHP-DB] I'm really stuck!

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 =

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

if($id) { $id = $pet; you first check for $id and then set it? while(list($pet)= mysql_fetch_row($ret)) print(BRyour 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 show

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

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 is

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

$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

[PHP-DB] creatlang

when we try to createlang pltclu tams we get this error: Error: load of file /usr/lib/pgsql/pltclso failed: /usr/lib/pgsql/pltclso: undefined symbol: tcl_createslave Running RH 72, php, postgresql that came with RH72 Can someone help please -- PHP Database Mailing List (http://wwwphpnet/)