Search found 120 matches

Actual Results

Post Posted: February 22nd, 2006, 4:02 am

:D Thanks for the extra idea, I'll try the preg_match() version now.


Post Posted: February 21st, 2006, 2:01 pm

Thanks, I'll go take a look at those and see what I come up with. Loads more questions probably! But it's all good learning experience...

Post Posted: February 21st, 2006, 7:25 am

Update: I've got this to work, but I need a little help refining this. I'm using PHP_SELF to pick up the page name which gives me:
Code: [ Select ]
Having the / infront of the filename was what I think was giving giving me problems, so my current solution is to have: [code] <?session_st...

Post Posted: February 21st, 2006, 5:31 am

I'm probably going to kick myself when I find out the answer to this! :D I have a filename saved in a session variable. I want to access this via PHP include function. I think the code will be something along the lines of: [code]<?session_start(); $page=$_SESSION['page']; include&...

Post Posted: February 17th, 2006, 11:09 am

:D Thanks for solving that for me, feeling much more confident now!

Post Posted: February 17th, 2006, 10:34 am

Thanks for quick reply and improved code! So, just to clear things in my head so i'll know this for next time, what is the difference between "content-type" and [content-type] when used in an expression this way? does "content-type" look for that phrase and [content-type] look fo...

Post Posted: February 17th, 2006, 8:33 am

I want the program to exit if the strings are found. The variables are coming from a text box on a form and I'm trying to make sure that headers can't be injected via the form, in terms of inserting bcc and cc to send out spam. This has happend to me already and I'm not going to let it happen again!...

Post Posted: February 17th, 2006, 2:37 am

I've been having a few issues this week with bad people messing about with my php form scripts. So, I'm adding more validation in to make things more secure. This is a portion of my script where I am trying to make sure that if content-type, bcc: or cc: are submitted in my text box, then my script w...

Post Posted: February 8th, 2006, 4:11 am

Thanks, that looks great. It's exactly the start that I need.



Post Posted: February 7th, 2006, 6:51 am

Yeh, that's the type of thing. The function of the list will be to identify products names. So for example, instead of the person filling in the form having to remember that product #67 is an apple, the drop down list will use the product id number to look up the product name and display that in the...

Post Posted: February 6th, 2006, 7:49 am

I'm trying to do a google search for some script/a tutorial which will help me create a drop down box on an HTML form. This drop-down will look up the values in a MySQL table then return the results to the form. I'm not sure I'm explaining it properly, I'm basically trying to achieve the same result...

Post Posted: November 11th, 2005, 2:49 am

PHP Freaks also have some good tutorials and examples of PHP/MYSQL

Post Posted: November 11th, 2005, 2:31 am

Before you jump in and learn mysql, i recommend you find out a bit about database design first. That way, when you come to mysql things will make a lot more sense! I just had a quick look on google for "relational database design tutorial" and came up with this:

Post Posted: November 3rd, 2005, 3:00 am

You need to save your file as a .php file for your code to work. If you save it as HTML, then your code will not be parsed.

Post Posted: November 3rd, 2005, 2:50 am

Thanks for your help. Looking at the bottom of the article, it was created in 1998! But it's good to know that it is supported now. I work for a college so that means that any web-based materials we produce have to be accessible as possible. So this will be a good feature to add to our forms I think.

Post Posted: November 2nd, 2005, 3:20 am

I was reading through a PHP text book which gave a basic form example to use as a basis for some scripts. In the example they gave, they added this <fieldset> tag into the script. I have been creating and using forms for a couple of years but have never used this before. I did a bit of researc...

Post Posted: July 5th, 2005, 7:33 am

yes, the nesting would take longer to load. As far as i can see, i agree that the nesting seems unnecessary. The only reason i can think to do it this way would be if you wanted to use cell spacing to create different border effects or if you wanted to mix percentage and pixel width to create a more...

Post Posted: July 5th, 2005, 2:19 am

am teaching myself and will be building a site for people 60 years plus so I will use tables to lay out the site (they are likely to have older browsers) with a css stylesheet. Have you done research into your exact audience? The reason I ask I am an IT tutor and I have done a lot of work with this...

Post Posted: April 14th, 2005, 4:12 am

Hi, I like this site. Nice and clean and easy to use. The pictures look professional without being to over powering. I do like the colour scheme, the bright green isn't usually a colour I would like on a site, but I think it works well to brighten up the grey and. The frequently asked questions page...

Post Posted: April 14th, 2005, 3:32 am

Hi, I'm very new to php myself so I'm maybe not the most reliable source of help, but i'll give it a go anyway! One part of the code which looks strange to me is $gt = @mysql_query($sql,$conn) or die("Could not execute SQL query"); I don't think you need the extra $conn (as you have already connecte...

Post Posted: March 10th, 2005, 9:51 am

I'm an idiot, extra' ='

This works:

Code: [ Select ]
SELECT datestart
FROM activity
WHERE datestart < Now( )
  1. SELECT datestart
  2. FROM activity
  3. WHERE datestart < Now( )

But is this the best way to do this?

Post Posted: March 10th, 2005, 9:16 am

I'm trying to write a MySQL Select query which will look for date entries which occurred on or before the current days date. I've tried
Code: [ Select ]
SELECT * FROM activity WHERE datestart='<=now()'
but it is not returning any results. Can anyone tell me where the query is going wrong and ...

Post Posted: January 28th, 2005, 2:20 am ... ag=nl.e589

Not a happy story!

Post Posted: January 21st, 2005, 8:05 am

I always add create my queries as a variable, then run the query on the next line. Makes the code easier to read, especially when you start getting complicated queries. So: [code]$query = "SELECT * FROM tableName"; $result = mysql_query($query) or die ("Couldn't execute qu...

Post Posted: January 18th, 2005, 4:27 am

Yup, that works.

Had a further look into the data in the tables and now everything is working the way it should be.

Thanks for your help, it is very much appreciated!

Post Posted: January 18th, 2005, 4:05 am

Ah! Stupid me! Thanks! Ok, so I have ammended my query to be: [code]SELECT courses.coursename, courses.duration, activity.datestart, activity.dateend, activity.status FROM courses INNER JOIN activity ON courses.courseid = activity.courseid WHERE activity.status = &quo...

Post Posted: January 18th, 2005, 3:18 am

I've been trying a few different variations (just because this seems so strange) and I've found that from the control panel,
Code: [ Select ]
SELECT * FROM `events`
works, but
Code: [ Select ]
SELECT * FROM events
doesn't work. However, when I try another table and use
Code: [ Select ]
SELECT * FROM courses
it ...

Post Posted: January 18th, 2005, 2:54 am

Hi, I'm using PHP myadmin 2.5.7-pl1 which i'm accessing through the control panel for my website. I am using the correct database, but when I tried the "SELECT * FROM events" I get the same #1146 error. I have noticed in the error text though that it is saying it that 'db.EVENTS' does not exist. Whe...

Post Posted: January 17th, 2005, 9:46 am

Have a look in Edit...preferences then into code format and code rewriting to see if there is anything set that shouldn't be.

Post Posted: January 17th, 2005, 9:37 am

Im using these two tables for my query: courses
Code: [ Select ]
courseid coursename duration descr
Code: [ Select ]
eventid courseid datestart dateend numberplaces status
I want the query to display coursename, duration, datestart, dateend and status where status=active. This is the query I've tri...
  • Sort by

© 1998-2016. Ozzu® is a registered trademark of Unmelted, LLC.