Search results for query: *

I've read a number of threads to try and solve this problem, I have a query string link the one below $insert = "insert into accounts values ('$accountid',NOW(),'','','','website','$company_name','','Student: Student/Graduate Member','','$turnover','$tel3','$home_address1...

Hi I have setup a nice little paging system to allow the page numbers to be displayed. The problem is I want to be able to show 10 pages at a time i.e. page 1.....10 then when page 2 is clicked it shows 2.....11 etc etc, does anyone know how to do this or is there a simple way I could add this...

Hi can anyone help me with this query $getcampaign = mysql_query("select * from prospect_list_campaigns"); while ($gotcampaign = mysql_fetch_row($getcampaign)) { $getprospect = mysql_query("select id,contact_id from prospect_lists_prospects where prospect_list_id = '$gotcampaign[2]'")...

Hi can anyone help me with this query $getcampaign = mysql_query("select * from prospect_list_campaigns"); while ($gotcampaign = mysql_fetch_row($getcampaign)) { $getprospect = mysql_query("select id,contact_id from prospect_lists_prospects where prospect_list_id = '$gotcampaign[2]'")...

Hi I'm trying to use the toggle function inside of a table but it will not allow me to do this any ideas why?

Hi I have created the following search script which works great. I need to be able to export the results of the search to a excel spreadsheet which I can do with normal pages but as this page brings up a lot of different results its not that straight forward. Does anyone know how I would pass...

Hi I want to be able to roll over a link but also display an image when the link is rolled over. does anyone know how to do this? thanks

Hi, I need to be able to split a search terms and then use it to query the database. If i enter one search term it works fine but I when two are enetered it doesnt work. Do I use explode() or preg_match() can someone please help.

hi I am trying to remove the last two digits from a postcode obviously this can be xxxx xxx or xxx xxx is the best way to remove the last two digits using substr() function and if so how do i do it to remove the last two digits? Thanks in advance

Hi I'm getting the following error from a PHP page which updates MySQL database You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mailto:student@codeworksconnect.net">student@codeworksconnect.net " where id'...

Hi does anyone know how to get the result 6 months from today? thanks

We have a membership system on our site and we want to be able to send an email out when the member is 6 months through their membership. I know how I would do this in ASP i.e. setting up the datediff function from the membership start date to todays date and then generate the email, but I...

Hi I might be having a really bad day but for some reason I cant work this out. I have a survey in an email and I want to pass the results of the survey to a PHP page which will then add these results to the mysql database. Does anyone have an idea of how to pass the results of the HTML survey...

Hi can someone help me. I have created a site with a number of iFrames to embed dynamic pages and often these pages link to other pages. The problem is that when the user clicks on a link in the frame and the subsequent page also needs to appear in the frame, it does not jump to the top of...

Hi all we are looking to emulate something like this but on a smaller scale http://www.chevyapprentice.com/apprentice.php?country=us and I was wondering if anyone knew of any tutorials that cover things like this. To break it down the abaility to drag and drop objects around a screen add then...

Hi can anyone see a problem with this. When I try to update the database it does not work have I missed something ? $finsql = "UPDATE gh_vacancies SET title = \"$title\", description = \"$description\", keyskills = \"$keyskills\", salary = \"$salary\", type = \"$type\", deadline =...

Hi can anyone help with this. I haven't used the htaccess file before. The script I am trying to run can take up to 15 mins to send out a batch email to around 1000 contacts and when I've contacted my server host to request that the max_execution_time be extended to around 15 mins they say it...

Hi can anyone help me, is there a better way to write this query, it seems very long winded to do what it needs to do $getcampaign = mysql_query("select id,prospect_list_id from prospect_list_campaigns where campaign_id = '$eventid'"); $gotcampaign = mysql_fetch_row($getcampaign)...

Hi is it possible to pass a variable to the top of the from the bottom i.e. a count result located in a while loop at the bottom to an if statement at the top?

Hi i'm trying to match these to URL's and if they match they need to direct the user to the login page <?php extract($_COOKIE); #echo "databaseuser = $databaseuser <BR>"; #echo $_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']; $uri = $_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']; $myurl1 =...