Hello,
I have table with messages, and i have users table, the are linked via PK
UserID - UserID, what i need is to select Messages for current month and
calculate top 5 posters list for current month.
I have create following query but it's not complete:
SELECT Handle, Screen_Name from MBoard
Hello guys
I make following query:
mysql SELECT b.type, a.link AS parent_link, b.link AS child_link FROM
bookmarks AS a, bookmarks AS b WHERE a.id = b.parentid order by
parent_link;
and here is result
++-++
| type | parent_link | child_link
Hello,
Guys i try to join to tables
slides:
id
userid
file
moment
users
id
username
As there few slids per user and i want to get only last one, i use following
sql query, but it fetches me first slide. How can i make it fetch last one
please?
SELECT slides.file, slides.moment, users.id,
Mark wrote:
--- Daniel Harik [EMAIL PROTECTED] wrote:
Hello,
I have 2 tables users table, that stores user info, and photos
table,
i want to select all users with one photo form photos table,
but i don't
want it to be photos * users = result.
Is there way to do
Paul Burney wrote:
on 2/28/03 3:15 PM, Daniel Harik at [EMAIL PROTECTED] appended the
following bits to my mbox:
Thank You for your reply, but the problem is that users may have many
photos, and i need to get only one, i use folllowing sql:
SELECT users.username, photos.file FROM users
Hello,
I have 2 tables users table, that stores user info, and photos table,
i want to select all users with one photo form photos table, but i don't
want it to be photos * users = result.
Is there way to do it?
Assuming you mean, you have a table called user_info and another
Hello
Guys how can escape chars like ' and so that MySQL doesn't report me
errors all the time, for example when i try to add data like It's, i
always have errors
Thank You
--
Best regards,
Daniel mailto:[EMAIL PROTECTED]
--
PHP General Mailing List
Hello
Guys how can escape chars like ' and so that MySQL doesn't report me
errors all the time, for example when i try to add data like It's, i
always have errors
Thank You
--
Best regards,
Daniel
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
Hello guys,
at moment i'm reading Hack Proofing your web apps book, but it makes
me scared, i have seen a class from newbienetwork.net(can't find it
now), that validates
user input, things like telephone number, state, country , email, and
also can check if only letters or numbers are in text
Hello Chris,
Thursday, January 03, 2002, 10:41:34 AM, you wrote:
CL Ive seen em on zend.com, I wrote my own. I would recommend you take a look
CL at the ones on zend.com and modify it to taste.
CL --
CL Chris Lee
CL [EMAIL PROTECTED]
CL Daniel Harik [EMAIL PROTECTED] wrote in message
CL
Hello guys
I have following code, it splits 1 array into 2(to make 2 colomns
out of 1) and then displays it, but for some reason it only displayes
1 array not second
$i=0;
$this-query( select * from topics);
while($this-fetchRow()){
$array[$i] = $this-record[name];
$i++;
}
Hello guys,
sorry for spamming with questions today, i have varuable called
$intro, it's stores pretty big story, but i want to display say 10
first words.
Thank You very much
--
Best regards,
Daniel mailto:[EMAIL PROTECTED]
--
PHP General Mailing List
Hello Guys,
Just a stupid question how can i make php show from a-z with a for
loop, don't want to make 26 hard coded links
Thank You very much
--
Best regards,
Daniel mailto:[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe,
Hello Fred,
Tuesday, December 25, 2001, 7:55:16 PM, you wrote:
F for ($Character = 65; $Character 91; $Character++)
F {
F echo chr($Character);
F }
F Fred
F Daniel Harik [EMAIL PROTECTED] wrote in message
F [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello Guys,
Just a stupid
Hello
I have a class called Member, it has member function called
vallidateForm(), i try to pass it a $HTTP_POST_VARS array it looks like this:
clas Member{
var $HTTP_POST_VARS;
function vallidateForm ($HTTP_POST_VARS){
echo $HTTP_POST_VARS['frmUsername'];
}
}
$user = new Member;
Hello
I need to pass about 15 values to function, what would be best way of
doing it?
Thank you very much
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators,
I have following code
?
class Member{
function vallidateForm ($HTTP_POST_VARS){
echo $HTTP_POST_VARS['frmUsername'];
}
}
$user = new Member;
if($action==register){
$user-vallidateForm($HTTP_POST_VARS);
}else{
$user-displayForm();
}
Why i try to run it i get error
Parse error:
Hello
Thank you for your prevoius replies
I have 1 main php and 1 chil, i was wondreing how can i execute that
child php file from parent, i just don't know how to do it with eval()
function
Thank You very much
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
Yes i tried that, but problem, is that child file is 1 more class, if
i include it i get error:
Fatal error: Cannot redeclare class blocks in c:\program files\apache
group\apache\htdocs\cms\blocks.php on line 3
Thank You
Have a nice day
--
PHP General Mailing List (http://www.php.net/)
To
Hello
I'm making vbulletin foru hack, that allows to rate members
my code is just 50 lines, I set link to my script from vBulletin page,
and after it has been clicked code executes, and then i want to return
user to the page where he clicked the link leading to my code, i was
wondering how can
Hello Guys
I have following code, sorry it's pretty big for posting, i want to
split the output into 2 colomns, been trying almost all still can't
get it working
here the link, with this code online http://funzz.cjb.net/itfaq/kbase.php
--
?
include mainfile.php;
WoW, thank you very much DL Neil, this is the best reply i've ever got during my
time on the web (since 1994).
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators,
I't just came into my mind, if 1 simple split that arrey in to 2
arrays, it would be much simplier and wouldn't need second loop, i
just wanted to know how can i split 1 array in 2 arrays
Thank You
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
Good evening
I was wondering how can I split, array that has 60 elements in it,
into 2 arrays with 30 elements each?
Thank You very much and have a good night :-)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
Want to split it in half
1 Big array:
1
2
3
4
5
6
Want to make
1 Small array:
1
2
3
2 Small array:
4
5
6
Thank You
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list
Hello guys
function replace_text_smiley(){
global $comment;
// To add a relation between a text smiley a an image smiley do this:
// $faces[text smiley here] = img tag to image smile here;
$faces[:)] = IMG SRC=\emoticons/smile.gif\;
$faces[:P] = IMG SRC=\emoticons/tongue.gif\;
$faces[:D]
Hello guys
function replace_text_smiley(){
global $comment;
// To add a relation between a text smiley a an image smiley do this:
// $faces[text smiley here] = img tag to image smile here;
$faces[:)] = IMG SRC=\emoticons/smile.gif\;
$faces[:P] = IMG SRC=\emoticons/tongue.gif\;
$faces[:D]
Hello guys
Thank You very much for your previous replies, could u help me with 1
more thing?
You see i have huge(for me) 100 000 record access table, i wanted to
convert it to mysql, i thought of making php convertor that uses odbc
and mysql, but maybe there is faster way?
And other thought
I used Jeff's method
http://adsl20066.estpak.ee/emt here is it working live
Thank You Jeff so much
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
Guys getting more serious here now, 3 500 000 records, foxPro
i'll try Jeff's method
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
pane teda c:/php voi c:/windows
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Hello guys
I store date in my dbase in folliwing format 2001-08-27 22:24:07, how
can i convert this to timestamp and do manipulation
Thank You very muc
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
I've tried this code:
$timea = explode( ,$timepostsed);
$timea1 = explode(-,$timea[0]);
$timea2 = explode(:,$timea[1]);
$timestamp =
mktime($timea2[0],$timea2[1],$timea2[2],$timea1[1],$timea1[2],$timea1[0]);
But it return -1
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe,
33 matches
Mail list logo