http://www.php.net/manual/function.readdir.php
complete with example.
Miles
At 03:24 PM 01/11/2001 +0530, sarahana wrote:
>Hi,
>I seem to be having some problem with the general php list, so I'm sending
>this question here - please do not get annoyed :-)
>
>I want to read a directory and count
add DISTINCT to your query
select distinct specific_p, qty from database where specific_p = 68030 and
qty > 0
For you second requirement, get them all, and just use the first one ...
can't remember exact syntax but something like
select specific_p from database where specific_p like %6803
ling of passwords completed.
end of output --
I believe it should show, in addition to the record count..
"In the while" 5 times, interspersed with password values.
What is the dumb obvious thing I'm missing?
Regards - Miles Thompson
--
PHP Database Mai
Richard,
What can one say? Too late? Too long looking at it? Reading too quickly?
or in the immortal wordsof Charlie Brow " AUUGH!"
Thanks a million and love your signature.
Miles Thompson
At 03:30 PM 2/21/01 +, [EMAIL PROTECTED] wrote:
> while( $row = mysql_fetch_a
Matthew,
Aren't we all. There's code at www.zend.com which deals with user logins,
mailing form information, cookies, storing data etc. Have a look at
www.thickbook.com, also WeberDev, DevShed and www.phpbuilder.com
Sessions are pretty easy to use, and you may want to consider them rather
tha
unction might also be a general purpose execution tool
for MySQL commands.
Anyone tried anything similar? It's a really cool way to quickly update a
database from a, in this case, tab-delimited file.
Miles Thompson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [
Three things I see:
1. You seem to be assigning hard-coded values to u_mange_users, and "0" ,
as it is last, will always win. I think, I alsway have to mess with them a
bit. That's why checking your SQL is important.
2. You are embedding a semi-colon in SQL statements. That's not necessary.
3
Matthew,
Do you want to be told how, or want to read an interesting article on just
this, including PHP script to build your archives. It's one of the early
PHP tutorials -- try a search on "php movie database".
I adapted code from that for my own archive, although I run a shell script,
logg
goes, I will go have a look at the page.
Regards - Miles
At 10:28 PM 2/28/01 +, Matthew Cothier wrote:
>>From: [EMAIL PROTECTED] (Miles Thompson)
>>To: [EMAIL PROTECTED],[EMAIL PROTECTED]
>>Subject: Re: [PHP-DB] Selecting number of news items on frontpage
>>Date:
Check your Interbase documentation. Normally you create your view as part
of the database and then use it like a table, most database's allow
parameterized views, where, at run time you supply the needed variable.
I'd also think that as both results are passed back to $sth, the execution
of $
Kevin,
You generally get much better performance naming and storing your file in a
directory, keeping only the link in a text field in MySQL. (Or just about
any other database for that matter.)
Miles Thompson
At 06:27 PM 3/6/01 +, Kevin Connolly wrote:
>Hi,
>I have a MySQL databas
Reminder - page has to be reloaded before cookie becomes visible. (or
should I say is picked up by the browser.)
Use phpinfo() to double check.
Miles
At 07:51 PM 3/6/01 -0300, JJeffman wrote:
>I've never used but there is a php function "get_browser()" which might do
>the work.
>I think the be
the ISP's. Aren't
there any open source mail programs for NT?
I don't think this would be very fast, but Python has an SMTP module which
is very easy to use, but then you'd be invoking Python and calling a script
every time you wanted to send something. Not an opt
g
$filelist ,= $file; before the echo statement, also echo $filelist to see
how it builds. If it is doing what you want, then substitute it for $file
in your update statement.
REgards - Miles Thompson
At 10:26 AM 3/12/01 -0800, Gavin Tong wrote:
>Hi, I've been trying to get this script
I think so, but check the SS lang manual. It should be under the syntax for
SELECT, maybe it's called "TOP". Haven't worked with SS for a while.
MIles
At 02:24 PM 3/12/01 +, Fredrik Wahlberg wrote:
>Is there any equivalent to MySQL's "LIMIT x,y" in Microsoft SQL-Server?
>
>/Fredrik
>
>--
>PH
That was the PostgreSQL book. I think it's still there as HTML, but hey,
support the cause and buy his book.
Miles
At 11:15 AM 3/12/01 -0300, you wrote:
>Hi all,
>
>I am new at PHP and I realize that the pdf format of the PHP Book by Bruce
>Momjian at http://www.php.net has been removed from th
/password
and, just possibly
3. Provide the most elemental of scripts so you can do a bulk
load, thereby creating your tables.
For that maybe a $50 one-time charge. $50 per month, never!
Publish their name and shame them!!
<< RANT MODE OFF >>
Best regards - Mi
expect?
How much time, if you have any idea at all, does MySQL demand in regular
attention?
Regards - Miles Thompson
At 05:53 PM 3/12/01 -0800, Ron Brogden wrote:
>At 09:29 PM 3/12/2001 -0400, you wrote:
>>THE ROTTERS!! They don't have to do ANYTHING to support MySQL except:
>&g
ur table will
blow out to the right, something users don't like.
How do you plan to have users select the cars they want more
information about?
Only you can answer these, and maybe you have. In which case, good luck.
Miles Thompson
At 07:52 PM 3/22/01 -0800, olinux wrote:
>I would
P2.ID
I don't see how this handles the null values, but I hope it can get you
started. I'll cheerfully hand this on to persons more expert in SQL than
myself. HOw you display it, once you have the values fetched is another
exercise.
The book is worth getting. ISBN 1-55860-323-9
Regard
Richard comes through again --- in spades!!
Miles
At 09:35 AM 3/26/01 +0100, [EMAIL PROTECTED] wrote:
>You may want to check out my tutorial on recursively processing this
>sort of structure on the easysoft website:
>
>http://www.easysoft.com/tech/php/tut_002/main.phtml
>
>Hope this helps
>
>
If you are searching in the same field (column) in each table, and the key
field has the same name in all tables, build an array of table names and
loop through it, executing your update on each iteration.
Regards - Miles Thompson
PS From your description it sounds as if you have a database
rk for you.
Regards - Miles Thompson
At 06:11 AM 12/5/2003 -0700, Aleks Kalynovych wrote:
Good morning all,
I have a couple forms that generate a unique ID based on taking the highest
number in the ID column adding 1 to its value. The problem is that I don’t
save that number until the form is submitte
n the dB if you setup a new table and set a
column\
To auto increment, it starts a the number 1. Can this be set to a higher
number
Say 5454 ??
TIA
Aleks
-Original Message-
From: Miles Thompson [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 8:24 AM
To: [EMAIL PROTECTED]
Subjec
1. Is the function allowed by MySQL?
2. Can you execute the function before the query, assign what it returns to
a var, then place the var in your query?
Miles
At 04:43 PM 12/10/2003 +0100, antonio bernabei wrote:
Hi,
I need to make a join between two tables. And I can use the mysql_query
functi
s there any way you can pare it down?
MySQL will select those records really quickly, but then the HTML has to be
generated and the broser has to render the list. Try and rethink this if
you can.
Regards - Miles Thompson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscri
PHP is SERVER side, not browser side.
That's a Javascript question.
Miles
At 11:14 AM 1/30/2004 +0100, Roy G. Vervoort wrote:
Is it possible to retreive the font size or view size from the browser.
In the browser it is possible to change the screenview (make it larger or
smaller for people with a
At 03:42 PM 2/2/2004 +0100, DiZEM PGC wrote:
I try connecting to an existing mysql DB. The first time I directly called
mysql_connect with all required
params (Path/Database,User,Password) and established a connection without
problems.
Second time I have used a script that includes a self-written c
Did you refresh the page after setting the cookie?
mt
At 05:00 PM 2/9/2004 -0800, Omelin Morelos wrote:
I have already tried it , It's not working.
Thanks
-Mensaje original-
De: Chris Wright [mailto:[EMAIL PROTECTED]
Enviado el: Monday, February 09, 2004 5:09 PM
Para: Omelin Morelos; [EMA
At 08:59 PM 3/3/2004 +, Donovan Hutchinson wrote:
Hi,
I'm working on a simple bit of flash that should display some text passed
into it from PHP. I'm using the FlashVars as following (trimmed for brevity):
..
In flash, i've set up a dynamic text block called nametext, and added the
foll
a and grouping it?
More information is needed to answer your question properly.
Regards - Miles Thompson
At 11:16 AM 3/11/2004 -0800, Marcjon Louwersheimer wrote:
I have IIS 4.x and MySQL running on the same machine. So do queries use
up bandwidth? Does it matter if I have 20 queries per page? Will that
>$query = "INSERT INTO myTable VALUES ('".$myVar."');';
Check the commas?
Miles
At 05:50 PM 3/28/2004 +1200, Martin Ryan wrote:
Got a dumb-ass question for you all. I have got insert queries working with
mssql_query($query); except if any of the variables have two or more words.
For example:
$myVa
1. Don't cross-post!
2. Read the string functions in the php manual. You probably don't want to
remove all white space, just trim. Have a look at
http://ca3.php.net/manual/en/function.trim.php
3. You will find a function to do exactly what you want.
Regards - Miles Thompson
At 10:
Don't cross post -- you'll eventually annoy enough people that they'll stop
responding!
Here are some suggestions:
Are you closing braces properly? (Assume you must be, otherwise errors
would be thrown.
Have you echoed your $cat_id so you know if you are getting?
Use the in_array function to s
At 11:12 AM 6/1/2004, Gerard Samuel wrote:
A bit off topic, but lately I've been running into situations, where I have
to know about using cursors with databases, like sql server, ibm db2
Can anyone point me to online resources that explains (to a practical newbie)
"cursors"
Thanks
Gerard,
Thin
nswer them.
Regards - Miles Thompson
At 07:53 AM 6/30/2004, Tom Chubb wrote:
Please can someone let me know their opinion on the following:
I have written some code for submitting a top 20 music chart online.
I use the following to insert into mysql:
INSERT INTO chart (name, chartpos, artist, title, lab
s a site where you are distributing published materials
(.pdf's) you may take a good look at what Adobe calls, or used to call, Web
Merchant, bite the bullet on the licensing and royalty fees, and reconcile
yourself to a Windows / IIS solution.
Cheers - Miles Thompson
At 02:23 PM 7/15/2004, Tim V
1. echo your $sql to make certain it's as sound as you think.
2. i don't see execution of the query: mysql_query( $sql) - you'll have to
put the die() & error after this function.
Hth - mthompson
At 12:05 PM 8/5/2004, Vincent Jordan wrote:
I have inserted '$address2', correctly in the row however
en you're ready to ask questions, but this one you'll have dealt with by
then.
Regards - Miles Thompson
At 11:01 PM 8/6/2004, Ron Piggott wrote:
I have created a MySQL database. The table I am creating is a subscriptions
database. I want to be able to export all e-mail addresses stored in
hese are still in print; they are both v. good and
quite product-neutral references. Joe Celko also had a web site with a
collection of articles he'd written for various magazines, don't know if
it's still up..
Regards - Miles Thompson
At 08:46 PM 8/10/2004, Ross Honniball wrote:
Norma,
Generally speaking issuing locks on records across the internet is not a
good idea. Too many things can happen that could result in the record
never being unlocked.
Recognize the HTTP is stateless, that's one of its limitations, and work
around that.
Regards - Miles
At 11:30 AM 8/13/20
Torsten,
Elegant!
Miles
At 02:03 PM 8/13/2004, Torsten Roehr wrote:
"Norma Ramirez" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Thanks for answer Miles, I'm aware of what you wrote but have a little
hope
> to find some way, and Robby what I'm trying to do is avoid the user for
> u
:
and call it from your browser. If your configuration is correct you will
see pages of information on your setup and configuration.
If not, then it's back to the installation section of the fine manual.
Regards - Miles Thompson
PS Remember, PHP executes SERVER side, not client side. Don&#x
istMonthqty06 + StkhistMonthqty07 +
StkhistMonthqty08) as total
.
. rest of statement ...
.
and total > 0
Regards - Miles Thompson
At 10:10 PM 8/28/2004, Ross Honniball wrote:
SQL Statement:
select *,@xtotal := StkhistMonthqty06 + StkhistMonthqty07 +
StkhistMonthqty08 as total
from StkMast
he mailing functions which Manuel Lemos has
on his site.
HTH - Miles Thompson
At 10:18 AM 9/20/2004, nikos wrote:
Hello list
A client of mine sends thousands of mails as newsletters and wants as to
make an Interface to admin this list. Its easy to put this mail list in
a MySQL table and make the
Check the MySQL docs - I *think* subqueries are supported in the latest
version, but not triggers or stored procedures. But as I say, check.
Alternatives? PostgreSQL or Firebird.
HTH - Miles Thompson
At 11:07 AM 10/1/2004, Matthew Perry wrote:
Thank you very much for your help.
If I had to
Eric,
Your second approach is fine. It's denormalized, extensible, and can be
manipulated using tools you put in place.
You may want to consider "groups" as well, thus people belonging to a group
could view/edit pages, that has the potential to save a lot of
administrative scut work.
A table
Good suggestion Anna, that's what we do for AllNovaScotia.com, plus we add
this bit of .css
@media print { body { display: none; } }
Then viewer can't print the page. We do this because only certain
subscribers have printing privileges.
Regards - Miles Thompson
At 0
Use ODBC to use MySQL from either Access or VB (or any other language!)
MT
At 12:25 PM 12/17/2004, Perry, Matthew (Fire Marshal's Office) wrote:
Here is the problem:
I am currently using MySQL and PHP for this application but have realized
recently that the bulk of my work is setting up three form
fit it to a language: maybe all the processing could
be done in the SELECT statement, maybe some will have to be done after the
results are returned.
Regards - Miles Thompson
At 12:42 AM 12/22/2004, Balwant Singh wrote:
hi to all,
may somebody guide me on the following:
I want to retrieve data from
ne, work with it and adapt it to your needs.
However, why is your form's action parameter set to a string of hyphens?
Regards - Miles Thompson
At 09:25 AM 12/28/2004, amol patil wrote:
hallo,
i have changed file signup1.php with login1.php, in action fied of form
and saved .
but when i r
Any report writer that supports ODBC.
As far as I know, there are no open source report writers like CR. (Gawd,
I'd hope they'd be better; my relationship with CR is sort of love-hate.)
Love it when the job's done, hate having to touch a working report because
everything's binary & when it break
This is waaay off topic, but:
I hope you mean retired, who will presumably work for less.
Why would you want one who's not current?
Just wondering - Miles
At 09:47 AM 2/2/2005, ioannes wrote:
I'm looking for a programmer, preferably in London or UK, who has been
maybe out of work for a few years,
At 11:10 AM 2/2/2005, Martin Norland wrote:
Miles Thompson wrote:
This is waaay off topic, but:
I hope you mean retired, who will presumably work for less.
Why would you want one who's not current?
Just wondering - Miles
At 09:47 AM 2/2/2005, ioannes wrote:
I'm looking for a programmer,
New version of MySQL, old PHP? possible password encryption mis-match?
Check out:
http://dev.mysql.com/doc/mysql/en/old-client.html
Regards - Miles
At 06:33 AM 2/10/2005, Denis Gerasimov wrote:
Hello,
I am trying to connect to MySQL using
$mysqli = new mysqli("example.com", "user", "pass",
found this
faster and more reliable.
Regards - Miles Thompson
At 10:16 AM 1/24/2002 +0100, K wrote:
>Hello,
>
>I would like to create database with many pictures.
>I have problem with inserting pictures to table in MySQL. I created table
>where one of the name of column is "imag
dlist $wherecondition" ?
When we think about it a bit, if we are assigning a SQL statement to $sql,
we are passing a dynamic variable to mysql_query(), so why not create it
using variables?
Cheers - Miles Thompson
At 11:58 PM 1/24/2002 -0500, Michael K. Dolan Jr. wrote:
>Is it possible
$sql = "SELECT DISTINCT * FROM newforum WHERE id='$id' OR replyto='$id''";
BUT you do have an OR in your where condition.
Try it - Miles
On Sunday 27 January 2002 10:18 am, Jordy Driessen wrote:
> Hello,
>
> Is there a query which can eliminate double results? Because my query ($sql
> = "SELEC
Garry,
Could you please explain (define) in one sentence(paragraph) what end
result you want. It might be possible to handle it in one SQL statement.
Miles Thompson
At 09:54 AM 1/30/2002 +1100, Garry Optland wrote:
>On Wed, 30 Jan 2002, DL Neil wrote:
>
> >
> > Can I req
Check the manual for the mysql_fetch_array() function, it shows you how to
extract data from $result. You will use the while loop (as shown in the
manual's example) to fill your combo box / selct list /drop down menu,
whatever we're calling that creature today.
Miles
At 12:45 PM 1/30/2002 -06
Assume query looks OK when you echo it? You're not seeing a literal "$id",
are you?
Does an id exist for $id? Is it numeric or char?
Check mysql_affected_rows() - what does it return?
Miles Thompson
At 02:07 PM 1/31/2002 +, Alex Francis wrote:
>I have an empty field i
Read the MySQL documentation on DELETE. Multi-table deletes are a new
feature in 4.x; for the present it's one table at a time.
Cheers - Miles Thompson
At 02:44 PM 2/1/2002 -0800, Adv. Systems Design wrote:
>Maybe my example attempt is misguided but the idea is
>to look up the p
This just showed up, where was it stuck?
Essentially you do a SELECT into your target table, if the target key
exists, which you determine from row count, then you do an UPDATE,
otherwise an INSERT.
I don't know what else you have wrapped around this, in terms of control
structure, so here's
t the script times out? Who is going to keep track of
when it was run? What check value scheme will you have in place to make
certain none of this happens?
What you are planning to do is bad practice. Please reconsider.
Regards - Miles Thompson
At 01:51 PM 2/4/2002 -0800, Jennifer Downey wrote
ng part of it. The web is a strange
place, very unlike any other programming environment, with conditions which
trip up people who have been programming for years.
Regards - Miles Thompson
PS When updating a numerical field in MySQL, the general form of the
statement is like
Did you type this out or cut/paste? There was a comma missing between >>>
state"\"zip <<<. Should work when you add the comma.
Add a WHERE condition for the update, otherwise every row will be set to
these values.
Common practice is to use single quotes around the char variables, saves a
lot
Google search for php wiki, or save that step and go to
http://sourceforge.net/projects/phpwiki/
Miles Thompson
At 05:26 AM 2/6/2002 -0700, jas wrote:
>Is there anyone out there that has developed an application using php and
>mysql that allows clients etc to update and maintain the
Unless there has been a very recent development, MySQL doesn't support
transactions. Use PostgreSQL, DB, etc.
Miles Thompson
At 09:51 AM 2/9/2002 +0300, Hayan Al Mamoun wrote:
>Hi, How can I maintain MySQL transactions with PHP
>
>Best Regards
>Hayan
>
>
>--
>PH
oded passwords are there so that htdig
can be authenticated to index these pages.
Regards - Miles Thompson
At 03:22 AM 2/12/2002 -0700, jas wrote:
>I am wondering if there is a way to force users to come from a certain page.
>For an example I am using a login page which once authenticated allows
At a philosophical level, I don't think this should be done -- I don't want
people messing with my browser settings, because sure as shooting they will
not be restored when I leave the site.
What is so precious in the HTML that one can't view the source?
Miles
At 12:12 PM 2/14/2002 -0600, Ric
How are you fetching the data?
Do you have indexes on the key fields used in queries?
Are you doing the work in SQL or sorting /rearranging a lot of arrays?
There are many possibilities for slowness, but you have to tell us what
you're doing.
Regards - Miles Thompson
At 11:53 AM 2/15
Jas
color=\"33\">\n";
}
?>
The is in the loop. Place it outside & you'll be OK.
Miles Thompson
At 01:35 AM 2/15/2002 -0700, jas wrote:
>I am having a little problem formating data retrieved from a database into
>table cells... So far after connecting
George,
From the Access help file ...
"You must use English (United States) date formats in SQL statements in
Visual Basic. However, you can use international date formats in the query
design grid." Have you tried the date as 04032002 or 04/03/2002? (Neither
make much sense in association wit
Read the MySQL docs and find out!
MT
At 10:27 AM 4/24/2002 +0300, Marius Ursache wrote:
>hi
>
>how many columns can have a mysql table?
>
>tnx
>
>--
> Marius Ursache (3563 || 3494)
>
>\|/ \|/
>"@'/ ,. \`@"
>
Jennifer,
In the manual it's probably under the SELECT heading. (I've not checked,
but that's a godd spot to start looking for the bits that can amke up the
WHERE clause.)
Try removing the single quotes - you have one before >%shopsear< and
another following iname, as > iname'" <
Sorry this
And Maureen is right! We just so *used* to seeing equal signs in SELECT
statements.
Smacking fist on head Miles Thompson
At 02:23 PM 4/25/2002 +, Maureen wrote:
>The query should read as below, without the = after the LIKE:
>
>$query = "SELECT uid, id, image, iname,
Jennifer,
Check if there is a "set exact" setting for MySQL.
Using LIKE should find everything beginning with "Starr". You may also have
to convert search term and target values to one of lower or upper case in
the SELECT statement.
Miles
At 10:55 AM 4/25/2002 -0700, Jennifer Downey wrote:
>
Go to Julie Meloni's site at http://www.thickbook.com and have a look at
the tutorials, or any of the tutorials listed on the PHP home page, or at
DevShed, or PHPBuilder, or WebMonkey, or Zend. There are lots to choose from.
Miles Thompson
At 07:55 PM 5/4/2002 +0200, Antoine Panier wrote
. Use mysql_affected_rows() to determine the
number of rows which were inserted.
Finally, you aren't assigning the return value from mysql_query(), so if
you are testing a variable on line 24 it has nothing assigned to it.
HTH - Miles Thompson
At 02:44 PM 5/5/2002 +0800, erich wrote:
>when i
2002 +0100, labhras sammin wrote:
>thanks for your help
>I have tested that everything works, valid handles, returned method values,
>etc.
>Line 23 is the dbase_add_record line. Do you know of anywhere there may be
>an example
>thanks Labhras
>
>
>"Miles Thompson&qu
tions were not really reliable and were intended mostly to
extract info for export to another database. I could not be 100% wrong on
that, and I've not worked with the dbase functions in PHP.
After this reply, please keep this focused on the php-db list.
Regards - Miles Thompson
At 12:14 P
I think this changed this in the more recent version(s) of MySQL. Check the
MySQL docs which match your current version. Proceed from there, it's only
a query.
Miles Thompson
At 03:11 PM 7/9/2002 -0400, Steve Bradwell wrote:
>Hi,
>
>What is the best way to simulate the fo
Check manual for stripslashes (and addslashes)
Here's the URL: http://www.php.net/manual/en/function.stripslashes.php
Miles
At 12:10 PM 7/12/2002 -0400, Blaine D. Dinsmore wrote:
>I was wondering if anyone knew a good method for handling data pulled from a
>MySQL database to the browser as well as
one, "ORDER BY probid" if probid is your autoinc field.
Cheers - Miles Thompson
At 12:34 PM 7/12/2002 -0400, Blaine D. Dinsmore wrote:
>I'm using MySQL and I have noticed that my primary key which are
>autoincrementing numbers do not sort properly when pulling the resul
of random thoughts - Miles Thompson
At 08:40 AM 7/18/2002 -0400, [EMAIL PROTECTED] wrote:
>I break up the search words using a function and then build a query based
>on the search criteria. If it is multiple words, I use REGEXP for the
>search.( I use a mysql database). then when there ar
At 07:29 PM 7/18/2002 +0530, Dasmeet Singh wrote:
>Miles Thompson wrote:
>>What database is being used?
>>How is the target structured and are there indexes to use?
>>My concern with this approach, though I don't have a better one, is that
>>it will be deathly
e what they are.
Regards - Miles Thompson
At 06:37 PM 7/18/2002 -0700, Vincent wrote:
>Hi, I'm a newbie here. I don't know what went wrong.
>I've tried searching for solutions and can't find any.
>How come pg_connect() isn't defined? Should I include
>any header file
what do you really want to do?
Miles Thompson
At 08:07 AM 8/3/2002 +0100, Dave Carrera wrote:
>High all
>
>I cant seem to get this sql working.
>
>I am trying to pull everything from table 1 (t1) where t1.id is not
>equal to table 2 (t2) id
>
>I cant find examples anywhere.
George,
It is likely that your win32 system did not care about case. If you are
using a *nix host it is case sensitive, and its installation of MySQL, by
extension, is as well.
Try echo'ing the select statement to see what you have.
Miles
At 10:42 PM 8/14/2002 +0100, Georgie Casey wrote:
>fo
Generally better to load information about the image, including its
location, to the database. This is faster, keeps the database to a
manageable size, and avoids unpacking the the image, so to speak, every
time you want to use it.
Miles Thompson
At 12:13 PM 8/15/2002 -0500, Bo wrote
SELECT * FROM tickets_work
WHERE employee_id = '$tech_id' AND
start > '$start' AND
end < '$end'
ORDER BY start
Which will select everything from tickets_work for a given employee between
start and end. What is not working?
Miles Thompson
);
>
> while ( $row = mysql_fetch_array( $TICKET_WORK_INFO ) )
> {
> $ticket_id = $row["ticket_id"];
> $start = $row["start"];
> $end = $row["end"];
> $total_hours = $r
Gerard,
This is a shot in the dark, but does the web server (usually NOBODY, but
"crash" in this case? Ominous name!) have an account on the XP box and the
appropriate permissions to write to the MySQL database? That's where I'd
start, along with checking mysql_error().
Miles
At 04:18 PM 8/
p script has the correct database
>credentials, it should do what it needs to do. Well on my FreeBSD box
>that is. But Im not sure if additional configurations are in order for winXP.
>
>Any guidance would be appreciated...
>Thx
>
>
>Miles Thompson wrote:
>
>>G
Don't want to get too philosophical, but don't PIM/Contact Management
projects like TWIG have a feature like this?
Now, this is just off the top of my head, but rather than create a
timeslots table, wouldn't you have an event table, and a member_booked
table? The minimum fields in event would
-MySQL function that can be used right after a
>Query that explicitly tells MySQL to close such a connection so that
>columns of type: INT - auto_increment will *always* start from 1 if the
>table contains no records (table is empty)??
>
>Thanks a lot for your help. :-)
>
>---
Checl your MySQL docs and redefine the table if necessary:
table type of ISAM - autoincrement numbers get reused
table type of MyISAM - autoincrement numbers are not reused.
Many people prefer the latter and use the values as primary and foreign keys.
Miles Thompson
At 05:21 PM 8/27/2002
They are "single issue" tutorial, aredevloped progressively and quite
clear. A new user must read the section of the manual which deals with
variables. The way PHP creates variables automatically can be a bit
confusing to the newcomer.
Hope this helps - Miles Thompson
At 04:49 PM 9
to be started with the -i switch to be
accessible from the Internet. Check docs.
Hope this helps - Miles Thompson
PS For help on the list #2 suggestion is really important.
At 06:10 PM 9/9/2002 +0200, Tomator wrote:
>I've installed MySQL and PostgreSQL on my XP. I'd like to make an P
. I hope you aren't planning to use this as foreign
key, i.e. for referencing information in this table from another table.
Miles Thompson
At 08:29 AM 9/11/2002 -0400, Anthony wrote:
>I'm doing an insert and need to get the record number that is generated
>when the record
1 - 100 of 300 matches
Mail list logo
