[PHP-DB] multiple tables and correct select statement

2007-10-23 Thread Jas
Hello all, I receive an error of the following: The used SELECT statements have a different number of columns. Any help, pointers, tutorials are appreciated. Here are the two tables structure I am trying to pull from: Table 1 mysql> describe orders; ++--+--+-+--

[PHP-DB] union/select statement & number of columns

2007-10-19 Thread Jas
Hello all, I receive an error of the following: The used SELECT statements have a different number of columns. Any help, pointers, tutorials are appreciated. Here are the two tables structure I am trying to pull from: Table 1 mysql> describe orders; ++--+--+-+--

[PHP-DB] Re: Looking for a small open-source PHP-DB app that utilize OOP.

2007-09-28 Thread Jas
HTH Jas T K wrote: > Hi, > For a study purpose, I'm looking for a small open source program that works > in PHP-MySQL. In particular, I would like to see some examples with PHP 5 > and Object-Oriented Programming (such as class, objects, and so on). > > I'm looking for

Re: [PHP-DB] Re: mysql statement [SOLVED]

2007-09-27 Thread Jas
od as LIKE OR LIKE OR ... > results-wise. I don't know if it's faster/less intensive or not though. > You'd have to do some tests. > > Also, comparisons like "=" should (if I recall) be faster than LIKE > comparisons. So if you really meant to use "=

[PHP-DB] Re: mysql statement [SOLVED]

2007-09-26 Thread Jas
uot;35132" -> OR `partnum` LIKE "35132" -> OR `vendor` LIKE "35132" -> OR `purpose` LIKE "35132" -> OR `tracking` LIKE "35132" -> OR `contact` LIKE "35132" -> AND `group` LIKE 'mac'

[PHP-DB] Re: Data not fetching in the textfield.

2007-09-26 Thread Jas
You could always do something like: while( $x = myql_fetch_array( $results ) ) { list( $var1, $var2, $var3, ... ) = $x; echo ""; } Chris Carter wrote: > I am trying to fetch data through this code: > > My code: > for($i=0;$i { > $rows = mysql_fetch_array($results); >

[PHP-DB] mysql statement

2007-09-26 Thread Jas
6 rows in set (0.00 sec) I am trying to essentially LIMIT all records returned to be limited by the `group` field so I can search for records and limit the rows returned by that one field. Any tips? TIA. jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] multiple fields all unique? [almost solved]

2004-02-04 Thread Jas
} ?> Might want to check the preg_match string to look for everything between ' and ' but other than that you should be able to list the record that your update statement is having a problem with. HTH Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] multiple fields all unique? [almost solved]

2004-02-04 Thread Jas
an doing a SELECT prior to and > just > comparing values, it lets you do this with just a single query and > only have > extra processing upon errors instead of every single update. I suppose that is what I am going to have to do before doing the update. If you know of a different

Re: [PHP-DB] multiple fields all unique? [almost solved]

2004-02-04 Thread Jas
date worked"; } else { echo "update didn't work"; } And... while($match = mysql_fetch_object($update)) { And.. while($match = mysql_fetch_array($update)) { So far everything I have tried will not allow me to find the exact field and contents of a record that matches an e

Re: [PHP-DB] multiple fields all unique? [almost solved]

2004-02-04 Thread Jas
Jas wrote: For this table to create 3 unique keys I did the following, in case it helps someone else out. +--+--+--+-+-++ | Field| Type | Null | Key | Default | Extra

Re: [PHP-DB] multiple fields all unique?

2004-02-04 Thread Jas
quot;,$db); $rows = mysql_affected_rows(); // Check results of operation if($rows == 0) { echo "No matching records found"; } else { echo "Matching records found"; } Hope this helps anyone else, and thanks for the tip on MySQL's UNIQUE field, wish I would have known i

Re: [PHP-DB] multiple fields all unique?

2004-02-03 Thread Jas
| varchar(100) | | | || +--+--+--+-+-++ 5 rows in set (0.00 sec) and this is the command I am tying to run to modify the hostname, mac & ip fields to unique. alter hosts add unique mac; etc. I have such a hard time with mysql&

[PHP-DB] multiple fields all unique?

2004-02-03 Thread Jas
n my own but the if - else statements are getting ridiculous. Thanks, jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Checking for duplicate records before update?

