Search found 14 matches

by sryuuza
Thu Aug 19, 2004 8:06 am
Forum: Miscellaneous
Topic: window.open() help!!!
Replies: 6
Views: 2341

window.open() help!!!

Here it goes... As most of you probably know, MS is coming out with SP2 for Windows XP.... most of the times i would careless, but this time i read the release file... and i was startled by this... "restricts two types of script-initiated windows that have been used by malicious persons to dece...
by sryuuza
Tue Aug 17, 2004 5:49 pm
Forum: PHP - Code
Topic: ORDER BY DATE with IF/ELSE
Replies: 3
Views: 904

I am using the DATE function of MySQL, and it works great....

but how do i make it MM-DD-YYYY instead of the default YYYY-DD-MM ??

would i put that in my php as a if else statement in the foreach?

##EDIT##
Opps, it is defualt YYYY-MM-DD
##EDIT##
by sryuuza
Tue Aug 17, 2004 5:21 am
Forum: Databases
Topic: call "ORDER BY" command from php
Replies: 22
Views: 22236

thank you, it ended up working great.... http://djmdevelopment.com/address2.php but then i changed the fields for numbers... and ran into a whole new problem... http://djmdevelopment.com/propertieslist.php i have made a new post regarding this issue here... http://www.devnetwork.net/forums/viewtopic...
by sryuuza
Tue Aug 17, 2004 5:12 am
Forum: PHP - Code
Topic: ORDER BY DATE with IF/ELSE
Replies: 3
Views: 904

ORDER BY DATE with IF/ELSE

I need to make it do that my part of my lists organize by date, and not by number, i also need the numbers to list correctly, instead of 1,10,5,50 I dont want to add a leading zero to those numbers, and sometimes they will even be like .5 and such... i believe i must make these declarations in the f...
by sryuuza
Mon Aug 16, 2004 6:45 pm
Forum: Databases
Topic: call "ORDER BY" command from php
Replies: 22
Views: 22236

everything is working great....

http://therandomjoe.com/DJM/idea4/address2.php

how do i specify certain fields that i want to show up, right now i just query the data base, and get all the fields... but i dont want to display the ID... how do i make it do i get everything but that field?
by sryuuza
Mon Aug 16, 2004 5:34 am
Forum: Databases
Topic: call "ORDER BY" command from php
Replies: 22
Views: 22236

so, i would just make up a recognized key of my choice...
like a variable...

and then where would i put that code, and how would i call it up?
by sryuuza
Mon Aug 16, 2004 5:11 am
Forum: Databases
Topic: call "ORDER BY" command from php
Replies: 22
Views: 22236

hmmm, i guess i dont understand how to make the variable work, so that it changes... would use of rand() help maybe? ##EDIT## //get field names $kv = rand(0,1); print "<tr>\n"; print " <th><a href='address2.php?id=$kv'>ID</a></th> <th><a href='address2.php?fname=0'>First Name</a></th>...
by sryuuza
Mon Aug 16, 2004 3:57 am
Forum: Databases
Topic: call "ORDER BY" command from php
Replies: 22
Views: 22236

WOW... the smallest things.... you are true guru :D now, just one more short question... lets say i want to add a "sort by email" option... do i just type... $recognized = array('lname'=>array('lastName',0,1),'fname'=>array('firstName',1,0),'email'=>array('email',2,0); or do i change somet...
by sryuuza
Mon Aug 16, 2004 3:47 am
Forum: Databases
Topic: call "ORDER BY" command from php
Replies: 22
Views: 22236

hmm... same issue.. except this time there is spaces... You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY lastName DESC' at line 1 i would suspect that the code should be printing... SELECT * FROM phoneList ORDER...
by sryuuza
Mon Aug 16, 2004 3:39 am
Forum: Databases
Topic: call "ORDER BY" command from php
Replies: 22
Views: 22236

well, that seemed to have moved this thing further... now i get an error instead of nothing.... You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY lastNameDESC' at line 1 that was when i went to this link.... http...
by sryuuza
Mon Aug 16, 2004 2:42 am
Forum: Databases
Topic: call "ORDER BY" command from php
Replies: 22
Views: 22236

like so?? //create a query $result = mysql_query("SELECT * FROM phoneList ORDER BY '$sql'", $conn); here is a much better example then what i linked first (downloadanime.com) http://animesuki.com/index.php?sortname=0 these people seem to be using the SAME code you are talking about.. i jus...
by sryuuza
Mon Aug 16, 2004 2:17 am
Forum: Databases
Topic: call "ORDER BY" command from php
Replies: 22
Views: 22236

i tried what he gave me and it didnt do a thing... no error... no change http://therandomjoe.com/DJM/idea4/address2.php <?php //make the database connection $conn = mysql_connect("localhost", "user", "pass"); mysql_select_db('db_name', $conn); //organize data $sql = 'SE...
by sryuuza
Mon Aug 16, 2004 1:56 am
Forum: Databases
Topic: call "ORDER BY" command from php
Replies: 22
Views: 22236

i know how to auto organize it.... but i want to be able to have the user select how to organize it, by clicking on the name of each column.

how would i go about making those column names links anyhow?
by sryuuza
Mon Aug 16, 2004 1:18 am
Forum: Databases
Topic: call "ORDER BY" command from php
Replies: 22
Views: 22236

call "ORDER BY" command from php

right now i am trying to build what http://downloadanime.org has, i want to make a list and be able to organize it by catagories... here is what i have so far.... http://therandomjoe.com/DJM/idea4/address.php i want to be able to organize by the names at the top "lastName", "email&quo...