Programming Forums > Web Development and Design > PHP

kruptof · Aug 31st, 2006, 3:33 PM

Quote:

<?
mysql_connect(xxxxxxxxx,'xxxxxxxx','xxxxxxxx')||die("Error Connecting to server");

mysql_select_db("db")||die("Error Connecting to database");

$result=mysql_query("select event from events")||die("error querying db");
echo $result[0];
#$cont=mysql_fetch_array($result);
?>

i can't seem to get this working..........when i run it nothing is ouputted when i try to use the fetch array function i get an error that i supplied an argument that is not an array.....i got values inside the db...any help please.

Ooble · Aug 31st, 2006, 5:50 PM

[php]$result=mysql_query("select event from events")||die("error querying db");
$row = mysql_fetch_row($result);
echo $row[0];[/php]

Enjoy.

Jimbo · Aug 31st, 2006, 5:51 PM

$result is not an array. It is a MySQL resource, assuming the query was successful (if it wasn't, you'd get the call to die()). After the call to mysql_fetch_array(), $cont should be an array containing something to the likes of Array("event" => /*whatever an event would be*/). You can call mysql_fetch_array($result) as many times as rows were returned from the query (mysql_num_rows($result)).

Aug 31st, 2006, 5:50 PM	#2
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 8	[php]$result=mysql_query("select event from events")\|\|die("error querying db"); $row = mysql_fetch_row($result); echo $row[0];[/php] Enjoy. __________________ Me :: You :: Them

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change the name of output file	jazz	C	4	Jun 28th, 2006 2:54 AM
MySQL with python?	snipertomcat	Python	2	Apr 13th, 2006 1:34 AM
Numerical data output to a file	can342man	C++	4	Jan 27th, 2006 4:21 PM
Tutorial - Using MySQL in C#	Darkhack	C#	12	Jan 17th, 2006 9:28 AM
It's giving me "Press any key to continue" and no other output..	Insomniac	C	15	Jun 5th, 2005 7:07 AM

Aug 31st, 2006, 5:51 PM	#3
Jimbo Battle Programmer Join Date: Feb 2006 Location: Bellevue, WA, USA Posts: 742 Rep Power: 3	$result is not an array. It is a MySQL resource, assuming the query was successful (if it wasn't, you'd get the call to die()). After the call to mysql_fetch_array(), $cont should be an array containing something to the likes of Array("event" => /whatever an event would be/). You can call mysql_fetch_array($result) as many times as rows were returned from the query (mysql_num_rows($result)).

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

Programming Forums > Web Development and Design > PHP

MYSQL output help