MySQL

Importing data from database into html page

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Apr 2009

Posts: 2

Reputation: otooleb6 is an unknown quantity at this point

Solved Threads: 0

otooleb6

Offline

Newbie Poster

Importing data from database into html page

Apr 3rd, 2009

Hi everyone,

I am creating a student timetable. I have the table done in html and I now need to input the values in the database.

I was trying to use something along the lines of

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
if(DAY = 'Monday' && TIME = '9') {
    echo(subject);
}
if(day = 'Monday' && time = '9') {
    echo(subject);
}

i keep getting an error of undefined day and time. I also tried

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
if(sem1week1.DAY = 'Monday' && sem1week1.TIME = '9') {
    echo(subject);
}
if(sem1week1.day = 'Monday' && sem1week1.time = '9') {
    echo(subject);
}

I got the same error except it was undefined sem1week1.day

appreciate any help

Last edited by Ezzaral; Apr 3rd, 2009 at 3:01 pm. Reason: Added [code] [/code] tags. Please use them to format any code that you post.

•

Join Date: Nov 2007

Posts: 3,744

Reputation: nav33n is a jewel in the rough

Solved Threads: 330

nav33n

Offline

Senior Poster

Re: Importing data from database into html page

Apr 3rd, 2009

•

Originally Posted by otooleb6

Hi everyone,

I am creating a student timetable. I have the table done in html and I now need to input the values in the database.

I was trying to use something along the lines of

if(day = 'Monday' && time = '9') {
echo(subject);
}

i keep getting an error of undefined day and time. I also tried

if(sem1week1.day = 'Monday' && sem1week1.time = '9') {
echo(subject);
}

I got the same error except it was undefined sem1week1.day

appreciate any help

Please post your code and explain your problem in detail. Use [code] tags to wrap your code.