thanks for the reply and advice airshow. I had thought of having the drop down menu's automated using a database but by the time i had got to the branch page, the unique content for each page would...

Hi all,

I'm creating different pages on a website for each branch in the country for a business. The way the user gets to their branch is through a dreamweaver generated jump menu.

My question...

bump

iv looked around quite a lot, most of them dont actually differenciate between new and default fonts. Maybe it would be good for somebody (me if i have the time to learn c+!) to design one. Id use...

hi all,

is there a program that lists all non-default fonts that have been manually installed on your computer?

Max

don't worry, iv found a solution - http://clicksms.co.uk/.

You make an account, buy a minimum of 100 texts (at about 10p each - buying in bulk gets price as low as 5p i think..) and then use a...

(I wasn't sure where to put this thread so move it if you need to! :])

I want to be able to send a text message to my mobile phone whenever I get an email through from my website (the sending of...

I like your design :) but take a look here

- http://www.lipsum.com/

easier than trying to make up random latin phrases for filling up space manually xD good luck.

perfect, thanks a lot :D

Heyy,

Thanks for the reply, your answer makes sense and seems very logical. I entered the following code in the phpmyadmin code tester:

SELECT * FROM images WHERE fbid IN (SELECT fbid FROM...

each photo is saved in the table images with FBID as the primary key.

Then ratings are saved in the ratings table and FBID refers to the photo the rating is about.

I want to only use photos...

or is it not possible?

Sure,


$sql="INSERT INTO bookings
(clientID, roomID, startdate, enddate, adults, children, roomtype, requirements)
VALUES
('$last_insert_client_id',
'NULL',
' ...

I think generally to store dates into the database its best to use a timestamp. A timestamp shows the number of seconds that have passed since January 1, 1970 00:00:00 GMT. You get the current...

Ahhh i know whats going wrong. This bit:


foreach($result_array as $key => $value)
{
echo '<tr><td>Start Date</td><td>'.$result_array['startdate'].'</td></tr>';
echo '<tr><td>End...

Thats really wierd..

Can you send the entire code to me?

try using this:


$result = mysql_query("SELECT * FROM bookings WHERE bookingID='".$_POST['bookingID']."'");


sometimes when you don't encapsulate the second part of the where condition in...

Ah okay I understand.

the only possible reason for this, is that in your database, you are searching for all records where the bookingID is 33. You must have 9 different records that fit this...

I dont think I can explain it easily.

I basically want to encapsulate this:


$get_photos = mysql_query('SELECT * FROM images');//get all photos
while($photos = mysql_fetch_array($get_photos)...

<?php

//do your query
$result = mysql_query("SELECT * FROM bookings WHERE bookingID='".$last_insert_booking_id."'");

//because your query uses a primary key, we only have one result and so...

What do you mean by:
2) It does bring back everything from the table

As for bringing it back in a table, use this:


<?php

//do your query
$result = mysql_query("SELECT * FROM bookings...

Iv editted the code. Use this instead:


<style>
<!--
body{
background-color:#FFFFFF
}
div#Navigation{
width:115px;

yeah sure. assuming you understand arrays, the foreach function cycles through each array segment and runs a specific piece of code for that segment. The segment's title is saved in the $key...

mysql_query("DELETE FROM user_notifications WHERE username='".$acc."' AND notification='".$note2."' ");




that should be fine. if its not, try checking your $acc and $note2 variables...

try this:

<?php

//do your query
$result = mysql_query("SELECT * FROM bookings WHERE bookingID='".$last_insert_booking_id."'");

//because your query uses a primary key, we only have one...

Hi all,

I need to do a query like this:

SELECT * FROM table1 WHERE ( SELECT COUNT(*) FROM table2 WHERE fbid = *current primaryKey*) > 150

How do I get the *current primaryKey* in order to do...

Thanks for all the replies, I can tell that in future ill be referring to all this info, so thanks :)

Iv gone with floatval(), it seems like the simplest and at the moment does exactly what I...

okay, so if I wanted to echo 10.000 as 10, I would have to just shave off the appended 0's?

How would I do this? Can anybody post a simple script to remove the appended 0's?

Max

I have tried decimal, but it always adds 0's onto the end of my number.

I want it to only add the exact number I enter in, so for example at the moment if i enter in 10, it changes it to 10.000...

Hi all,

I need to save a number to 3 decimal points, however I want 10.3 to be saved like this:

10.3

not this:

10.300

****************SOLVED****************

silly mistake, the column `rating` was a varchar, and so when sorting by rating, it treated 10 as being lower than 9. Iv changed it to integer and it works...

Hi,

Im having a wierd problem with my mysql query:

I have entries in my database with a rating (out of 10) and a timestamp, and I want to pull out the highest rated entry from the past 30 days....

Hi all,

I'm looking for a tutorial on how to make a dynamic flash photo gallery. I want it to do the following:


Automatically detect images in a folder without having to manually list them...

no luck with that post dickersonka :/

Also the problem with this is that google checkout will only accept the information through posted hidden fields with their specific parameters, and as far...

Hi all,

I know it sounds stupid (the title of this thread) but I am using php to write some hidden fields to a form and when the form is submitted some of the hidden fields are not being sent....

dont worry, iv figured it out. Do something like this:

explode the cart into an array.
foreach($cart as $pid)
{
if the pid is in the array, do nothing
else: use substr_count to get the QTY ...

Hi all,

I have a shopping basket feature on my website which saves the product's primary key in the session array called 'cart', each one seperated by a comma, so example: '123,456,789'.

Now in...

.. that will be farrrr to vague. iv looked a lot into this already and havnt got anywhere. anyway if anybody is in the same boat and is looking for some kind of server-side video to .fla converter...

anybody? :P

ahh fantastic, thanks for the script. I think I just dived in head first without trying to understand whats happening where first which is why my variables were so scrambled.

just incase anybody...