[PHP-DB] Re: Urgent!!!

2002-01-03 Thread George Nicolae
and who looks the query with substr the date so i get only the year? Type the exact query you make. -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com Thomas Omega Henning [EMAIL PROTECTED] wrote in message [EMAIL

[PHP-DB] MySQL Password Writes but Doesn't Read!@#%^

2002-01-03 Thread Matthew Tedder
Can someone please explain this to me?! It's a real puzzle.. Using the password('abc') command in a MySQL insert statement works for me but using it again in a select statement does not. Well--it does in one MySQL database I have but doesn't in another one. I've done exactly the same

RE: [PHP-DB] MySQL Password Writes but Doesn't Read!@#%^

2002-01-03 Thread Novotn Petr
Hello, Clear - coding has 16 characters - you have defined usrpassword in the second DB for 15 - probably one character is missing with coding. I am rather sure it is the problem, if not - sorry to disturb you Regards, Petr. -Original Message- From: Matthew Tedder [mailto:[EMAIL

[PHP-DB] Re: Urgent!!!

2002-01-03 Thread Thomas \omega\ Henning
Sorry but I don't have the query done yet . But maybe later I will have it done but I don't know how to use the substr command in mySQL . If you tell me how to use it I will post it on the forum. Thomas omega Henning George Nicolae [EMAIL PROTECTED] wrote in message [EMAIL

Re: [PHP-DB] The file '/tmp/phpxw2cJS' must be in the database directory or be readable by all

2002-01-03 Thread Bogdan Stancescu
Do you have control over where the file to be loaded is located? If so, simply create a directory in your user's home, and do what the error message says :-) HTH Bogdan Hayan Al Mamoun wrote: I have this error when I try to execute Load Data Infile .. statement, although temp directory

SV: [PHP-DB] The file '/tmp/phpxw2cJS' must be in the database directory or be readable by all

2002-01-03 Thread Trond Erling Hundal
Looks like an uploaded file... (Did you make a page that lets you upload the file then run it into your table?) Upload the file manually, chmod it to 777 or whatever... But when you uploaded it, the file has your default read/write permissions that should work within mysql. Then you should be

[PHP-DB] Re: Urgent!!!

2002-01-03 Thread George Nicolae
I have some idea about your problem but to solve I need some information. 1. you have a datatime, data, timestamp,time or year column? if you have a data type column with -mm-dd format you can use the following query select substring_index(date_record,-,1)+id from test date_record is a

[PHP-DB] finding records wiht non-null columns

2002-01-03 Thread bill
Is there a better query than SELECT * FROM some_database WHERE some_column I had tried WHERE some_column NULL but that didn't work. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

RE: [PHP-DB] finding records wiht non-null columns

2002-01-03 Thread Jonathan Hilgeman
...WHERE some_column IS NOT NULL; - Jonathan -Original Message- From: bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 8:19 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] finding records wiht non-null columns Is there a better query than SELECT * FROM some_database WHERE

RE: [PHP-DB] finding records wiht non-null columns

2002-01-03 Thread Leotta, Natalie (NCI/IMS)
In my database (Sybase) that won't work. You have to use not like 'NULL' or it gives an error about not using text in a where clause unless you use like. Weird, but it will work with the not like 'NULL'. -Natalie -Original Message- From: Jonathan Hilgeman [SMTP:[EMAIL

RE: [PHP-DB] finding records wiht non-null columns

2002-01-03 Thread Bjarte Husebo
Please note that (empty string) and NULL is not the same value. The following query will return records where x is not null: SELECT * FROM db WHERE x IS NOT NULL; But since and NULL is different values, it might just as well return empty strings. If you want records where x actually

[PHP-DB] Big Problem...Need Help Quick

2002-01-03 Thread Kelvn
I have deleted the DB by mistake. Please I don't know how to write the rollback statement. I need complete code from you guys. Please Help Quick. Thanks Kelvin. ( I used PHP and MYSQL ) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

[PHP-DB] How much for a Job Site

2002-01-03 Thread olinux
my company would like to develop a job site similar to monster.com or hotjobs.com - Basically it would allow users to post resumes, employers post jobs and be searchable by multiple fields. What is the cost 1] if it is custom developed for us 2] if we use an - off the shelf solution (I was

[PHP-DB] Re: Big Problem...Need Help Quick

2002-01-03 Thread Kelvin Yip
SomeOne Please Help Thanks. Kelvin. Kelvn [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I have deleted the DB by mistake. Please I don't know how to write the rollback statement. I need complete code from you guys. Please Help Quick. Thanks Kelvin.

Re: [PHP-DB] Re: Big Problem...Need Help Quick

2002-01-03 Thread Miles Thompson
Kelvin, Backup is your friend, I hope you have one. The only way you can implement a rollback is if you use transactions in your code. In general terms it works like this ... Begin transaction SQL processing ,etc. If no errors Commit transaction else Rollback End

[PHP-DB] nysql_query confusing selects for inserts?

2002-01-03 Thread Ken Kinder
This is extremely annoying. For some reason, mysql_query seems to be confusing my left join for an insert or update. The reason being, that the query runs fine, but the result isn't usable. Here's the example code. Table definitions are below if that helps. $err = 0; // $result =

[PHP-DB] Need Help Please

2002-01-03 Thread Kelvn Yip
I have deleted all the info. from the Table by mistaken. Now, I need to rollback all the info. otherwise, none of the user can login to a page. Please..Help I don't know how to rollback. Can someone provide me a complete code , So, I can put up the DB online asap. Thanks. Kelvin. -- PHP

RE: [PHP-DB] Need Help Please

2002-01-03 Thread Rick Emery
Kelvin, As I asked before: WHAT DATABASE ENGINE ARE YOU USING? -Original Message- From: Kelvn Yip [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 11:39 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Need Help Please I have deleted all the info. from the Table by mistaken. Now,

RE: [PHP-DB] nysql_query confusing selects for inserts?

2002-01-03 Thread Rick Emery
Have you actually print out $sql before its execution then copied-and-pasted it to the MYSQL command line. Or are you assuming that because you typed it into the MYSQL command line, then it must be correct? -Original Message- From: Ken Kinder [mailto:[EMAIL PROTECTED]] Sent: Thursday,

Re: [PHP-DB] nysql_query confusing selects for inserts?

2002-01-03 Thread Ken Kinder
Yes, I copied it verbatium and copied it right from the HTML source into this email. On Thursday 03 January 2002 11:22 am, Rick Emery wrote: Have you actually print out $sql before its execution then copied-and-pasted it to the MYSQL command line. Or are you assuming that because you typed

RE: [PHP-DB] nysql_query confusing selects for inserts?

2002-01-03 Thread Rick Emery
So show us the print out when you printed $sql. I'm certain it did not look like: select lead.lead_id, lead.firstname, lead.lastname, lead_support_1.plusfour from lead left join lead_support_1 on lead.lead_support_id = lead_support_1_id But

[PHP-DB] Deleting form multiple tables

2002-01-03 Thread olinux
Does mysql not support deletes from multiple tables? [ie] DELETE FROM vendors, billing WHERE vendors.v_id = '1' AND vendors.vb_id = billing.b_id Thanks much, olinux __ Do You Yahoo!? Send your FREE holiday greetings online!

[PHP-DB] Input to DB from form

2002-01-03 Thread James Kupernik
I'm trying to input that data entered into a form into a table in my DB. Here is the code I have. $db = mysql_connect(localhost,cloft,spring); mysql_select_db(countryloft,$db); $sql = INSERT INTO catalogreq (BFNAME,BLNAME,ADD1,ADD2,BCITY,BZIPA,BSTATE,BCTRY,BTELO,DATE) VALUES

RE: [PHP-DB] Input to DB from form

2002-01-03 Thread Ryan Marrs
Are you even calling the mysql_query() function? Should look something like this: Mysql_connect(localhost,cloft,spring); mysql_select_db(countryloft); $sql = INSERT INTO catalogreq (BFNAME,BLNAME,ADD1,ADD2,BCITY,BZIPA,BSTATE,BCTRY,BTELO,DATE) VALUES

Re: [PHP-DB] Input to DB from form

2002-01-03 Thread Mihail Bota
check if all your fields are indeed strings (char, varchar) and not numbers. Mihail Bota On Thu, 3 Jan 2002, James Kupernik wrote: I'm trying to input that data entered into a form into a table in my DB. Here is the code I have. $db = mysql_connect(localhost,cloft,spring);

RE: [PHP-DB] Deleting form multiple tables

2002-01-03 Thread Rick Emery
Multiple-table delete was implemented with MYSQL vers 4.0 -Original Message- From: olinux [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 12:52 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Deleting form multiple tables Does mysql not support deletes from multiple tables?

[PHP-DB] test, pls del

2002-01-03 Thread louie miranda
test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] php+mysql simple query help me pls! ty.

2002-01-03 Thread louie miranda
Hi, can someone help me here! :( I can't query the data on my sql from php. db is fine, i couldnt see the prob in php! pls help, ty. # MSQL ### mysql desc members; +--+-+--+-+-++ | Field

RE: [PHP-DB] php+mysql simple query help me pls! ty.

2002-01-03 Thread Rick Emery
Test the mysql_query() return value: $result = mysql_query(SELECT * FROM members) or die(Error:.mysql_error()); there may be an error in your query. -Original Message- From: louie miranda [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 1:59 PM To: [EMAIL PROTECTED] Cc:

Re: [PHP-DB] php+mysql simple query help me pls! ty.

2002-01-03 Thread Sharif Islam
I think you need while loop here. $result = mysql_query(SELECT * FROM members,$db); while ( $row =mysql_fetch_object($result)) { printf(ircname: %sbrn, mysql_result($result,0,ircname)); printf(email: %sbrn, mysql_result($result,0,email)); printf(realname: %sbrn,

Re: [PHP-DB] nysql_query confusing selects for inserts?

2002-01-03 Thread Ken Kinder
It does/did. I add this print statement: $result = mysql_query($sql) || $err = 1; print preb$sql/b/pre\n; And it yields this: prebselect lead.lead_id, lead.firstname, lead.lastname, lead_support_1.area_code from lead left join lead_support_1 on

[PHP-DB] Re: [PHP] php+mysql simple query help me pls! ty.

2002-01-03 Thread louie miranda
yes, i forgot something, this = mysql_select_db(mydb,$db); i did not specify my db name. thanks :) louie - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'louie miranda' [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 04, 2002 4:06 AM

RE: [PHP-DB] Re: [PHP] php+mysql simple query help me pls! ty.

2002-01-03 Thread Rick Emery
Specifying this doesn't matter. That would only equal TRUE or FALSE (per the manual). Your problem lies elsewhere. -Original Message- From: louie miranda [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 2:25 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: [PHP] php+mysql

Re: [PHP-DB] nysql_query confusing selects for inserts?

2002-01-03 Thread Ken Kinder
I saved the query to a file, did a diff, and it does have one difference: there are DOS newlines in the string. Could that do it? Do you know how to strip those out? On Thursday 03 January 2002 11:40 am, Rick Emery wrote: So show us the print out when you printed $sql. I'm certain it did not

RE: [PHP-DB] nysql_query confusing selects for inserts?

2002-01-03 Thread Rick Emery
That's what I wondered about. How are you building the SELECT statement. I would have thought it'd be: $query = select lead.lead_id, lead.firstname, lead.lastname, lead_support_1.plusfour from lead left join lead_support_1 on lead.lead_support_id = lead_support_1_id -Original Message-

Re: [PHP-DB] Re: [PHP] php+mysql simple query help me pls! ty.

2002-01-03 Thread louie miranda
yes, but anyway it work. :) ty.. - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'louie miranda' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 04, 2002 4:26 AM Subject: RE: [PHP-DB] Re: [PHP] php+mysql simple query help me pls! ty. Specifying this doesn't

Re: [PHP-DB] nysql_query confusing selects for inserts?

2002-01-03 Thread Ken Kinder
The query itself is built dynamically from form input, but I did get it resolved. I don't know why, but with dos carage returns, it just didn't work. Thanks for your thoughts. On Thursday 03 January 2002 01:40 pm, Rick Emery wrote: That's what I wondered about. How are you building the

RE: [PHP-DB] printing php variable into html print $result; ?

2002-01-03 Thread Rick Emery
You must extract the results of the query row-by-row. while( $row = mysql_fetch_array($result) ) { print ircname:.$row['ircname'].BR; print email:.$row['email'].BR; print realname:.$row['realname']..BR; print asl:.$row['asl'].BR; print

Re: [PHP-DB] printing php variable into html print $result; ?

2002-01-03 Thread louie miranda
Oh YEAH!! it work!! YEHEY!! yahoo!!! thanks rick! =) louie - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'louie miranda' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 04, 2002 4:51 AM Subject: RE: [PHP-DB] printing php variable into html print $result;

Re: [PHP-DB] Deleting form multiple tables

2002-01-03 Thread Miles Thompson
Not as I understand the docs. Very few relational databases do. Miles Thompson At 10:52 AM 1/3/2002 -0800, olinux wrote: Does mysql not support deletes from multiple tables? [ie] DELETE FROM vendors, billing WHERE vendors.v_id = '1' AND vendors.vb_id = billing.b_id Thanks much, olinux

Re: [PHP-DB] Input to DB from form

2002-01-03 Thread Miles Thompson
You have to execute the query, like so: mysql_query( $sql ); placing this after the code which creates $sql. Also check that your datatypes match, it's often worthwhile echoign $sql so you can see exactly what it contains. Regards - Miles Thompson At 01:52 PM 1/3/2002 -0500, James Kupernik

[PHP-DB] printing php variable into html print $result; ?

2002-01-03 Thread louie miranda
Hi, is it possible to print the sql query? i mean i want to print the output of the command SELECT * FROM members; and output it into html, i tried print $result; -- it gives me different output.. Resource id #2 ty, louie... # PHP SCRIPT ### html

[PHP-DB] Re: [PHP] printing php variable into html print $result; ?

2002-01-03 Thread Philip Olson
A quick rewrite of your code: ?php $conn = mysql_connect($host, $user, $pass); if (!$conn) { echo 'Could not connect: '. mysql_error(); exit; } mysql_select_db($dbname); $sql= SELECT * FROM members; $result = mysql_query($sql); if (!$result) { echo 'Could

[PHP-DB] Re: Urgent!!!

2002-01-03 Thread George Nicolae
select substring_index(date_record,-,1)+id as sum from test order by sum -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com Thomas Omega Henning [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL

[PHP-DB] phpmyadmin

2002-01-03 Thread Viper1
I am trying to use the phpmyadmin to create an online resume site. I have created a table and it seems to be fine but I need some more help on the next steps also how to test the database out. I started by making a table called resumes # of fields is 11 first field is name var is 20 and so on.

[PHP-DB] Re: phpmyadmin

2002-01-03 Thread Mattias Nordstrom
Viper1 wrote: I am trying to use the phpmyadmin to create an online resume site. I have created a table and it seems to be fine but I need some more help on the next steps also how to test the database out. I started by making a table called resumes # of fields is 11 first field is name var

Re: [PHP-DB] phpmyadmin

2002-01-03 Thread Miles Thompson
You're really asking a database design question, and it can be answered only by asking more questions. The first has to be how much do you know about relational databases? The basic theory on normalization, simple queries, etc., covers about 6~10 pages. There are some very good tutorials on