vb.org Archive - can't get info from mysql

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - can't get info from mysql (https://vborg.vbsupport.ru/showthread.php?t=42355)

mr e	08-16-2002 04:47 AM

can't get info from mysql

ok i have a completely different page, nothing to do with vb, but here's what i have so far...

PHP Code:


		
			
$DB = mysql_connect( "localhost", $DBUSER, $DBPASS ) or die("Could not connect to $DBNAME");



mysql_select_db( $DBNAME, $DB ) or die("Could not find database");



function view() {

        $getshouts = mysql_query("SELECT * FROM shouts");

        while(list($shouts) = mysql_fetch_array($getshouts, $DB)) {

        echo $shouts[name];



        }

...

and yes i DO have more in the view() funcion but i only listed what was neccessary, basically i can't get it to echo anything out, im only using the echo as a test to see if i can actually use the variables, i have tried quite a variety of ways but still can't figure out whats up...hope you can help :D

Dark_Wizard

08-16-2002 11:29 AM

This:

Code:

echo $shouts[name];

should be this:

Code:

echo "$shouts[name]";

mr e	08-17-2002 06:14 AM

this is what i have now, i've narrowed it down and i know it's something to do with the SELECT

PHP Code:


		
			
$getshouts = mysql_query("SELECT name FROM shouts");

if (!$getshouts) {

echo("<P>Error performing query: " . mysql_error() . "</P>");

exit();

;}



echo "Your name is $name ! ";

and i have 4 entries all the same and it prints
Your name is ! Your name is ! Your name is ! Your name is !
so i dunno what the problem is, so hope someone can help :D

Dark_Wizard

08-17-2002 11:33 AM

Change this:

Code:

$getshouts = mysql_query("SELECT name FROM shouts");

if (!$getshouts) {

echo("<P>Error performing query: " . mysql_error() . "</P>");

exit();

;}



echo "Your name is $name ! ";

to this:

Code:

$getshouts = mysql_query("SELECT name FROM shouts WHERE name=$name");

if (!$getshouts) {

echo("<P>Error performing query: " . mysql_error() . "</P>");

exit();

;}



echo "Your name is $name ! ";

Ajay	08-18-2002 08:57 PM

PHP Code:


		
			
        $getshouts = mysql_query("SELECT * FROM shouts");

change that to
this should work:

PHP Code:


		
			


$getshouts = "SELECT * FROM shouts";

mysql_query($getshouts)

or something similar

mr e	08-18-2002 10:07 PM

ok i finally got it, thanks all :D

All times are GMT. The time now is 08:15 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01238 seconds Memory Usage 1,729KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (4)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: