PHP - MySQL, WHAT IS WRONG WITH THIS??

[Anon]

I am quite new to PHP and MySQL, what is wrong with this code? When I run it instead of the right thing appearing, it writes Resource id #2 on the screen. the query is not the problem, because when I run it on phpmyadmin it displays the correct thing... I guess it is in the echo $result part?

<?php
$db = mysql_connect("localhost",username,password);

mysql_select_db("my_db",$db);

$result = mysql_query("SELECT screensavers FROM racsite WHERE number = 0",$db);

echo $result;

?>

[daynah]

I think it's your username and password. They should be in quotes. When you print out $result, it's actually an array I believe. Try this code and see if it works:

$db = mysql_connect( "localhost", $dbusername, $dbpassword );
$connection = mysql_select_db( "my_db", $db );
$query = "SELECT screensavers FROM racsite WHERE number = '0'";
$result = mysql_query($query, $db);

while($myscreensavers = mysql_fetch_array($result))
{
printf("screensaver: %s<br>", $myscreensavers["screensavers"]);
}

[Anon]

The mysql_query returns a resource. To actually get at the results you have to call the fetch row function, mysql_fetch_row with, in your case "$result". This will give you the first row from your query in an associative array, an array indexed with words that correspond to the name of the columns in your table, that you can access. You can then echo out what you want. The code would look similar to this:

while($result_row = mysql_fetch_row($result))
{
print "$result_row['column_name'];
}

I used print but you could use echo. If you wanted to just dump the output you could use print_r($result_row).

[Anon]

NOTE: In my last post I put a quote before $result_row that should not be there.

[Anon]

still doesn't work 🙁 I took out that quote, and copy & pasted the code u wrote, but now nothing appears on the screen :/

[Anon]

This was your code:

<?php
$db = mysql_connect("localhost",username,password);
mysql_select_db("my_db",$db);
$result = mysql_query("SELECT screensavers FROM racsite WHERE number = 0",$db);
echo $result;
?>

and this is mine:

<?php
$db = mysql_connect("localhost",username,password);

mysql_select_db("my_db",$db);

$result = mysql_query("SELECT screensavers FROM racsite WHERE number = 0");
while ($record=mysql_fetch_assoc($result)){
echo $record["screensaver"];
}
?>

Maybe you should add single quotes before and after de zero (like this: '0'),
but I'm not sure.
Let me know if this works 🙂
bye

[Anon]

Heres the code I would use, I've tried it out and it does work.

<?php

$connect = mysql_connect("localhost","username","password");
$db = mysql_select_db("my_db",$connect);
$query = "SELECT screensavers FROM racsite WHERE number = 0";
$result = mysql_query($query);

while($row = mysql_fetch_array($result))
{
echo$row["screensavers"];
}
?>

Also make sure your username and password are in quotes as it will not work, they aren't in the code you posted I notice.

[Anon]

Kris

your code works fine as well,just needed the username and password in quotes.
Didn't need the single quotes before and after the zero.