[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
for reference: http://us3.php.net/zend-engine-2.php http://www.php.net/oop 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

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

2007-09-27 Thread Jas
unclear. I know I get some kooky ideas sometimes. Also, anyone see anything I screwed up or have thoughts on this matter? Good luck! -TG - Original Message - From: Jas [EMAIL PROTECTED] To: php-db@lists.php.net Date: Wed, 26 Sep 2007 12:08:53 -0600 Subject: [PHP-DB

[PHP-DB] mysql statement

2007-09-26 Thread Jas
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

[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 input name=storename type=text value=$var1; } Chris Carter wrote: I am trying to fetch data through this code: My code: for($i=0;$imysql_num_rows($results);$i++) {

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

2007-09-26 Thread Jas
- OR `vendor` LIKE 35132 - OR `purpose` LIKE 35132 - OR `tracking` LIKE 35132 - OR `contact` LIKE 35132 - AND `group` LIKE 'mac' - ORDER BY `ordernum` - LIMIT 0 , 30; Jas wrote: I am looking for some advice on how to achieve something and so far have been unable to do what I

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

2004-02-04 Thread Jas
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 it sooner, I wouldn't be so pissed off from frustration. Jas -- PHP Database Mailing

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? [almost solved]

2004-02-04 Thread Jas
will not allow me to find the exact field and contents of a record that matches an existing record in the database. See below for details on database structure etc. Any help is appreciated, jas Jas wrote: Jas wrote: For this table to create 3 unique keys I did the following, in case it helps someone

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

2004-02-04 Thread Jas
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 method please elaborate. thanks again, Jas -- PHP Database

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

2004-02-04 Thread Jas
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

[PHP-DB] multiple fields all unique?

2004-02-03 Thread Jas
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

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

2004-02-03 Thread Jas
) | | | || +--+--+--+-+-++ 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's manual. Jas -- PHP Database

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

2003-12-30 Thread Jas
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
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

[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, 15,$db)or die(mysql_error

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 input button 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] wrote in message news:[EMAIL PROTECTED

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

2002-09-22 Thread Jas
' 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 help on this would be great. Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[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 appreciated Jas

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

2002-08-01 Thread Jas
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
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 variable? -- PHP Database Mailing List (http://www

[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_users'; $sql = SELECT

[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 database table

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

2002-07-22 Thread Jas
on this would be appreciated! Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] never seen this before..

2002-06-24 Thread Jas
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

[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 correct so the error seems to be how

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

2002-06-12 Thread Jas
wtf? /tablebr ?php echo $ipaddy; ?br ?php echo $referrer; ?br ?php echo $date_stamp; ?br ?php echo $sql_insert; ?br ?php echo $sql_content; ?br ?php echo $id; ?br ?php echo $file_name; ?br ?php echo $file_size; ?br Any help would be great! Jas -- PHP Database Mailing List (http://www.php.net

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 query keeps giving me this: ?php /* Get

[PHP-DB] new pair of eyes

2002-05-31 Thread Jas
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

[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 = auth_users; $sql = DELETE user_id, f_name

[PHP-DB] how to pull array out?

2002-05-30 Thread Jas
\nbsp;nbsp;input type=\reset\ name=\reset\ value=\reset\/td/tr /form/table; echo $record; It only echoes the resource id, any help or examples would be great Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-05-30 Thread Jas
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 need to pull the contents of an array into

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

2002-05-30 Thread Jas
. after I have indeed RTFM'ed. Thanks again, Jas Julie Meloni [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Jas (and anyone else) - With all due respect, you're acting like a troll. Posting a question, getting MANY correct answers, then reposting the

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(SELECT * FROM $table,$dbh

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

2002-05-29 Thread Jas
\ name=\reset\ value=\reset\/td/tr /form/table; echo $record; } else { blah blah } Thanks in advance, 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-05-29 Thread Jas
. 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 select box and that name or $user_id is then

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

2002-05-29 Thread Jas
=\reset\/td/tr /form/table; echo $record; Thanks in advance, Jas Natalie Leotta [EMAIL PROTECTED] wrote in message 7546CB15C0A1D311BF0D0004AC4C4B0C024AC420@SSIMSEXCHNG">news:7546CB15C0A1D311BF0D0004AC4C4B0C024AC420@SSIMSEXCHNG... I could be missing something, but it looks like you a

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

2002-05-28 Thread Jas
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] 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
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
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 this I would appreciate it. Thanks in advance, Jas -- PHP

[PHP-DB] If statement for sql statement

2002-04-09 Thread jas
not sure of the mysql command to not update anything. Any help would be great. Jas if( $file_name = '--' ) $sql = dont update table; else $sql = UPDATE $table_name SET image01_t = \$files\; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

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

2002-04-05 Thread Jas
wrong, also on another note I don't want to put the file in 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

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

2002-04-05 Thread Jas
not execute query... sorry about not knowing where I am going 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

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=$filesCould not execute query. Please try again later -- 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, visit

[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

[PHP-DB] textarea and mysql query

2002-03-18 Thread jas
= mysql_fetch_array(mysql_query(SELECT wel_area FROM cm_index,$dbh)); echo textarea name='wel_area' value='{$record['wel_area']}' cols='25' rows='8'/textareabrinput type='submit' name='save' value='save'br\n; ? /form Any help would be great. Jas -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] textarea and mysql query

2002-03-18 Thread jas
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: form name=wel_area method=post action=index_confirm.php3 target=box ?php $record = mysql_fetch_array(@mysql_quer

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, jas wrote: I need

Re: [PHP-DB] textarea and mysql query

2002-03-18 Thread jas
$record['wel_area']. If this is a multidimensional array then you will need to access it differently... Example: echo $record[0][0].\n; Try this is your text area and see if that comes out... Thank you, Ray Hunter Firmware Engineer ENTERASYS NETWORKS -Original Message- From: jas

[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

[PHP-DB] records into an editable box

2002-03-06 Thread jas
(mysql_result($result,wel_area)); ? Thanks in advance, 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?? And you want to populate the

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, Ric MaƱalac at [EMAIL

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

2002-02-28 Thread jas
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 get

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

[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

[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_register(isloggedin); $islogged

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 save it into a session, on

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

2002-02-25 Thread jas
to 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] Passing contents of array on as variables...

2002-02-25 Thread jas
PROTECTED] wrote in message [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: Ok to this point I have been able

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

2002-02-25 Thread jas
.) 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... ?php // Database connection paramaters require '../path/to/db.php';

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

2002-02-25 Thread jas
HTH MB jas [EMAIL PROTECTED] said: As of right now if you run the php script and view source on the page you can see that it does place the content of db table into array... ex. BCurrent Inventory/B/fonthr color=33/td/tr INPUT TYPE=hidden NAME=car_type[Ford] INPUT TYPE=hidden NAME=c

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

2002-02-25 Thread jas
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 passing the contents of the array as a varible to the confirmation page for deletion. I am a

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
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 like this? For some reason this

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 contents of an array (array[0]array[1]...) b

[PHP-DB] Associating table id...

2002-02-22 Thread jas
... 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

[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 database and so fa

[PHP-DB] Array HELL!!!!

2002-02-22 Thread jas
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

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] wrote in message [EMAIL

[PHP-DB] Parse Error

2002-02-21 Thread jas
\); $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

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

Re: [PHP-DB] Parse Error

2002-02-21 Thread jas
', '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]... Jas.. First of all you don't have the variable $cars assigned.. Second of all, we sti

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 : DELETE FROM $table_name WHERE $cars =\$

[PHP-DB] debugging?

2002-02-21 Thread jas
is as follows... ?php require '../scripts/db.php'; $sql = @mysql_query(DELETE FROM $table_name WHERE $id = 'id',$dbh) or die(Could not execute query, please try again later); print(changes made); ? I have been trying everything under the sun and cannot get this to work. please help. Jas -- PHP

[PHP-DB] Errors Deleting...

2002-02-21 Thread jas
. Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-02-21 Thread jas
].\remove/td /tr\n; echo rest of table and cell output; } echo trtdinput type=\submit\ name=\delete\ value=\delete\/td/tr/form/table; ? Gurhan Ozen [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Jas, You still have cars as your checkbox name.. change

Re: [PHP-DB] debugging?

2002-02-21 Thread jas
(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: - Remove the @, it suppresses the error - change die(Could not execute query, pl

Re: [PHP-DB] debugging?

2002-02-21 Thread jas
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]">news:[EMAIL PROTECTED].

[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. ?php require '../scripts/db.php'; $result = mysql_query(SELECT * FROM cur_inv,$dbh) or die(Could

[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 PROTECTED]... Ok I a

[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 ?php require '../scripts/db.php

[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] 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? ?php require

[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] 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] Required pages...

2002-02-12 Thread jas
this 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] Updating Database problem...

2002-02-06 Thread jas
point me to a good tutorial on this type of function. Thanks in advance, Jas ?php # trim extra spaces from these variables $c_name = trim($c_name); $s_addy = trim($s_addy); $city = trim($city); $state = trim($state); $zip = trim($zip); $phone = trim($phone); if($c_name == ) { $c_nameerr = Please

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

2002-02-06 Thread jas
= @mysql_query($sql, $connection) or die (Could not execute query. Please try again later.); # -- } ? Rick Emery [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Jas, Why are you initiating an UPDATE comm

[PHP-DB] query error...

2002-02-05 Thread jas
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 a , and it is not working... Any insight would be great. Thanks in advance, Jas -- PHP Database

[PHP-DB] Combined sql statement

2002-02-04 Thread jas
to simply update and overwrite the current table entry. Any help would be appriciated and if you could please document it so I understand and dont have to ask again. Thanks, jas WOW, your neat -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] phpMyAdmin Problem....

2002-02-01 Thread jas
yeah that sounds like apache not being setup right Matt Williams [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I just added phpMyAdmin to a new Apache Server, and I'm getting this error: cannot load MySQL extension, please check PHP Configuration. I

[PHP-DB] DB Connection Class

2002-01-31 Thread jas
a few tutorials on the subject but they keep going way over my head, I need a simple to understand method of reusing a connection for each query. Please help! Thanks in advance! Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands

[PHP-DB] DB Connections

2002-01-31 Thread jas
tutorials on it and as of yet they all seem to go over my head. If someone could give me some more insight into this area I would greatly appriciate it. Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

[PHP-DB] MySQL Connections

2002-01-31 Thread jas
Ok how can I find some good resources on how to create a db connection class that doesnt go over my head? I need to be able to connect to a mysql database as the page loads and thoughout the page run 6 separate queries on different fields. please help! jas -- PHP Database Mailing List (http

Re: [PHP-DB] Connection class

2002-01-31 Thread jas
email editor choked. =) Thanks again. Jas Rick Emery [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... huh? You open the connection once for the page and then you CAN make multiple queries to it from the same page. Why are you trying to create a clas

[PHP-DB] MySQL Connection Class

2002-01-30 Thread jas
I know this may seem a little vague but I would like to know where a good tutorial on creating database connection class files would be. I have been looking and as of yet I have not found one that deals specifically with this question. Thanks in advance. Jas -- PHP Database Mailing List

  1   2   >