ing a resource identifier to get the rows.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
Hutchins, Richard wrote:
Marc
vl n hs ss
Incidentally - I *think* in some of these he's actually answering
questions, but they must be fairly old, I archive every two months or so
and I don't see any matches in my current.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The
h a couple different levels and find a pretty happy
balance.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
[EMAIL PROTECTED]
er just emitting the whole of the file or some such.
I'd suggest using telnet and issuing your get statement right there
telnet yourserver 80
GET /
this should give you exactly what your server returns on such a request,
minus any customizations it has for the useragent. View source can li
d www problems. > Michelle, go back to your little
box.Little Box ?
That's what they call a linux (of some description) O/S machine, a box.
it's just OS - it's an abbreviation, not O/S like O/S 2.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, Int
, assuming things
work as promised (I've never used it myself).
If you need to work with pngs and the likes, imagecolorexactalpha /
imagecolorclosestalpha - requires GD 2.01 and PHP 4.0.6
(imagecolorallocatealpha requires PHP 4.3.2 though, oddly enough)
cheers,
--
- Martin Norland, Sys A
needed.
Of course, it's possible it's something else entirely - but something
should be logged when the pages bail out like that.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not nece
ackaged. Upgrade gd.
* funny, since gd stood for 'gif draw' originally.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospi
it was added. Your other options are to expressly state the tables
you want dumped
mysqldump [OPTIONS] database [tables]
the old fashioned way. You can get listings of the database through php
and just have an `ignore` array that skips them when building the dump
command.
cheer
cs are your friend :)
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
--
PHP Database Mailing List (http://www.ph
7; (13)
what do you get with:
mysql -u root -p -S/var/lib/mysql/mysql.sock
chances are you need to tell php where your mysql socket is (through
php.ini).
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do no
you can change to meet their final request (which always
differs from their initial) earlier rather than later. Bottom line is
this is probably a new request, but you may have to eat it depending on
your situation / relationship / contract.
cheers,
--
- Martin Norland, Sys Admin / Database
t install php4-mysql;
see how that goes. You might need to re-remove everything. When all is
said and done check your php.ini, in case it has remaining lines
pointing at wrong libs/etc.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinio
ects. Which
nobody asked for. The only solution is to use different names for the
javascript variables describing/referring to your form/other elements.
h8_ie_nothing = MM_findObj("nothing");
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outrea
isn't strictly a security issue, it is a
convenience that can cause unwanted/undue variable namespace pollution.
I'd recommend you disable it on your development machine ( in your
php.ini configuration file ) and then you'll have to set about changing
any variables that are coming
s the line number of the script as if it were a plain text
file.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
--
PHP Databas
o "line counted"(sic)?
no. (but the line with the include() call counts normally
3. are d parts of the file that are not in php (i mean that are not contained within the php delimeters) also counted?
yes.
in short, it's the line number of the script as if it were a plain text
file.
you'll have to set about changing
any variables that are coming from get/post - e.g.
if (isset($submit)) {
becomes
if (isset($_POST['submit'])) {
and the likes.
It's odd that your PHP 5 installation has this enabled - the default
changed to it being off in PHP 4.2.0, a
o try migrating down, and might be
better off looking for a new host or setting up php5 on your current
host (either you or them installing it, more likely you'll have to if
it's even allowed).
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3
doing now - depending on whether or
not the servers can always be on. Is it possible to have a delay on the
updating of information - to have a master server for the writes, and
local slave servers at each site for just reads - or are writes too
common a change?
Cheers,
--
- Martin Norla
Martin Norland wrote:
include() :P
seriously though, Page1.php and Page4.php are the only two pages that
should exist, if any. Page2 and Page3 should pretty much guaranteed be
turned into function calls or classes and called from Page4.php. You
don't need to separate logic and displ
turned into function calls or classes and called from Page4.php. You
don't need to separate logic and display in separate scripts that you
push everything at, just separate your logic out into function calls.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Ou
hem should in
fact be UPDATE statements. You'll want to fix that before your data
gets *too* sparse.
Once that's all fixed, go to step 5.
5) rewrite all the database accesses to prevent people from doing sql
injection attacks and ruining everything.
cheers,
--
- Martin No
iciently static, though in that case you could also
just alias it / etc.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Ho
idn't go through. This will
only increase load on your server and, depending on what the users are
doing (and how your backend is written) could throw someone or something
into a state of confusion.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3
sending
output before your scripts even start. Is there any kind of header,
wrapper, server-side include, or anything around the script - or perhaps
you're making use of output buffering and the server isn't allowing its use?
cheers,
--
- Martin Norland, Sys Admin / Database / Web Develo
ts it to be there still.
Could be wrong, it's happened before.
Incidentally, why does PHP need:
Professional Services Automation
Personal Security Advisor
Public Safety Announcement
Python Software Activity
Port Scan Attack
( 3 letter abbreviations
g what psa is, I have to run to a meeting but I may
try looking again later.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
--
then have two copies of
your entire data. If you need to pull your whole set of results out
into an array, you can immediately use pg_free_result() or
mysql_free_result() afterwards to free up the copy using memory in the
database.
cheers,
--
- Martin Norland, Sys Admin / Database / Web
est (if it's a concern) you might want to.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
--
PHP Database Ma
ob_* functions, remember though - you're just analyzing, don't
leave the html out unless you really want to!). - except it changes to
have you cater your output more to be predictable. Also, remember to
account for htmlentities if that's an issue, & => &, etc. Re
mel list_php wrote:
Thank you very much!
[snip]
I didn't get the tag though, what does that mean?
It was merely a cautionary warning about sites that force a base href
for relative URIs (including, of course, URLs)
See: http://www.w3.org/TR/html4/struct/links.html#h-12.4
cheers,
--
- M
ert a single row into the user_department_interactions table, if you
only ever want to store whether they interacted at all, you can set
constraints and catch the error on insert, or search before inserting.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
gt; "Jun", "07" => "Jul", "08" => "Aug", "09"
=> "Sep", "10" => "Oct", "11" => "Nov", "12" => "Dec");
... incidentally, Oct/Nov/Dec should ha
problem - like a bum cable, a bad hub, or a conflicting IP address. Try
using the system locally, off a web browser running on it, and see if
you still see the same issues (if possible). Try this after ruling out
the important stuff, as these issues are unlikely if you literally just
swapped a mac
ly screams
it's a buffering problem IMO.
http://www.php.net/odbc_longreadlen mentions truncation, but it's
talking about TEXT/BLOB and the likes, since you *can* get the full
results, I doubt this is meaningful.
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, Inte
Anthony Robins wrote:
When retrieving ODBC results from Sybase SQL Anywhere 6 and 9 from a
CALLed procedure, the output to the browser is being arbitrarily
truncated.
$DataSourcePassword = "pass";
$DataSourceName = "source";
$ODBCConnect =
odbc_connect($DataSourceName,$DataSourceUserID,$DataSou
Martin Norland wrote:
00 8-19/2 * * mon-fri /usr/bin/php /foo/backup_script.php
I should have mentioned this - this runs twice an hour Monday through
Friday, between the hours of 8am and 7pm. You would more likely prefer
05 1* * * your_command
which would run at 1:05am every day. use
from cron and pass it this script. (In
either case,
00 8-19/2 * * mon-fri /usr/bin/php /foo/backup_script.php
[if you aren't suppressing output properly, you can also do this]
00 8-19/2 * * mon-fri /usr/bin/php /foo/backup_script.php > /dev/null
[though it's better to suppress output p
ERE round1.game1='H' AND
round1.username=tipping.username AND tipping.username='jerry';
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Childre
s
prematurely]. Definitely try the fsockopen bit first, and give it a few
go's if it's not working.
I'll try the fsockopen "connection test" on the oracle port. Thanks for your
help.
Welcome to the list!
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, In
set_time_limit() to make sure it
doesn't run too long. Just be sure not to set_time_limit() for your
whole set of scripts, unless you really want them to abort after the 5
or 10 second limit you're setting ocilogon (unlikely).
cheers,
--
- Martin Norland, Sys Admin / Database / Web Devel
es I know it (the correct British spelling) is
still English - but it does open the wider concern.)
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Chil
y.
Elbonian spelling. (tribute/apologies to Scott Adams)
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
--
PHP Database Ma
sense, honest!)
Now back to your regularly scheduled international discussion...
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hosp
On a side note, who's sick of seeing the word optimizing misspelled in
the title? :)
Ah, the things we do to keep a thread clean.
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily repr
- any
standard sql engine will support the same features)
My statements were always related to using pagination in a general sense
- e.g. a class you create for pagination, that can paginate any manner
of query cleanly. If you're dealing solely with hard-coded /
hand-crafted queries, you can
than just
running the single query. But if you get to page 99, you'll likely find
this is faster. Feel free to do your own tests, many factors can change
all of these findings, and it's best to match them to suit your own
scenario.
cheers,
--
- Martin Norland, Sys Admin / Database /
avoid the migraine of trying to read unsplit code.
Cheers,
Martin Norland wrote:
Perry, Matthew (Fire Marshal's Office) wrote:
I guess my real question is how to parse the output from someone else's
site. Setting up the lookup procedure from data in my database and
filling
their form wit
fp, then move on to doing what you need - instead of
doing your database stuff right away.
*/
echo fgets($fp, 4096);
}
//close fp - we are done with it
fclose($fp);
}
Cheers,
--
- Martin Norland, Sys Admin / Datab
nt covered
address on file, people may mistype things - new buildings are created -
roads are renamed, etc.
Someone should contact maps.google.com and see about adding this sort of
information to that :)
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outr
no clue if that's the
'accepted' term for them. Makes sense to me, though.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Res
#x27;woopsie!';
to the top of your script and running it.
-
echo ${$VarName}['second'];
is what you want - you want to be very clear what order these things
need to be analyzed in, especially when dealing with arrays and the likes.
Cheers,
--
- Martin Norland, Sys Admin / Dat
Jochem Maas wrote:
Martin Norland wrote:
ioannes wrote:
My first attempt was to use $result=array_merge($result1,$result2) -
doesn't work. 'not a valid resource'
I have two databases with different connections, so MySQL UNION query
would not work.
How do I merge the result set
your
query to the database, the database does the query but doesn't return
the full result - instead it just returns a resource to the result, so
you can get it as you need it.
I suggest you start from that information and work forward.
cheers,
--
- Martin Norland, Sys Admin / Database / Web
It all depends on the
system requirements, your budget, and your time.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hosp
rint_r as a number not as a "select blah" - it's a
result resource, a pointer of sorts).
More likely is the query is invalid, go ahead and print_r() the
variable being passed to mysql_num_rows() on line 61 (put it before the
mysql_num_rows call) and see what info you get back in t
;
Without the exact code, I can only give you examples of about how it
should look - but that's the gist of it.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of
M student
-> GROUP BY student_name;
"""
The default separator is the comma. Just toss in a 'GROUP_CONCAT(year)
AS year' and appropriate 'GROUP BY' clause and have at it.
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
es up no space if a (new)
user hasn't completed any rounds (for example ;-)
[snip]
One should be indexing all their tables properly :P
All good valid points, well said.
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained w
- but rest assured, that's your problem.
now I'm sitting here wondering if ?* and ?+ are interchangeable, and
thinking so.
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily repres
pliated, and all of your queries would need the
chunk added.
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
--
PHP Database Ma
rt. Your interface won't get the testing it would
otherwise, but it will sure save a huge heap of hours, for someone at
least. If you get updates in digital form, you can always diff them and
just add the new bits. The error rate approaches zero much faster
without the human factor.
Cheers,
--
-
n of insert and select?
[snip]
Optionally, you could do it in multiple queries using a temporary table.
Yes it's not a single mysql query, but it doesn't have to pop out and
do any iteration in PHP, which does keep it cleaner and more organized.
Cheers,
--
- Martin Norland, Sys Admin /
ove to turn it on for a new project (though I might end up turning it
right back off!), but it's just not feasible with my existing projects.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necess
fpRead, "Purpose");
$end = strpos($fpRead, "", $start);
// make what we're doing clearer for the mailing list
// also helps in case offsets are a little strange.
$length = $end - $start;
$what_i_want = $substr($fpRead($start,$length));
cheers,
--
- Martin Norland, Sys Admin /
---
you'll want to couple this with some of the following:
; Log errors to specified file.
;error_log = filename
; Log errors to syslog (Event Log on NT, not valid in Windows 95).
error_log = syslog
/longwindedrant
Cheers,
--
- Martin Norland, Sys Admin / Database / We
ated ordering, they're manually ordered for some
reason? If it's not 'we want to manually order them' - In a products
database, I would think you could just have an "ORDER BY product_group,
product_name" or some such.
Cheers,
--
- Martin Norland, Sys Admin / Databas
Ron Piggott wrote:
Is there a way to find out the IP address of the computer submitting a
form --- other than through a cookie. Is there a header command or
something like this? Ron
Response:
rtfm / wrong list
Answer:
for Apache, $_SERVER['REMOTE_ADDR'];
Cheers,
--
- Martin Norland,
Craig Hoffman wrote:
Thanks for getting back to me... Comments below -
On Feb 28, 2005, at 10:49 AM, Martin Norland wrote:
Craig Hoffman wrote:
Hi There,
I'm trying to configure my OS X box to work with PEAR. Everything
seems to be working (updating PEAR libraries, etc.) except when I ru
ur own custom, or some
frameworks?). You may also try changing it to require_once, in case
something is already require'ing it.
The error is clearly stating that there's already a "class DB" defined.
It's defined somewhere.
Cheers,
--
- Martin Norland, Sys Admin /
connect using this MD5
hash of the password - anyone who could read that script could similarly
just connect using the MD5. Store your password in an included file
outside of the webroot.
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s
sible though.
This should get you pointed in the right direction if you aren't already
(note - sql is untested, and I always hose my GROUP BY's on the first
try - but it should be close :) )
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x325
her method of authentication.
Traditionally this is done with mailing a user a password reset link,
and having that link only available for a short period of time.
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within thi
your password in an included file
outside of the webroot.
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
--
PHP Dat
ou have,
if you really want to use their boolean, is leaving the boolean and
always selecting it as:
SELECT (boolean_field = 't') AS boolean_field FROM table;
of course, using a smallint will work 'universally' if you ever changed
databases - which may or may not be of interes
_POST['op']) || $_POST['op'] != 'ds')
I vote for the first one.
Bret
Your vote is misplaced - the first one isn't what he wanted... with that
statement, his form will never be printed and it can never be set.
Cheers,
--
- Martin Norland, Sys Admin / Database / We
<<
...
the rest of your stuff, then on its own line right at the beginning of
the line (no tabs/etc. :( )
...
EOF;
it basically echo's until it sees that delimiter, that could be EOD or
STOP or whatever (well, there might be reserved words issues - I could
more easily check if I could
te # bytes " type message in the error log. Check
that, and increase memory_limit in your php.ini if this is the case.
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
and the for($i= code above are both there to
accomplish the same thing, but $value stores the last seen value, so it
would have looked as if you were still inside the foreach's scope.
Stick with the foreach imo, since you don't need the counter. (you can
get it back by using your foreach,
sql server.
Apologies that this may not be very useful, but your problem is
extremely odd - if it's *not* a permissions / database error.
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not
ate');
header('Pragma: private'); // allow private caching
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // set to
be modified 'now'
session_cache_limiter("private, must-revalidate"); // allow private
caching, but
even create a class to store this information, if you wanted -
so long as you have the class include()'d before you unserialize the
object. In all likelihood, however, you'll prefer just the straight
$_SESSION.
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, Int
because sessions force no-cache, and (IE in particular) has real issues
with storing the output of a no-cache'd https - you can't save it
locally or open with an external application, because either way it has
to store it somewhere other than memory, which would be caching.
Cheers,
--
.app_id, b.resource_id, b.word, b.score FROM tablename AS a,
tablename AS b WHERE a.app_id != b.app_id AND a.word = b.word;
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those o
s
/ solutions / clarification when searching archives and the likes. It's
just polite :)
(this is part of why I try to always set the reply-to to the list)
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this
owser I've ever seen sends "C:\pics\subdir\pic1.jpg".
It will *display* that to the user, but it doesn't submit the local
path, it just uploads the file and gives the filename.
Cheers,
--
- Martin Norland, Database / Web Developer, International Outreach x3257
The opini
viding keywords, categories, folders or labels to
go along with the images for your users, instead of trying to match
their organization with yours.
Cheers,
--
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily
l you what the default for your
system is, but there are php functions to get configuration options, if
you don't have it in any obvious places.
Cheers,
--
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
probably can find better. Any sane packaged dropdown code
should be explicit about requiring the user to use onload to instantiate
things.
Cheers,
--
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily repres
sqli.default_socket to the same
as the mysql.default_socket. I can't tell you what the default for your
system is, but there are php functions to get configuration options, if
you don't have it in any obvious places.
Cheers,
--
- Martin Norland, Database / Web Developer, Internatio
e class.
Namely, $this->who_fricking_knows. (technically $this->null I suppose...
interesting question, don't feel like creating a dummy class just to
find out though).
$this->$mysql_link should have been $this->mysql_link
$this->$mysql_result should have been $this->mysql_result
e),id) from client where prim_id=1;
Cheers,
--
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
--
PHP Database Mailing List (http://www.php.net/)
To u
w years, was to find someone desperate - perhaps they've proposed
this project multiple times and nobody wants to touch it :)
I didn't know you could say off topic on this list... guess you just
can't say its abbreviated form in the subject or - ah heck, who knows.
Cheers,
--
-
itly allow only one
statement per call). Finally - the concept of bind variables (or
equivalent) are your friend (as Jochem already knows with firebird iirc).
Cheers,
--
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not neces
to
the group. suExec might also be of some worth.
I'm sure there are solutions other than running apache as user sybase.
Still - glad it's working for you at least!
Cheers,
--
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this em
the suggestion that he check whether he
should be passing more arguments to the function.
You make a good point - that is that the example code is there to make
sure things are working, and then to start changing it - get a good
baseline, and work from there. Sound advice - would that more heeded i
], and that wherever php might need to store the connection
record externally (if applicable) is writable?
Unfortunately - you may not be alone:
http://bugs.php.net/bug.php?id=30721
http://bugs.php.net/bug.php?id=17489
Cheers,
--
- Martin Norland, Database / Web Developer, Internat
o print just once, and have a counter that sets the
image to load (and if the counter goes beyond 3 - either have it not
display the image, or add more images :), or limit the query to only
return the latest three (add "limit 0, 3" to the query) )
Cheers,
--
- Martin Norland, Database /
a string in PHP?
If you're quoting these values, you should be having no problem.
e.g. INSERT into TABLE_FOO (colname) values ('-');
but this will error: INSERT into TABLE_FOO (colname) values (-);
Cheers,
--
- Martin Norland, Database / Web Developer, International Outreach x3257
1 - 100 of 116 matches
Mail list logo