2003-12-30 Thread Jas
se!"; } I think what I really need to know is if there is a quick way to sort through the results of the current database records and do comparisons against the form. If any one has done something like this before could you please show me an example or point me to a good resource. Thanks in advance. Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] sql errors?

2003-12-15 Thread Jas
$db)or die(mysql_error()); If you echo the posted vars they are all present and the same statement works in other places of the script and from the command line. Any help is appreciated. Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] form not working...

2003-11-10 Thread jas
Yeah, sorry that code wasn't updated... after the $_session['table'] is called the doesn't attempt to post the data form the $_session['table'] if that makes sense... all the error checking isn't the problem jas "Jeffrey N Dyke" <[EMAIL PROTECTED]&

[PHP-DB] form not working...

2003-11-10 Thread jas
For some reason my form to edit selected items is not working, I think I need a new set of eyes. Any help is appreciated... Jas // inc.php function db_retrieve() { require 'dbase.inc.php'; $tble = $_SESSION['table']; $show = @mysql_query("SELECT * FROM $tble LIMIT 0, 1

[PHP-DB] Add items to field using update?

2002-09-22 Thread Jas
PE=MyISAM; Now everytime a new page is reached I want to update only the 'pages' field, here is the current sql statement that overwrites the contents of the 'pages' field. UPDATE $table SET pages = '".$PHP_SELF."' WHERE session = '$holy_cow' any

[PHP-DB] SQL update help

2002-09-20 Thread Jas
Here is my statement UPDATE $table SET pages = $PHP_SELF WHERE session = $holy_cow However it will not update I recieve this error: You have an error in your SQL syntax near '/admin/login.done.php WHERE session = 5d44389bd70881131b9ea7573eba34d4' at line 1 Any help would be appre

[PHP-DB] Whats the best way to update...

2002-08-01 Thread Jas
"$HTTP_SESSION_VARS['session']" or if the session vars are the same it would insert a new row? I hope I am asking the question correctly. Any help, examples would be great! TIA Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Benefits of assigning query to variable

2002-07-31 Thread Jas
w would be something like: if (!$search_string && !$var02) { $sql; } else { $sql; } HTH Jas "Brian Graham" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Are there any benefits to assigning a query to a variabl

[PHP-DB] Column count error?

2002-07-26 Thread Jas
I am not sure how to resolve this type of error, any help is appreciated. TIA Jas /* Error message */ Column count doesn't match value count at row 1 /* Code to query db for username and password */ require '/home/bignickel.net/scripts/admin/db.php'; $db_table = 'auth_use

[PHP-DB] Re: Not sure what I am doing wrong here?

2002-07-23 Thread Jas
No kidding huh? Thanks a ton. "David Robley" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > says... > > Ok, now I am not sure why I cannot get this output into a variable so I can > > place it into a databas

[PHP-DB] Not sure what I am doing wrong here?

2002-07-22 Thread Jas
x27;$ipaddy','$whois')"; $result = @mysql_query($sql_insert,$dbh) or die(MYSQL_ERROR()); // No error but what gets entered for the var $whois is arin(66.56.34.32) ?> // These results should be placed in $whois which is empty // This returns arin(65.44.33.23) which is wrong

[PHP-DB] Re: never seen this before..

2002-06-24 Thread Jas
. TIA Jas <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > TIA -- > > > column in your table denotes your primary key? After that, how is it > incremented? Is it auto or do you have some other form of it. I think > your code is corr

[PHP-DB] never seen this before..

2002-06-24 Thread Jas
addy','$date')" or die('Could not insert client info'); $result = @mysql_query($sql_insert,$dbh) or die(MYSQL_ERROR()); Any help on this would be great TIA Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] resource id#2 - ????

2002-06-12 Thread Jas
Thanks a ton, I was really looking right past that variable. Jas "Paul Dubois" <[EMAIL PROTECTED]> wrote in message news:p05111763b92d3addd3b4@[192.168.0.33]... > At 11:42 -0600 6/12/02, Jas wrote: > >Not sure how to over come this, the result of a database quer

[PHP-DB] resource id#2 - ????

2002-06-12 Thread Jas
); session_register('referrer'); session_register('date_stamp'); } ?> Just to make sure everything is working correctly I have echoed every statement to the screen so I may see what's going on like so: // my results should be here but instead I get Resource ID #2 printe

[PHP-DB] Re: new pair of eyes

2002-05-31 Thread Jas
Sorry, got it working, just needed to remove user_id, f_name etc. and it works fine. "Jas" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I think I am missing something: > $db_name = "database"; > $table_name = &quo

[PHP-DB] new pair of eyes

2002-05-31 Thread Jas
uld not execute query. Please try again later."); Its not deleting the records based on a hidden field in a form named $user_id Any help would be great! Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: Re[2]: [PHP-DB] how to pull array out?

2002-05-30 Thread Jas
SUCCESS Ok, I have fixed the problem. Here is the code, I hope it helps anyone that comes accross something like this. Sorry for being a "troll". Jas // Displays select form of current users in database table for editing $table = "users"; $record = @mysql_query("S

Re: Re[2]: [PHP-DB] how to pull array out?

2002-05-30 Thread Jas
understand I am trying to learn this scripting language and RTFM does not help as most of the time I post here as a LAST resort, i.e. after I have indeed RTFM'ed. Thanks again, Jas "Julie Meloni" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PRO

Re: [PHP-DB] how to pull array out?

2002-05-30 Thread Jas
trying to find an answer to a problem and reading your RTFM does not help. Thannks again, Jas "Jason Wong" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Friday 31 May 2002 00:19, Jas wrote: > > Not sure how to do this, but I

[PHP-DB] how to pull array out?

2002-05-30 Thread Jas
Edit Account $user_id First Name:i.e. John Last Name:i.e. Doe Email:i.e. [EMAIL PROTECTED] User Name:i.e. j-doe Password:(password must be alpha-numeric, i.e. pAs5w0rd) Confirm Password:please confirm password entered     &q

Re: [PHP-DB] Resource ID#2 ????

2002-05-29 Thread Jas
Last Name:i.e. Doe Email:i.e. [EMAIL PROTECTED] User Name:i.e. j-doe Password:(password must be alpha-numeric, i.e. pAs5w0rd) Confirm Password:please confirm password entered     "; echo $record; Thanks in advance, Jas "Natali

Re: [PHP-DB] Resource ID#2 ????

2002-05-29 Thread Jas
at least I think. Any help would be great! Jas "Jason Wong" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Thursday 30 May 2002 00:17, Jas wrote: > > Ok here is my problem, I set this up so a user selects a name form a selec

[PHP-DB] Resource ID#2 ????

2002-05-29 Thread Jas
AIL PROTECTED] User Name:i.e. j-doe Password:(password must be alpha-numeric, i.e. pAs5w0rd) Confirm Password:please confirm password entered     "; echo $record; } else { blah blah } Thanks in advance, Jas -- PHP Database Mailing L

[PHP-DB] creating errors

2002-05-28 Thread Jas
('$pw')'"; Is there any reason this would not work? Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Error? new set of eyes...

2002-05-28 Thread Jas
ost/portfolio.php on line 169 Any help would be great!! Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] loop?

2002-05-24 Thread Jas
Not quite sure how to get this piece of code to loop through the records and echo them back one line per one record... Echo record set... Any help would be great! thanks Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How to store results into a session variable..

2002-04-30 Thread Jas
I need a tutorial or example on how to take a result from an mysql query and place it into a session variable. Please help? Thanks in advance, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql results to a session variable?

2002-04-27 Thread Jas
this. Any help would be great. thanks in advance, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Unique Field for text field...

2002-04-20 Thread Jas
to query the database and put the results into a form for later use... The problem I am having is how would I assign a unique field name for each entry displayed? I am not sure how I can do this with the $col_value simply echoing the results onto the page, if anyone could shed some light on thi

[PHP-DB] If statement for sql statement

2002-04-09 Thread jas
if there is a way to create an if statement that would either update or not update a selected field in the database. Below is a piece I would assume would work however I am not sure of the mysql command to not update anything. Any help would be great. Jas if( $file_name = '--'

Re: [PHP-DB] Stuck on db entry from select box...

2002-04-05 Thread Jas
Upon doing a print $sql before the mysql_querie I get this output; UPDATE cm_index SET ad01_t=$files"Could not execute query. Please try again later -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Stuck on db entry from select box...

2002-04-05 Thread Jas
wrong but still new to these advanced functions. Thanks in advance, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Stuck on db entry from select box...

2002-04-05 Thread Jas
the database table I want to put the path to the file in the database table, any help would be greatly appriciated. =) Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] how to question...

