[Submit Button]

Hi,

You could try this:
[code]
<form name="nameOfTheForm" action="phptest1.php" method="POST">
<input type="hidden" name="msg" value="This is the message and it would probably be too long to use GET"/>
<a href="javascript :document.nameOfTheForm.submit();">submit</a>
</form>
[/code]

(Remove the blank after 'javascript' and before ':')

[<textarea> Multi-line input onto a database?]

Hi,

I don't think your linebreaks have disappeared. They are in your contents but as the character '\n'. If you want to show your contents in HTML you have to use nl2br($contents)

[Paging help]

Hi,

On the way you lost the } from the while loop, that's the cause of showing just one video.

I think you don't want to declare a table for every video you dislplay. I rewrote a piece of your code:
[code]
...
$result = mysql_query($query) or die('Error, query failed'); ?>
<div align="center">

<table cellpadding="2" width="65%"  border="0" cellspacing="0" cellpadding="0">
<? while($row = mysql_fetch_array($result)) { ?>
<tr>

<td width="50%">

<a href="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?= $row['id'];?>"><IMG BORDER="0" img src="media/thumbs/<?=$row['thumbnail'];?>" height="80" width="80"><p>

</a></td>
<td width="50%">

<a href="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?= $row['id'];?>"><b><?php echo $row['title'];?></b></a><br>Added on <?=$row['date'];?>
<br>Plays: <?=$row['playcount'];?>

</td></tr>
<? } ?>
</table>
<?php

// how many rows we have in database
...
[/code]

[help with querying database]

Hi,

Is your time stored as a date or as a string?

If it's a string you hav a BFP. (The B stands for Big and the P for Problem)
But if it is stored as date or timestamp you can query on it. The where-statement should look like this:
[code]
WHERE time BETWEEN '2005-01-16' AND '2006-01-15'
[/code]

[Can't see whats wrong with my code]

Hi,

My first gues is to remove the { and } in your sqlstatement. I think they don't belong there.

The linenumber in the errormessage is the linenumber within you sqlstatement, not your php-code.

[Adding two values]

Hi,

You mean something like this?
[code]
$sql ="SELECT SUM(cost + costtwo) as 'cost' FROM results WHERE resultid = '$resultid'";
$sql = @mysql_query($total,$connection) or die(mysql_error());
[/code]

Yea, thats realy easy, isn't it?

[the right way to connect and close DB connections]

Hi n8w,

Do you have any reason to use mysql_db_query instead of mysql_query?

$cid = mysql_connect($host,$usr,$pwd); already creates a connection to your database, the mysql_db_query creates a new connection to your database and you won't use the connection you already made.
Read the reference: [a href=\"http://www.phpfreaks.com/phpmanual/page/function.mysql-db-query.html\" target=\"_blank\"]mysql_db_query[/a] and [a href=\"http://www.phpfreaks.com/phpmanual/page/function.mysql-query.html\" target=\"_blank\"]mysql_query[/a]

I never close a databaseconnection, it is closed on termination of the script. I think?

[Problem with a regex]

Hi Sykoi,

I think you try the wrong way. Why use regular expression?

Why not use unserialize?

I should do it this way:

[code]
$var = unserialize($ucashbank);
$amount = ceil($var['amount']);
[/code]

This wil return the result you disire.