Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: benrob82
- Content: Threads
- Order by date
-
PHP MySQL insert
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... -
Advanced Pagination
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... -
MySQL PHP Left join help!!
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]'")... -
Left Join help!!
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]'")... -
toggle with table
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?- benrob82
- Thread
- Replies: 4
- Forum: Javascript
-
Passing sql query to another page
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... -
Javascript newbie question
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- benrob82
- Thread
- Replies: 5
- Forum: Javascript
-
How to split a search term
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. -
substr() question
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 -
Unknown reason for error
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'... -
todays date plus 6 months
Hi does anyone know how to get the result 6 months from today? thanks -
Auto email sent every 6 months
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... -
Email form to database
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... -
iframes
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...- benrob82
- Thread
- Replies: 2
- Forum: HTML, XHTML & CSS
-
Flash Project help
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...- benrob82
- Thread
- Replies: 0
- Forum: Adobe: Flash
-
PHP-MySQL Update problem
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 =... -
htaccess help (max execution time)
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...- benrob82
- Thread
- Replies: 5
- Forum: Linux (server)
-
PHP query string
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)... -
passing variables
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? -
Help with URL matching
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 =...