2002-04-04 Thread jas
can use a select box to select the file path in which I would like to save to database, like I said I don't want someone to do it for me, I just need a resource such as a tutorial or example to run with. Thanks a ton, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] Re: calculations based on checkbox value

2002-03-22 Thread jas
will need to subtract a certain amount if a checkbox is checked. I am assuming that the IF statement would be something like... IF $variable = 1; { $variable - $total = $total2 ) Else do the rest of the code... I am still a newbie to php so any help would be great. Thanks in advance, Jas

[PHP-DB] calculations based on checkbox value

2002-03-22 Thread jas
there has accomplished a similar function and if so could you point out a good tutorial or let me see some sample code? Thanks in advance, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] textarea and mysql query

2002-03-18 Thread jas
John, that worked great. Thanks again for your help, I am going to do a tutorial on using textareas in order to edit contents of a database considering i had a hell of a time trying to find one elsewhere. Jas "John Hughes" <[EMAIL PROTECTED]> wrote in message 003e01c1ceb2

Re: [PHP-DB] textarea and mysql query

2002-03-18 Thread jas
you, > > Ray Hunter > Firmware Engineer > > ENTERASYS NETWORKS > > > -Original Message- > From: jas [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 18, 2002 12:07 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] textarea and mysql query > > > Yeah tha

Re: [PHP-DB] textarea and mysql query

2002-03-18 Thread jas
Sorry, the connection is established already so that part works just fine. It is getting the results of said connection \ query to appear in a textarea vs. a text line. "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > On Monday 18 March 2002 14:53,

Re: [PHP-DB] textarea and mysql query

2002-03-18 Thread jas
ut the code to the screen like a dos echo command that would help out alot. Thanks in advance, Jas "Ray Hunter" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Try this: > > > $record = mysql_fetch_array(@mysql_query("SELEC

[PHP-DB] textarea and mysql query

2002-03-18 Thread jas
I need some help with a query to place the results within a text area... here is the code and so far every time I try it out all that happens is it displays the textbox but not the results of the query. \n"; ?> Any help would be great. Jas -- PHP Database Mailing Li

[PHP-DB] text area

2002-03-11 Thread jas
I am wondering where I could find a good tutorial on displaying the contents of a database field within a textarea for editing. Any help would be great! Thanks in advance, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Monitor files

2002-03-07 Thread jas
open source s/w that is commercially available for download etc. Maybe a tutorial on the subject would be great. Thanks Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] records into an editable box

2002-03-06 Thread jas
No dan I mean textbox... but I am assuming you dont have any idea where a good tutorial would be then. Thanks anyways. Jas "Dan Brunner" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello!! > > Do you mean a textarea??

[PHP-DB] records into an editable box

2002-03-06 Thread jas
How would I change this sql statement to pull the db table and display it within an editable box within a form? Any help or tutorials would be great. text:\n"; printf(mysql_result($result,"wel_area")); ?> Thanks in advance, Jas -- PHP Database Mailing List (http:

Re: [PHP-DB] security

2002-03-05 Thread jas
how can you find out what the php.ini is looking like? is there a way to use php to get that info. i have used phpinfo() but i cannot see whether or not file_uploads is disabled Jas "Paul Burney" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED].; on 3/3/02 7:39 PM

