vb.org Archive - help selecting from vb3

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

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

- - help selecting from vb3_user table! (https://vborg.vbsupport.ru/showthread.php?t=66793)

benroles

07-02-2004 05:51 PM

help selecting from vb3_user table!

Hello,

I know what I am doing (I think!) in PHP but I am having real problems reading the VB3_ tables... This code should check if the username exists in the database, but I cannot get it to work. Can anyone please tell me why?

$query = "SELECT * from vb3_user where 1 and username like '$username'";
$result = mysql_query($query);
$rows = mysql_num_rows($result);
echo $rows; //JUST A TEMPORARY THING FOR TESTING
if ($rows>0){
echo('! The username you selected is already being used. Please select another.');
}

Please note that I already called a connection to the database in an include:

$db = mysql_connect("localhost","xxxxx","xxxxx");
mysql_select_db("xxxxx",$db);

When I run this script on another table I get back the number of rows through the echo command, but on the vb3_user table I get nothing, not even an 'echo' of $rows (which should be 1 or 0).

PLEASE can somebody explain what the hell is happening?!!

Regards,
Ben.

Andreas

07-02-2004 05:59 PM

I assume the table name (vb3_user) is correct?

PHP Code:


		
			
$query = "SELECT * from vb3_user where 1 and username like '$username'";

You should better change this to

PHP Code:


		
			
$query = "SELECT * FROM vb3_user WHERE username = '$username'";

Also replace

PHP Code:


		
			
$result = mysql_query($query);

with

PHP Code:


		
			
$result = mysql_query($query) or die('Query not successful: ' . mysql_error());

to see what's going wrong with the query.

Modin

07-02-2004 06:42 PM

you get nothing because when there's no result from your query, you should get nothing in your result, and therefore nothing for your rows.

Try using this code instead (also as Kirby said, don't use the 'WHERE 1' and have the 'or die' code)

Code:

$query = "SELECT * from vb3_user WHERE username like '$username'";

$result = mysql_query($query) or die('Query not successful: ' . mysql_error()); 

if ($result){

    echo('<p><strong><font color="#FF0000">! The username you selected is already being used. Please select another.</font></strong></p>');

}

All times are GMT. The time now is 11:11 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01875 seconds Memory Usage 1,719KB 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 (1)bbcode_code_printable (4)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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: