FORMAT return?

If i have a feild in a database that has a currency amount like 100.00 Is there a way to FORMAT AS (x,xxx,xxx.xx) in the sql so that the return is 1,000,000.00 ? Or is there way to do it in PHP? I've done this in ASP, but I can't seem to find it in MySql or in PHP

sorting this egroup

Maybe I overlooking the obvious here, but hey it won't be the first time. How does everyone sort this group in their email client? I have yet to find a way to manage these emails because of the lack of a consistent item in each email. i.e MySql in the subject line etc Suggestions?

if feild is not null

I'm trying to create a mysql statment (in a php page) that says: my header http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsu

RE: parameters?

sorry...this is the error i get: Warning: Supplied argument is not a valid MySQL result resource in /www/prunet/agent_result.php3 on line 110 -Original Message- From: Glyndower [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 18, 2001 1:55 AM To: Matt Wagner; Craig Westerman Cc

parameters?

I'm a newbie to MySql / Php and heres what i'm trying to accomplish: I have a set of hard coded links that each have a sql parameter value like below: http://www.foo.com/agent_result.php3?$agent_id=9805";>My Link Text I'm trying to pass that parameter into a query on another page and have it di

naming feilds

Is it possible to create a table,with say 200 feilds (named 1-200) using phpmyadmin and then import a text file into this table and have the first row of the text file as the feild names and rename the feilds names on the table? ---

RE: DBASE help

Hi Gang, is there a feild number limit in MySql? Like in Access you can only have 255 feilds, is this also true in MySql? or is there any limit to the number of feilds? - Before posting, please check: http://www.mysql.com/man

whats wrong here?

LOAD DATA LOCAL INFILE '/tmp/phpFBsb3v' REPLACE INTO TABLE agents FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''' LINES TERMINATED BY '\n' (agent_id,first_name,last_name,email_address,area_code,area,have_picture,abo ut) anybody see anything wrong in this ??? I've also tryed '\r' and '\r\n' fo

importing text files using phpmyadmin

I've included my text file as an attachment, but a sample of that data is below, for those who arn't playing with attachmnets nowadays... :) I'm using phpmyadmin and I' (still) trying to import a text file into an existing table. I've included the feils names in the attachment for reference, but

myodbc from windoze to unix

This is the email I recieved from tech support of the host i'm using, in reference to using MyOdbcand MyAccess to connect from Access on a windoze machine to MySql on a unix machine. "All remote db connections are blocked so phpmyadmin or using ssh to connection (secure telnet) is the two databas

RE: MyOdbc to unix

Re my previous message about tech support and access from windoze to unix. follows is the response i recieved from them: "Can you provide the command line sequence sent to the servers in terms of user, pass, db name, hostname, etc? remember that the hostname is localhost for mysql. From there we

RE: excell text file to mysql table using php admin?

Heres the text file i'm trying to upload, btw... Hi, I'm using PHP Admin 2.2.0pre5 (unofficial stable-branch)and MySql 3.22.32 I have created the following table: Field Type Attributes Null Default Extra Action agent_id smallint(6)No 0Change Drop Primary Index Unique first_name ti

excell text file to mysql table using php admin?

Hi, I'm using PHP Admin 2.2.0pre5 (unofficial stable-branch)and MySql 3.22.32 I have created the following table: Field Type Attributes Null Default Extra Action agent_id smallint(6)No 0Change Drop Primary Index Unique first_name tinytextNo Change Drop Primary Index Unique l

RE: Uploading files using PHP to database.

yup, i have this same question...it seems to me, unless i'm missing something obvious that you have to create the table and feild names first, then upload the txt file? Is this correct? - Before posting, please check: http://

conversion

Ok , Granted I'm really new at this but, I'm starting to feel as though I'm missing something very obvious here. If I have a tect file , say a excell spredsheet saved as a CSV tab delimited, can i import that into MYsql and have it create th eneccesary feild names? if so, how? -

php admin

I downloaded and installed php admin, seems like a really useful tool. But, if I try to create a table with more than 20 feilds it craps out my browser. It doesn't create all the option feilds, and if I dare to scroll the page, it acts like I'm out of video memory. Less than 20 feilds works great

Page Refresh?

Still traveling very slowly down the newbie road with PHP and mysql. I finally succeded in getting the INSERT function to work, although I secretly susoect it was a permissions issue witth my ISP, but their not talking, lol. It was a good lesson though. Todays problem, ladys and gents is that I

INSERT problem

Hi all, I'm new to the whole PHP and MySql stuff and I hopeful that I can get a push in the right direction for what I'm sure is a very sinple problem. I have succesfully created a databse using telnet and added data to it also using telnet. I have also succesfully got the data to display on a