30 NP$ For Whoever Can Give Me Simple Code Snippet

buddybuddha · 09-12-2005, 03:32 PM

Im looking for a small sql code snippet to do an extremely simple task. Surely I could read an online tutorial, but Im really lazy. So there a 30 NP$ reward for whoever can give me the code.

I know how to connect to the database and how to select a database.

So assuming Im in the database, how do I:

1- Select a table named plog_users
2- View a given row, lets say for your code, row #2
3- Store the data contained in that raw as variable $nug

miseria · 09-12-2005, 03:41 PM

PHP Code:

  <?php

 
$db_host = "localhost";

$db_username = "";

$db_password = "";

$database = "plog_users";

 
 
mysql_connect(localhost,$db_username,$db_password);

@mysql_select_db($database) or die( "Unable to select database");

 
 
$query = "SELECT * FROM 'row#2' ";

$result=mysql_query($query);

$num=mysql_num_rows($result);

 
$i=0;

while ($i < $num) {

 
$nug=mysql_result($result,$i,"row#2");

 
$i++;

}

 
 
?>

I think something along those lines

buddybuddha · 09-12-2005, 03:53 PM

I think thats wrong because the database isn't plog_users the table is.

miseria · 09-12-2005, 03:57 PM

PHP Code:

  <?php

 
$db_host = "localhost";

$db_username = "";

$db_password = "";

$database = "";

 
 
mysql_connect(localhost,$db_username,$db_password)  ;

@mysql_select_db($database) or die( "Unable to select database");

 
 
$query = "SELECT 'row#2' FROM 'plog_users' WHERE UID=' ' ";

$result=mysql_query($query);

$num=mysql_num_rows($result);

 
$i=0;

while ($i < $num) {

 
$nug=mysql_result($result,$i,"row#2");

 
$i++;

}

 
 
?>

I'm sure somebody will corect me on that. I have my own frustrations with MySQL

buddybuddha · 09-12-2005, 04:01 PM

Ah wait I forgot something too. Im looking for a specific column as well. The column name is UID.

miseria · 09-12-2005, 04:09 PM

Edited ^

It's wrong but it's a guideline

**Eric** · 09-12-2005, 04:13 PM

Something like this?

PHP Code:

  <?php

 
$dbhost = "localhost";

$dbuser = "username";

$dbpass = "password";

$dbname = "";

 
 
$db = mysql_connect($dbhost, $dbuser, $dbpass);

mysql_select_db($dbname, $db) or die("Error: " .mysql_error());

 
 
$query = mysql_query("SELECT `UID` FROM `plog_users`") or die("Error: " .mysql_error());

$result = mysql_query($query);

 
while ($row = mysql_fetch_array($result))

{

$nug = $row['row#2'];

echo $nug;

}

 
 
?>

Le Wolf · 09-12-2005, 04:36 PM

PHP Code:

  $result = mysql_query("SELECT `UID` FROM `plog_users`");

$uid = mysql_result($result,1); // row 2

buddybuddha · 09-13-2005, 01:00 PM

Hmm well that just about did it, sorta. And since Iused part of everyones code, I couldnt think of a fair way to distribute the NP$.

So whoever can figure out this error gets the 30 + a bonus 10!

I wrote the following code

Code:

<?php

$x = 0;

/* Set mysql variables */
$db_host = "localhost"; //Leave localhost
$db_user = "buddha_nugget"; //DB username
$db_name = "buddha_nugget"; //DB Name
$db_pass = "*****"; //DB User password

$connect = mysql_connect("$db_host","$db_user","$db_pass") or die(mysql_error());
$select_db = mysql_select_db("$db_name");

//Do sqlquery and get variable num
$sqlquery = mysql_query("SELECT * FROM plog_users");
$num = mysql_num_rows($sqlquery);

echo $num;
echo "<br>";

//Found Number of Rows

while ($x == 0)
{

	//Generate Random Number
	$random = rand(0,$num-1);

	//Connect
	$dbhost = "localhost";
	$dbuser = "buddha_nugget";
	$dbpass = "*****";
	$dbname = "buddha_nugget";

	$db = mysql_connect($dbhost, $dbuser, $dbpass);
	mysql_select_db($dbname, $db) or die("Error: " .mysql_error());

	$query = mysql_query('SELECT id FROM plog_users');
	$uid = mysql_result($query, $random); //Random Row

	$result = mysql_query('SELECT status FROM plog_users');
	$stat = mysql_result($result, $random); //Random Row

	if ($stat == "1"){$x = 1;}
	
	echo $random;
	echo "<br>";
	echo $uid;
	echo "<br>";
	echo $stat;
	echo "<br>";
}

echo "final";
echo "<br>";
echo $random;
echo "<br>";
echo $uid;
echo "<br>";
echo $stat;

?>

Tried to comment, but its a diagnostics code to tell me why it isnt working.

Inside the plog_users table I have the following data.

