script for query a db help needed

Question

i have the following code in php:

$host="localhost"; // Host name
$username="***"; // username
$password="***"; // password
$db_name="***"; // Database name
//$rc_profile_table="rc_profile_table"; // Table name
//$rc_profile_relation_table="rc_profile_relation_table"; // Table name


mysql_connect("$host", "$username", "$password");
mysql_select_db("$db_name");

$sql="SELECT created_at FROM rc_profile_table where created_at > 2011-04-19 08:00:00";
$result=mysql_query($sql);
$count=mysql_num_rows($result);

$sql="SELECT created_at FROM rc_profile_relation_table where created_at > 2011-04-19 08:00:00";
$result2=mysql_query($sql);
$count2=mysql_num_rows($result);

 mysql_close();

pleas select your code and click the {} icon when you ask a question. This will format the code. — tim_a
– tim_a, Commented Apr 20, 2011 at 10:06

KillerX · Accepted Answer · 2011-04-20 10:05:41Z

3

What do you actually want to do? You have to describe the problem else no one can help you...

answered Apr 20, 2011 at 10:05

KillerX

1,4661 gold badge15 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

CloudyMarble Over a year ago

and this is a comment and not an naswer!

tim_a Over a year ago

Then you should not comment :-)

tim_a · Accepted Answer · 2011-04-20 10:15:23Z

0

You have no proper error handling. The mysql functionality provided with php have a build in function that outputs the error on the screen. This would be a lot better:

<?php
$host="localhost"; // Host name 
$username="***"; // username 
$password="***"; // password 
$db_name="***"; //db name

$connection = mysql_connect($host, $username, $password) or die("Could not connect to the database: " . mysql_error()); 
mysql_select_db($db_name, $connection) or die("Could not select database: " . mysql_error());

$sql = "SELECT `created_at` FROM `rc_profile_table` WHERE `created_at` > '2011-04-19 08:00:00'"; 
$result = mysql_query($sql) or die("Could not execute query: " . $sql . "ERROR: " . mysql_error()); 
$count = mysql_num_rows($result);

mysql_close($connection) or die(mysql_error());

?>

answered Apr 20, 2011 at 10:15

tim_a

9701 gold badge7 silver badges21 bronze badges

4 Comments

tim_a Over a year ago

if you find a answer of someone really useful you need to accept this. You can do this by pressing on the V icon (so it becomes green) in the left upper corner of an answer. (Under the number with votes).

charlie_cat Over a year ago

how can i now write the output to a text file to make it look nice? thank you

tim_a Over a year ago

to a .txt file or to a a webpage?

charlie_cat Over a year ago

thank you i sorted it, i wanted to run a few queries on the db to get some stats to send to a client in a text file thanks all!

Mark Baker · Accepted Answer · 2011-04-20 11:05:44Z

0

In addition to the error handling already mentioned, for your second resultset, you might want to ensure that $count2 is the number of rows returned in $result2 rather than in the first resultset ($result)

$sql="SELECT created_at FROM rc_profile_relation_table where created_at > 2011-04-19 08:00:00"; 
$result2=mysql_query($sql); 
$count2=mysql_num_rows($result2);

answered Apr 20, 2011 at 11:05

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Collectives™ on Stack Overflow

script for query a db help needed

3 Answers 3

2 Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related