[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, >

[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'); >

[PHP-DB] Re: forced page links...

2002-02-27 Thread jas
, Jas "Lerp" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi there :) I use session variables to do this, once the user has logged in > and you know they are who they say they are, set a session variable using > > session_r

[PHP-DB] forced page links...

2002-02-27 Thread jas
unclear on how the use of sessions would require the user to visit each page in succession. Thanks in advance, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-26 Thread jas
Would you have an example of that? Jas "Beau Lebens" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > rather than all the hidden fields and stuff you guys are trying to do - why > not just build the array variable you want, then sa

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
everyone. Jas "Natalie Leotta" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Jas, > > I've run into the same kind of problem with the site I'm doing for work. > > My first solution was to use the query string to pass

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
Jas "Jas" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Ok, I think I understand what you are talking about. So now I know what I > need to accomplish, and would you happen to know of a good place to learn > about something

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
would appreciate it. Thanks again, Jas <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > One problem I see is that you are sending all of the values for all of your > fields (except the id field) from the first page to the second page, not just

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
car_type[0] and loop through all of the values > in the array. > > ie. > > $i=0; > while ($car_type[$i]) { > > I have added more code below that should help. > > MB > > > jas <[EMAIL PROTECTED]> said: > > > Yeah, tried that and it still isnt passi

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
the hidden element, ie. > > > > You were naming the field as an array with no value. > > if you want to pass this as an array of values, you would need to use: > > > > Give that a try and see if it works. > > HTH > > MB > > > jas <[EMAIL PROTECTED]&g

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
(i.e. car_type etc.) "Jas" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Oops... yeah its a monday. > Bjorn, I reverted back to my original code because I was getting confused... > Here is page one... > // Database connect

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
ssage [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Let's see what your code looks like now and where it is returning the > word "array". That might help determine where the problem lies now. > > MB > > jas <[EMAIL PROTECTED]> said: > > > O

[PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
delete selected records from the db it only displays the word "array". Not quite sure where I need to go from here... Any insight would be a great help. Thanks in advance, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Array HELL!!!!

2002-02-22 Thread jas
STRING' or `NUM_STRING' or `'$'' in /php/rem_conf_t.php3 on line 21 Wouldn't I need to adjust the value=\"$id[]\" to something like value=\".$id[].\" because we passed an array not a string? Not sure. Thanks again. You are sincerely helping me unders

Re: [PHP-DB] Array HELL!!!!

2002-02-22 Thread jas
Well ok now that I know it isn't an array I am having problems with, how exactly am I supposed to create a variable (that can be passed to another page) from a selected set of records? Thanks again for the politeness, Jas "Spyproductions Support Team" <[EMAIL PROTECTED]> wr

[PHP-DB] Array HELL!!!!

2002-02-22 Thread jas
me pointers on what the hell I am doing wrong please let me know, I would be very glad to hear your opinion and the correct way to accomplish this. (And, yes I went through just about every tutorial I could find on how to delete records, which by the way did nothing for putting the results of a select statement into an array or variable for futher processing.) Have a good weekend everyone!!! Pissed and frustrated... Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Associating table id...

2002-02-22 Thread jas
into the same problem that I am having please give me a shove in the right direction. Thanks in advance, Jas "Jas" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Ok I have been working on this function to delete an item from a mysql &

[PHP-DB] Associating table id...

2002-02-22 Thread jas
help... I am still fairly new to php and mysql and there is definately something I am missing here and I think its because I need to associate the checkbox with the id and the id field from the database does not seem to be linked to the rest of the record in said fields... Thanks in advance, Jas And yes

Re: [PHP-DB] debugging?

2002-02-21 Thread jas
nt know enough about php and mysql to understand what this means... is there some kind of chart or definitions for error messages? I tried looking on mysql.org and couldnt find anything specific. In any event, thanks in advance. Jas <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]"&g

Re: [PHP-DB] debugging?

2002-02-21 Thread jas
$id = 'id'",$dbh) or die(mysql_error()); Is there anywhere on php.net or mysql.org that give exact error meanings? Thanks again, Jas "Olinux" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > jas, > > Try this: > - R

Re: [PHP-DB] Errors Deleting...

2002-02-21 Thread jas
count,"car_type")); echo "remove \n"; echo "rest of table and cell output"; } echo ""; ?> "Gurhan Ozen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Jas, > You still have cars as your checkbo

[PHP-DB] Errors Deleting...

2002-02-21 Thread jas
ot;)); echo "\n"; } echo ""; ?> file 2. - takes variable of checkbox and then queries db trying to delete any record based on the id. code is as follows... I have been trying everything under the sun and cannot get this to work. please help. Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] debugging?

2002-02-21 Thread jas
ot;)); echo "\n"; } echo ""; ?> file 2. - takes variable of checkbox and then queries db trying to delete any record based on the id. code is as follows... I have been trying everything under the sun and cannot get this to work. please help. Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Parse Error

2002-02-21 Thread jas
Could you maybe give me an example of how to associate the checkbox with the id? Thanks again, Jas "Gurhan Ozen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Ok then it sure will not work.. because you have : > > &qu

Re: [PHP-DB] Parse Error

2002-02-21 Thread jas
x27;1', 'Ford', 'Bronco', '1969', '4500', 'vin897655', 'none'); Sorry about that... still a bit of a newbie here. =) Jas "Gurhan Ozen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...

Re: [PHP-DB] Parse Error

2002-02-21 Thread jas
Here is the code from the file that queries the db and pulls the current contents of the db and provides a check box form for each record to delete the items in the db. I dont know if this will help but like I said before any insight would be great. Thanks in advance. Jas Current Inventory

[PHP-DB] Parse Error

2002-02-21 Thread jas
ROM $table_name WHERE $cars = \"$car_type\",\"$car_model\",\"$car_year\",\"$car_price\",\"$car_vin\",\"$dl r_num\""); $result = @mysql_query($sql, $connection) or die ("Could not execute query. Any insight would be great... thanks again. Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Deleting records...

2002-02-20 Thread jas
I forgot to include the error message I am recieving when trying to remove records using the check box. Parse error: parse error in /path/to/php/done2.php3 on line 22 Thanks in advance. Jas "Jas" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTEC

[PHP-DB] Deleting records...

2002-02-20 Thread jas
Ok I am trying to delete records from a database using an html form. I have 2 files, file one = remove.php3 which queries the database table and displays the current contents. Code is as follows. Current Inventory"; $count = -1; while ($myrow = mysql_fetch_row($result)) { $count ++; echo "Type

[PHP-DB] formating problem

2002-02-19 Thread jas
I feel kinda dumb for posting this but here it is... I am trying to query a table then format the results so it looks like the rest of the site and the darn delete button to remove db entries keeps showing up at the top. Here is the code... Thanks in advance. Jas Current Inventory"; $count

[PHP-DB] formating w/ table

2002-02-15 Thread jas
I am having a little problem formating data retrieved from a database into table cells... So far after connecting and querying the database table the data is put into table cells, however after the first entry is displayed in the table all the other entries loose the formating, HELP? Current Inven

[PHP-DB] optimizing script...

2002-02-15 Thread jas
and html markup from all the fields in the form at once... here is my code, any insight would be great. I am not asking you to do it for me, I just want to know how and what the best way to condense it would be. Thanks in advance. Jas # - Error correction for car_type field

[PHP-DB] Form Validation

2002-02-14 Thread jas
Anyone know of a good function to strip characters and stuff that would cause mysql to crash from forms? Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Disable Right click w/ php?

2002-02-14 Thread jas
I have been looking on php.net for a function to disallow people to right click to view source... anyone have a good idea of how to accomplish this without using java-script? Thanks in advance, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Required pages...

2002-02-12 Thread jas
could be accomplished I would appriciate it. Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] help files...

2002-02-06 Thread jas
hether you used php to query a database table made for your different help sections or did you use the applet method? I am just not sure what the best option would be for this type of thing. Thanks in advance, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://w

Re: [PHP-DB] Updating Database problem...

2002-02-06 Thread jas
uot;,phone=\"$phone\""; $result = @mysql_query($sql, $connection) or die ("Could not execute query. Please try again later."); # -- } ?> "Rick Emery" <[EMAIL PROTECTED]> wrote in message [EMAIL P

[PHP-DB] Updating Database problem...

2002-02-06 Thread jas
r can point me to a good tutorial on this type of function. Thanks in advance, Jas "; $formerr = $formerr + 1; } if($s_addy == "") { $s_addyerr = "Please enter your Street Address"; $formerr = $formerr + 1; } if($city == "") { $cityerr = "Pl

[PHP-DB] query error...

2002-02-05 Thread jas
ing: Unexpected character in input: '\' (ASCII=92) state=1 in /path/to/wwwdemo_change.php3 on line 22 Parse error: parse error in /path/to/wwwdemo_change.php3 on line 22 I have looked on MySQL.com at the update function and it states I can use the SET under UPDATE for multiple fields separated by

  1   2   >