Empty Query?

[elite_prodigy]

Why is navId comming out blank?

 

 

<?php

include 'config.php';
include 'functions.php';

mysql_select_db('exembar_site');

if( isset($_POST['title']) & isset($_POST['display']) & isset($_POST['topbar']) & isset($_POST['content'])) {
$title = $_POST['title'];
$display = $_POST['display'];
$top = $_POST['topbar'];
$content = $_POST['content'];

//sanitize everything
$title = sanitize($title);
$display = sanitize($display);
$top = sanitize($top);
$content = sanitize($content);

$sql = "INSERT INTO `navigation` VALUES('','{$display}','')";
mysql_query($sql) or die(mysql_error());

$sql = "SELECT * FROM `navigation` WHERE `display`='{$display}'";
$res = mysql_query($sql) or die(mysql_error());
$stuff = mysql_fetch_array($res) or die(mysql_error());

$navId = $stuff['id'];
echo $navID;

$sql = "INSERT INTO `pages` VALUES('','{$title}','{$navID}')";
mysql_query($sql) or die(mysql_error());

$sql = "INSERT INTO `pgContent` VALUES('','{$top}','{$content}','{$navID}')";
mysql_query($sql) or die(mysql_error());

//header("location:{$root}");

}
else {

echo "Variables Were Not Defined!";

}

?>

 

I don't know what to try, as i've tried it all....

[cwarn23]

One reason that I can see is because of the below line:

echo $navID;

PHP is case sensitive and should be the following:

echo $navId;

Hope that helps.

[chronister]

I am not an expert on this stuff by any means and I may be wrong here, but this don't look right to me..

 

$sql = "INSERT INTO `navigation` VALUES('','{$display}','')";

 

To the best of my knowledge, an insert statement should look like this..

 

$sql = INSERT INTO tableName (fieldName1, fieldName2, fieldName3) VALUES ('$value1', '$value2', '$value3');

 

Thats what I can see offhand... but like I said I could be wrong about the structure of your query.

 

Nate

 

[New Coder]

I am not an expert on this stuff by any means and I may be wrong here, but this don't look right to me..

 

$sql = "INSERT INTO `navigation` VALUES('','{$display}','')";

 

To the best of my knowledge, an insert statement should look like this..

 

$sql = INSERT INTO tableName (fieldName1, fieldName2, fieldName3) VALUES ('$value1', '$value2', '$value3');

 

Thats what I can see offhand... but like I said I could be wrong about the structure of your query.

 

Nate

 

 

You don't have to specify columns in an insert statement. It will insert the data in the order the columns are stored in the table hence the '' (blanks) in the values.

However as a best practice I would always state the columns.

 

However I've never used { } around my values. So not sure if this is correct.

[waynew]

I am not an expert on this stuff by any means and I may be wrong here, but this don't look right to me..

 

$sql = "INSERT INTO `navigation` VALUES('','{$display}','')";

 

To the best of my knowledge, an insert statement should look like this..

 

$sql = INSERT INTO tableName (fieldName1, fieldName2, fieldName3) VALUES ('$value1', '$value2', '$value3');

 

Thats what I can see offhand... but like I said I could be wrong about the structure of your query.

 

Nate

 

 

You don't have to specify columns in an insert statement. It will insert the data in the order the columns are stored in the table hence the '' (blanks) in the values.

However as a best practice I would always state the columns.

 

However I've never used { } around my values. So not sure if this is correct.

 

NEVER use that kind of query structure. What if you decide to add a column later on?

[New Coder]

aha fair point but I find it useful when I only want to insert into specific columns and then still search on null values. Preferences I guess..

[waynew]

I know. It's just that I'm after coming from a job where the last programmer had used that style of query and that style only. I had to rewrite every query.

[elite_prodigy]

But i have no intentions at all of adding new columns, so I used that query struct. Makes my life easier...

[keiran420]

you can add ARRAYS into querys using {}....

[elite_prodigy]

Does anyone know why this query is not working at all? It's coming back empty....

[chronister]

Did you try the whole $navID vs $navId thing..... that would make a big difference as has been pointed out...

 

I would say try echoing out your query and make sure that the values are filled in like your expecting.

 

When I have issues with a sql statement, I generally will echo them out and try them in phpmyadmin... found a lot of issues that way.

 

Thats the only 2 things I can suggest.

 

Nate

[l0ve2hat3]

yes take out the brakets in all ur querys

[haku]

There is nothing wrong with the brackets in the queries, and for the sake of readability, it is better to have them.