Search results

I have some code below which outputs a HTML table. The values in each cell come from a database. I want to add a function to the view and delete cell (marked in red) so when everytime a user clicks on it, it will do a SQL command i.e. "Delete * From ".$Dis. How can i do this?? $temp = 1...

i tried that but no joy... i printed the SQL code out and found that a space has been added to the varible name (see code below) SELECT * FROM users_details WHERE user_id = (SELECT users_id FROM users_login WHERE Username = 'Richard ') Why has a space in the; 'Richard ') been added? ive...

when i print $z to the screen it showed the varible i wanted, but won't keep this value in the SQL query??

I have a problem is passing the values across in the SQL in the PHP code below. The $z variable will get a value from the session, the $z value will then be used in the SQL. However the value doesn't get passed across to the SQL code. <? $db_conn = new COM("ADODB.Connection"); $connstr =...

SQL Query Hey guys, I have the code below which inputs data in a database, however instead of inputted the values i want, it inputs the string: Is there someting wrong with $RowName? $ColName = "Col1,Col2,Col3"; $RowName = "'$line[0]','$line[1]','$line[2]'"; $data =...

I have some code(below) that the INSERT function wont work. The error message displayed is: "Fatal error</b>: Uncaught exception 'com_exception' with message 'Error [0x8002000e] Invalid number of parameters." <? if ($a == 1) { echo "<script type='text/javascript'> \n"; echo "var temp1; \n"...

thanks for ur help, looking back on it makes sence. A quick question for you, could i do the same but instead of putting the values into a MS access DB, could i put the values into a Multi-dimentional Array?

Hey i got the code to work, however when i insert the data into the Access database only the 01 and 02 value get inserted. any ideas? Also when i do get all the data in, the data in the Accesss table looks like this: 01 02 James Mike fred lane school lane Is...

ok thanks i try that out in min... What i have is a application that uploads a ".txt" file to my server. The application will then read the information and put the data in a HTML table. The .txt file contains data e.g. 01, Richard, fred, 22, 02, Matt, mike, 55 ........ The cells are separted...

Thanks for that :) the code works fine. Is there a way that i can use the code but instead of having the table in another html file, have the table in the same php file (the html table is made by using php tags)

PHP is fine thank you :)

Yes thats correct! Please note the values in the HTML table do change, so i want something like: "INSERT INTO temp_table1 ("Col1","Col2",".....") VALUES ("Cell 1","Cell 2","....") Where "Cell 1 & 2" is the values in the HTML table.

I have a html table that contains data and i want to insert the data into an Access data. Any ideas how to do this? Table1: 01, Rich, Mike, 23, fred lane, 02, James, milner, 45, School Lane, 03, Rob, Matthews, 89, College Road, I connect to the database using this code: $db_conn = new...

Hey there, Purpose: I want to design and build a basic system that detects human movement using magnetic sensors. These sensor will be attached to the human body. The problem that i have is that i dont understand how to build this system. I understand that you must have a magnetic...