You are here: Re: No results populating from SQL Query « All PHP « IT news, forums, messages
Re: No results populating from SQL Query

Posted by Martin Jay on 05/19/06 15:56

In message <1147918204.024611.120110@y43g2000cwc.googlegroups.com>,
"c.wrinn@gmail.com" <c.wrinn@gmail.com> writes
><?
> $mysql = mysql_connect("localhost","cwrinn","cw5324") or die('Unable
>to Authenticate to ODBC'.mysql_error());
> mysql_select_db(snapon_dev, $mysql) or die('Error Selecting
>Database'.mysql_error());
> $result = mysql_query("select * from branch limit 0,30", $mysql) or
>die('Error querying database'.mysql_error());
> $num = mysql_num_fields($result;

Missing ), should be:

$num = mysql_num_fields($result);

Check here to see what value $num has. If it's zero the SELECT is
probably failing.

It might also be a good idea to check what database permissions "cwrinn"
has.
--
Martin Jay

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация