Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

PHP Forum


You are currently viewing our PHP Forum as a guest. Please register to participate.
Login



Freelance Jobs

Reply
Old 08-04-2010, 07:37 AM [help] php+mysql
Novice Talker

Posts: 13
Name: krator
Location: Brasil , Porto Seguro
Trades: 0
hello am new to php + mysql, I am not able to connect php with my sql's giving him an error in mysql_fetch_array, I'm very new even if they could help me I would greatly appreciate it, the site is this www.creddinh.com.br/dinh, now I thank everybody, here's the piece of code.
Quote:
while($v=mysql_fetch_array($bB,MYSQL_ASSOC)){
$_CATEG["$v[id]"] = $v[nome];
}
$bB=mysql_query("SELECT * FROM {$DB_PRENOM}_subcategorias ORDER BY idcateg, nome");
while($v=mysql_fetch_array($bB,MYSQL_ASSOC)){
$_SUBCATEG["$v[id]"] = $_CATEG[$v[idcateg]].' - '.$v[nome];
}
and here the line 53
Quote:
Array('campo'=>'subcategoria', 'nome'=>'Sub Categorias', 'tamanho'=>'200', 'tipo'=>'select', 'tamanho'=>'30', 'opcoes'=>Array(''=>'')+$_SUBCATEG, 'traduzivel'=>'falso'),
krator is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 08-04-2010, 08:47 AM Re: [help] php+mysql
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,384
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
the query returned no records
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 08-04-2010, 08:57 AM Re: [help] php+mysql
Novice Talker

Posts: 13
Name: krator
Location: Brasil , Porto Seguro
Trades: 0
Now I added
Quote:
$bB=mysql_query("SELECT * FROM {$DB_PRENOM}_subcategorias ORDER BY idcateg, nome")or die( mysql_error() );
some mistakes but i went ta still giving an error on line 16

tracking site www.creddinh.com.br/dinh

I thank you all
krator is offline
Reply With Quote
View Public Profile
 
Old 08-04-2010, 09:02 AM Re: [help] php+mysql
Novice Talker

Posts: 13
Name: krator
Location: Brasil , Porto Seguro
Trades: 0
I am Brazilian do not speak English well maybe that might hinder me T_T
krator is offline
Reply With Quote
View Public Profile
 
Old 08-04-2010, 09:32 AM Re: [help] php+mysql
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,384
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Quote:
Table 'cred_banco.Creddinh_subcategorias' doesn't exist
Should give you a clue to the error
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 08-04-2010, 09:43 AM Re: [help] php+mysql
Novice Talker

Posts: 13
Name: krator
Location: Brasil , Porto Seguro
Trades: 0
how do you solve x_x I'm pretty new to php and mysql, is how you explain? please.
krator is offline
Reply With Quote
View Public Profile
 
Old 08-04-2010, 10:16 AM Re: [help] php+mysql
chrishirst's Avatar
Missing! presumed drunk.

Posts: 42,384
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
using the correct name for the table you are tring to access would fix it.
__________________
Chris. ->>
Please login or register to view this content. Registration is FREE
<<-

A foolish consistency is the hobgoblin of little minds
Thought for today:- Is SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 08-04-2010, 10:29 AM Re: [help] php+mysql
Novice Talker

Posts: 13
Name: krator
Location: Brasil , Porto Seguro
Trades: 0
I could connect many thanks.

very thank you
krator is offline
Reply With Quote
View Public Profile
 
Old 08-04-2010, 01:05 PM Re: [help] php+mysql
Novice Talker

Posts: 10
Name: Muhammad Umer Farooq
Trades: 0
hey it helps me too
omerfarooq123 is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to [help] php+mysql
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 1.61486 seconds with 12 queries