Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by astrodestino

  1. astrodestino

    Session Variables doesnt work

    I get this error with session_start: Warning: session_start(): Cannot send session cookie - headers already sent by (output started at C:\Inetpub Apache\wwwroot\ad\cache\tpl_ca_classic.overall_header.php:7) in C:\Inetpub Apache\wwwroot\ad\test_cartanataltestproximainc.php on line 1 And values...
  2. astrodestino

    Session Variables doesnt work

    no, if I use session start I get errors everywhere and also it says in php.net that session_start doesnt need to be called everywhere. Is it is not called session_start will be called automatucally. :S
  3. astrodestino

    Session Variables doesnt work

    Yes I got it. I always used ASP now I was forced to migrate a web app to PHP. I got somre problems with this, I have this code: $_SESSION["test_session"] =1; But when I got to my sencond page whe session variable value is null... how can that be? Tnx!
  4. astrodestino

    Session Variables doesnt work

    Tnx but Im having probles: $_SESSION("totaltest_session")== "0"; $_SESSION("test_session")==1; $_SESSION("pregunta_session")==1; Error: Fatal error: Call to undefined function: () in C:\Inetpub Apache\wwwroot\ad\test_cartanataltestinc.php on line 13 Why is that? Tnx
  5. astrodestino

    Session Variables doesnt work

    Hi! I made a online test application where I need to work with session variables. I got this code session_start(); if (!session_is_registered("test_session")) { session_register("totaltest_session"); session_register("test_session"); session_register("pregunta_session")...
  6. astrodestino

    Query Error

    Hi! I got mys site which is running ok at my localhost. I upload it and when I want to access it will return: SELECT * FROM horoscopo where dia=09 and mes=12 and ano=2005 order by id asc limit 0,30 query failed. The database, username and password are ok cause if I change anyone os those I...
  7. astrodestino

    Problems with dates

    I did it! tnx for you help!
  8. astrodestino

    Problems with dates

    ITnx for the reply but I got two columns in the database, one with lowerdate(fecha1) and one with upperdate(fecha2) what I want to do is to select the recorset where the selected date value is greater than fecha1 and smaller than fecha2. Tnx
  9. astrodestino

    Problems with dates

    Hi! I'm migrating my site form mssql & asp to mysql & php and I'm having a problem with this sql sintax. What I do is select a value between 2 dates and show the results but I cannot figure how to do it in mysql. My mssql sintax is: $sqlstm="SELECT * FROM vidas_pasadas where...
  10. astrodestino

    Usung 70% of Micro :(

    Hi! tnx for the replies. The results of the query were: id int aday int amonth int ayear int sign nvarchar text ntext
  11. astrodestino

    Migrating form MSSQL to MySQL

    I did it strSQL="SELECT tblAuthor.Username, tblAuthor.Author_ID, tblThread.Author_ID,tblThread.Topic_ID, tblThread.Thread_ID, tblThread.Message_date from tblAuthor, tblThread left Outer Join tblTopic on tblTopic.Forum_ID = tblTopic.Forum_ID WHERE " & strDbTable & "Author.Author_ID = " &...
  12. astrodestino

    Migrating form MSSQL to MySQL

    But whi it takes too long to retreive data? I am working with my Localhost and the database is at my hosting provider and when I execute the site my site begins to download too much from the db before showing data. Is that normal when you work with a remote db? Tnx
  13. astrodestino

    Migrating form MSSQL to MySQL

    This is the original: SELECT top 1 tblAuthor.Username, tblAuthor.Author_ID, tblThread.Author_ID,tblThread.Topic_ID, tblThread.Thread_ID, tblThread.Message_date FROM tblAuthor, tblThread WHERE tblAuthor.Author_ID = tblThread.Author_ID AND tblThread.Topic_ID IN (SELECT top 1tblTopic.Topic_ID...
  14. astrodestino

    Migrating form MSSQL to MySQL

    Honestly I dont know. How can I translate the MSSQL sintax? This is a forum sintax and it should display forum title, number of threads, number of topics and las author name but I cant get the author name displayed, it will show the first user on the DB (the admin) Tnx!
  15. astrodestino

    Migrating form MSSQL to MySQL

    Hi! I am migrating from MSSQL to MySQL and I'm having trouble converting the SQL strings. I got thins: '' strSQL = "SELECT top 1" & strDbTable & "Author.Username, " & strDbTable & "Author.Author_ID, " & strDbTable & "Thread.Topic_ID, " & strDbTable & "Thread.Thread_ID, " & strDbTable &...

Part and Inventory Search

Back
Top