webbhost

Thank you for your reply again Nock

After 30 days of dispair with this script - I finally got to the bottom of it - and it was the VERY first thing I thought it was and tried to sort out.

After sending one last support ticket to TSO last night in a bid to get the problem fixed before I left them and found another hosting company... one of their support guys changed a setting on the servers firewall - and low and behold.... it WORKS!.

Some times, you just have to keep going on and on and on until the right person hears your message and knows what to do. Crazy as it sounds this is a massive weight off my shoulders seeing that queue of e-mail start sending out!

Thanks for your help anyway - hopefully someone in the future will see this thread and not have to go through the ball ache I've been through to get it fixed.

I've asked support what they changed to make it work, so if they tell me I will post the response on here so someone else can point their tech support to the same thing.

Hi LucifersAngel
 
For future reference if you wish to send information like this using get...
 
Rather than this:

<form action="index.php?page=projects" name="filterform" method="get">
 
This will do exactly the same but in correct format:

<form action="index.php" name="filterform" method="get"> <input type="hidden" name="page" value="projects">
 
Writing variables inside the address of the action is not really practical and if you change your method for whatever reason, coding it in the way you have done will kick you back.
 
Using the extra hidden form variable means you can keep your GET method.

Okay, sounds like you're referring to what SQL query to run... The second one is easy...
 

SELECT * FROM `TableName` WHERE `Field` = 'flower'
^ selects all the entries with flower in the field you stated.
 
As for the above one, theres probably a direct SQL query to do this... probably the same as above but instead of = it would say !=
 
Not tried that method through so I'll give you a quick example

$query = "SELECT * FROM `TableName`"; $result = mysql_db_query($DBName, $query, $link); while ($row = mysql_fetch_array($result)){ if ($row['fieldname'] != "luxury gifts"){ echo "Display Row"; } }
 
Sound like what you are after?

I think nl2br() might be what you are after

oh ok, in that case, use something like

$result = preg_replace('/\r?\n/', '<br />', $subject);