bs0d |
Subject: "re: SQL
Question"
Posted: @ 10:19 pm on Mar 11 2007
|
|
|
 Member #: 1 Rank: Admin. - (1,505) Since: 02/06/05 Posts: 600 From: USA
|
What do you
mean by
if($user) ?
Maybe,
if(!empty($user
)) ? Also, on
your delete
query, I would
do it like
this:
Code:
$query =
mysql_query(&q
uot;DELETE FROM
`members` WHERE
`user_id` =
'".$user
."'&quo
t  ;
if(!$query) {
echo("use
r not
deleted."<
img
src=http://www.
allsyntax.com/f
orums/images/sm
ilies/wink.gif
border=0>;
} else {
echo("Use
r
deleted."<
img
src=http://www.
allsyntax.com/f
orums/images/sm
ilies/wink.gif
border=0>;
}
Also, to open
PHP, I havent
seen <script
language="
;php">
too much. You
can just use
<? or
<?php if
alot faster
than typing all
of that out.
Edited at 12:00:27 am on 03/12/07
|
Viewed: 13,209 Times | |  |
gravy |
Subject: "re: SQL
Question"
Posted: @ 12:38 am on Mar 12 2007
|
|
|
 Member #: 294 Rank: User - (63) Since: 03/07/07 Posts: 66 From: MN
|
bs0d
said...
<
i>
What do you
mean by
if($user) ?
Maybe,
if(!empty($user
)) ? Also, on
your delete
query, I would
do it like
this:
<BR><s
pan
style=font-size
:10px;><u
>Code:</u
></span&g
t;<BR><
;div
name="div
_box"
class="di
vCode">
;
$query =
mysql_query(&q
uot;DELETE FROM
`members` WHERE
`user_id` =
'".$user
."'&quo
t ;
if(!$query) {
echo("use
r not
deleted."<
img
src=http://www.
allsyntax.com/f
orums/images/sm
ilies/wink.gif
border=0>;
} else {
echo("Use
r
deleted."<
img
src=http://www.
allsyntax.com/f
orums/images/sm
ilies/wink.gif
border=0>;
}
Also, to open
PHP, I havent
seen <script
language="
;php">
too much. You
can just use
<? or
<?php if
alot faster
than typing all
of that out.
I went with a
whole different
method of
selecting the
user for
deletion, and I
am now close to
getting done.
It works now, I
dont know what
I did, must
have changed
something to
the right
whatever.
Yeah my editor
opens that
style of php
for beginning
and end. i
change it to
<? and ?>
if I remember
to
Photo Hosting
Scripts? It's
what I do.... |
Viewed: 13,205 Times | |  |
gravy |
Subject: "re: SQL
Question"
Posted: @ 12:41 am on Mar 12 2007
|
|
|
 Member #: 294 Rank: User - (63) Since: 03/07/07 Posts: 66 From: MN
|
basically what
I am doing is
making an admin
section for
your member
registration
script. so far
I have each
member's
username,
email, and ID
to show on the
page.
then you have
the option to
delete any
member with the
click of
link.
Photo Hosting
Scripts? It's
what I do.... |
Viewed: 13,203 Times | |  |
lingh0e |
Subject: "re: SQL
Question"
Posted: @ 5:34 am on Mar 13 2007
|
|
|
 Member #: 291 Rank: User - (29) Since: 03/03/07 Posts: 29 From: Ohio
|
I'd be
interested in
this mod, since
all the work I
have been doing
on my own site
has been with
the idea of
eventually
integrating it
into a fully
functional
administrative
panel...
Let me know how
you progress.
I'd be willing
to help you
work on it if
you like.
Feel free to
kick me if I
get annoying |
Viewed: 13,172 Times | |  |
gravy |
Subject: "re: SQL
Question"
Posted: @ 11:53 pm on Mar 13 2007
|
|
|
 Member #: 294 Rank: User - (63) Since: 03/07/07 Posts: 66 From: MN
|
lingh0e
said...
<
i>
I'd be
interested in
this mod, since
all the work I
have been doing
on my own site
has been with
the idea of
eventually
integrating it
into a fully
functional
administrative
panel...
Let me know how
you progress.
I'd be willing
to help you
work on it if
you like.
Hey man,
I have it now
so that I can
view and email,
and delete any
member, plus
view and delete
any comments,
and view and
delete any
photos that are
uploaded.
I can send you
the code or
part of it if
you want it.
Photo Hosting
Scripts? It's
what I do.... |
Viewed: 13,152 Times | |  |
bs0d |
Subject: "re: SQL
Question"
Posted: @ 1:36 am on Mar 14 2007
|
|
|
 Member #: 1 Rank: Admin. - (1,505) Since: 02/06/05 Posts: 600 From: USA
|
Hey, that view
and delete
uploaded
photo's is a
good idea...
Hrm...
|
Viewed: 13,149 Times | |  |
gravy |
Subject: "re: SQL
Question"
Posted: @ 1:55 am on Mar 14 2007
|
|
|
 Member #: 294 Rank: User - (63) Since: 03/07/07 Posts: 66 From: MN
|
LOL, yeah this
is the first
time I have
incorperated
these functions
into my photo
host script.
Seems like a
good idea to
have these
things
available to
the owner.
Photo Hosting
Scripts? It's
what I do.... |
Viewed: 13,145 Times | |  |
gravy |
Subject: "re: SQL
Question"
Posted: @ 4:42 pm on Mar 14 2007
|
|
|
 Member #: 294 Rank: User - (63) Since: 03/07/07 Posts: 66 From: MN
|
Edited at 04:43:46 pm on 03/14/07
Photo Hosting
Scripts? It's
what I do.... |
Viewed: 13,122 Times | |  |
gravy |
Subject: "re: SQL
Question"
Posted: @ 7:04 pm on Mar 14 2007
|
|
|
 Member #: 294 Rank: User - (63) Since: 03/07/07 Posts: 66 From: MN
|
Now I have
another
question.
How would be
the best way to
keep track of
member uploaded
images. So when
they log in
they can choose
to see the
photos they
have
uploaded?
I have tryed a
few different
ways but keep
coming up with
errors...
Anyone?
Photo Hosting
Scripts? It's
what I do.... |
Viewed: 13,115 Times | |  |
bs0d |
Subject: "re: SQL
Question"
Posted: @ 10:11 pm on Mar 14 2007
|
|
|
 Member #: 1 Rank: Admin. - (1,505) Since: 02/06/05 Posts: 600 From: USA
|
I think a
simple way of
doing it would
be to name the
images by
username+whatev
er. So display
all images
where the
beginning of
the image name
is equal to the
username
|
Viewed: 13,103 Times | |  |
Viewing Page: 1 of 1 |