[PHP-DB] query error

2005-04-16 Thread pete M
I've got a database table with a whole list of windows file paths. eg Advent Tower PC\C\Program Files\Microsoft Office\Microsoft Binder.lnk Advent Tower PC\C\Program Files\Microsoft Office\Microsoft Excel.lnk Advent Tower PC\C\Program Files\Microsoft Office\Microsoft Office Setup.lnk Advent Tower

[PHP-DB] Query Error

2003-11-04 Thread Robert Sossomon
I've been racking my brain and the web for finding a solution and no luck so far. Here's the form: $display_block .= HRInput item: form method=post action=\additem.php\nbsp;nbsp;nbsp;nbsp;Item ID:input type=\text\ name=\sel_item_id\BRQuantity: select name=\sel_item_qty\; $display_block .= option

Re: [PHP-DB] Query Error

2003-11-04 Thread CPT John W. Holmes
From: Robert Sossomon [EMAIL PROTECTED] And here is the additem.php file where it check for the info in the field and it is erroring out. It would be rather useful to know the error... $get_iteminfo = select * from GCN_items where 'item_num' LIKE '%$_POST[sel_item_id]%'; Take away the

RE: [PHP-DB] Query Error

2003-11-04 Thread Robert Sossomon
; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Query Error From: Robert Sossomon [EMAIL PROTECTED] And here is the additem.php file where it check for the info in the field and it is erroring out. It would be rather useful to know the error... $get_iteminfo = select * from GCN_items where

Re: [PHP-DB] Query Error

2003-11-04 Thread CPT John W. Holmes
From: Robert Sossomon [EMAIL PROTECTED] The errors as it prints are: The query I just ran was: select * from GCN_items where `item_num` = '%fm-a294%' The query I just ran was: Resource id #2 0 Those aren't errors; it's just what you asked the script to display. Your query simply isn't

RE: [PHP-DB] Query Error

2003-11-04 Thread Robert Sossomon
! -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 1:31 PM To: Robert Sossomon; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Query Error From: Robert Sossomon [EMAIL PROTECTED] The errors as it prints are: The query I

[PHP-DB] Query error

2002-10-02 Thread Wilmar Perez
Hello guys Does anybody have a clue on what wrong with the following sentence? select author_code from author where author_code not in (select author_code from authorxcat); Thanks ***

Re: [PHP-DB] Query error

2002-10-02 Thread Jeffrey_N_Dyke
: Subject: [PHP-DB] Query error 10/02/2002 10:54 AM

RE: [PHP-DB] Query error

2002-10-02 Thread Beau Lebens
something like select author_code from author where author_code not in ($previousResults) HTH Beau // -Original Message- // From: Wilmar Perez [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 2 October 2002 10:54 PM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Query error // // // Hello

[PHP-DB] query error

2002-05-05 Thread erich
when i perform query an mysql db, to insert a new record, the PHP says: Warning: Supplied argument is not a valid MySQL result resource in g:\wwwroot\phpusermanager-1.0\add_order.php on line 24 the snippet is as follows ? // connect to the database $conn = mysql_connect ($db_host, $db_user,

Re: [PHP-DB] query error

2002-05-05 Thread Jason Wong
On Sunday 05 May 2002 14:44, erich wrote: when i perform query an mysql db, to insert a new record, the PHP says: Warning: Supplied argument is not a valid MySQL result resource in g:\wwwroot\phpusermanager-1.0\add_order.php on line 24 the snippet is as follows ? // connect to the

Re: [PHP-DB] query error

2002-05-05 Thread Miles Thompson
Echo your INSERT statement, so that you know what it looks like, if you have the values you expect, field names are spelled correctly. that you're not inserting char into int, etc. Use mysql_errno() and mysql_err() (Check those against manual to determine what error you are getting. Use

[PHP-DB] query error...

2002-02-05 Thread jas
Ok what is wrong with this sql statement? $sql = UPDATE $table_name SET c_name=\$c_name\,s_addy=\$s_addy\,city=\$city\,state=\state\zip=\zi p\,phone=\$phone\; The error I recieve is as follows Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /path/to/wwwdemo_change.php3 on line

Re: [PHP-DB] query error...

2002-02-05 Thread biorn
Try putting single quotes around your variables in your update statement instead of the escaped double quotes, they are easier to read. Also, were you wanting to update all entries in that table to the same, c_name, s_addy, city, state, zip and phone? If not, you will need to add 'where

Re: [PHP-DB] query error...

2002-02-05 Thread DL Neil
Ok jas Ok what is wrong with this sql statement? $sql = UPDATE $table_name SET c_name=\$c_name\,s_addy=\$s_addy\,city=\$city\,state=\state\zip=\zi p\,phone=\$phone\; insufficient checking: comma missing between state and zip incorrectly escaped before phone ... I have looked on MySQL.com

Re: [PHP-DB] query error...

2002-02-05 Thread Miles Thompson
Did you type this out or cut/paste? There was a comma missing between state\zip . Should work when you add the comma. Add a WHERE condition for the update, otherwise every row will be set to these values. Common practice is to use single quotes around the char variables, saves a lot of

[PHP-DB] query error

2001-01-25 Thread Randy Johnson
When I run any kind of query this is the value of result Resource id #2 Example $result= mysql_query (" Select * from ACCT_TBL ") or die ("Error".mysql_error()); print result; any ideas? randy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] query error

2001-01-25 Thread Mark Newnham
Looks fine, now retrieve the rows from the query. -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 12:46 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] query error When I run any kind of query this is the value of result