Dammit,I need some help with a simple script

csk8er59

Alright,I have one table with 4 fields,id,name,caption,and catid. I want to display name but I'm having some retarded trouble.Here's the code for the script:

<?php
echo "Welcome to Cosmic Charge";
require ('http://127.0.0.1/config.php');
//Selecting the whole table boards.
$sqlquery = mysql_query('SELECT * FROM `boards` ORDER  BY `catid` ASC');
//Lists boards.
while ($row = mysql_fetch_array($sqlquery)) {
echo $row[1];
}
?>

Here's config.php:

<?php
//The DB connection file <_<
require ('http://127.0.0.1/sql.php');
//ERROR REPORTING TO DA MAX BABY
error_reporting (4095);
//Sets a variable for the time it takes to load the page.
$load_time = array_sum (explode (' ', microtime())); 
?>

The SQL connect file is correct,also.All it displays is Welcome to Cosmic Charge. Nothing else.And there is a row in the DB,too.So uhh,any help is appreciated.

TheDefender

Originally posted by csk8er59
Alright,I have one table with 4 fields,id,name,caption,and catid. I want to display name but I'm having some retarded trouble.Here's the code for the script:
<?php
echo "Welcome to Cosmic Charge";
require ('http://127.0.0.1/config.php');
//Selecting the whole table boards.
$sqlquery = mysql_query('SELECT * FROM `boards` ORDER  BY `catid` ASC');
//Lists boards.
while ($row = mysql_fetch_array($sqlquery)) {
echo $row[1];
}
?>
Here's config.php:
<?php
//The DB connection file <_<
require ('http://127.0.0.1/sql.php');
//ERROR REPORTING TO DA MAX BABY
error_reporting (4095);
//Sets a variable for the time it takes to load the page.
$load_time = array_sum (explode (' ', microtime())); 
?>
The SQL connect file is correct,also.All it displays is Welcome to Cosmic Charge. Nothing else.And there is a row in the DB,too.So uhh,any help is appreciated. [/B]

Where is the connect file called from? Where is the mysql_connect() portion of your script... Is there more, because I don't see where you are making your connection to the DB.

csk8er59

require ('http://127.0.0.1/sql.php');
That's the SQL connect file and command.

tekky

Originally posted by csk8er59
require ('http://127.0.0.1/sql.php');
That's the SQL connect file and command.

have you put any debug commands in to see that this file is being called? generally you dont use a URL as a require path.... so I could see this not working....

TheDefender

Sorry csk8er59, I missed that. Post the connect stuff as well... (Obviously change the username and password to generic values first)

Tekky, I have written scripts to use full URLs (to test with) before without any problems.

csk8er59, have you tried adding mysql_die()'s to your connect and query statements to see if they error at all?
Also, try echoing your $sqlquery to make sure it is right too.

tekky

$sqlquery is going to be a result ID so... echoing it wont accomplish much 😉

"Result #3" or "ResourceID #3" something like that would be all he'd get

TheDefender

You are right tekky...

csk8er59, what I meant was make this change:

$qry = "SELECT * FROM boards ORDER BY catid ASC";
$sqlquery = mysql_query($qry);
echo $qry;

Echo out the actualy $qry verbage to see what is actually being queried. Thanks for the catch tekky.

tekky

Originally posted by TheDefender
You are right tekky...

csk8er59, what I meant was make this change:
$qry = "SELECT * FROM boards ORDER BY catid ASC";
$sqlquery = mysql_query(qry);
echo $qry;
Echo out the actualy $qry verbage to see what is actually being queried. Thanks for the catch tekky. [/B]

well... you would need mysql_query($qry) 😉

but this is pointless in his case... he is setting no variables in the $qry string... so the string will be just as it is when he sets it... (unless his original Query string was only an example...

echoing a static string returns that static string....

TheDefender

the mysql_query($qry) is there... It's the line that reads:
$sqlquery = mysql_query($qry); (after I made my corrections on my earlier post of course 😉)

And, yes, I concede your point that since there are no variables, it doesn't matter anyhow... Just looking for a little humor, because I have seen stanger things (as I am sure you have).

csk8er59

Alright,here is sql.php:

<?php


$link = mysql_connect('localhost', 'useredited', 'passedited');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}

$db_selected = mysql_select_db('boards', $link);
if (!$db_selected) {
   die ('Can\'t use boards : ' . mysql_error());
}

mysql_close($link);
?>
Trying to echo the SQL variable did nothing either. This is weird...I checked to make sure all of the commands work with 4.35 and they do...

TheDefender

First thing's first, escape your single quote in your die statement.

die ('Can\'t use boards : ' . mysql_error());

Also, you are closing your connection with mysql_close($link) in your sql.php befor eyou ever query the database... Move the close function to after the query.

csk8er59

Originally posted by TheDefender
First thing's first, escape your single quote in your die statement.

die ('Can\'t use boards : ' . mysql_error());

Also, you are closing your connection with mysql_close($link) in your sql.php befor eyou ever query the database... Move the close function to after the query.

1.It is escaped,I don't know why the hell it didn't display it 0_o
2.Removing mysql_close did nothing.
🙁

laserlight

What exactly is your "retarded trouble"?

For starters, put aside this current script, and test your database connection, selection, and a simple query.

Once you're sure that this works, you can move on to debugging the other parts of your actual script.

TheDefender

OK, there is nothing "obvious" then, so let's build the connect, pull the data, and display the results all on one page, with no error checking (other than the connect and db select errors.

Also, do the DB and table both use the name "boards"? Just curious is all...

$link = mysql_connect('localhost', 'useredited', 'passedited') or die("Could not connect: " . mysql_error()); 
$db_selected = mysql_select_db('boards', $link) or die("Could not use the boards db: " . mysql_error()); 

$qry = "SELECT * FROM boards ORDER BY catid ASC"; 
$sqlquery = mysql_query($qry); 

while ($row = mysql_fetch_array($sqlquery)) { 
echo $row[1]; 
}

[edit]Sorry laserlight, I was creating my post when you posted...[/edit]

csk8er59

That worked...Thanks! There must be something wrong with me config.php file...Now I gotta find that out.Thanks a lot though!

TheDefender

No Problem... The best thing to do next is to begin adding the error checking back in (all in the same file) and one at a time. As you progress, keep checking your results.

Then later, break things up into their separate includes... Do it piece by piece, so if something fails, you will know what change you made, and will be able to more quickly and easily identify the problem.