[RESOLVED] checkbox query

hazel999

can somebody tell me how to display every sentence with a checkbox beside it?
and do i need a row to form a sentence in the table? can i separate the words in displaying it from a column of the table and not necessary to form new row just to get a sentence??

etully

This way, the sentences will run together without starting a new row for each sentence:

<input type=checkbox name=sentence1 value=1>This is a sentence. <input type=checkbox name=sentence1 value=2>This is a sentence. <input type=checkbox name=sentence1 value=3>This is a sentence. <input type=checkbox name=sentence1 value=4>This is a sentence.

or with a table, each sentence gets its own row:

<table>
<tr>
<td><input type=checkbox name=sentence1 value=1></td>
<td>This is a sentence. </td>
</tr>
<tr>
<td><input type=checkbox name=sentence2 value=1></td>
<td>This is a sentence. </td>
</tr>
<tr>
<td><input type=checkbox name=sentence3 value=1></td>
<td>This is a sentence. </td>
</tr>
<tr>
<td><input type=checkbox name=sentence4 value=1></td>
<td>This is a sentence. </td>
</tr>
</table>

Houdini

Hey you put the sentence on the right, you should have put them on the left cause you just ought to. No, just kidding it is a good answer. All it is is HTML anyway. Knowing a little about form elements would help in cases like this. Now if people could learn about checkboxs and select statement.

hazel999

hey sorry, how do i put it in a way that it takes rows from database in php? and why is it that when i use the codes <tr><td> in php, it will overlap my template on the left?

kakki

maybe this:
( table:sentences consist of "id", and "text" )

$db_server = 'localhost'; // edit that to your db-ip
$db_name = 'aDB'; // edit that to your database
$db_user = 'root'; // edit that to your user
$db_passwort = 'mega';// edit that to your password
$db = @mysql_connect($db_server, $db_user, $db_passwort);
$db_select = @mysql_select_db($db_name);
$sql = "SELECT * FROM sentences";
$q = mysql_query( $sql );
while ( $line=mysql_fetch_array( $q ) )
{
echo '<input type="checkbox" name="sentence"'.$line[ 'id' ].'" value="1">'. $line[ 'text' ] .'<br />';
}

....
no idea, what youre writing about a template on the left side, but you can also use tables
and a bit of css to place the table anywhere you like

hazel999

Hi kakki
yes, i manage to display it by the way i want and the overlapping thingy, its solved because i did not include the table. Do you mind giving some example codes on checking multiple entries and deleting them? do i have to put it together with the delete button form?