id column- 1,22,21
status column- 1,3,2

After running the diagnostic program I get wierd results.

something along the lines of

3
2
22
2
1
21
3
0
1
1
final
0
1
1

The 3 is right, there are that man rows. Also, the 0,1,1 part is right.

But grouping the other two

2,22,2
and
1,21,3
which represent row,id,status

we find an error.

Row 2 is supposed to have 21,2
Row 1 is supposed to have 22,3

So it finds the proper status code, but not the proper id.

Anyone know why?

BTW- Im using phpmyadmin to view the tables.

Also, the grouping of those errors is consistent.

09-12-2005, 03:32 PM	#1 (permalink)
buddybuddha NamePros Regular Join Date: May 2005 Location: PA Posts: 212 74.00 NP$ (Donate)	30 NP$ For Whoever Can Give Me Simple Code Snippet Im looking for a small sql code snippet to do an extremely simple task. Surely I could read an online tutorial, but Im really lazy. So there a 30 NP$ reward for whoever can give me the code. I know how to connect to the database and how to select a database. So assuming Im in the database, how do I: 1- Select a table named plog_users 2- View a given row, lets say for your code, row #2 3- Store the data contained in that raw as variable $nug __________________ The Kevin Dolan Design By Dolan Genetic Programming Source EuroToDollar: Forex Basics

09-12-2005, 03:41 PM	#2 (permalink)
miseria SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 545 205.50 NP$ (Donate)	PHP Code: `<?php $db_host = "localhost"; $db_username = ""; $db_password = ""; $database = "plog_users"; mysql_connect(localhost,$db_username,$db_password); @mysql_select_db($database) or die( "Unable to select database"); $query = "SELECT * FROM 'row#2' "; $result=mysql_query($query); $num=mysql_num_rows($result); $i=0; while ($i < $num) { $nug=mysql_result($result,$i,"row#2"); $i++; } ?>` I think something along those lines

09-12-2005, 03:53 PM	#3 (permalink)
buddybuddha NamePros Regular Join Date: May 2005 Location: PA Posts: 212 74.00 NP$ (Donate)	I think thats wrong because the database isn't plog_users the table is. __________________ The Kevin Dolan Design By Dolan Genetic Programming Source EuroToDollar: Forex Basics

09-12-2005, 03:57 PM	#4 (permalink)
miseria SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 545 205.50 NP$ (Donate)	PHP Code: `<?php $db_host = "localhost"; $db_username = ""; $db_password = ""; $database = ""; mysql_connect(localhost,$db_username,$db_password) ; @mysql_select_db($database) or die( "Unable to select database"); $query = "SELECT 'row#2' FROM 'plog_users' WHERE UID=' ' "; $result=mysql_query($query); $num=mysql_num_rows($result); $i=0; while ($i < $num) { $nug=mysql_result($result,$i,"row#2"); $i++; } ?>` I'm sure somebody will corect me on that. I have my own frustrations with MySQL Last edited by miseria; 09-12-2005 at 04:09 PM.

09-12-2005, 04:01 PM	#5 (permalink)
buddybuddha NamePros Regular Join Date: May 2005 Location: PA Posts: 212 74.00 NP$ (Donate)	Ah wait I forgot something too. Im looking for a specific column as well. The column name is UID. __________________ The Kevin Dolan Design By Dolan Genetic Programming Source EuroToDollar: Forex Basics

09-12-2005, 04:09 PM	#6 (permalink)
miseria SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 545 205.50 NP$ (Donate)	Edited ^ It's wrong but it's a guideline Last edited by miseria; 09-12-2005 at 04:13 PM.

09-12-2005, 04:13 PM	#7 (permalink)
Eric NPQ's PA, Slave, and On Call Coder Technical Services Join Date: Mar 2005 Posts: 4,545 0.71 NP$ (Donate)	Something like this? PHP Code: <?php $dbhost = "localhost"; $dbuser = "username"; $dbpass = "password"; $dbname = ""; $db = mysql_connect($dbhost, $dbuser, $dbpass); mysql_select_db($dbname, $db) or die("Error: " .mysql_error()); $query = mysql_query("SELECT `UID` FROM `plog_users`") or die("Error: " .mysql_error()); $result = mysql_query($query); while ($row = mysql_fetch_array($result)) { $nug = $row['row#2']; echo $nug; } ?> __________________

09-12-2005, 04:36 PM	#8 (permalink)
Le Wolf NamePros Member Join Date: Jul 2005 Posts: 100 45.15 NP$ (Donate)	PHP Code: $result = mysql_query("SELECT `UID` FROM `plog_users`"); $uid = mysql_result($result,1); // row 2 __________________ My host is better than yours

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tutorial: Creating a simple cgi hit counter for your site using Perl	deadserious	Webmaster Tutorials	3	05-29-2004 01:31 AM
A simple cgi hit counter for your site using Perl	deadserious	CODE	2	11-07-2003 08:23 AM

Technical Services