[SOLVED] Exam Results script. Please help me ..........

[ankur0101]

Now showing different error

 

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 '' at line 1

[Axeia]

Something is wrong with the query itself, echo it out and keep trying in PHPmyadmin or some other mysql frontend till it's fixed. Then fix it in your code.

[Mchl]

I am willing to bet, that $roll_number is empty.

[ankur0101]

No, its not empty, I have entered a record from backed

My database is not empty

[.josh]

well everything else in your query string is hardcoded, so that leaves your variable. Echo out your variable before the query.  Does it echo what it's supposed to?

[ankur0101]

well everything else in your query string is hardcoded, so that leaves your variable. Echo out your variable before the query.  Does it echo what it's supposed to?

 

Echo it out ... what does that mean ?

[Mchl]

Use echo to display its value.

[ankur0101]

Im damn confused .. can anybody solve this problem ?

What changes I have to do in my pages , please sir can you tell me with code ?

[trq]

As has been stated, you need to echo out your query and take a look at it to determine what is wrong with it.

[ankur0101]

Ok thanks

I will do so. I will also screen shots

[ankur0101]

Screen shot of database

 

 

Screen shot of index.php

 

 

Screen shot of Result Page

 

 

 

 

[Mchl]

The variable in your form is called 'roll_no_textbook' and in the script 'roll_no'. Decide on one.

[ankur0101]

the name and ID of textbox is roll_no_textbox

 

Name of table is roll_no

[ankur0101]

Is this code is working on your PC / Server ?

[Mchl]

Sorry... I got lost in your code...

 

But I guess I've found the issue

 

This is in your index.php

<form id="form1" name="form1" method="post" action="result.php">
        <div align="center">
          <label>Roll Number :
          <input type="text" name="roll_no_textbox" id="roll_no_textbox" />
          </label>
          <label>
          <input type="submit" name="button" id="button" value="search" />
          </label>
        </div>
      </form>

 

As you can see it uses method="post"

 

This is in your result.php

$roll_number = $_GET['roll_no_textbox'];

 

Ooops... it uses $_GET instead of $_POST

[ankur0101]

Now new error

 

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 '-table WHERE roll_no =' at line 1

[Mchl]

Well? You should be able to fix that one by yourself. It's pretty obvious.

[ankur0101]

Ohh, Im getting rid of these errors

I created new table "resulttable"

Put the all data of result-table

 

Now showing 1 more error

 

 

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 '' at line 1

 

When I click submit button, it opens result.php instead of reault.php?roll_no=1

[Mchl]

I created new table "resulttable"

Put the all data of result-table

 

Changing the query to use 'result_table' instead of 'result-table' would be enough...

 

Now showing 1 more error

 

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 '' at line 1

 

 

Which file? Which line?

 

When I click submit button, it opens result.php instead of reault.php?roll_no=1

 

That's how method="post" works.

[ankur0101]

HIP HIP HURREYYY .... :D :D :D :D :D

 

ITS NOW WORKING FINE  :D :D ;D

 

WHAT I LEARNED IS .>>>>>>>>

Always Keep in mind what I am writing

Make sure that both PHP and SQL syntax are correct

 

So what was the problem ?

 

I wrote incorrect SQL syntax, My database table name was "result-table"

 

I changed it to "resulttable"

 

Now its working , I am damn happy, thank you all friends ......

[hyper]

Ankur can you please share the working code? I need this badly.

[Maq]

Ankur can you please share the working code? I need this badly.

I'd suggest creating a new thread with your code and the specific issue you're experiencing.

[Obison]

am confuse here .were is the mysql table for this tutorial . i have been looking for a way to do this and am finding it difficult.i need assistance with this php script am new in php and this my project work assignment ,if you wish to help me you can contact me obilor4mummy@gmail.com

[GowthamPrabhu]

Hi friends,

 

I am trying to implement the same feauture of displaying results,

 

actually i want to display the details of the students.

 

i have database named as friends and table named as friendss

 

the table contains field names such as srollno - Roll No

sname- Name

rme- phone Nmber

mailme-  Maill Address

 

what I want is if i give their rollno in  a text box their details should be displayed. can anyone help me in this. 

 

Also i want to display their photo , the name of the photo is same as roll number and the photos are saved under images folder. 

 

please help me

 

contact address miles2gogowtham@gmail.com