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 IamaSherpa 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: *

  1. lentildal

    is there anything wrong with this query??

    hi all is there anything wrong with this query? it doesnt seem to be working... $query = "UPDATE table_name SET commentid = 'NULL', commentname = '$comm_name[$id]', commentmail = '$comm_mail[$id]', commentsite = '$comm_site[$id]', commentcomment = '$comm_comm[$id]' commentdte = 'NULL'...
  2. lentildal

    help needed to display results of query

    hi people i have a form which goes a bit like this i didnt include everything - just the important stuff... PHP: while(list($id,$comment) = @each($disp_array)) { ?> <tr><td>Date added:<?= $comment[dte] ?></td><td align='center' rowspan='5'><input type=&quot;checkbox&quot...
  3. lentildal

    help debugging a guestbook type of thing

    hi, i have this code buts its not working exactly right. i wondered if anyone would have a second to look through it and let me know what im doing wrong... code: // check to see if the page is posted and data sent if ($REQUEST_METHOD == &quot;POST&quot; && $HTTP_POST_VARS) { //set...
  4. lentildal

    formatting URLs and timestamp within &lt;form&gt; input field

    thanks give me all your lentils
  5. lentildal

    help needed with arrays

    hi i think you are right anikin, that is a much better way of doing it. i tried the mailto thing and it works well, in flash too. but how do you write the code to check for http:// and turn it into a link? thanks give me all your lentils
  6. lentildal

    help needed with arrays

    no the urls are links in the database. i made them into links because they are also displayed in a flash textbox which can read html. the guestbook is in flash. when someone submits their email or URL it gets turned into a link before it is saved to the database. its done with preg_replace. i...
  7. lentildal

    formatting URLs and timestamp within &lt;form&gt; input field

    hello i have some URLs in my database like <a href=&quot;mailto:test@test.com&quot;>test@test.com</a> and <a href=&quot;http://www.test.com&quot; target=&quot;_blank&quot;>www.test.com</a> i also have a timestamp(8) field like 20020101 i would like to display them in an html form, in...
  8. lentildal

    help needed with arrays

    hmmm how can i make the URLs printout properly? i tried adding rulencode but that doesnt do it properly either... give me all your lentils
  9. lentildal

    help needed with arrays

    hi anikin i think that helped a bit, but its not working right yet. take a look... http://lentildal.co.uk/test/adcomm.php give me all your lentils
  10. lentildal

    help needed with arrays

    hi guys thanks for your replies hi again anikin i tried your code out and i had it working for a second, but then i added more textboxes and i cant make it work anymore. this is what i have so far: $query = &quot;SELECT * FROM $table_name ORDER BY commentid DESC&quot;; $res =...
  11. lentildal

    help needed with arrays

    hey folks i have a table with these fields in each row... commentid (autoincrement int key) commentname (text) commentmail (text) commentsite (text) commentcomment (text) commentdte (timestamp) i have this code... $query = &quot;SELECT commentid, commentname, commentmail, commentsite...
  12. lentildal

    help with while() loop to update database

    hi anikin i got it working! thank you so much for all your help. you have been very generous with your time. thanks thanks thanks thanks thanks thanks thanks thanks :-D give me all your lentils
  13. lentildal

    help with while() loop to update database

    hi, just for your reference, here are both scripts (everything included!) first script: <?php // database variables $sqlhost = &quot;localhost&quot;; $db_user = &quot;username&quot;; $db_password = &quot;password&quot;; $db_name = &quot;dbname&quot;; $table_name = &quot;tablename&quot;; //...
  14. lentildal

    help with while() loop to update database

    hi anikin i changed those things but it still says that the document contains no data.... any idea why that might be? give me all your lentils
  15. lentildal

    help with while() loop to update database

    hi anikin my stupid webserver has gone down now! damnit >:-< i think your script will work now, but i cant test it. as soon as my server is back online i will test it and post the results here. give me all your lentils
  16. lentildal

    help with while() loop to update database

    hmmm, now it says the document contains no data! this is what the first script looks like so far <table cellspacing='0' cellpadding='0'> <form method='POST' action='test4.php'> <? for ($a=0; $a < $num_rows; $a++) { $array=mysql_fetch_array($result); $add_num=$array['bbml_email']; ?> <tr>...
  17. lentildal

    help with while() loop to update database

    hi anikin i made those changes. i get: Warning: Wrong datatype for first argument in call to in_array() in /**my URL**/test4.php on line 23 x12 - one for every entry in the table i suppose... should: $email_array=$HTTP_POST_VARS['echck']; be echck again or should i change that to eadd...
  18. lentildal

    help with while() loop to update database

    hi anikin i made that change, now the output looks like this: UPDATE SET bbml_email='test@test.com' WHERE bbml_id=11 test@test.com is the last entry in my table. it gives this result no matter which checkbox is checked. or even if more than one is checked. same with the number 11. i dont...
  19. lentildal

    help with while() loop to update database

    hi anikin, thanks for taking the time to look at my problem. i appreciate it. my table is like this: two columns. one called bbml_id (int auto increment primary key) and another called bbml_email (varchar unique) there are 12 entries in my table. i used your code, but im afraid it doesnt...
  20. lentildal

    help with while() loop to update database

    ok anikin, ive reworked the code a bit in the first script: // set connection variables $connection = @mysql_connect(&quot;$sqlhost&quot;, &quot;$db_user&quot;, &quot;$db_password&quot;) or die(&quot;Couldn't connect.&quot;); // connect and select database $db = @mysql_select_db ($db_name...

Part and Inventory Search

Back
Top