Go Back   Dreamweaver Club Forums > Hand Coders Forum > PHP
Register FAQ Members List Search Today's Posts Mark Forums Read

Thread Tools Display Modes
Old 04-08-2012, 02:54 AM   #1
Join Date: Apr 2012
Posts: 2
Default fetching table data (newbie)

First I should say I am new to working with DW and do not have it connected to a server. Instead I use an ftp client but I think I have everything in the right place (I have been playing with the script and the results seem to corroborate this...). I would also rate myself as a newbie as I am also a long way out of using PHP or mySQL queries...In any case:

I set up a two db tables. One table has an int in the second field (field2), the other has a varchar in the second field (login_name). The script seems to connect to the db, but when I use mysql_fetch_array to retrieve data from the different tables, using the first table an echo produces the proper value; from the second table (the one with a name/string/varchar in it), the echo is blank (nada, nothing prints on the webpage).

I checked the fetch array and it can return either (int or varchar) yes?

My code looks like all the others that are following the video that David Jackson produced but perhaps I should include it here (in case I have misplaced a ; or something (I have been working for hours and hours on this and am bleary-eyed.))?

Thanks in advance for any info

PS I think I have connected to the db -- I am now searching for the php to query what tables the script can name, but any input/advice/questions would be appreciated.

Thanks for any info

Last edited by querieshere; 04-08-2012 at 03:16 AM.. Reason: update
querieshere is offline   Reply With Quote
Old 04-08-2012, 03:50 AM   #2
Join Date: Apr 2012
Posts: 2
Default fetching table data (newbie)

Hey, I solved this problem by re-checking the table structures. Thanks to any that chose to look. I have asked the admin to delete the post but if it is still here perhaps it will help someone...

cheers + best
querieshere is offline   Reply With Quote

Thread Tools
Display Modes

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

Forum Jump

All times are GMT. The time now is 02:34 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com