Search found 21 matches

by da9nlc
Thu Apr 17, 2003 8:57 am
Forum: JavaScript
Topic: error on page
Replies: 2
Views: 2241

error on page

I am having an error on page when I click on the link in blue. It is supposed to call up an email form. <A HREF=javascript:ContactMe('contact.htm')>Contact</a> Below is the script which I have place between the <head> tags on my page. <script LANGUAGE="JavaScript"><!-- Begin function ContactMe ( URL...
by da9nlc
Thu Apr 03, 2003 8:13 am
Forum: mySQL & php coding
Topic: displaying limited number of records in each page
Replies: 0
Views: 1057

Similar problem

Hi I see you didnt get a reply to your post Im getting the same. I have had the same problem getting the first set of results and when I click on next it just seems to restart the sequence and giving me error I have not filled in details, showing the variables arent being sent and just going to page...
by da9nlc
Wed Apr 02, 2003 9:55 am
Forum: PHP coding => General
Topic: "$_SERVER['PHP_SELF']."
Replies: 3
Views: 1418

No think $_POST['var']

I tried get rather than post but was not the problem. I have done phpinfo and all variables are being parsed. So I am becoming increasingly confused as to why I am unable to move from one set of rows to the next i.e. 1 to 10 and 10 to 20. I installed apache server with phpdev 4.2 on my system thinki...
by da9nlc
Wed Apr 02, 2003 5:34 am
Forum: PHP coding => General
Topic: "$_SERVER['PHP_SELF']."
Replies: 3
Views: 1418

I solved the php_self error

I soved the php_error I was receiving And yes I did echo ($_POST['var']; I did echo the query too a couple of times its used as part of title of result page. Below is the way <?php for ($i=1; $i <= $pages; $i++) // loop through each page and give link to it. { $ppage = $limit*($i - 1); if ($ppage ==...
by da9nlc
Tue Apr 01, 2003 1:19 pm
Forum: PHP coding => General
Topic: "$_SERVER['PHP_SELF']."
Replies: 3
Views: 1418

"$_SERVER['PHP_SELF']."

I found this next and previous script that produces the results the way I want. Problem is (infact with every example of script I have tried), the fact when I click on the links to show the next rows all that happens is the whole script re-runs through which is not what i want rather than just from ...
by da9nlc
Sun Mar 16, 2003 9:14 am
Forum: mySQL & php coding
Topic: nextprevious timeout
Replies: 8
Views: 2468

Re: All variables echoing

[quote="da9nlc"]Its ok I sorted it
by da9nlc
Sat Mar 15, 2003 6:16 am
Forum: mySQL & php coding
Topic: nextprevious timeout
Replies: 8
Views: 2468

Help Confussed

I have managed to find a number of page limit scripts in tutorals, but the one in next & previous timeout is the closest I have got to actually returning the results as I require. When queries I sent to the database that I know only require the single page all is fine. The problem is when queries ar...
by da9nlc
Wed Mar 12, 2003 2:42 am
Forum: mySQL & php coding
Topic: nextprevious timeout
Replies: 8
Views: 2468

Re: All variables echoing

[quote="da9nlc"]All variables are echoing and seem to be set ok. My only grievance at the moment is the fact that when I set the $pagelimit = 5 all the records I have in the database (4 at the moment) including images show fine on one page. The problem occurs again when I drop the $pagelim...
by da9nlc
Tue Mar 11, 2003 1:45 pm
Forum: mySQL & php coding
Topic: nextprevious timeout
Replies: 8
Views: 2468

All variables echoing

All variables are echoing and seem to be set ok. My only grievance at the moment is the fact that when I set the $pagelimit = 5 all the records I have in the database (4 at the moment) including images show fine on one page. The problem occurs again when I drop the $pagelimit back down to 3 I get on...
by da9nlc
Tue Mar 11, 2003 4:05 am
Forum: mySQL & php coding
Topic: nextprevious timeout
Replies: 8
Views: 2468

Getting result but...

Im getting a result now the problem being it appears I used a WHILE statement. I changed it to $row = @mysql_fetch_array($strSQL);// This seem to work. As I stated in earlier post the database includes image file this is all working fine getting number of records held in database which I have set to...
by da9nlc
Mon Mar 10, 2003 1:36 pm
Forum: mySQL & php coding
Topic: nextprevious timeout
Replies: 8
Views: 2468

nextprevious timeout

I have a query script setup which seems to giving a timeout problem causing a fatal error. The problem seems to be when it runs the second query part of the script which returns required data that I want limited results per page. $strSQL = mysql_query("SELECT * FROM tablename WHERE column_name LIKE ...
by da9nlc
Wed Mar 05, 2003 12:27 pm
Forum: mySQL & php coding
Topic: next & previous prob
Replies: 1
Views: 946

next & previous prob

I had set up the script just to SELECT * which was working perfectly showing all records including image file path to Image Folder. The problems started when I introduced the page LIMIT, next & Previous function below. Could someone have a look at it I have made notes the parts that are giving probl...
by da9nlc
Mon Mar 03, 2003 8:15 am
Forum: PHP coding => General
Topic: Looking for a function name
Replies: 2
Views: 1217

Thanx

Yes I checked mysql.com it was my query syntax where the problem. Being used to mainly access(sorry didnt mean to swear) I was busy trying to mess about with <> rather than thinking more literal. But I sorted the problem the other day and the query is producing the results as I want. Thanks
by da9nlc
Mon Mar 03, 2003 5:10 am
Forum: PHP General
Topic: looking for funtion name
Replies: 2
Views: 1268

Thanks wizard

I decided to concentrate on the query syntax that was the problem. It turned out it was more logical than I thought god bless BETWEEN and AND.

I have done the query and it is outputing the data the way I wanted.

Thanks :lol:
by da9nlc
Sun Mar 02, 2003 1:05 pm
Forum: PHP General
Topic: looking for funtion name
Replies: 2
Views: 1268

looking for funtion name

I've searched php.net for 'RECORDSET' (as I know it in asp) to no avail so I guess that it comes under another term. I have set $result = mysql_query(select * blah..) to search all and return rows as called by $searchterm. What I am wanting to do is to be able to search the result of the above query...
by da9nlc
Sun Mar 02, 2003 12:38 pm
Forum: PHP coding => General
Topic: Looking for a function name
Replies: 2
Views: 1217

Looking for a function name

I've searched php.net for 'RECORDSET' (as I know it in asp) to no avail so I guess that it comes under another term. I have set $result = mysql_query(select * blah..) to search all and return rows as called by $searchterm. What I am wanting to do is to be able to search the result of the above query...
by da9nlc
Thu Feb 27, 2003 9:55 am
Forum: PHP General
Topic: newbie echoing help
Replies: 5
Views: 2037

Re: So whats wrong with it

<? $d = $result["id"]; //declaring variables I got fom a tutorial in tutorial. In fact I kept getting an Undefined Variable Error in he echo part below before I put it in. { while ($row = mysql_fetch_array($result)); echo (htmlspecialchars(stripslashes($row["$id]))); } ?> // the echo section was ta...
by da9nlc
Thu Feb 27, 2003 9:03 am
Forum: PHP General
Topic: newbie echoing help
Replies: 5
Views: 2037

So whats wrong with it

<? $d = $result["id"]; //declaring variables I got fom a tutorial. In fact I kept getting an Undefined Variable Error in he echo part below before I put it in. { while ($row = mysql_fetch_array($result)); echo (htmlspecialchars(stripslashes($row["$id]))); } ?> // the echo section was taken from Sam'...
by da9nlc
Thu Feb 27, 2003 5:38 am
Forum: PHP General
Topic: newbie echoing help
Replies: 5
Views: 2037

newbie echoing help

The first part of my script is working fine searching database and retrieving data held within according to searchterm. The html part is working to showing the number of records I know are held in the database. I am using phpdev's program using windows 95 and my files are kept in the www file as adv...
by da9nlc
Mon Feb 24, 2003 3:24 pm
Forum: mySQL & php coding
Topic: Undefined Variables
Replies: 4
Views: 1569

Thank guys

Having read all your responses I have found useful and got through the rest of the script ok. Even the guy who thinks he's god or maybe doesnt I guess you were pushing me towards the include_once function thanks. At the same time as buying Sams php web development I bought their Developer Cookbook i...
by da9nlc
Mon Feb 24, 2003 12:34 am
Forum: mySQL & php coding
Topic: Undefined Variables
Replies: 4
Views: 1569

Undefined Variables

I have been following Sam's Php + Mysql web developement book. Having written out the script the way the book has them: trim($searchterm); if(!searchtype || !searchterm) When I ran the script I got the error undefined variables. Having sifted through various sites and tutorials I found one that show...