Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: yamy
  • Order by date
  1. yamy

    empty vs !empty

    Thanks!
  2. yamy

    empty vs !empty

    which syntax is correct: if (empty ($_POST['var'])) { or if (!empty ($_POST['var'])) { and if both are correct, what determines the use of the leading ! thanks amy
  3. yamy

    insert values into multiple tables

    thanks for all the additional tips. I agree about cleaning up user data before it gets to the db and will take that on soon. the mysql_query(insert.....) syntax i found online and it is working but i'll work on getting up to date with all the code. ?? the mysql_connect.php script contains the...
  4. yamy

    insert values into multiple tables

    you rock, aardvark! that error message display was just the trick to show me the solution. contact table pk was duplicating. i made it an autoincrement and then added the value NULL to the insert query. voila! thanks to all you teks for your tips - you are great. Cheerio! amy
  5. yamy

    insert values into multiple tables

    thanks Jet, but I have tried exactly what you suggest with no success. now i have a completely broken script that does nothing. this is the last iteration i have tried, with no success: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"...
  6. yamy

    insert values into multiple tables

    ps - does it make sense that for every table i should have a separate form with its own submit button? maybe that is the trouble with my script - there is only one form with many fields, that ultimately are headed for one of five different tables in the db. thanks
  7. yamy

    insert values into multiple tables

    I am searching for codes examples that show how to use PHP with MySql to send form data into more than one table. i can send form data into one table only, no matter how i try, no data will go into the second table. the sequence that works for data into a single table is: 1. set variables -...
  8. yamy

    query - add values to multiple tables

    thanks, i will move to the PHP forum as suggested. and, i have lots of books, i wish i could find just one freaking example of this in a book or on line somewhere. it's not for lack of trying, trust me. byby
  9. yamy

    query - add values to multiple tables

    I can get the closing echo statements to print with this revision, but still cannot get entries into the second table <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head>...
  10. yamy

    query - add values to multiple tables

    I can get an entry into the first table.(company) i managed to get one entry into the second table (contact), one time - and then it stopped working when i itried to add a second field in the second table, must be another of those dreaded 'typos'. a well, this code does not print the echo...
  11. yamy

    query - add values to multiple tables

    Hi Rac2, ok i think you might have nailed the problem on the head. my working model uses: $result=mysql_query($query) followed by if ($result) echo "some stuff"; else "echo some other stuff"; so, to follow your point, it seems I need to have my if ($result).... OR, your $mysql_query and I...
  12. yamy

    query - add values to multiple tables

    well, no, it does NOT look like that! your red-letter insertions are what i don't have. are they to separate the insert calls? are the ... required also, or just shorthand for 'more like this'? thanks
  13. yamy

    query - add values to multiple tables

    my db has multiple tables with an online form that captures data to go into one or more of these tables. i have total success with a single table db - from user entered data to mysql db record - perfecct. now i am testing the new multi-table db using just two of the tables, and i know the...
  14. yamy

    POST - howto help with arrays

    I realized all of what you are saying halfway through writing my last post. More to the point, I understood that I could go no further without analyzing and establishing the table structure. I've got a terminal case of hurry up and want it now disease but I do try hard to find my answers in the...
  15. yamy

    POST - howto help with arrays

    Thanks for the reply. I read thru the link you sent. Is my alternative to create individual columns for each variable? In this instance I want the user to be able to select more than one option and the database should hold it all. i am answering my own question as I write this - yes, of...
  16. yamy

    POST - howto help with arrays

    I have a form with differing inputs: text, checkbox, radio, select option. (www.sutryn.com/2007webscripting/contact_form_includes.php) All the data goes via PHP into MySQL db with no trouble EXCEPT in the case of the checkbox array. I found information about "serialize", but i've missed some...
  17. yamy

    great Firewall of China

    our company is experiencing an increase in disappearing or undeliverable emails going into or coming out of China, Taiwan, and other asia-pacific countries. no matter the nature of the error (550, spam blacklist, just plain gone into the ether), there is some days that mail goes and comes fine...
  18. yamy

    white space and content m odel

    <?xml version="1.0" encoding="iso-8859-1" ?> <!DOCTYPE techdatatable [ <!ELEMENT aatable (grade+,application+,description+,color+,viscosity+,gapfill+,shearstrength+,torquebreak+,torqueprev+, fixturetime+,temp+,specs*)> <!ELEMENT grade+ (#CDATA)> in the above code snip - this produces the...
  19. yamy

    php &amp; html error

    almost always it is a mis-placed or mis-used single or double quote. what a challenge to keep those rules straight. thanks for listening, i've got this on the run now! regards,
  20. yamy

    php &amp; html error

    added note typical of my php experience, now it is all broken again. i realized i had posted db access in my posting so i went to add a new user, assign new user access to db and now no access works except direct thru the mysql gui. i don't know how to help me now!

Part and Inventory Search

Back
Top