Title: RE: [PHP-DB] index.html or index.php
?
echo I am currently viewing . $_SERVER[REQUEST_URI];
?
REQUEST_URI and a simple string manipulation will help you.
___
Shaun Riches
Computer Science Student
-Original Message-
From: Ron Piggott (PHP) [mailto:[EMAIL
?
How is that?
___
Shaun Riches
Computer Science Student
http://www.sh4un.co.uk
-Original Message-
From: Ron Piggott (PHP) [mailto:[EMAIL PROTECTED]]
Sent: Fri 29/09/2006 16:21
To: PHP DB
Subject: [PHP-DB] Array
If I have the sentences
Check one two three four. You did
Title: RE: [PHP-DB] Search engine
What about the MySQL LIKE command? Research it.
This is assuming your data is stored properly without redundant data and in a MySQL database.
___
Shaun Riches
Computer Science Student
-Original Message-
From: Ron Piggott (PHP
Hi,
Is it possible to have a clause in a mysql SELECT statement? I would the
query to display the date except where it equals the default 000-00-00 to
display n/a or something similar.
For example SELECT DATE_FORMAT(B.Booking_End_Date, \%Y-%m-%d\) AS 'Booking
End Date' FROM Bookings (IF
It means there is a problem with your query,
if you send the query back to the group someone may be able to help.
Andy Amol [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I have posted my problem at No: 33892 of this mailing list. I have
received 1 reply. No: 33897
My exact
Hi,
Can anyone recommend some software that I can use to backup our MySQL
database on a webserver to a PC in the office on an hourly basis? I have
found SQLjob - related to SQLyog! - which appears to do a exactly what I am
looking for, however I have also come across a few posts about its poor
, for mysql you can
use:
WHERE (LEFT('Brick',3) = LEFT(Post Code,3))
If you are using other dbserver, check your manual.
- Original Message -
From: Shaun [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 16, 2004 10:45 PM
Subject: [PHP-DB] Brick Codes
Hi,
I
) = LEFT(`Post Code`,3))
^^ no quotes^^ back ticks (because of the
space in the column name)
HTH
Ignatius
_
- Original Message -
From: Ricardo Lopes [EMAIL PROTECTED]
To: Shaun [EMAIL PROTECTED]
Cc: PHP DB [EMAIL PROTECTED]
Sent
Hi,
I have a table of Locations around the country. My system produces reports
based on these Locations. I also have a table containing Brick Codes e.g.
BrickPost Code
AB51AB51
AB52AB52
AB55AB55
AB56AB56
AL01AL1
AL02AL2
AL03AL3
AL04AL4
How can I compare the
Hi,
How can I update a column where the first letter begins with 'M' and adjust
it so that column ends with 'M' instead. So something like 'UPDATE table SET
column = 'xxxM' WHERE column = 'Mxxx'. I hope this explains what I am trying
to achieve!
Thanks
--
PHP Database Mailing List
Hi,
I have (among others) two DATE columns in a table; Booking_Date and
Booking_Completion_Date. How can I run a query that updates
Booking_Completion_Date to be 2 days after Booking_Date where
Booking_Completion_Date is NULL?
Many thanks
--
PHP Database Mailing List (http://www.php.net/)
To
Hi,
Is it possible to have an incrementing row count in my query that is not
part of the table data?
i.e.
1 data data
2 data data
3 data data
...
This has to be done in the query not the PHP!!
Thanks for your help
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Hi,
I have a Bookings application. When a Booking is made it is entered in to
the Bookings table. Bookings take place at Areas, held in the Areas table.
Each Area has a unique Area_ID held in the Bookings table for each Booking.
Each Booking needs to be completed and when done so the
PROTECTED]
Mensaje citado por Shaun [EMAIL PROTECTED]:
Hi,
I have a Bookings application. When a Booking is made it is entered in
to
the Bookings table. Bookings take place at Areas, held in the Areas
table.
Each Area has a unique Area_ID held in the Bookings table for each
Booking.
Each
Hi,
I have an question on how to create a completely database / xml driven site
i.e. the page names, links, the site map etc are held in the database. I
think I have solved most problems but what I would really like to do is
limit the number of pages I need. Can I manipulate the server such that
Hi,
is there a PHP function that wil return the names of the columns for a given
table?
Thanks for your help
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
I need to retrieve the data and column names from a single row in a table,
i.e. 'SELECT * FROM Table WHERE Field_ID = 1'
How can I get PHP to show the data and the column names? With reference to
my earlier post and the replies I can't use DESCRIBE in conjunction with
SELECT and I don't want
Hi,
What is the maximum length for the name of a column in MySQL?
Thanks for your help
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Date and Booking_End_Date. These columns are both of type
DATETIME. The following query calculates how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours they
Hi,
I have a table called Bookings and a table called User. Bookings are created
and hold the User_ID of the User who created it (Booking.Booked_User) and
the User who will be going on the booking (Booking.Booking_Creator). How can
I create a report that lists both users on each row. If I do
-Original Message-
From: Shaun [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2003 11:24 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Selecting two names from a table
Hi,
I have a table called Bookings and a table called User. Bookings are
created and hold the User_ID
Hi,
I have two columns in my Bookings table of type DATETIME -
Booking_Start_Date and Boking_End_Date. How can i update every row so that
all of the times for Booking_Start_Date are 09.00 and all of the times for
Booking_End_Date are 17.30, without affecting any of the dates?
Thanks for your
Hi,
I am making some alterations to my Database. I have a table called projects
and a table called Work_Types. Projects currently contains the name of the
work type (Work_Type) but now I want to change this so it contains the
Work_Type_ID, is it possible to update Projects with one query?
Thanks
.
On Sat, 4 Oct 2003 13:45:56 +0100, Shaun spoke thusly about [PHP-DB]
Help With Another UPDATE Query Please!:
Hi,
I am making some alterations to my Database. I have a table called
projects
and a table called Work_Types. Projects currently contains the name of
the
work type (Work_Type) but now
David Robley [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Time and Booking_End_Time. These columns are both of type
DATETIME. Given
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Time and Booking_End_Time. These columns are both of type
DATETIME. Given any day how can I calculate how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours
Hi,
I have a query that returns a number from culculation in my table. It
returns say 4.00, 8.75, 0.00, 12.50 etc. How can I get MySQL to return the
number without any zeros, i.e. 4, 8.75, 0, 12.5 etc?
Thanks for your help
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Shaun [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Time and Booking_End_Time. These columns are both of type
DATETIME. Given any day how can I calculate how many hours are available
between
Shaun [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
David Robley [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
In article [EMAIL PROTECTED],
[EMAIL PROTECTED]
says...
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Time
Hi,
I have a table called Bookings which has two important columns;
Booking_Start_Time and Booking_End_Time. These columns are both of type
DATETIME. Given any day how can I calculate how many hours are available
between the hours of 09.00 and 17.30 so a user can see at a glance how many
hours
Hi,
I have two columns in my Bookings table of type DATETIME -
Booking_Start_Date and Boking_End_Date. How can i update every row so that
all of the times for Booking_Start_Date are 09.00 and all of the times for
Booking_End_Date are 17.30, without affecting any of the dates?
Thanks for your
Hi,
is it possible to create a query with parameters such that it selects a
field if it isn't null?
for example:
SELECT
A.Column1,
A.Column2,
(if not null, B.Column1)
FROM Table1 A, Table2 B
Thanks for your help
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
i'm sorry,
i rushed that previous post!!!
what i meant to ask was, if the value of B.Column1 is null then can the
query be written such that we dont select A.Column2.
Sorry!
Shaun [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
is it possible to create a query with parameters
Hi,
I have a column in my table called address. When users add an address with a
textarea they sometimes press return for a new line and this seems to be
putting line breaks into the database, so I have 2 questions:
1. How can I clean the table, so for example changing:
Ashfield Business
Hi,
I have (amogst others) three tables in my database named Bookings, User, and
Representative. A User and a Representative are different types of user,
however I now want to merge these tables into one - User. When a Booking is
made, the User_ID and the Rep_ID are stored in the Booking table. I
Hi,
I have a table in my database called Users. This table has (among others)
two columns called Location and Name. Location will be either 1, 2, 3, or 4.
How can I produce a query that groups the result into Location and then for
each Location order the User by Name?
Thanks for your help.
--
Hi,
Is it possible to combine the COUNT AVG functions using MySQL? I have a
table called Bookings and I need to find out the average number of bookings.
So I need to count the number of bookings in the table and then get the
Average, is this possible?
Thanks for your help
--
PHP Database
Hi,
Is it possible to change the way a query is displayed from a MySQL database.
For example if I have a column that contains '1' or '0' can I run a query
that returns 'Yes' for every '1' and 'No' for every '0'?
Thanks for your help
--
PHP Database Mailing List (http://www.php.net/)
To
Hi,
How can I SELECT a portion of a field in a table for example the first
character, or the second two characters etc?
Thanks for your help
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
In a small part of my database I have two tables as follows:
# -- MySQL dump --
#
# Table structure for table 'WMS_Data'
#
CREATE TABLE WMS_Data (
Data_ID int(11) DEFAULT '' NOT NULL auto_increment,
Booking_ID int(11) DEFAULT '0' NOT NULL ,
Data_Field_1 varchar(100) ,
tried pulling the data out as object, array row but always lose the
end.
Any help please!
Shaun
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
Is it possible to get MySQL to total the values of a select statement, say
'SELECT ColumnName FROM Table WHERE ColumnName = '1''
Say I have three values in ColumnName all of '1' then can I get MySQL to
return 3?
Thanks for your help
--
PHP Database Mailing List (http://www.php.net/)
To
this:
extraData:
PK extraData_ID
FK Booking_ID
Description Here you describe the data to be captured Ej.
Location
Data-And here the actual data Ej. Quebec
This way you can capture N records of extra data for the booking
Shaun [EMAIL PROTECTED] escribió en el
the data colleccted at each booking will be the fields set by an
administrator that he/she feels are appropriate to collect for that project.
Gustavo Del Castillo Meza [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
What kind of data do you need to collect at each booking?
Shaun
Hi,
I would be very interested to see an example of how it would be possible to
enter a query into a text area and the results of the query displayed on the
next page, similar to PHP admin I guess, are they any examples out there?
--
PHP Database Mailing List (http://www.php.net/)
To
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi Shaun
Comments inline ...
On 01 Apr,2003 at 13:37 shaun shaun wrote:
snip
Hi,
I would be very interested to see an example of how it would be possible
to
enter a query into a text area and the results of the query displayed
Hi,
I am creating a database for a web application. The idea for the application
is for a company administrator to be able to log into the site and allocate
staff to a project.
Staff will be able to log in and update the status of the project they are
working on and clients will be able to log
Hi,
Is it possible to catch the type of error message returned form a
mysql_query(); funtion
for example
if ($error == //duplicate row for table)
{
echo This row already exists in the table;
}
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Hi,
I would be very grateful if someone could look at my table design for me
please. The sytem will be used to
allow users to log in to a web site and book staff. Here is my design so
far.
# -- MySQL dump --
#
# Table structure for table 'WMS_Allocations'
#
CREATE TABLE
Hi,
I have the following table structure, as my installation of MySQL doesnt
support Foreign keys i have to maintain the referential integrity myself. So
if i delete a user, how can i make sure that the allocations from the
allocations table where the user_id is the same as the one being deleted
Hi,
I have the following tables in my database:
CREATE TABLE WMS_Allocations (
Allocation_ID int(11) DEFAULT '' NOT NULL auto_increment,
Project_ID int(11) DEFAULT '0' NOT NULL ,
User_ID int(11) DEFAULT '0' NOT NULL ,
PRIMARY KEY (Allocation_ID),
);
CREATE TABLE WMS_Projects (
Hi,
I have just found out that I can't use nested queries with MySQL so could
someone tell me how i can transform the following query for use with MySQL?
SELECT * FROM Allocations WHERE (SELECT Project_ID FROM Project WHERE
Project_Name = $_POST[project_name])
thanks for your help
--
PHP
a more prerferable way to do this would be to store a reference to each file
in the database, maybe renaming each file name to the 'files_id' of your
table...
Michiel Van Heusden [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
is there any possibility using PHP 4 to store entire files
Hi,
i would like to list all of the tables and field names in my database
e.g.
table 1
field 1
field 2
field 3
table 2
field 1
field 2
field 3
table 3
field 1
field 2
field 3
etc
is there a simple way to do this?
thanks for your help
--
PHP Database Mailing List
Hi,
I am creating a web site which will have different types of users:
Administrators, clients and staff. Is it possible/good practice to have 3
tables related to one table i.e.
USER
user_id (PK)
|
I would really appreciate some advice from anyone who has worked with or
developed their own content management system.
This is my scenario, when i have finished creating a site, i want to be able
to add in the CMS with a minimum amount of fuss. I want to be able to get
the CMS to recognize all
Hi,
I am creating a database for a web application. The idea for the application
is for a company administrator to be able to log into the site and allocate
staff to a project which will be a clinical trial at a particular practice.
Staff will be able to log in and update the status of the
Hi,
Please could someone tell me what the syntax is to add a column to a table?
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Is it possible to make a MySQL connection object global, so that it doesn't
need to be declared as a parameter to be accessed from individual functions?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Dear Entrepreneur:
Can you honestly say that you're earning the type of income you
thought you would when you first began your networking career?
Unfortunately, the history of networking says that there's a 95%
chance you are not earning what you would like to earn.
How many different
in the first table, then delete the row in the
second table, third table, etc. Then loop for the next intance. Theres got
to be a better way. Also, after this is done should I run some sort compact
or defrag on the database that restore wasted space?
Thanks,
Shaun
Rick Emery [EMAIL PROTECTED] wrote
Fiesta
does anybody know how to connect to a sybase database thats using the
adaptive server anywere driver???
i tried
$hostname = "host";
$username = "user";
$password = "pass";
$dbName = "database name";
$table = "table name";
Sybase_CONNECT($hostname, $username, $password) OR DIE(
62 matches
Mail list logo