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'...
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="checkbox"...
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 == "POST" && $HTTP_POST_VARS) {
//set...
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
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...
hello
i have some URLs in my database like
<a href="mailto:test@test.com">test@test.com</a>
and
<a href="http://www.test.com" target="_blank">www.test.com</a>
i also have a timestamp(8) field like
20020101
i would like to display them in an html form, in...
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 = "SELECT * FROM $table_name ORDER BY commentid DESC";
$res =...
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 = "SELECT commentid, commentname, commentmail, commentsite...
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
hi, just for your reference, here are both scripts (everything included!)
first script:
<?php
// database variables
$sqlhost = "localhost";
$db_user = "username";
$db_password = "password";
$db_name = "dbname";
$table_name = "tablename";
//...
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
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>...
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...
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...
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...
ok anikin, ive reworked the code a bit in the first script:
// set connection variables
$connection = @mysql_connect("$sqlhost", "$db_user", "$db_password")
or die("Couldn't connect.");
// connect and select database
$db = @mysql_select_db ($db_name...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.