PHP and Sybase variables

[Jeewizz]

Hi all,

I am trying to find out how to do this (which is how I do it though isql) through PHP:

declare @date smalldatetime
select @date = getdate()

Do you send it through as a query using sybase_query()? (I couldn't get this to work...)

Can you use Sybase variables through PHP? Or do I need to use PHP to do the calculations I need rather than Sybase?

Thanks!

[jeremuck]

it's not very clear what you are trying to do.
Can you explain it again?

Are you trying to select all records with a date from a sybase db?

[Jeewizz]

Hi,

the declare statement declares the variable named @date, and the select statement asigns a value to that variable.

So my @date varibale, after completing the select statement , will have the current date as given by the getdate() function.

What I'm trying to do is make the DB do the work with some date processing I'm doing, rather than PHP, as the result set is quite large.

Jen