From what I can see, the order that you created the table with and the
order of the fields in the query do not match up. Changing the query to:
$add_all = "INSERT INTO $table
values('','$name','$day','$question','$email','')";
Should make things run just fine.
Cheers,
Andy
Charalambos Nicolaou
Oops. I left a field in.
Change it to:
$add_all = "INSERT INTO $table
> values('','$name','$day','$question','$email')";
Andy
Andy Ladouceur wrote:
From what I can see, the order that you created the table with and the
order of
A regexp like this should work:
/^([a-zA-Z]|\s)+$/
Cheers,
Andy Ladouceur
Andy Amol wrote:
Hi,
I would like to test whether a given sting contains only character, it should also support spaces.
eg "Course Book String". I am able to test "CourseBookString".
Also I would
Dan Bowkley wrote:
else {
$query_insert = "INSERT INTO boards (wo_num, name, phone, email, date, board_type, last_three, weight_in, weight_out) VALUES (\'$wo_num\', \'$name\', \'$phone\', \'$email\', \'$date\', \'$board_type\', \'$last_three\', \'$weight_in\', \'$weight_out\')";
No need to esca
I think what you may be looking for is the DESCRIBE command. It allows
you to get information about table columns.
http://dev.mysql.com/doc/mysql/en/DESCRIBE.html
Andy
Andy Amol wrote:
hi,
I want to display the table coulumns along with those values below it. I am only able to display the tab
You can pass arrays via GET using the syntax:
http://localhost/index.php?val[1]=one&val[2]=2&...val[key]=value
Andy
Pete M wrote:
http://localhost/index.php?val_one=one&val2=2
on index.php
print_r($_GET) will show the array
echo "val l=".$_GET['val_one'];
echo "val 2=".$_GET['val2'];
its CAse s
Hey everyone,
Currently planning out the databases for a large project, and have
decided to use separate SQLite database files for each users hit
statistics. The problem is, there are two webservers, with a load
balancer. I'm wondering what suggestions people might have on accessing
the sqlite
Hi Jack,
The 'black box' you see is a newline, which can be removed by doing this:
$string=str_replace("\n","",$string);
$string=str_replace("\r","",$string);
That will replace \n (The newlines) and \r (The returns) with nothing,
getting rid of your problem. Hope this helps,
-Andy
Jack <[EMAIL PR