[gielvandam]

Hello,
Now I did allready search for days.
I cann't find the mistake.
The form works.
The echo is correct
But the select ... where is wrong.
The result says "Could not successfully run query "
Look at Peter's Mobiele Sites Vieuw responceswhere I test this simple select procedure.

The whole code:

<?php
/*
Template Name: students-vieuw-responces
*/
?>

<?php get_header(); ?>

<?php if (have_posts()) : the_post(); update_post_caches($posts); ?>

<div class="post" id="post-<?php the_ID(); ?>">
<h2><?php the_title(); ?></h2>

<?php
/*
Vanaf hier de kode om iets op te halen uit de database
*/
?>

<div id="questionForm">
<!-- begin form -->
<form method=post>
<ul>
<li>
<label class="formFieldQuestion">
ID
</label>
<input class=mainForm type=text name=zoeken id=zoeken size='50' value=''>
</li>
<li class="mainForm">
<input id="saveForm" class="mainForm" type="submit" value="Submit" />
</li></ul>
</form>
<!-- end of form -->
</div>

<table border="1">

<?php
echo $_POST ['zoeken'];
/* Verbinding met de MySQL database maken.*/

$db = mysql_connect("localhost" , "debxxxx" , "xxxxx") or die (mysql_error());

/* Selecteer de database waarop de query gedraaid moet worden.*/

mysql_select_db("debxxxxxx", $db);

/* Uitvoeren van de query.*/

$sql = "SELECT * FROM `students` WHERE eu=" .$_POST ['zoeken'].


/* Het resultaat van de query in een array variabele stoppen, zodat we deze later uit kunnen lezen.*/

$result = mysql_query($sql);

if (!$result) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}

/* Met behulp van de functie mysql_fetch_assoc halen we de rijen

uit de array op.*/

while ($row = mysql_fetch_assoc($result)){

[maneetpuri]

Hi,

The query looks fine to me -

Change the line –

$result = mysql_query($sql);

In your code with the following line –

$result = mysql_query($sql) or die(mysql_error());

This will show the error that has been generated, which will help you troubleshoot the problem.


Hope this helps.

Cheers,

~Maneet

[gielvandam]

Dear Maneet or any other reader,

Thank you for your reaction but it still doesn't work.

If I change WHERE eu=" .$_POST ['zoeken']. into WHERE eu='non-EU' "; then the SELECT works. But I cann't use the form then
You can see it yourself at the site At this moment it is static, not using the FORM.
So the mistake must be in that part.

Do you see anything?

[gielvandam]

Hello,

I didn't stop searching to solve.
Now I did WHERE 'eu'=' ".$_POST ['zoeken']." ");
And the mistake returned is 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 '' eu' at line 1
I think it has something to do with qoutes.

[gielvandam]

Hello,

SOLVED.

I made a step before.
$zoeken = $_POST["zoeken"];

Then I changed in SELECT the last part in WHERE firstproject='$zoeken'";

And now it works fine.
I can go on.
Thanks to my puzzeling

[scott2500uk]

The correct $sql is:

PHP Code:

$sql = "SELECT * FROM `students` WHERE `eu`='".$_POST['zoeken']."'"; 

or

PHP Code:

$sql = "SELECT * FROM `students` WHERE `eu`='{$_POST['zoeken']}'"; 

But remember you are taking user inputed data and can be dangerous for your database. Make sure you make the data safe first with the use of mysql_real_escape_string():

PHP Code:

$sql = "SELECT * FROM `students` WHERE `eu`='".mysql_real_escape_string($_POST['zoeken'])."'";