[Alphabeticly Sort Results]

Hi, your question is bit vague here. Can you give me an example of what is that you are tyring to do here?

Cheers
Shiva!

[Checking for result of call to mssql_query()]

You dont have to explicitly check for true or false.

[code]$insert = sprintf("INSERT INTO Users (FirstName, LastName, Usrname,Passwrd, AccessLevel, last_login,UserID)
                        VALUES ('%s', '%s', '%s', '%s', '%d', '%s', '%d')",
                            $FirstName, $Surname, $uname, $passwd,$accesslevel, $regdate, $_SESSION['UID']);
$Reply = mssql_query($insert, $link);
if ($Reply)
{
    echo "Data Inserted";
}
else
{
  echo "Not Inserted";
}
[/code]

[PHP and MS-SQL Stored Procedures]

You can try something like this.....hoepfully should help you

[code]<?php


require_once 'Database.php';
$db = Database::connect('Database_Name');

$arg1 = 26;
$arg2= 1;
$myquery = "pSomeStoredProcedure ". $arg1.",".$arg2

$db->query($myquery);

?>
[/code]

[DATE, shoud be a quick question.]

Hi, If you are using MySQL refer DATE_FORMAT(date,format)  function.

[error in small code]

This is the output of the program


                        ****************************
                        ****************************
                        ******** L-G-H Team ********
                        ****************************
                        ****************************
                            the result is 6.285714
                                you got it :D

press any key to exit...

[Expert help needed!]

Hi, I did some testing and the search works fine without logging me out. Did you happen to fix the issue?

[error in small code]

Hummm very strange which compiler are you using. I tried using Visual Studio 6.0 and no errors.

[Query was empty help!!]

Hi Cohan,

Thanks for the posting. Whenever you feel you need help please make sure you can narrow down the issue to an extend. I dont think we can go thorugh the long code which you have posted. Let uu know exactly were you think the issue is.

Thanks

[Redirects based on URL variables...]

Hi,

You have to use the META tag for this

[code]<meta http-equiv="refresh" content="2;url=http://mypage/index2.php">[/code]

[error in small code]

The code is running perfectly fine provided you have closed all the printf statements.
Whats is the error you get?

[Error updating info to a database...]

Please refer to this link

[url=http://www.phpfreaks.com/forums/index.php/topic,2139.0.html]http://www.phpfreaks.com/forums/index.php/topic,2139.0.html[/url]

[PHP+IIS]

Hi, Why dont you try to use the windows installer which is simple and easy.

 

http://in.php.net/releases/index.php

[IIS Functions]

Can you be more clear on what you mean by IIS functions?

[change port of the IIS server]

1. Open IIS
2. Select Default WebSite Properties
3. Go to "Web Site" Tab
4. Change TCP Port to desired port number (default is 80)
5. Click on Apply
6. Stop-Start you IIS Server.

[forum]

Please refer to the link in my singnature.

[Help with database query]

Ho whave you stored the text file? Whats the data type you used?

[A SELECT using SUM and AVG that returns the wrong result]

Hi,

I guess your query needs to be like this. There needs to be some mapping between the two table (primary-foriegn) key relation.

[b]assignmentdata table values[/b]

[table][tr][td]3, 3, 'Sports (Action)', 10
2, 2, 'Portraits (1 straight, 1 environmental)', 10
1, 1, 'Photograph Something Meaningful', 10
[/table]

[b]grades table values[/b]

[table][tr][td]1, 1, 1, '9.0', 'Nice solution to a difficult...etc. etc.'
2, 1, 1, '8.0', 'Nice solution to a difficult...etc. etc.'[/table]



[CODE] SELECT SUM(a.maxgradepoints) AS maxgrade, AVG(g.earned) AS avgrade FROM assignmentdata a, grades g where a.id=g.id[/CODE]

[b]Output[/b]

[table][tr][td]20    8.50000[/table]

What I would suggest is to have your tables relations fixed. Go through the basics.

[connect to a remote sql server using odbc and php4 in iis]

Hi,

There are different ways of connecting to the system. Using ODBC is one way and please refer the manuals for functions related to ODBC. Let us know if you have toruble getting started.

[Changing DSN to DSN-Less]

Not sure if this will really help

Please refer this tutorial

[url=http://www.phpfreaks.com/tutorials/104/0.php]http://www.phpfreaks.com/tutorials/104/0.php[/url]

[Failing to insert binary(md5()) password]

What is the field type of "Passwrd" ? try using "binary" type if you havent.

[please help - Join query]

Hi,

Please make sure you use the code tags when you post anything. Its becomes very hard for us to go thorugh your posting.

[A SELECT using SUM and AVG that returns the wrong result]

What is the structure of your  "grades" table?

[PHP vulnerability]

Dont try it folks this is just another trick.

[assigning a user to a specific database]

You can set the privelage that the user will have on the database.

Refer manual to set the privelage.

 

You can also store the database that the user will be accesing along with the user name and password. You can retrive this information and make him access the database thats is specified.

[Need help with query involving dates]

First thing Please DOnt double post .....

 

Now to your question

 

You can use DATE_ADD function which is quiet handy

 

select DATE_ADD(\'2004-01-11\',INTERVAL 7 DAY) 

 

We know a week has 7 days

 

The above query will add 7 days to the given date

 

The result of the above query would be 2004-01-18

 

Now you have to save the result and add till the date difference is ZERO

SELECT (TO_DAYS(\'2004-04-17\')-TO_DAYS(\'2004-01-11\'))

 

This query will give the date difference which is 97

 

So you need to maintain a variable which would also subtract \"7\" from this total and also add to the date.

 

So when the result is ZERO it means that you have finished.

 

I hope I am clear