Mattyspatty

try not using num and '' it may work, else the autonumber isnt a primary key which can cause a problem

woohoo!! tyvm works now weldone both of u

thx thats an improvement, but i need it to search the whole table, i didnt use distinct but it didnt work anyway. can u see any way round my problem? the full thing is: i ahve a form and a textbox to find users, you can search m AND t and ive made it echo the query after i applied stuff to it and i get username LIKE '%m%' AND username LIKE '%t%' so i put that on the end of my main query, is this not working? cos i only get 1 result btw i like ur quotes on ur profile

"SELECT * FROM user_stats WHERE username LIKE '%m%' AND LIKE '%t%'"; i tried to make it search my DB for username were theyre like m and t (if u didnt undertsand it) basically i want things like matty bart timmy but with my old methods of doing the guery for each input (m and t) i wud get matty bart timmy matty timmy as it wud get m and t twice, so how can i make it work?!? cos the current script (see top) doesnt work at all :S whats wrong?

$query="SELECT * FROM `".$table_name."` ORDER BY id ASC|DESC";

what do u want the data in the hidden field to a variable? $_POST['hiddenfieldname'] or $_GET if u used get on ur form

*slap* name="Submit" on your mailing.php but on mailing1 and 2 u used $_POST['submit'] CAPITALS MATTER!!

i am sure DW has some sort of repeating table thingy, use it if u can find it if not youll have to get sum1 to rebuild it cos DW makes code difficult to edit in certain situations

so you want to setup a connections page? its in the tutorials sumwere, but dont put ur DName just put localhost

you cant get a variable $email, unless you assign $email to a value.

[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--] [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]echo[/span][span style=\"color:#DD0000\"]\"<input type=\'hidden\' name=\'myhidden\' value=$revdist_ID>\"[/span][span style=\"color:#007700\"];[/span][span style=\"color:#0000BB\"]?> [/span] [/span][!--PHP-Foot--][/div][!--PHP-EFoot--]

what you are saying should work if im not mistaken, i use similar methods but not with ->, give it a go

what exactly do u need? a script to send you e-mails or the full code for how to make the dropdowns and calculate and send the data etc.?

using that date format, sorting just months may be a lil tough..

what about a login system? that keeps the so called 'admin' set to be able to do commands with sessions or cookies defining u as 'admin'