.. any help appreciated
(and as far as I can tell, I've done every step in all MySQL install guides
I could find ... atm I'm running on a restored version of the default mysql
DB with the % users set ... since the firewall locks out remote access, I
didn't think it's a big deal
A day early =) ... but happy new year to you too
Rene
Fate would have it, that on Tue, 30 Dec 2003 12:17:29 +0530,
<[EMAIL PROTECTED]> wrote:
>Hi PHP Coders,
>
>Wishing you all a very happy and prosperous 2004.
>
>Aynsoft
>
>www.aynsoft.com
Rene Brehmer
aka Metalb
Table name is history, and only have 3 fields:
histID, date, entry
I need it to pick the last record without knowing the date of it. Got
picking specific records down good, but be damned if I can figure this one
out...
TIA
Rene
Rene Brehmer
aka Metalbunny
http://metalbunny.net/
References, t
t;Select date, item from some_table ORDER BY date DESC LIMIT 1
>
>to get the latest dated item.
>
>-Micah
Rene Brehmer
aka Metalbunny
http://metalbunny.net/
References, tools, and other useful stuff...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ECTED] wrote:
>I have had similar problems before. I have just created your table in
>MySQL. Seems you can't have an AUTO_INCREMENT column that is UNSIGNED.
>Doesn't mention this in the manual though.
>
>Neil Morgan
Rene Brehmer
aka Metalbunny
http://metalbunny.net/
Refer
e able to list only those that have Thunderbird in the
type field...
also ... how do I do range searches ... like listing all speeds from 500 to
1000 or something like that ???
yeah, I seriously need some decent documentation for constructing SQL search
strings....
TIA
Rene
--
Ren
;
>and there are many others.
>by the way in the code you wrote you have:
>
>
>
>and then you use:
>
>$id=$_GET['id']; <--- if this is the same than $HTTP_GET_VARS['id'] this
>wont work
>
>
>Where does that mail function (is it a func
will that cause any protential problems, or should I go through the files
and put it in where missing
the thing is that it does a few includes criss-crossing a few files ... so
finding where to put the damn thing is not always possible, with SQL pulls
from 7 tables and such ...
Rene
--
Rene Br
y .= ' ORDER BY l1';
break;
case 'fsb':
$query .= ' ORDER BY fsb';
break;
case 'multi':
$query .= ' ORDER BY multi';
break;
case 'clock':
$query .= ' ORDER BY clock';
break;
case 'type':
$query .= ' ORDER BY type';
break;
case 'variant':
$query .= ' ORDER BY variant';
break;
case 'model':
$query .= ' ORDER BY model';
break;
case 'make':
default:
$query .= ' ORDER BY make';
break;
}
switch ($_GET['ad']) {
case 'd':
$query .= ' DESC';
break;
case 'a':
default:
$query .= ' ASC';
break;
}
}
The order part is of course not that relevant in this case, but I left it
in the snip for the variables set in the query part to make sense...
Question is simple: What do I change in the code to make it do partial
field matches, instead of complete ???
Hoping for help :) ... TIA
Rene
--
Rene Brehmer
aka Metalbunny
http://metalbunny.net/
References, tools, and other useful stuff...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
// actual post content
edit // tracking data of editings
not that it's really relevant in this case, but these 2 tables are through
the relations tied together with 8 other tables handling the forums and
perms and users and statistics and such ... that's the reason why I want to
keep
will always exist (unless MySQL makes a mistake and dumps a row without
being told to), because they're only run inside other queries that look for
the respective catID/forumID these uses, so they won't be called unless
that particular category/forum exists. So there shouldn't be a
ve it a. expand the entire branch under 'parent 1' leading to 'sub-child
2', but not expand any other branches in the root structure, AND, b. have
it not expand beyond showing the sub-folders of 'sub-child 2'
One thing at a time, of course, figure out a. first, then b. shouldn't be
all that difficult to handle (or what ?)...
Last tree structure I did was mostly logical, not visual ... and it was
done in VB long ago ... so it's not code that can be recycled...
TIA
Rene
--
Rene Brehmer
aka Metalbunny
~ If you don't like what I have to say ... don't read it ~
http://metalbunny.net/
References, tools, and other useful stuff...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
en it
will take about as long to convert that to something workable in PHP, as it
will figuring out how to do it in PHP
Rene
At 14:15 30-03-2004, you wrote:
Already been done:
http://www.destroydrop.com/javascripts/tree/
Mark
--
Rene Brehmer
aka Metalbunny
~ If you don't like what I
specific numrows - 1 ... :-/
I know this is a kludge to do it this way ... but it's what I need for now
... later I'll get to do it a more brilliant way...
TIA
Rene
--
Rene Brehmer
aka Metalbunny
~ If you don't like what I have to say ... don't read it ~
http://metalbunny.ne
can be inserted.
This is what i see.Data 362,692 Bytes
Index 5,120 Bytes
Overhead 22,568 Bytes
Effective 345,244 Bytes
Total 367,812 Bytes
Your help will be very much appreciated.
Thanks
Piet
--
Rene Brehmer
aka Metalbunny
~ If you don't like what I have to say ... d
the database ... and keep their subfolders attached ...
Sofar I'm a bit blank in regards to this especially because I'm doing
it to figure out how to do it, but don't really have anything specific I
want to use it for yet, that requires more than 2 level of folders...
Rene
e's not much in using that function properly ...
Rene
--
Rene Brehmer
aka Metalbunny
~ If you don't like what I have to say ... don't read it ~
http://metalbunny.net/
References, tools, and other useful stuff...
Check out the new Metalbunny forums @ http://forums.metalbunny
g the mail() command)."
... Is there a way to get the bounces to go to the reply to address?
I've never really cared to, but now that he mentions it ... It would be
nice.
<>< Ryan
--
Rene Brehmer
aka Metalbunny
~ If you don't like what I have to say ... don't read
ouldn't rewrite everything
everytime, but try to reuse as much of the code as entirely possible ... so
yes, code reuse is good, but if you don't understand the code you reuse,
you're not really benefitting much of it (other than ending in the same
category as script-kiddies)...
Rene
-name to database..
Each page contain information of certain user..
How to save page to HTML file with PHP...??
Nicholas Sk2
--
Rene Brehmer
aka Metalbunny
~ If you don't like what I have to say ... don't read it ~
http://metalbunny.net/
References, tools, and other useful stuff...
Ch
join so it will
include the posts even if it cannot find anything to join with in hf_users
and hf_user_stats ???
I know it looks like deleting levels will cause problems as well, but the
code for that has been made so deleting a level will move all users assigned
to that level to a differe
make those posts display as posted by a guest, and
>RB> because the displayname is stored with the post, it would not list as
>RB> Visitor/guest.
>
>RB> What I have problem with is figuring out whether this is a kludge or the
>RB> only way to do it. Or is there a better way
5'' at line 1
(Obviously I attempted to delete the thread with ID 85 here)
I'm dealing with MySQL 3.23.56-log and PHP 4.3.0 ...
Any ideas for optimizing this will be greatly appreciated, esp since I'm
not all that great with the more complex SQL syntax...
TIA
Rene
--
Rene Brehmer
04 10:23:52 -0400, John Holmes
<[EMAIL PROTECTED]> wrote:
> From: "CJ Koh" <[EMAIL PROTECTED]>
> > unsubscribe me
--
Rene Brehmer
aka Metalbunny
If your life was a dream, would you wake up from a nightmare, dripping of
sweat, hoping it was over? Or would you wake up hap
ot;) or die('Unable to get random record'.mysql_error());
$personID = mysql_result($personquery,0);
--
Rene Brehmer
aka Metalbunny
If your life was a dream, would you wake up from a nightmare, dripping of
sweat, hoping it was over? Or would you wake up happy and pleased, ready to
take on the da
wrote:
I tried a little research on the mysql list but didn't find what I was
looking for.What is the limit of a MySQL database? How many hundreds
of thousands of records can a database hold before it gets too
sluggish to work on a production server?
thanks,
--
Rene Brehmer
aka Metalbunny
If
his in
reverse since that's what I need for the visual part...
Using MySQL btw ...
TIA
Rene
--
Rene Brehmer
aka Metalbunny
If your life was a dream, would you wake up from a nightmare, dripping of
sweat, hoping it was over? Or would you wake up happy and pleased, ready to
take on the day wit
nly way to
see it would be to go through the database itself, and as a policy, I don't
allow anyone except me within 6 feet of the running system database.
Securing sensitive information goes beyond just having a fancy login
system, you'll need to control access to the system that store
the server to parse an SQL statement that's closer to table structure,
rather than the OR statements that has to be transformed first.
Sorry if I'm just a blind mouse that can't seem to find things in the MySQL
manual. It's not really my best friend...
TIA
Rene
--
Rene Breh
However, you'd need a join that makes sense for a multi-table delete. I
don't know if it will work with a union, I have never tried, maybe somone
else will chime in.
thanks a whole bunch ... can't believe how close I was ... and I couldn't
even find it in the manual :-/
and f
sure that
those records indeed are to be deleted. I prefer to mark the record as
deleted for a time before permanent deletion. That way its recoverable
should something really bad happen.
bastien
--
Rene Brehmer
aka Metalbunny
If your life was a dream, would you wake up from a nightmare, drippi
n advanced :).
Christmas is coming up, and my girl wants to know what to give me ... heh :P
Rene
--
Rene Brehmer
aka Metalbunny
If your life was a dream, would you wake up from a nightmare, dripping of
sweat, hoping it was over? Or would you wake up happy and pleased, ready to
take on th
Thanks ... the reviews for that one are pretty promising :p
Rene
At 04:37 04-11-2004, David Orlovich wrote:
I'd recommend Welling and Thomson PHP and MySQL Web Development. It's
nice and thick and a new (3rd) edition has just come out.
David.
--
Rene Brehmer
aka Metalbunny
If your
At 04:42 04-11-2004, Manuel Lemos wrote:
Hello,
On 11/04/2004 01:22 AM, -{ Rene Brehmer }- wrote:
Any recommendations for a book that goes into depth with the SQL language
and specifically MySQL's variant, and especially using that with PHP
I don't need a beginner's guide,
e let us know what you (or your girlfriend) end up buying since I'm
sure there are others that are facing the same decision.
Rich
--
Rene Brehmer
aka Metalbunny
If your life was a dream, would you wake up from a nightmare, dripping of
sweat, hoping it was over? Or would you wake up happy and
Hi gang
I'm in need of, if at all possible, cutting down the processing time for
sending messages to multiple recipients with my insite messenger. The
current version runs 1 query to get the names of all recipients, then 1
query per recipient, and then 1 query to deliver a copy to the sender.
Th
1. learn the basics of arrays
2. RTFM
At 12:27 11-11-2004, peppe wrote:
Hi ,
I have numbers in my array
0 0 0 1 1 1 1 1 1 1 1 0 0 0 0
or
0 0 0 0 0 0 1 1 1 1 0 0 0 0 0
or
1 1 1 0 0 0 0 0 0 0 0 0 0 0 0
how can I find the first 1 and the last is there a function for it
--
PHP Database Mailing List (
At 13:42 11-11-2004, Sebastian Mendel wrote:
// send Messages
$sql = '
INSERT INTO `hf_privmessages`
(`ownerID`,`fromID`,`toID`,`from_name`,`to_name`,`priority`,`date`,`subject`,`message`,`folder`)
SELECT `userID` AS `ownerID`,
' . (int) $userID . 'AS `fromID`,
yeah, I noticed that ... haven't had a chance to check for certain, but I
believe the server I have to work with is 3.23 ... and since my space is
rented, I don't have alot of say in upgrading ... although it might be
possible to get them to do it ... their PHPMyAdmin is really old too ... :-s
at, and it works exactly as intended, then I don't
think it's a problem with the \r\n header seperators...
Thanks to y'all ... now I just gotta figure out why Mercury doesn't process
the commands. ... commands sent by regular mail are processed ... so it
must be a problem wi
en't ever used MySQL before, or any other SQL for that matter, so got
0 experience in getting the system up and running with it...
TIA
Rene
--
Rene Brehmer
aka Metalbunny
http://metalbunny.net/
References, tools, and other useful stuff...
--
PHP Database Mailing List (http://www.php.net/)
T
es']."','".$_POST['totdef']."','".$_POST['totoff']."','".$_POST['ally']."','".$_POST['owner']."')";
mysql_query($query);
mysql_close();
}
the error messag
s
many times as one would like, which is not desirable.
If you don't know the game, I do realise that understanding what I talk
about may be a bit difficult. I apologize for that. But if anyone have
anymore questions to this project, I'll happily ask them. If it's about the
game,
also tried changing the row number to 0, but results in the same errors.
I can't find any decent reference on the web that shows how to do this -
field extraction - when there's only the single record. So I've been mixing
code from various places. And I don't even know if
Hi gang
My CPU database (http://metalbunny.net/computers/cpudb.php) - still a work
in progress - used to be in 1 table, but for several reasons I've decided
it's better to split the data into multiple related tables. Obviously this
means I have to rewrite the query tool for it, and that's where
... inline ... for ease:
At 23:53 31/03/2005, Juffermans, Jos wrote:
So far, I have found a few mistakes in your SQL:
$query .= " OR `variant` LIKE '%".$_GET['search']."%'";
Why do you have backtick-quotes around variant? Know that backticks are used
to call system commands. You also use th
Documented research indicate that on Thu, 16 Jun 2005 16:20:31 +0100 (BST),
babu wrote:
> Ya joseph u r right, i am thinking of the url to be generated to be send to
> the user.
> I followed u r steps but did not understand some points.
>
>>>2.) Store that string to the database somewhere
>
Documented research indicate that on Mon, 20 Jun 2005 12:47:56 +0100,
[EMAIL PROTECTED] wrote:
> The trick is your using the wrong ' instead you need ` ...
>
> go away from kl;->' and go to `->123 ;)
> The key above the (Tab) key, or the key next to the number 1 above the q.
I hope you realis
noying with those "failed mail delivery"
viruses ... It should help a bit if the server simply refused any post that
contains attachments, or routed it to /dev/null, whatever's simplest...
--
Rene Brehmer
aka Metalbunny
We have nothing to fear from free speech and free information
th mysql_errno() and mysql_error() which catches invalid queries.
I built my own sessions system, using the database and cookies. There's
always a session active, that's why this part of the code doesn't check
for it. I made it this way so I can run the login/logout script at
password_sha1='5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8')
This code is identical in functionality to the previous example,
except the query has no LIMIT - this is not required as it prevents
the possibility of coding error handling for multiple accounts
(perhaps unnecessary, excepting ve
51 matches
Mail list logo